# How do I perform a reconciliation for the first time in my accounting software?

Applies to: United States · Updated 2026-09-24

First, confirm the account exists in your books with an opening balance traceable to a bank or card statement, and that every transaction from your start date onward is recorded. Treat the software's opening figure as an assumption and check it against the statement balance for the same day. Then work the first statement to a zero difference, resolving any opening disagreement by finding its cause, never by changing the opening balance until the run clears.

## Why is a first reconciliation different from every later one?

An ordinary reconciliation starts from a beginning balance that an earlier reconciliation already proved. A first reconciliation has nothing behind it. The starting figure is whatever was keyed in, imported or calculated when the account was set up, and the first run is the moment you either prove it or quietly adopt it.

QuickBooks Online describes the opening balance as "the starting point for your account in QuickBooks," and it states that when you reconcile an account for the first time, the opening balance is the only entry that is reconciled. Every later reconciliation builds on that one reconciled entry. If it is wrong, every later period inherits the error.

## What has to be in place before you start?

Three conditions decide whether a first run can succeed. Most failed first runs trace back to one of them.

1. **The account exists in your books with an opening balance.** In QuickBooks Online the opening balance is recorded as a journal entry in the account's register, carrying Opening Balance Equity as the other side.
2. **The opening balance is itself supported.** You need the statement that shows the real account's balance on the opening balance date. QuickBooks Online lists a copy of the bank or credit card statement for the period you are reconciling as a prerequisite for correcting a first-time opening balance.
3. **Every transaction from the start date through the statement's ending date is recorded.** If a payment or deposit is missing from the books, it looks the same on screen as an item that simply has not cleared yet, and you cannot tell the two apart.

Use this pre-flight checklist before you open the reconciliation screen:

| Check | How to confirm it |
|---|---|
| The account is set up in the books | It appears in the chart of accounts with the right account type |
| An opening balance entry exists | Open the account register, find the opening entry and note its date |
| The opening date and amount are known | Write down the date and amount of the opening entry |
| The statement for that date is in hand | The statement covering the start date is downloaded or on paper, not just "available from the bank" |
| The opening entry agrees with the statement | The register's opening amount equals the statement balance for the same day, or the difference is fully explained by listed items |
| Nothing else is already marked reconciled (QuickBooks Online) | Only the opening entry shows as reconciled |
| Transactions are complete through the ending date | Every statement line for the period has a matching entry in the books, or you know which ones are missing |
| The first statement to reconcile is chosen | You have its ending date and ending balance |

The "nothing else is already marked reconciled" check matters because of how QuickBooks Online treats a first run. It says no other transactions should be reconciled, and in the register every other transaction's reconciliation mark should be blank or a C (cleared), not an R.

## Where does the opening figure come from, and can you trust it?

The figure the software opens with depends on how the account was set up. The steps below follow QuickBooks Online as Intuit's U.S. help pages document it; other software may derive and present the opening figure differently, so confirm the equivalent in your vendor's documentation. There are three paths:

- **Entered when the account was created.** When you create a new account in QuickBooks Online, you pick a day to start tracking transactions and enter the balance for your real-life account for that day.
- **Set when a bank feed was connected.** QuickBooks Online says that when you first connect a bank or credit card account, it sets the opening balance using the real-world account balance from the day you choose to start tracking transactions.
- **Carried over from a prior system or a spreadsheet.** The figure is whatever the conversion produced. It is covered in its own section below.

On a first run, QuickBooks Online expects the beginning balance on the reconciliation screen to match your bank statement once the opening balance is right. So the opening figure is the opening balance entry, and nothing more.

That is the whole point of a first reconciliation: the figure is presented, not proven. The software supplied it, but no prior reconciliation stands behind it, so it carries no more assurance than the keystrokes, feed or import that created it. Before you rely on it, look up the statement balance for the same date. QuickBooks Online's first-time check is exactly this: check the account's balance for the same day as the opening balance and compare the two.

## How do you choose the start date?

Pick a date for which you hold, or can still download, the bank or card statement. The start date is the only point where the books and the bank are assumed to agree without proof, so it needs a document behind it. If you choose a date whose statement you can no longer get, the whole reconciled history rests on a number nobody can check.

