How to Reconcile in QuickBooks Online: QuickBooks Bank Reconciliation From PDF Bank Statements
A reconciliation is only ever as good as what is already in the register. Most of the time people lose to reconciling, they are not making arithmetic mistakes, they are ticking off a statement against months QuickBooks never received. PDFQBO turns those PDF statements into QBO files QuickBooks imports, so the transactions exist before you open the Reconcile screen.
Quick answer
To reconcile in QuickBooks Online, open Transactions then Reconcile, choose the account, and enter the ending balance and ending date exactly as they appear on your bank statement. Tick off every transaction in QuickBooks that also appears on the statement until the difference reads 0.00, then select Finish now. Two conditions decide whether that takes five minutes or an afternoon. The beginning balance QuickBooks shows has to match the statement, and every transaction printed on the statement has to already exist in the register.
Last updated August 2026
Get the missing months into QuickBooks
Upload a PDF bank statement and download a QBO file you can reconcile against.
No credit card required to try your first statement.
How do I reconcile in QuickBooks Online?
Reconciling is a comparison, not a calculation. You are holding one month of bank statement next to the same month in QuickBooks and confirming that the two agree line for line. QuickBooks does the running total for you. Your job is to decide, for every line on the statement, whether QuickBooks already knows about it.
Get the statement and the register to cover the same month
Download the PDF statement for the period you are reconciling. If the account was never connected, or the feed did not reach that far back, convert the statement and import it before you go any further. Reconciling against a half-empty register is the single most common way people waste an evening.
Open Reconcile and choose the account
Go to Transactions and then Reconcile. Newer QuickBooks Online layouts put it under All apps, then Accounting, then Reconcile. Pick the bank or credit card account that matches the statement in front of you, not a similarly named one.
Check the beginning balance before you type anything
QuickBooks shows a beginning balance it worked out from everything already marked reconciled. It should equal the opening balance printed on the statement. If it does not, stop and fix that first, because nothing you do further down will make the month close.
Enter the ending balance and ending date
Copy both from the statement exactly. A statement that runs to the 3rd of the following month ends on the 3rd, not on the last day of the month, and using the wrong date is a quiet way to leave several transactions stranded.
Tick off what appears on both sides
Work down the statement rather than down the QuickBooks list, because the statement is the authority. Sorting the QuickBooks side by amount rather than date makes matching much faster once you are past a dozen or so lines. Anything on the statement with nothing to tick is a transaction you still need to enter.
Finish at a difference of 0.00
When the difference reads zero, select Finish now. QuickBooks marks every ticked line with an R and saves a reconciliation report you can reopen later. If the difference is not zero, the section below is the order to work through.
A monthly rhythm is what keeps this cheap. Reconciling twelve statements in December means twelve chances for one bad month to poison every month after it, and no memory of what any of the odd transactions were. If you have inherited a file that is a year behind, the QuickBooks cleanup and catch up workflow is the faster way in, because it rebuilds the register first and reconciles afterwards.
Why is my beginning balance wrong in QuickBooks Online?
Because the beginning balance is not stored, it is calculated. QuickBooks adds up everything currently marked reconciled in that account and shows you the result. So a beginning balance that was right last month and is wrong this month means something already reconciled has since been changed, deleted, moved to a different account, or had its R removed. QuickBooks flags this with a message that your account is not ready to reconcile yet, and offers a link to the reconciliation discrepancy report.
That report is the fastest diagnostic in QuickBooks and most people never open it. It lists every reconciled transaction that has been touched since it was reconciled, and a Change Type column telling you what was done to it. Work down the report until the total discrepancy reads zero and the beginning balance repairs itself.
| What the discrepancy report says | What actually happened | How to put it back |
|---|---|---|
| Amount changed | Someone edited the total on a transaction after it had been reconciled, usually while cleaning up a category. | Open the transaction and restore the amount the bank actually cleared. If the new amount is the correct one, the original entry was wrong and the difference belongs in the current period, not in a closed month. |
| Deleted | A reconciled transaction was removed from the file, often as part of clearing what looked like a duplicate. | Re-enter it with its original date and amount, then mark it reconciled in the register so it rejoins the closed month. |
| Account changed | The transaction was recategorized into a different bank or credit card account, so it left the account you are reconciling. | Move it back to the account it cleared in. If it genuinely belonged elsewhere, both accounts now need their beginning balances rechecked. |
| Reconcile status removed | The R was cleared directly in the register, either deliberately or by clicking through the status column by accident. | Click the status field back to R. Nothing else about the transaction needs to change. |
| Nothing listed, balance still off | The problem is not an edit. Either the very first reconciliation started from a wrong opening balance, or a whole period was never entered. | Check what the account opened with, then confirm every month between then and now was actually reconciled. Gaps in the register, not edits, are the usual answer. |
If the trouble goes back to the day the account was created rather than to a recent edit, the balance is probably sitting in the wrong place on the balance sheet. Opening Balance Equity and a wrong opening balance after a QBO import both produce a beginning balance that will never match, no matter how carefully you tick.
What do I do if my reconciliation doesn't balance?
Read the difference itself before you start hunting. The number QuickBooks leaves on screen usually describes the mistake, and recognizing the shape of it turns a line-by-line search into a thirty second fix. Below are the patterns worth checking in order, from the ones that take seconds to the ones that mean a transaction is genuinely missing.
| The difference looks like | It almost always means | Where to look |
|---|---|---|
| It divides evenly by 9 | Two digits were typed the wrong way round. A 54 entered as 45 leaves a difference of 9, and 1,200 entered as 2,100 leaves 900. | Scan the amounts for a pair of transposed digits rather than looking for a missing line. The transaction is there, it is just wearing the wrong number. |
| It is exactly twice an amount on the statement | That transaction is posted in the wrong direction. A deposit entered as a payment moves the balance by double its own value. | Halve the difference, find that amount on the statement, and check whether QuickBooks has it as money in or money out. |
| It matches one amount on the statement exactly | That single transaction is either missing from QuickBooks or entered twice. | Search the register for the amount. No result means it was never entered. Two results mean the bank feed and a manual entry both created it. |
| It is small and shows up every month | A recurring bank charge or interest credit that nobody enters because it never appears in an invoice or a bill. | Read the last few lines of the statement, where maintenance fees, wire charges and interest normally sit. |
| It changes each time you reopen the screen | Transactions in the period are still being edited, imported or recategorized while you reconcile. | Finish the categorization work first, then reconcile against a register that has stopped moving. |
| It equals the whole statement's activity | The month is simply not in QuickBooks. This is normal for any period before the account was connected. | Convert the statement to a QBO file, import it, then reconcile the month you now actually have. |
There is one option worth naming so you can decline it. QuickBooks will let you finish a reconciliation that does not balance by posting an adjusting entry for the difference. It closes the month, and it hides the error rather than resolving it, leaving an unexplained figure in your books that an accountant will eventually ask about. Use it only for genuinely trivial rounding on an account you are about to close, never as a way past a difference you have not identified. A longer walkthrough of the hunt lives in fixing a QuickBooks reconciliation that will not balance.
How do I reconcile a month my bank feed never downloaded?
You import it from the statement. A bank feed is a convenience for the present, not an archive of the past. When you connect an account, most banks hand QuickBooks somewhere around ninety days of history, and some hand over considerably less. Everything before that point never arrives, and no amount of refreshing or disconnecting and reconnecting will produce it.
That gap is invisible until you try to reconcile. The current month closes fine, so the file looks healthy. Then you go back to reconcile the first quarter, or an accountant asks for the year, and the register simply stops at a date. The statements themselves are the missing data, and they are already sitting in online banking as PDFs.
Converting them is the shortest route. Upload the PDF, review the transactions the converter has read, and download a QBO file that QuickBooks accepts through the same File Upload path it uses for any bank download. The transactions land in For Review, you categorize them like any other batch, and the month becomes reconcilable. Because you review the output before it posts, this is not a black box: you see what is going into the file first. If you are handling several entities at once, the multi-company statement import workflow covers keeping the files straight across clients.
One habit saves repeated trouble here. Download the statements as they are issued, every month, and keep them with the books, even for accounts that feed cleanly today. Feeds break, banks get acquired and change their connection, and the ninety day window is unforgiving about the months you did not think you would need. The statement is the only copy of the record that the bank guarantees.
How do I reconcile a credit card in QuickBooks Online?
The mechanics are identical, but the signs are reversed and that trips people up. On a credit card the ending balance is what you owe, so charges increase it and payments reduce it. Enter the closing balance from the card statement as a positive number and let QuickBooks handle the direction.
Two card-specific items belong in the register before you start: the interest charged for the period and any annual or late fee. Neither arrives as a bill and neither is anyone's expense to approve, so they routinely go unentered and leave a small stubborn difference. At the end, QuickBooks offers to record the payment you made against the card. If that payment already exists in the checking account register, decline, or you will create it twice.
Reconciling a business credit card goes through a full card month, including multiple statements at once.
How do I undo a reconciliation in QuickBooks Online?
Undoing an entire reconciliation in one action is a QuickBooks Online Accountant feature. Working from a client file opened through Accountant, you reach it under Reconcile, then History by account, then Undo in the Action column. A standard QuickBooks Online user does not get that button and has to clear the reconciled status transaction by transaction in the register instead.
Before you undo anything, be sure you need to. Undoing removes the reconciliation report and any attachments saved with it, and because the beginning balance is recalculated from whatever is still marked reconciled, every later month is affected too. A single misposted transaction is usually better fixed on its own.
How to undo a reconciliation in QuickBooks Online covers both paths step by step, including what happens to the months after the one you undo.
Who runs into this
Bookkeepers taking on a new client
The file arrives reconciled through some month nobody can name, and the feed will only reach back a quarter. The statements are the only way to establish where the account actually stood.
Businesses that changed banks
The old account stops feeding the day it is closed, but its final months still have to be reconciled before the balance sheet is right.
Anyone reconciling a prior year
Tax work, a loan application or a review all reach back past what any feed holds, and every one of those months has to tie to a statement.
Accounts that never connected
Small local banks, credit unions and some business card products have no working feed at all, so every month is a manual import from the start.
Frequently asked questions
What does reconcile mean in QuickBooks?
Reconciling means proving that the account in QuickBooks matches what the bank says happened. You compare one statement period against the same period in the register, confirm every transaction appears on both sides, and end with a difference of zero. Once a month is reconciled, its transactions are marked R and the balance for that date is trustworthy enough to build a financial statement on.
How often should you reconcile in QuickBooks?
Once a month, for every bank and credit card account, as soon as the statement is issued. Monthly is the right interval because it matches how banks report and keeps each investigation small. Quarterly or annual reconciling is common and costs more than it saves, since a single error early in the year silently breaks every period that follows it.
What is the difference between a bank feed and a reconciliation?
A bank feed brings transactions into QuickBooks. A reconciliation proves the result is complete and correct. Feeds miss items, duplicate them, and stop reaching back after roughly ninety days, so accepting everything a feed downloads is not the same as agreeing with the bank. Reconciling against the statement is the check on the feed, which is why it stays necessary even on a fully connected account.
Can you reconcile in QuickBooks Online from a PDF bank statement?
Yes, and for older periods it is often the only option. QuickBooks cannot read a PDF directly, so you convert the statement into a QBO file, import it through File Upload, and reconcile against the transactions that arrive. The reconciliation itself is identical to one done on feed data. The difference is only in how the transactions got into the register.
What does the R mean in QuickBooks?
R means the transaction has been through a completed reconciliation. C means cleared, which is what a downloaded transaction gets before anyone has reconciled it, and a blank status means neither. QuickBooks builds each new beginning balance from the R transactions only, so changing something marked R is what breaks a reconciliation that closed cleanly last month.
What is a reconciliation report in QuickBooks?
It is the saved record of a finished reconciliation, listing the statement dates, the beginning and ending balances, and every cleared and uncleared transaction as of that moment. You reach it from Reconcile, then History by account. Accountants ask for it because it is the evidence that a period was actually tied to a statement rather than assumed to be right.
How do I reconcile multiple months in QuickBooks Online?
One statement at a time, oldest first. There is no bulk reconcile, and doing them in order is not just tidiness: each month's beginning balance depends on the month before it being right, so starting in the middle guarantees a mismatch. Import every missing month before you begin, then reconcile forward without leaving gaps.
Should I force a reconciliation to balance in QuickBooks?
Only for trivial rounding you have already investigated. Finishing with a difference makes QuickBooks post an adjusting entry, which closes the month while leaving an unexplained amount in the books. That figure does not go away, it shows up in reviews and at tax time, and by then nobody remembers what it stood for. Find the difference instead.
Why does QuickBooks say my account isn't ready to reconcile?
That message means the beginning balance no longer agrees with the last reconciliation, so QuickBooks is refusing to build on a broken foundation. Something previously reconciled has been edited, deleted, moved or unmarked. Follow the link it offers to the discrepancy report, resolve every line listed there, and the reconcile screen becomes available again.
Do I need to reconcile if I use bank feeds?
Yes. A feed is an unverified copy of the bank's data delivered by a connection that can drop transactions, deliver them twice, or fail quietly for weeks. Reconciling is the step where you compare that copy against the statement the bank stands behind. Skipping it means your balance sheet rests on whatever the connection happened to send.
Reconcile against a register that is actually complete
Convert the PDF statements for every month your bank feed never delivered, import the QBO files, and work through the reconciliations in order with nothing missing underneath them.
Convert a statement nowRelated guides
The accountant path, the register path, and what it costs you.
Hunting a difference down to zero, in order.
Reversed signs, interest, and the payment prompt to decline.
Rebuild a year of register before reconciling it.
What to check in For Review before you reconcile.
The main converter, any bank, any account.