Learn · Accounting & bookkeeping
how to unreconcile in quickbooks online
Short answer
To unreconcile a single transaction in QuickBooks Online, open the register, find the transaction, and click the checkmark in the reconciled (R) column until it clears. To undo an entire reconciliation period, you need QuickBooks Online Accountant's 'Undo Reconciliation' tool, or you must manually uncheck every transaction from that statement one by one.
By Marcus Brandt · Head of Seller Accounting
Updated July 20, 2026
Reconciliation mistakes are common once your books mix bank feed transactions with batched Amazon settlement deposits, and unwinding a bad reconciliation in QuickBooks Online isn't as obvious as clicking one button. This guide walks through both the single-transaction fix and the full-period undo, plus why Amazon sellers hit this problem more often than most small businesses.
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.
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?
How to unreconcile a single transaction
This is the most common scenario and the easiest to fix without any special tools or accountant access.
- •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.
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
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.
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.
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. 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.
Frequently asked questions
- Can I unreconcile in QuickBooks Online without an accountant login?
- Yes, for individual transactions — just click the R in the register to clear it. For a full-period undo, the native tool is only available through a QuickBooks Online Accountant user, so you'd need to invite one or handle it manually line by line.
- Will unreconciling change my bank balance?
- Unreconciling doesn't change actual transaction amounts, but it does affect your reconciled beginning/ending balance for that period, since the transaction (or whole batch) is no longer counted as matched. You'll need to re-run the reconciliation afterward to confirm everything still ties out.
- Does unreconciling delete the transaction?
- No. Unreconciling only removes the reconciled status; the transaction stays in your books exactly as recorded. You then edit, recategorize, split, or delete it separately if that's what actually needs fixing.
- Why does this matter more for Amazon sellers than other small businesses?
- Because Amazon settlement deposits bundle many transaction types into one bank line, sellers are far more likely to reconcile a deposit before its components (fees, refunds, ad spend, reserves) are split out correctly, forcing a later unreconcile-and-fix cycle that simpler businesses rarely hit.
- Should I fix the categorization before or after unreconciling?
- Unreconcile first, then fix the categorization or splits. Editing a reconciled transaction directly can throw off your reconciled balance in ways that are harder to trace than simply undoing the status first and rebuilding the reconciliation afterward.
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.