To reconcile in QuickBooks Online for the first time, pick one bank statement as your starting point, confirm the account's opening balance entry equals that statement's beginning balance, and make sure nothing except the opening balance is already marked reconciled. Then reconcile that first statement normally. Every later month inherits this starting figure, so get it right once.
Choosing the starting statement for a first QuickBooks Online reconciliation
The starting statement is the earliest statement you want QuickBooks Online (QBO) to agree with. Pick the one whose beginning date matches the date on the account's opening balance. If the books start on March 1, the first statement to reconcile is the one that opens on March 1, not the most recent one in your inbox.
Intuit's guidance on entering opening balances in QuickBooks Online points the same way. It asks for the date you want to start tracking the account and the balance from your bank statement for that date, so the start date and the statement should be chosen together.
Three situations change the choice:
- A brand-new bank account. Use the statement that covers the day the account opened. The opening balance is often zero or the first deposit.
- A company moving from another system. Start at a month boundary that the old system already reconciled. The old system's last reconciled balance becomes your proof that the starting figure is right.
- A business that never reconciled at all. Choose a clean cut, usually the start of the fiscal year. Older months can be reviewed separately, but they should not block the books you are about to rely on.
Avoid a start date in the middle of a statement period. A mid-period start forces you to split one statement into a part QBO knows about and a part it does not, and the first reconciliation becomes guesswork.
Is the QuickBooks Online opening balance entry right?
The opening balance entry is right when its date and amount match the bank statement's beginning balance for the starting period. QBO records it as a deposit posted against Opening Balance Equity. Open the account history, find that entry, and compare it to the statement before you touch the Reconcile page.
Intuit's article on fixing issues the first time you reconcile an account gives the path. Go to All apps, then Accounting, then Chart of accounts. Find the account and select Account history. The opening balance line shows Opening Balance Equity in the payee account column and Opening Balance in the memo. Note its date and amount.
Compare both values to the statement:
- The date should be the statement's beginning date, or the day before it, depending on how your bank prints the opening figure. Be consistent with whichever reading you choose.
- The amount should equal the statement's printed beginning balance to the cent.
If the amount is wrong, Intuit's article says to expand the entry, correct the amount in the Deposit column and save. The same article notes a common cause: the opening balance can leave out transactions that were still pending at the bank when the account was created in QBO. A connected bank feed can also produce an opening figure on its own, totalled from downloaded history, and that figure is only as reliable as the download.
Clearing stray R marks from QuickBooks Online account history
Before the first reconciliation, the only line that should carry an R, for reconciled, is the opening balance entry. Every other transaction should show C, for cleared, or a blank box. A stray R on any other line moves the beginning balance on the Reconcile screen, and the first month will refuse to agree.
Stray R marks usually come from one of three places. Someone clicked the tick column in the register by hand. An import from another system brought reconciled flags across. Or a previous attempt at reconciling was abandoned without being undone properly.
Intuit's first-time article describes the check: open Account history, confirm that the opening balance carries an R, then scan the rest. If another transaction has an R, expand it, click the tick box until it is blank, and save.
Clearing a mark this way is a manual override, so record what you changed. A short note with the transaction date, amount and reason is enough. If an earlier reconciliation was finished and saved, undoing it is a different job. Unreconciling in QuickBooks Online without damage explains what each route removes and what it leaves behind.
What about transactions dated before the QuickBooks Online start date?
Transactions dated before the opening balance date sit outside the period the first reconciliation covers. They are already inside the opening balance figure, so leaving them unreconciled in QBO would make them look like open items forever. Intuit's first-time article says to reconcile such earlier transactions first, using its separate guide for them.
These older entries appear for ordinary reasons. A bookkeeper keys in December invoices paid in January. A bank feed downloads ninety days of history when the account connects. An accountant posts a prior-year adjustment that touches the cash account.
Before you decide what to do, sort them into two groups:
- Entries that duplicate history the opening balance already contains. These double count cash. Ask whoever entered them whether they belong in QBO at all, and remove them only after you understand why they were added.
- Entries that are genuinely outstanding at the start date, such as a check written in February that cleared in March. These are real reconciling items. The opening balance should be the bank's figure, and the outstanding check must still appear in QBO so it can clear on the March statement.
The second group is where first reconciliations most often go wrong. If the opening balance was taken from the books instead of the bank, outstanding items get counted twice or not at all.
A first QuickBooks Online reconciliation, worked for one checking account
A worked example makes the sequence concrete. Here, a business starts QBO on March 1 and reconciles its March statement as the first one. All figures below are example values, made up for illustration.
| Item | Example amount |
|---|---|
| Statement beginning balance, March 1 | $18,240.55 |
| Opening balance entry in QBO, dated March 1 | $18,240.55 |
| Check 1042, written February 26, cleared March 3 | $1,375.00 |
| March deposits on the statement (6 lines) | $22,910.40 |
| March withdrawals on the statement (31 lines, excluding check 1042) | $19,604.18 |
| Statement ending balance, March 31 | $20,171.77 |
Check 1042 is the interesting line. It was written before the start date, so the bank's March 1 balance does not yet reflect it. The opening balance therefore matches the bank, and check 1042 must exist in QBO as a February-dated payment so it can be ticked in March.
On the Reconcile screen, enter $20,171.77 as the ending balance and March 31 as the ending date. The beginning balance should show $18,240.55. Tick the six deposits, the 31 withdrawals and check 1042. The cleared total works out as 18,240.55 + 22,910.40 − 19,604.18 − 1,375.00 = 20,171.77, and the Difference reads $0.00.
Run the same arithmetic on the statement before you begin. If the beginning balance plus deposits less withdrawals does not equal the printed ending balance, the statement or your reading of it is wrong, and no ticking will fix that. PreciseBankFlow foots every statement this way and, when it does not foot, shows the difference and any statement line whose amount matches it; it is opening to CPA and audit firms in small groups.
When not to force a first QuickBooks Online reconciliation to zero
Stop and repair the setup when the first reconciliation's beginning balance does not match the statement, or when the Difference equals a round, unexplained figure. A first reconciliation that is forced to zero bakes the error into every month that follows. Fix the opening entry or the stray marks, then start again.
QBO lets you finish a reconciliation with a difference and accept a journal entry for the gap. On a first reconciliation that entry is especially harmful. It records an amount with no description of what went wrong, it hides a setup error behind a reconciled flag, and a reviewer later has to unpick it.
Other signs that point to setup, not ticking:
- The Difference equals the total of one or two old checks. That suggests outstanding items from before the start date are missing from QBO.
- The beginning balance on the Reconcile screen differs from the opening balance entry. That means another line already carries an R.
- The Difference changes each time you reopen the screen. That means someone is editing dated transactions in the period.
Payroll accounts are a common example. If payroll liabilities were set up with balances that do not match the tax filings, the cash side and the liability side both start wrong; reconciling payroll liabilities in QuickBooks covers the liability half of that repair.
Go-live checklist after the first QuickBooks Online reconciliation
Going live means the first reconciliation is saved, its report is filed outside QBO, and the second month can start from a proven figure. Treat the first month as a setup step that needs its own review, not as routine work. A short checklist keeps it from being skipped.
- Save or print the first reconciliation report and keep it with the March statement. Where to find bank reconciliations in QuickBooks Online shows the screens for getting a copy out.
- Write a one-paragraph setup note: the start date, the opening balance, where it came from, and any items carried in from before the start date.
- Ask a second person to compare the opening balance with the statement and initial the note.
- Confirm the beginning balance offered on the April Reconcile screen equals the March ending balance.
- List any items left unticked in March, with the reason each is still open.
- Repeat the opening balance check for every other bank and card account before reconciling them.
Organisations with a board or finance committee should add one step: present the setup note at the next meeting, so the starting figure has an owner beyond the bookkeeper. Nonprofits often have this requirement in their policies, and reconciliation software for nonprofits and their boards looks at what a committee needs to see each month after that.