Learn · Accounting & bookkeeping
how do i reconcile in quickbooks online
Short answer
To reconcile in QuickBooks Online, go to Settings > Reconcile, pick the account and statement ending date/balance, then check off transactions until the difference shows $0.00. For Amazon sellers, this only works cleanly if your Amazon payouts are first broken into sales, fees, refunds, and reserves — not dumped in as one lump deposit.
By Marcus Brandt · Head of Seller Accounting
Updated July 18, 2026
Reconciling in QuickBooks Online is the process of matching your books to your actual bank statement so you can trust the numbers you're looking at. For most small businesses it's a five-minute monthly chore. For Amazon sellers it's often the single most frustrating task in QBO, because a single Amazon settlement deposit can bury dozens of fee types, refunds, and reserve holds that never match a clean bank line item.
What 'Reconcile' Actually Means in QuickBooks Online
Reconciling isn't about categorizing transactions — it's about proving that every dollar that hit your bank account is recorded in QuickBooks, and nothing is missing or duplicated. QBO compares your book balance against a statement balance you enter, and you check off cleared transactions until both numbers agree to the penny.
If they don't agree, QuickBooks isn't broken — it's telling you something in your books doesn't match reality. That's usually a missing deposit, a duplicate entry, or (for sellers) an Amazon payout that got recorded as raw revenue instead of being split into its components.
Step-by-Step: How to Reconcile an Account
The mechanics are the same whether you're reconciling a checking account, credit card, or a merchant clearing account you use for Amazon.
- •Go to Settings (gear icon) > Tools > Reconcile
- •Choose the account, then enter the statement ending date and ending balance from your actual bank or card statement
- •Check off every transaction in QBO that appears on the statement
- •Watch the 'Difference' field — it must hit $0.00 before you finish
- •If it doesn't zero out, look for a transaction on the statement that's missing from QBO, or one in QBO that's duplicated or dated wrong
- •Click 'Finish now' only once the difference is zero — this locks the period so past transactions can't be edited without a warning
See it in BeanHawk
Every settlement becomes one clean journal
BeanHawk parses each marketplace payout line by line and posts a single summarized journal to QuickBooks or Xero — sales, fees, refunds, facilitator tax, and reimbursements mapped to the right accounts, balanced to the penny.
- ✓Debits equal credits or it won't post — no more deposits booked as revenue
- ✓Marketplace facilitator tax routed to a liability account, out of your income
- ✓The net deposit lands in a clearing account that matches your bank feed exactly
Why Amazon Sellers' Reconciliations Never Balance
Amazon doesn't deposit your revenue — it deposits a net settlement every two weeks that mixes product sales, referral fees, FBA fees, refunds, reimbursements, advertising spend, and reserve holdbacks into one bank line. If you record that single deposit as 'Sales' in QuickBooks, your bank reconciliation will technically balance (the deposit amount matches), but your income statement will be wrong — fees get lost inside revenue, and you can't see true margin.
This matters more than it used to. Third-party sellers now account for more than half of the physical gross merchandise sold on Amazon, and the accounting complexity scales with that volume — fee structures, reserves, and reimbursement timing all touch the same settlement deposit you're trying to reconcile.
The fix is to record each Amazon settlement as a journal entry (or import) that breaks out gross sales, each fee category, refunds, and reserves separately, so the net deposit still ties to the bank statement but your P&L reflects reality. This is exactly the gap Amazon accounting software that syncs to QuickBooks & Xero is built to close — it maps settlement data into QBO-ready entries automatically instead of one lump sum.
When to Reconcile — and What to Do When It Won't Balance
Reconcile every bank and credit card account monthly, right after your statement closes. Waiting quarterly or annually means small errors compound and become much harder to trace back to a single transaction.
If the difference isn't zero, don't force it by adding a plug entry — that hides the real problem. Instead, sort by amount and compare line by line against the statement; the culprit is almost always a missing deposit, a transaction entered twice, or a date that rolled into the wrong period. Reconciliation discrepancies around tax collection are also worth double-checking given how sales tax rules have shifted: since the Supreme Court's South Dakota v. Wayfair decision, states can require tax collection based on economic nexus, and nearly all states with a sales tax now have marketplace facilitator laws requiring Amazon itself to collect and remit — meaning tax amounts inside your settlement shouldn't flow through your P&L as your own liability.
Frequently asked questions
- Why won't my QuickBooks reconciliation balance?
- Almost always it's a missing transaction, a duplicate entry, or a wrong date on a deposit or payment. Sort the unreconciled list by amount and compare it side-by-side with your bank statement — the mismatch is usually one specific transaction, not a systemic error.
- Should I reconcile my Amazon settlement deposits like a bank account?
- Yes, but only after the settlement has been broken into its components — sales, fees, refunds, reserves. If you reconcile against a single lump deposit recorded as 'sales,' the bank reconciliation will pass but your income statement will be inaccurate.
- How often should I reconcile in QuickBooks Online?
- Monthly, tied to your bank and credit card statement cycles. Reconciling less often makes errors harder to trace and increases the chance you'll need to reopen closed periods.
- Can I edit a transaction after I've reconciled it?
- You can, but QuickBooks will warn you that it affects a reconciled period, and doing so will throw off your next reconciliation. If you must fix something, it's cleaner to add an adjusting entry in the current period instead.
- Does reconciling affect what I owe for sales tax or 1099-K reporting?
- Indirectly, yes — clean reconciliations mean your recorded sales and fee totals are trustworthy inputs for tax filings. Note the IRS 1099-K reporting threshold for platforms like Amazon has been changing and phasing in recent years, so check the current IRS guidance rather than assuming the old $20,000/200-transaction rule still applies.
See what Amazon owes you — free
Connect your seller account and get a free reimbursement audit. No credit card, keep 100% of what you recover.