how do i reconcile in quickbooks online

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.

The concept is identical whichever product you're on. Whether you run QuickBooks Online or Desktop, reconciling means agreeing your ledger to an outside statement; only the screens and the undo options differ, and Desktop keeps a reconciliation report you can reprint while QBO stores yours under the reconcile history. Anyone moving between the two is learning a menu, not a method.

It helps to separate reconciliation from the bank feed, because QBO blurs the two. The bank feed pulls transactions in and suggests matches; reconciliation is the formal monthly checkpoint that says 'as of this date, these books and this statement agree.' Accepting bank feed matches all month doesn't replace reconciling. The feed can double-import, miss days, or match a deposit to the wrong entry, and the monthly reconcile is what catches it.

Before You Start: Three Things to Have Ready

A smooth reconciliation starts before you open the Reconcile screen. First, have the actual bank or card statement in front of you, PDF or paper. Don't reconcile against the bank feed itself; the statement is the independent source of truth, and using the feed as both the data and the check defeats the purpose.

Second, make sure the prior month was reconciled and finished. QBO reconciliations chain together: each one starts from the previous ending balance, so an unreconciled or broken prior month guarantees this month won't tie.

Third, if you sell on Amazon, decide where settlements live. Most e-commerce accountants set up a clearing account (a dedicated holding account in QBO) where the full settlement detail gets recorded: gross sales in, fees and refunds out. The net amount then transfers to checking, where it matches the bank deposit exactly. That one structural choice is the difference between reconciliations that take minutes and ones that take evenings.

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

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.

Reserves deserve a special mention because they break the timing, not just the categories. Amazon sometimes holds back part of a settlement (account-level reserves, unavailable balances) and releases it in a later payout. If your books recognize the full sales amount but the bank only received the net-of-reserve figure, you'll chase a phantom difference that's really just money Amazon is still holding. A clearing account absorbs this cleanly: the reserve sits as a balance in the clearing account until Amazon releases it.

A Worked Example: One Settlement, Reconciled

Say a hypothetical two-week settlement reports $10,000 in gross sales, $1,500 in referral fees, $1,800 in FBA fulfillment fees, $400 in refunds, a $120 reimbursement for lost inventory, and a $500 reserve holdback. Amazon deposits the net: $5,920.

The wrong way: book a $5,920 deposit to 'Amazon Sales.' Bank reconciles fine, and your P&L now understates revenue by $4,080 and shows zero fees. The right way: post a journal entry crediting sales $10,000 and reimbursement income $120, debiting fee expense $3,300 and refunds $400, with the $500 reserve staying in the clearing account and $5,920 moving to checking. When the bank feed shows the $5,920 deposit, it matches the transfer exactly. Difference: zero, and every number on the P&L is real.

Multiply that by twenty-six settlements a year, add a second marketplace or an eBay store, and you can see why doing this by hand gets old fast. The structure isn't hard; the volume is.

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. A useful shortcut: if the difference equals one transaction's exact amount, search for that amount. If it's double a transaction, you've likely got a duplicate. If it's a strange figure, check for two errors offsetting imperfectly.

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.

Every connected app is another thing to reconcile

Marketplace payouts get the blame, but any app writing into your ledger can break a reconciliation the same way. Take stock of your QuickBooks Online integrations before you go hunting for a mystery difference, because each one is a source of transactions you didn't type.

Card processors are the most common culprit after Amazon. Integrate Square with QuickBooks Online and you'll see the same net-deposit pattern: Square batches a day's sales, keeps its processing cut, and deposits the remainder, so a $1,000 sales day arrives as something less than $1,000 in the bank. Book the deposit as sales and your revenue is short by exactly the fees. Route it through a clearing account like you would an Amazon settlement and both the P&L and the bank line come out right.

Accounts payable tools behave differently and trip people in the opposite direction. A Bill.com integration with QuickBooks Online syncs bills and their payments, so the payment appears in QBO on its own. Enter it a second time from the bank feed and you've created a duplicate that will sit in your unreconciled list looking legitimate. Any bill pay review you do should start with the question of which system is the source of truth for a payment, not which one has the nicer approval workflow.

The same caution applies to imports. If you import sales receipts into QuickBooks Online from a spreadsheet or a third-party importer, check whether a connector is already posting those same sales, because two tools covering one channel is the fastest way to double your revenue on paper. Intuit-approved QuickBooks Online apps are reviewed for the integration, not for whether they overlap with the other five apps you've installed. Add one at a time and reconcile a full month before adding the next.

Common Reconciliation Mistakes to Avoid

A few habits cause most reconciliation pain, and they're all avoidable.

Forcing the difference to zero with an adjustment entry tops the list. It feels like finishing; it's actually burying an error that will resurface bigger next month. Second: reconciling from the bank feed instead of the statement, which lets feed glitches pass unchecked. Third: letting months pile up unreconciled, then trying to fix a year at once, where one early error cascades through every later period. Fourth, seller-specific: matching an Amazon deposit against individual order entries the bank feed imported, creating duplicates on top of your settlement journal.

Worth understanding before any of that: in QuickBooks Online, expense vs bill is not a style preference. An expense records money already gone, so it hits the bank account and shows up in your reconciliation. A bill records money owed, sits in accounts payable, and touches the bank only when you pay it. Sellers who enter a bill and then also enter an expense for the same supplier payment end up with the invoice paid twice in the books and a reconciliation that won't close. Same story with the check-versus-expense choice, where the only real difference is whether you're recording a check number.

One more subtle trap: editing or deleting a transaction in a closed, reconciled period while cleaning up your chart of accounts. QBO warns you, but the warning is easy to click through, and your next reconciliation opens with a beginning-balance discrepancy you don't remember causing. When that happens, run the reconciliation discrepancy report; it lists exactly which reconciled transactions changed.

Tools That Make Seller Reconciliation Automatic

Once you're past a handful of settlements a month, the sane move is an amazon quickbooks integration that posts each settlement as a broken-out entry automatically. This is a crowded, mature category: BeanHawk does it with inventory reconciliation and FBA reimbursement auditing attached, a2x quickbooks sync is the long-standing pure connector, and Link My Books plays the same role with its own approach. Any of the three beats manual journal entries.

When you evaluate quickbooks for amazon sellers setups, test one specific thing during the trial: post a real settlement, then reconcile the matching bank deposit. If the tool's entry matches your deposit to the penny on the first try, the mapping is right. If you're adjusting entries by hand to force a match, the configuration (or the tool) is wrong. Also check multi-channel support early; if eBay or Shopify is in your future, you want one system handling all payouts the same way rather than a different connector per channel.

The honest trade-off: if you're doing a few orders a week, software is overkill. A monthly manual journal entry from Amazon's settlement report takes twenty minutes and costs nothing. The switch point is when settlements stack up faster than you reconcile them, or when you stop trusting your own margin numbers. Good amazon bookkeeping isn't about the tool; it's about every deposit tying to a broken-out entry, however you get there.

There's a payoff beyond a tidy checkbox. Reconciled books are what make the rest of QuickBooks worth using: a budget vs actual report in QuickBooks Online only means something if the actuals have been proven against a statement, and the same goes for margin by SKU, cash forecasts, and anything you hand an accountant. Reconciliation is the step that turns bookkeeping into information.