Reconcile Invoices with Higher Balance in Bank Feed (QBO)
Last updated: November 9, 2026
Sometimes your bank feed deposit doesn’t match the payment amount in QuickBooks Online (QBO). For example:
Invoice Total: $500
QBO Payment: $485 (after processor fees)
Bank Deposit: $500
Or the reverse: QBO shows $500, but the bank shows $485. Here’s how to reconcile.
Option 1: QBO Shows Net, Bank Shows Gross
QBO Payment = $485
Bank Deposit = $500
Fix: Add an adjustment for the missing $15.
In QBO, go to + New > Bank Deposit.
Add a line:
Received From: Customer Name
Account: Accounts Receivable (or Payment Clearing)
Amount: $15
Memo: Adjustment for under-recorded payment
Save. Now QBO matches the $500 deposit.
Option 2: QBO Shows Gross, Bank Shows Net
QBO Payment = $500
Bank Deposit = $485
Fix: Subtract processor fees.
In QBO, go to + New > Bank Deposit.
Select the $500 payment from Undeposited Funds.
Add a new line:
Account: Bank Fees or Processing Fees (Expense)
Amount: -$15
Confirm deposit total = $485.
Save. Now QBO matches the bank feed.
Summary Table
Scenario | Fix |
QBO shows $485, bank shows $500 | Add +$15 line in Bank Deposit |
QBO shows $500, bank shows $485 | Add -$15 fee in Bank Deposit |
Payments are batched | Combine in one Bank Deposit and subtract total fees |
QBO can’t match bank feed | Recreate deposit using Undeposited Funds + fee adjustment |
Pro Tips
Always use Undeposited Funds as the holding account.
Don’t adjust invoices to match fees—record them as separate expenses.
Track processor fees in a dedicated expense account (e.g., “Payrix Fees”).
Summary
Adjust deposits, not invoices, to match net/gross differences.
Use Bank Deposits to add/subtract fees.
Keep fee tracking separate for cleaner reporting.