When a customer pays through QuickBooks Payments, the processing fee comes out before the money lands in your bank account. That's why the deposit in your bank feed is smaller than the invoice total, and QuickBooks can't find an automatic match for it. Here's how to fix that, whether you're matching today's deposit or catching up on a few from a while back.
Match today's deposit to the invoice
- Go to Bookkeeping, then Transactions, then Bank transactions.
- Find the deposit sitting in the For review tab and open it.
- Select Find match to see suggested invoices or payments. If nothing lines up because of the fee, head to Sales & Get Paid, then Sales transactions, and find the payment tied to that invoice.
- Add a line for the processing fee to account for the gap between the invoice total and what actually landed in your bank. This keeps the record itemized and shows exactly where the fee went.
Once that fee line is in place, the deposit amount and the payment record match, and QuickBooks can connect the two going forward.
Catching up on older deposits
If you're working through a backlog of these, it's often easier to build the deposit yourself instead of matching one at a time:
- Move the customer payment into Undeposited Funds if it isn't already there.
- Start a new Bank Deposit and select that payment.
- In the Add funds to this deposit section, add a line for the fee. Choose your Bank Charges & Fees account and enter the fee as a negative amount so the deposit total matches your bank statement.
- Save the deposit, then match it to the downloaded transaction in your bank feed.
Either way, once the fee is accounted for, your invoice stays marked as paid and your bank feed lines up with your books.
Let us know if you run into anything else while you're matching these up!
Resources:
Match your bank and credit card transactions
Fix downloaded bank transactions
Record and make bank deposits in QuickBooks Online