QuickBooks Online's own guidance on setting up an opening balance says: "For new accounts, use the day you opened it at your bank. For existing accounts, use the beginning date for your next statement". Aligning the start date with the start of a statement period means the first statement you reconcile begins exactly where your books begin. The opening figure is then the statement's opening balance for that period, which is the closing balance of the day before; transactions dated on the start date itself are recorded separately and are not part of it.

The start date commits you to three things:

- **Everything before it is excluded** from the reconciled record. Earlier activity lives only inside the opening balance.
- **Everything after it must be recorded**, because the first statement is matched line by line against the books.
- **The opening balance has to exist before you reconcile.** QuickBooks Online's journal-entry method for adding a missing one is only for accounts not yet reconciled: "Only use this method if you haven't reconciled the account yet." So settle the date, and get the opening balance in, before the first run.

## Is the account new, or does it already have history?

The two situations share a name but not a method.

**A newly opened account with no earlier activity.** This is the short path. The opening balance is zero and the date is the day the account was opened at the bank; record the deposit that opened the account as an ordinary transaction (an owner contribution or a transfer). If you instead enter the opening deposit as the opening balance, make sure the same deposit is not also recorded or downloaded as a transaction. Confirm that the opening entry matches the first statement's opening figure, confirm every transaction on that first statement is in the books, and run the reconciliation. There is no history to evidence.

**An account with history before the start date.** Money moved in and out before your books begin, so the bank balance on the start date may not equal what your old records show on that date. The usual reason is timing. An outstanding check is "a check that was written and deducted from the financial records of the company but has not been cashed by the recipient," and a deposit in transit is "a deposit that was made by the business and recorded on its books but has not yet been recorded by the bank." Items like these, written before the start date but clearing after it, are the characteristic complication of a first run on an established account.

Within this second case, check which of these applies:

- **The earlier activity is recorded.** Then the opening entry is dated before the oldest of those transactions — QuickBooks Online says to "Enter a date that comes before the oldest transaction in the account" — and carries the real-life account balance for that earlier date, so they are not counted twice. Those transactions then have to be reconciled before you work the first statement; for QuickBooks Online, Intuit's first-reconciliation page points to its own procedure.
- **The earlier activity is not recorded, and you need it.** If periods before your start date were never recorded and you need them reconciled, a first reconciliation is the wrong operation. That is a backlog of unreconciled periods, and it is handled by working through the earlier periods first, which is a separate question.

## What if the opening balance was carried over from another system or a spreadsheet?

A converted opening balance is the output of a migration, not a reconciled position. Before the first run adopts it, agree it to the bank or card statement balance at the conversion date.

1. Find the date the converted balance is dated. That is your conversion date.
2. Get the statement that shows the balance on that date.
3. Compare the two. If they differ, list the items from the old system that were outstanding at the conversion date, such as checks written but not yet cashed and deposits recorded but not yet credited. The converted figure should equal the statement balance plus or minus those listed items, with nothing left over.
4. Check the other side of the conversion entry. Accounting software balances setup entries against an equity account, and Opening Balance Equity "is not a true equity account. It is a temporary account used by accounting software to balance initial entries when setting up a company's books." A converted cash balance that is off by an unexplained amount leaves that amount parked there.

Some software gives you a place to carry the listed items into the first run. Sage 50 U.S., in its 2024 help edition, documents beginning transactions for this; check that your release still offers it. They are for an outstanding amount that "was originally entered as part of the general ledger account beginning balance," and they are not posted to the general ledger. Sage also requires that the item is dated before the beginning-balance date and has not cleared on the first statement you reconcile. Sage says: "They are used only when initially reconciling an account."

In other software, find how your vendor documents outstanding items that predate the opening balance before you start; do not clear them by changing the opening balance by an amount you cannot list item by item.

## How do you work the first run?

With the prerequisites confirmed, the run itself follows the normal pattern. What changes is what you check at the start:

