how to unreconcile in quickbooks online

Why sellers end up needing to unreconcile

For most small businesses, a bank reconciliation is a clean 1:1 match between the bank feed and the ledger. For Amazon sellers, it isn't. A single Amazon settlement deposit can bundle sales, refunds, FBA fees, advertising spend, storage charges, and reserve holds into one number that hits your bank account. If that lump sum gets matched to the wrong invoice, categorized as pure revenue, or reconciled before the settlement is broken out into its components, your reconciled balance looks fine on the surface while the underlying detail is wrong.

This isn't a small-business edge case. Third-party sellers account for more than half of the physical gross merchandise sold on Amazon, which means a huge share of QuickBooks users are reconciling multi-line marketplace payouts, not simple checks and deposits. Add sales tax complexity from marketplace facilitator laws now covering nearly every state with a sales tax, and it's easy to see why reconciled periods for e-commerce sellers need correction more often than a typical service business.

Here's a hypothetical version of the classic blowup. Say Amazon deposits $8,240 on March 14. That deposit actually represents $10,100 in sales, minus $1,420 in referral and FBA fees, minus $310 in refunds, minus $130 in ad spend. A bookkeeper matches the $8,240 to a 'Sales' entry, reconciles March, and moves on. The bank reconciles perfectly. Meanwhile revenue is understated by $1,860, expenses are missing entirely, and gross margin is fiction. When the mistake surfaces during tax prep, every settlement in the reconciled period has to be unwound and rebooked, which is exactly the situation this article exists for.

The fix depends on scope: are you correcting one bad transaction inside an otherwise-correct reconciliation, or do you need to blow up an entire month and start over?

Before you unreconcile anything: three preparation steps

First, print or save the reconciliation reports for every period you might touch. Go to the Reconcile page, open History by account, and export the reports. Once you undo a reconciliation, that report is your only record of what the period looked like when it balanced, and you'll want it when rebuilding.

Second, write down the current beginning balance for the account and the statement ending balances for each affected period. Undoing reconciliations shifts the beginning balance backward, and if you're unwinding several months, it's easy to lose track of which statement you're rebuilding toward.

Third, figure out the root cause before unwinding. If one deposit was miscategorized, you need the single-transaction fix. If the beginning balance was wrong from the start, or a batch of settlement deposits was booked as lump-sum revenue for months, you're looking at a full-period undo, possibly several. Unwinding three months to fix a problem that lived in one transaction is wasted work; unpicking one transaction when the whole period is rotten just delays the real repair.

How to unreconcile a single transaction

This is the most common scenario and the easiest to fix without any special tools or accountant access. Typical triggers: a settlement deposit was matched to the wrong open invoice, a transfer between your own accounts got booked as income, or a duplicate from the bank feed slipped through and both copies ended up reconciled.

Note what happens the moment you clear that R. QuickBooks will flag a beginning balance discrepancy on the account equal to the amount you unreconciled, and the warning stays until the transaction is either marked reconciled again or picked up in your next reconciliation. That's expected behavior, not a new problem, so don't 'fix' it with an adjustment entry mid-repair. The steps:

• •Go to Accounting > Chart of Accounts, find the bank or credit card account, and click 'View register.'
• •Locate the transaction. Reconciled items show an 'R' in the checkmark column; cleared-but-unreconciled items show a 'C'.
• •Click directly on the R in that column. It will cycle from R to blank (or to C, depending on your setup); that single click unreconciles just that line.
• •Fix the underlying issue: recategorize the transaction, split it to match the Amazon settlement detail, or delete and re-enter it correctly.
• •Re-add it to the next reconciliation, or manually mark it R again once you're confident it's accurate.

How to undo an entire reconciliation period

If a whole month's reconciliation was built on a bad starting balance or a batch of misclassified settlement deposits, unchecking transactions one at a time is slow and error-prone. QuickBooks Online Accountant has a built-in tool for this. Go to the Reconcile page, open the Reconcile History/Reports section, find the period, and use the 'Undo' action next to it. This reverts every transaction in that reconciliation back to unreconciled in one step, restoring the prior beginning balance.

Only accountant users (or a firm with QBOA access to your books) have this tool natively in the base product. If you're on a standard QuickBooks Online subscription without an accountant attached, your options are: invite an accountant user (even temporarily) to run the undo, or go through the register and manually click off every R for that statement period, then correct the beginning balance figure. Either way, do this before you touch the transactions themselves. Undo the reconciliation status first, then fix the categorization or splits underneath.

Worth knowing if you've used the other product: this is one area where QuickBooks Online or Desktop genuinely differ. Desktop lets any user undo an entire reconciliation from the Reconcile window without an accountant license, which is why longtime Desktop users are surprised the cloud version gates it. Same accounting, different permissions model.

