Accounts receivable · cash application

Match My Deposits

A customer or a payout service sends one lump sum and no remittance advice. Paste your open invoices and your bank deposits, and Match My Deposits works out which invoices each deposit paid, including batched payouts, processor fees taken off the top and partial payments. Everything runs in this page; your data is never uploaded.

Deposits in–

Applied to invoices–

Fees taken–

Still owed to you–

Deposits unexplained–

Your data

Showing example data

Open invoices CSV from Stripe, QuickBooks, Xero or a spreadsheet. Needs an amount column; invoice number, customer and date help.

Bank deposits Your bank's transaction export. Only money in is used; card spend and transfers out are skipped.

Fee per payout ($) Fee rate (%) Most invoices per deposit

Deposits

How it decides: deposits with only one possible combination are settled first, so they can't lose an invoice to a looser match. A payer name in the bank memo narrows the search to that customer. When several combinations fit equally well, it says so and lets you pick. A payment smaller than anything that fits is applied to that customer's oldest invoices as a partial payment.