1. Open the reconciliation for the account and choose the first statement after your start date.
2. Before you match anything, compare the beginning balance on the screen with the statement's opening balance. If they differ, stop and resolve it first (see the next section).
3. Enter the statement's ending date and ending balance.
4. Match each item on the statement to its entry in the books. In QuickBooks Online you select the checkbox next to each transaction in the reconciliation window that matches a transaction on your account statement.
5. For any statement line with no matching entry, record the missing transaction from its source document, not from the statement alone, except for items that originate with the bank, such as fees and interest, where the statement is the source.
6. Leave items that have not cleared unchecked. On an account with history, that includes any pre-start items carried as outstanding.
7. Finish only when the difference is zero and every remaining uncleared item is one you can name.

When you finish, keep the output. In QuickBooks Online, "After finishing, QuickBooks saves a reconciliation report."

The general method of tying the books to the bank, which is the same for every period, belongs to the guide on what a bank reconciliation is and how to prepare one.

## What does a disagreement at the opening figure mean?

A difference between the software's beginning balance and the statement's opening balance is the classic first-run failure. QuickBooks Online says that when the balance is wrong on a first reconciliation, "it's often due to an incorrect opening balance." Read the difference before you touch anything. Each cause calls for a different fix:

| What the difference is | What it tells you | What to do |
|---|---|---|
| The opening entry was keyed or imported wrong | The opening figure does not match what the statement supports for its own date | Correct the entry to the figure the statement supports for that date |
| The opening entry is being compared with a balance from another day | Two balances from different days are being compared | Compare it with the bank's balance for the opening entry's own date: the statement's opening balance for that period, which is the prior day's closing balance |
| Items were outstanding at the start date | The books and the bank legitimately differed on that day | It depends on your software (see the example below); check how yours treats outstanding items that predate the opening balance |
| Another transaction is already marked reconciled | Something besides the opening entry is counted in the beginning balance | In QuickBooks Online, if the account has truly never been reconciled, remove the reconciled mark. If the marks may come from an earlier reconciliation by someone else, stop: this is not a first reconciliation and the marks should not be removed here. |
| No cause can be found | The opening figure is unsupported | Stop and investigate. Do not finish the run. |

A worked example with invented figures: your books start on March 1. The opening balance was converted from a spreadsheet at 11,500.00. The bank statement shows 12,400.00 at the end of February, a difference of 900.00. The old records show check 1041 for 900.00, written February 26 and not yet cashed. The difference is fully explained, but what you do next depends on which of two documented models your software follows.

In Sage 50 U.S., in its 2024 help edition, check 1041 is entered as a beginning transaction: the amount was part of the general ledger beginning balance, the entry is not posted to the general ledger, and the beginning balance stays at 11,500.00 with the check listed as outstanding.

In QuickBooks Online the opening balance is the amount in the real-life account on the day tracking starts, and the beginning balance on the reconciliation screen is expected to match your bank statement: the opening entry carries the bank's 12,400.00, not 11,500.00. Where older transactions are dated before the opening balance, Intuit's first-reconciliation page sends you to its own procedure for reconciling them first.

Either way, every amount you carry has to be one you can name. If the difference had been 937.50, the remaining 37.50 would be unexplained, and the first run should not be finished until you find it.

QuickBooks Online's documented first-time remedy, when the opening entry doesn't match the bank, is to open the Opening Balance Equity entry and "edit the balance so it matches your bank records." That is the documented fix when the entry disagrees with the bank's balance for its own date. It is not a way to clear a difference you haven't explained.

## Why not just change the opening balance until the run clears?

Moving it by an unexplained amount doesn't resolve the difference. It writes the difference into the account's starting point, where no later reconciliation will ever look at it again.

Change the opening balance only when you can show, from the statement for that date, that the entry itself was wrong. In every other case, find the cause first.

## What if you can't finish because the prerequisites aren't met?

Stop and fix the prerequisite, not the reconciliation:

