QuickBooks deposits, matched for real.
Invoices and payments matched to the deposits that actually paid them, even when one deposit covers twenty.
What comes in from QuickBooks
- Invoices
Customer, invoice number, due date, amount and what is still owed on each.
- Payments received
Each payment applied to its invoices, including partial payments and overpayments.
- Deposits
The deposits you record, grouping payments the way you think the bank received them.
Why it won’t match on its own
Payments wait to be deposited
Payments sit in Undeposited Funds until someone groups them into a deposit, and that grouping is often a guess.
Processors pay net
A Stripe or Square deposit falls short of the invoices it paid by fees nobody has booked yet.
One payment, several invoices
A single ACH can cover three invoices, or part of one, with no invoice number on the bank line.
One rule, in plain words
Match QuickBooks payments to Chase deposits when a day’s payments add up to one deposit.
sum of payments = deposit, same day1,630 matched
When they add up short, the difference is kept on the match and shown for what it is, a fee or a partial payment. Nothing is forced to zero.
What Numerics works out
An invoice is only paid once the money is matched at the bank, so this ageing is worked out from cash, not from what was marked paid.
You go run your business.
Bring a month of QuickBooks records to the call. You’ll see them matched before it ends.