One rule that saves a lot of grief: reconciliations stack. If you need to undo February, and March and April are already reconciled on top of it, undo April first, then March, then February. Reaching into the middle of the stack (or editing a reconciled transaction from months ago) is how beginning-balance discrepancies are born. Work backward, fix the problem period, then re-reconcile forward month by month, checking that each period's ending balance matches its bank statement before starting the next.

After the undo: rebuilding without new mistakes

With the period unwound, resist the urge to bulk-fix. Correct transactions one settlement at a time: split each Amazon deposit into its components (gross sales, refunds, referral fees, FBA fees, advertising, reserves) using the settlement report from Seller Central as your source of truth, not the bank amount. When the splits are right, the deposit total will still equal the bank line to the penny, and the reconcile screen will match it cleanly.

If QuickBooks shows a beginning balance discrepancy after your undo, don't force it with an adjusting entry. Open the discrepancy report (the link appears next to the warning), which lists exactly which transactions were changed or deleted while reconciled. Fix those at the source. Reconciliation adjustment entries are a last resort because they hide problems rather than solve them, and they compound: an adjustment this month means next month's reconciliation starts from a number nobody can explain.

It's not only deposits that cause this, either. Deleting a reconciled transaction is the single most common source of a beginning balance discrepancy, and it usually happens innocently: someone spots a duplicate supplier charge and uses QuickBooks Online delete bill on a bill that was already reconciled, or removes an expense that looked wrong. The transaction vanishes from the register; the reconciliation report still counts it. Unreconcile first, then delete or edit. Bulk imports deserve the same caution. If you import expenses into QuickBooks Online from a spreadsheet while the bank feed is also pulling the same charges, you get duplicate pairs, and the ones that slip into a reconciled period have to be unpicked the same slow way. It also pays to be deliberate about QuickBooks Online expense vs bill when you record these: a Bill sits in accounts payable until it's paid and reconciles through the payment, while an Expense reconciles directly against the bank line. Mixing the two for the same purchase is how the same cost gets counted twice.

Budget real time for this. Rebuilding one month with weekly settlements is an afternoon. Rebuilding six months of lump-sum-booked marketplace deposits across Amazon, eBay, and Shopify is a multi-day project, and it's often worth handing to a bookkeeper who's done marketplace cleanups before, then keeping the maintenance yourself once the books are clean.

Avoiding repeat unreconciles on Amazon settlement deposits

The real fix isn't a faster undo, it's not needing one. Most reconciliation blowups for sellers trace back to treating a settlement deposit as a single revenue line instead of breaking it into sales, refunds, fees, ads, and reserves before it ever hits the bank feed. Once that habit is in place, reconciliation becomes routine matching instead of forensic accounting.

Check your bank rules while you're at it, because they quietly cause repeat offenses. Rules in QuickBooks Online are built to auto-assign categories to recurring transactions, which is a gift for a utility bill and a trap for marketplace payouts: a rule that files every deposit containing "AMZN" as Sales will keep recreating the exact error you just spent an afternoon undoing. Exclude your marketplace deposits from auto-categorization entirely, or point the rule at your clearing account instead of an income account. Do the same for a refund on QuickBooks Online that arrives as a separate deposit, since those get auto-filed as income more often than anything else.

This is also where 1099-K and sales tax reporting quietly compound the damage. The IRS's third-party platform reporting threshold has been phasing down from the old $20,000/200-transaction level, so more sellers now get a 1099-K that has to tie back to books that were never split correctly in the first place; verify the current threshold before you file. Sort out settlement detail at the source and reconciliation, tax filing, and 1099-K reconciliation all get easier at once.

Tools built specifically for marketplace accounting handle this automatically, pulling each settlement apart into the right ledger lines before it ever reaches your bank feed. A proper amazon quickbooks integration posts each settlement as a summarized, balanced journal entry, so the deposit in your bank feed matches a ready-made entry instead of a mystery lump. Amazon accounting software that syncs to QuickBooks & Xero does exactly that, so what lands in QuickBooks is already reconciliation-ready instead of one lump sum you have to decode after the fact.

When you evaluate options to connect amazon to quickbooks, test three things with a real settlement: does the posted entry tie to the deposit to the penny, does it separate refunds and reserves from fees, and does it handle a settlement that spans a month-end? A2X pioneered this category (a2x quickbooks summaries are the reference point most sellers compare against), Link My Books and BeanHawk compete on the same job, and the same logic applies to an ebay quickbooks integration or a shopify quickbooks integration if you sell on multiple channels. Multi-channel sellers should insist on one tool covering all channels; two different connectors with two different posting styles is how the next reconciliation mess starts. The same test applies to any other feed touching the same bank account, so if you integrate Square with QuickBooks Online for in-person sales alongside your marketplace connectors, check that its payouts post as summaries rather than per-order lines. When you're shopping, start from the Intuit-approved QuickBooks Online apps list: approved integrations get reviewed and tend to survive API changes, and an app that breaks silently mid-month is a reconciliation problem waiting to happen.