- **No opening balance exists.** QuickBooks Online lets you add one later with a journal entry, dated before the oldest transaction in the account: "Enter a date that comes before the oldest transaction in the account." It then has you mark that journal entry as reconciled, because "This prevents it from showing up on a future reconciliation." It restricts this method to accounts you haven't reconciled yet.
- **An opening entry exists but you don't know whether it's right.** Get the statement for its date. QuickBooks Online's instruction is: "Use your bank statements to make sure the opening balance is correct."
- **You can't get the statement for your start date.** Move the start date to one you can document before any period is reconciled.
- **Transactions for the period are missing.** Record them first.
- **Earlier periods were never recorded.** Treat it as a backlog, not a first reconciliation.

## What does the finished first reconciliation fix for every later period?

It fixes three things. The opening balance on the start date becomes a proven position. The first statement's ending balance becomes the beginning balance the next reconciliation must match. And every item left uncleared becomes a named item that the next statement should clear. From then on, a beginning-balance difference means something changed after the fact, not that the start was never checked.

The first run must leave evidence behind:

- The statement showing the balance on the start date,
- The first reconciled statement,
- The reconciliation report the software saves,
- The list of outstanding items at the start date, with what each one is,
- For a converted balance, the comparison of the converted figure to the statement at the conversion date.

Keep them with your business records.

## Sources

1. Intuit Inc. — *Fix issues the first time you reconcile an account in QuickBooks Online*, Updated 8/24/2026. https://quickbooks.intuit.com/learn-support/en-us/help-article/banking/fix-issues-first-time-reconcile-account-quickbooks/L1aksm3QU_US_en_US
2. Intuit Inc. — *Enter and manage opening balances in QuickBooks Online*, Updated 8/25/2026. https://quickbooks.intuit.com/learn-support/en-us/help-article/bank-deposits/enter-opening-balance-account-quickbooks-online/L7NcxTbuu_US_en_US
3. Intuit Inc. — *What to do if you didn't enter an opening balance in QuickBooks Online*, Updated 8/25/2026. https://quickbooks.intuit.com/learn-support/en-us/help-article/journal-entries/enter-opening-balance-quickbooks-online/L4l3NZSMR_US_en_US
4. Intuit Inc. — *Reconcile an account in QuickBooks Online*, Updated 8/5/2026. https://quickbooks.intuit.com/learn-support/en-us/help-article/statement-reconciliation/reconcile-account-quickbooks-online/L3XzsllsK_US_en_US
5. The Sage Group plc — *Enter Beginning Transactions in Account Reconciliation*, Sage 50 U.S. 2024 help, published October 20, 2023. https://help-sage50.na.sage.com/en-us/2024/Content/Banking_General_Ledger/Account_Reconciliation/Enter_Beginning_Transactions_in_Account_Reconciliation.htm
6. OpenStax, Rice University — *Principles of Accounting, Volume 1: Financial Accounting, 8.6 Define the Purpose of a Bank Reconciliation, and Prepare a Bank Reconciliation and Its Associated Journal Entries*, Published April 11, 2019. https://openstax.org/books/principles-financial-accounting/pages/8-6-define-the-purpose-of-a-bank-reconciliation-and-prepare-a-bank-reconciliation-and-its-associated-journal-entries
7. AccountingTools, Inc. (Steven Bragg) — *Opening balance equity definition*, March 9, 2026. https://www.accountingtools.com/articles/opening-balance-equity.html

## Related questions

- [What is a bank reconciliation, who prepares it, and how do I tie the books to the bank (with a worked example)?](https://uppago.com/resources/what-is-a-bank-reconciliation-and-how-to-tie-the-books-to-the-bank)
- [How do I catch up reconciliation for old or prior-period transactions that remain unreconciled, working through earlier periods to bring the reconciliation current?](https://uppago.com/resources/how-to-catch-up-unreconciled-prior-period-transactions)
- [How do I reconcile accounts in my accounting software?](https://uppago.com/resources/how-to-reconcile-accounts-in-accounting-software)
- [Which of my accounts actually need to be reconciled, and how often?](https://uppago.com/resources/which-accounts-need-to-be-reconciled-and-how-often)
- [Where in my ERP or accounting system do I find the bank reconciliation function — which transaction code or menu route opens it?](https://uppago.com/resources/where-to-find-the-bank-reconciliation-function-in-an-erp-or-accounting-system)