Reconciling is a QuickBooks screen with a checkbox per transaction, and it stays there. No assistant ticks those boxes for you. What changes when your books are connected to one is the twenty minutes on either side of that screen. Before you start, a pass that turns up the duplicate expense and the customer payment still sitting in Undeposited Funds. Afterwards, help reading the mess when the difference refuses to go to zero. The steps below come from Intuit's own help article. The prompts are the part you can hand off.
To reconcile an account in QuickBooks Online, start with the bank or credit card statement for the period, and make sure every transaction in that period is entered and categorized. Go to All apps, then Accounting, then Reconcile. Select Reconcile, or Get started the first time. Choose the account from the Account dropdown, check the Last statement ending date, then enter the Ending balance and Ending date from your statement and select Start reconciling. Compare the list on screen against the statement and tick the checkbox beside each transaction that appears on both. The Cleared balance moves as you tick. When the Difference reads 0.00, select Finish now, then Done. QuickBooks saves a reconciliation report, which you reach from History by account on the Reconcile page. When the difference will not close, the cause is normally a missing, duplicated or wrongly dated transaction rather than an arithmetic mistake.
The QuickBooks steps, in order
| # | Where | What you do |
|---|---|---|
| 1 | Before you open anything | Have the statement for the period. Every transaction in it is entered and categorized in QuickBooks |
| 2 | All apps, then Accounting, then Reconcile | Select Reconcile, or Get started if this is the file's first reconciliation |
| 3 | The Account dropdown | Pick the account. Check the Last statement ending date: your statement should start the day after it |
| 4 | Ending balance and Ending date | Copy both off the statement, then select Start reconciling |
| 5 | The matching list | Tick each transaction that also appears on the statement. The Cleared balance moves as you go |
| 6 | The Difference figure | Keep going until it reads 0.00. Edit info reopens the ending balance and date if you typed one wrong |
| 7 | Finish now, then Done | QuickBooks writes the reconciliation report for that period |
Two notes from Intuit's article that save time. If the account is connected to a bank feed, QuickBooks enters the starting balance and downloads the transactions itself, so some accounts arrive already balanced. And there is an optional step 6 in Intuit's own numbering: you can upload the statement file for its AI-powered reconciliation, which Intuit says may take up to an hour to verify.
The pass before you open the reconcile screen
A bank reconciliation in QuickBooks Online rarely fails on the screen itself. Almost everything that goes wrong there was already wrong before you got there. These questions run on a read-only connection, which is what every Caribooks connection starts as, so nothing here can change your books.
"List every transaction in the chequing account between 1 and 31 August 2026: date, type, number, name, amount, and whether it is cleared."
Look at the count first. If the ledger holds 180 lines for a statement with 140, you have 40 differences to explain and the reconcile screen is the slowest possible place to find them.
"In that list, flag any likely duplicates: same name, same amount, within five days of each other."
The classic pair is one transaction entered by hand and the same one accepted again from the bank feed. On the reconcile screen it looks like two legitimate lines, and ticking the wrong one balances the month while leaving the expense doubled.
"What is the balance of Undeposited Funds today, and which payments make it up?"
Payments recorded against invoices but never grouped into a deposit. The bank shows one lump and the ledger shows five payments, so nothing matches and the difference sits there.
"Which deposits in August group more than one payment? Give me each deposit total and the payments inside it."
So you tick the deposit rather than hunting for individual invoices that will never appear on the statement.
"Anything in the chequing account dated in August but created or modified after 1 September?"
A backdated entry is the usual reason a month that balanced last week stops balancing today.
"What is still uncleared in the chequing account from before 1 August, with dates and amounts?"
Stale cheques and old feed items. Anything more than a few months old is either genuinely outstanding or a mistake nobody ever cleaned up.
"Bank charges, interest and returned payments posted to the chequing account in August."
These are the small statement lines that originate on the bank's side and were never entered. They are the most common cause of a difference under fifty dollars.
Under the hood these are ordinary reports. get_transaction_list accepts a cleared filter with the values Cleared, Uncleared and Reconciled, and returns an is_cleared column, which is what lets the assistant answer the last question without guessing. Deposits and detail come from search_deposits and get_general_ledger.
Example output, on a fictional company
Studio Nord is a six-person design studio in Montréal. Here is the pre-reconcile pass on its chequing account for August 2026, before anyone opened the reconcile screen.
| Flag | Detail | What it was |
|---|---|---|
| Undeposited Funds | 6,780.00 across four payments | Three customer payments from 28 to 30 August never grouped into a deposit |
| Likely duplicate | Imprimerie Hochelaga, 1,240.00, on 12 and 14 August | Entered by hand, then the bank feed item was accepted a second time |
| Grouped deposit | 9,150.00 on 21 August, four invoices inside | Matches one statement line. Tick the deposit, not the invoices |
| Created after the fact | Journal entry dated 31 August, created 9 September | Backdated depreciation. Legitimate here, but it moved the closing balance |
| Uncleared since May | Cheque 1042, 480.00, Papeterie Duval | Never presented. Still outstanding, so it stays unticked |
| On the statement only | Bank charges 42.50 on 30 August | Never entered in QuickBooks |
Four of those six needed a fix, which took about ten minutes in QuickBooks. The reconcile itself then closed at 0.00 on the first attempt. That is what the pre-pass buys you.
Then you tick the boxes
There is no reconcile tool in the connector. The reconciled flag is set on that screen and nowhere else, so the ticking is yours. What the assistant gave you is a shorter list to tick and a reason for each line that will not match.
The QuickBooks reconciliation report
QuickBooks saves a report for every finished reconciliation. You get to it from the Reconcile page by selecting History by account. That report is not one of the reports the connector can pull, so the way to use it in a conversation is to export it and paste or attach it there.
"This is the reconciliation report for the chequing account, August 2026. The difference is 412.50. Compare the uncleared items against the ledger and tell me which single item or pair adds up to that."
Two arithmetic checks are worth asking for by name, because they are boring and instant. A difference that is exactly twice a transaction on your list means that transaction was entered with the wrong sign. A difference divisible by 9 usually means two digits were transposed somewhere.
Fixing a QuickBooks reconciliation discrepancy
QuickBooks checks the beginning balance before it lets you start, and it should equal the ending balance of your last reconciliation. When it does not, you get stopped. Intuit's path to the cause: go to All apps, then Accounting, then Reconcile, pick the account, then find the alert saying your account is not ready to reconcile yet and your beginning balance is off, and select We can help you fix it. That opens the Reconcile Discrepancy Report, which lists what changed, when, and who changed it.
Write down the exact amount you are off by first. Whatever you find should add up to it.
Two kinds of change never show up on that report. Deleted and voided transactions, which you find under Settings, then Audit log, filtered to the account and to the period since your last completed reconciliation. And transactions marked R outside a reconciliation, which you find by opening the account register from Chart of accounts and filtering on Reconcile status.
This is where a connected assistant earns its keep, because it can work the ledger side while you read the report:
"List every transaction in the chequing account created or modified since 15 August, with the amount, who touched it, and when."
Look for amounts matching your discrepancy, alone or in pairs. Intuit is explicit that only a change made in error should be reversed, and plenty of what the report flags was deliberate. The assistant finds the candidates. Whether an edit was a mistake is your call, and when the fix reaches into a closed period, it is your accountant's.
How to undo a reconciliation in QuickBooks Online
The honest answer is short, and it starts with a warning from Intuit's article on undoing a reconciliation: undoing is irreversible, and it permanently deletes the reconciliation report and anything attached to it. Download what you want to keep first.
To unreconcile one transaction, go to All apps, then Accounting, then Chart of accounts, select View register on the account, find the line and select it, then select the box in the checkmark column repeatedly until it is blank. The status cycles from R to C to blank. Select Save. Intuit warns that this changes the beginning balance of your next reconciliation, so be sure you have the right line before you clear it.
To undo a whole reconciliation, sign in as the Primary Admin, go to All Apps, then Accounting, then Reconcile, select History by account, find the reconciliation, and in the Action column pick Undo from the dropdown. Read the warning, tick the checkbox, select Undo reconciliation, then Done.
No assistant does either of these, ours included. Before you undo a month, ask what actually broke. It is usually one edited transaction, and unreconciling four weeks of work to reverse it is a bad trade.
Where this is the wrong tool
One bank account and forty transactions a month. The reconcile screen is already a five-minute job. A pre-pass is ceremony.
Books that are months behind. Categorizing comes first, and reconciling only makes sense once the period is posted. Start with a month of expenses and come back afterwards.
The ticking itself. If what you want is for something to tick the boxes and finish the reconciliation, no connector does that, because the reconciled flag lives on that screen. Read the month-end close checklist for what does move to a conversation.
QuickBooks Desktop. Online only, structurally, because Desktop has no API to connect to.
If nothing is connected yet, start here. Every prompt above runs on read-only access, which is what a connection starts with, so you can run a full pre-reconcile pass before deciding whether write access is worth switching on. The rest of what the connector reads is on the QuickBooks MCP page.