QuickBooks Reconciliation Discrepancy After Marketplace Deposits

Your QuickBooks Online bank reconciliation is off by $187.40 after matching marketplace deposits, even though the bank balance looks correct on the statement. This illustrative quickbooks reconciliation discrepancy calls for two separate checks: whether checking agrees with the bank, and whether marketplace activity is recorded correctly.

Those are related, but they are not interchangeable. A deposit categorized entirely as sales can reconcile perfectly while understating fees. Conversely, accurate settlement accounting will not fix a duplicate bank deposit or an incorrect statement ending date.

Start with the bank reconciliation difference. Then trace the affected payout through settlement support and a clearing account. Do not use an unexplained adjustment to force either balance to agree.

Diagnose a QuickBooks reconciliation discrepancy before editing sales

QuickBooks Online reconciles the statement ending balance against the beginning balance plus the transactions you select as cleared. The bank feed is a separate workflow: matching a downloaded transaction does not establish that every item selected in the reconciliation belongs on that statement.

For this illustrative $187.40 difference, first confirm that you entered the statement ending balance and closing date correctly. Compare the reconciliation beginning balance with the previous completed reconciliation. If those agree, compare selected deposits and withdrawals with the statement, line by line.

Search for an amount of $187.40, but do not assume there must be one transaction for that amount. Several omissions can net to the same difference. Check the direction too: an extra deposit and a missing withdrawal can have the same effect on the reconciliation.

If the beginning balance changed, review the prior reconciliation report and audit history for edited, deleted, or unreconciled transactions. Avoid changing a completed period casually. Have your bookkeeper review the correction before altering previously reconciled bank activity.

Explain the net deposit with settlement support

Amazon, eBay, and Walmart deposits generally represent settlement proceeds, not gross customer sales. Build a bridge from the marketplace report to the actual payout before deciding what QuickBooks should contain.

Use the settlement identifier, payout reference, currency, and reporting period. A bank posting date alone is weak evidence because the marketplace can initiate a payment before the bank receives it. Save the settlement detail and any reserve or adjustment reports with your reconciliation notes.

In this illustrative example, one settlement has no refunds, opening balance, reserve movement, or other adjustments:

If someone recorded a $5,000.00 deposit in checking, that entry exceeds the actual bank receipt by $187.40. Selecting it in reconciliation creates a bank difference. The fee matters here because the bank entry is gross instead of net, not simply because a fee exists.

If checking already contains exactly $4,812.60, missing fee classification alone does not explain a $187.40 bank reconciliation difference. Continue checking selected transactions and duplicates. The Amazon settlement reconciliation guide covers the broader settlement bridge when more components are involved.

Check the marketplace patterns that hide the cause

Fees and reserves inside the payout

Fees withheld from a settlement reduce the payout without creating a separate bank withdrawal. Recording both a reduced deposit and an additional checking withdrawal for those fees understates bank cash. The expense belongs in the settlement accounting unless it was actually charged separately to the bank.

Reserves are different from fees. A withheld reserve can remain an asset or part of a supported marketplace balance, depending on your account structure. Its later release is not automatically new revenue. Track opening reserves, amounts withheld, releases, and closing reserves rather than treating every shortfall as expense.

Multiple settlements behind one bank deposit

One bank receipt may represent several payouts, and one settlement may produce multiple receipts. Match the supported combination, not the nearest single amount. Where QuickBooks offers matching to multiple existing transactions, confirm their combined total and references before accepting the match.

Do not create another deposit just because an individual settlement does not equal the combined bank line. If a combined deposit entry is necessary, use it instead of separate checking entries for the same receipts, not in addition to them.

Undeposited Funds and duplicate sales

Check whether customer payments already sit in Undeposited Funds. If they do, a second settlement journal crediting sales can duplicate revenue. Review the original sales receipts, invoices, payments, and deposit workflow before choosing how to move those existing amounts into settlement clearing.

A bank feed transaction added as sales can also duplicate a payout transfer already recorded from clearing. Adding and matching are not equivalent: adding creates accounting activity, while matching connects the downloaded line to activity already in the books. Review the register, not just the feed status.

Example journals: settlement through clearing, then bank

The following illustrative entries use the same $5,000.00 sales, $187.40 fee, and $4,812.60 payout. They assume none of the sales or fees has already been recorded. They demonstrate the intended accounting, not additional entries to post over an existing sales workflow.

Clearing now holds the amount due from the marketplace. Checking has not changed. The fee is recognized without inventing a separate bank payment, and sales remain visible at the gross amount used in this simplified example.

When the supported payout reaches checking, record the movement once:

Match the downloaded deposit to this existing bank movement. Do not add another sales receipt or deposit for the same money. Both entries balance, and this settlement leaves no clearing balance because the example excludes reserves and timing differences.

If your books already contain the incorrect gross deposit, do not simply post these journals on top. Identify its offsetting accounts and any linked payments first. Correct or replace the erroneous workflow while preserving valid sales records and avoiding changes to reconciled periods without review.

For an overview of a settlement-based connection, see the Amazon–QuickBooks integration. The same control applies regardless of marketplace: explain settlement activity, record it once, and match the resulting cash movement.

Steps to fix the difference and complete reconciliation

1. 1

   Save the evidence

   Keep the bank statement, current reconciliation details, settlement report, and payout references. Note the $187.40 difference and whether checking appears too high or too low in this illustrative case.

2. Verify the reconciliation inputs: Confirm the statement date and balances. Resolve a changed beginning balance separately from current settlement classification, using the previous reconciliation and audit history.

3. Locate the bank entry: Find the payout in the checking register. Compare its amount and date with the actual statement receipt, then search for duplicate deposits, transfers, or fee withdrawals.

4. Trace the complete settlement: Rebuild the payout from sales, refunds, fees, reserves, and adjustments. For combined receipts, document every settlement included and confirm the combined total.

5. Review existing sales records: Establish whether sales were recorded through invoices, sales receipts, an integration, or a manual journal. Check Undeposited Funds before introducing another revenue entry.

6. Correct the supported error: Fix the specific duplicate, wrong bank amount, or missing transaction. Use clearing for settlement activity where appropriate, and retain a note explaining the original entry and correction.

7. Match and reconcile: Match the bank feed to the correct existing payout entry. Return to reconciliation, select only statement transactions, and confirm the difference is zero without a plug.

8. Review clearing separately: Tie any remaining clearing balance to reserves, unpaid settlements, or payouts in transit. Save that schedule alongside the completed bank reconciliation.

Troubleshooting when the difference remains

If the amount remains unchanged, inspect what you actually edited. Reclassifying a net deposit from sales to clearing changes reporting but not checking. It therefore cannot remove a bank reconciliation difference caused by an extra selected withdrawal.

If the difference disappears only when you select a transaction outside the statement period, stop and check the dates. A payout in transit can legitimately remain outstanding. Selecting it early hides a timing issue rather than resolving it.

If checking reconciles but clearing does not, investigate settlement completeness and opening balances. Keep separate clearing accounts or reliable tracking for each marketplace so an Amazon reserve is not accidentally offset against an unrelated Walmart payout.

Do not accept a suggested match solely because the amount fits. Confirm the settlement reference and receipt date, especially when repeated payouts share an amount. A wrong match can leave the right payout outstanding and confuse the next reconciliation.

Make the next marketplace reconciliation easier

Keep a repeatable settlement file: report, payout reference, account mapping, bank match, and explanation of outstanding clearing items. Review both controls monthly. Checking should agree with the statement; clearing should agree with supported marketplace balances and timing items.

If that work is becoming repetitive, ClearPayout helps reconcile marketplace sales into QuickBooks Online through a settlement-based workflow. Explore the Amazon connection and ClearPayout pricing to assess the fit for your setup. Start with one supported payout, not a forced adjustment.