6.3 Month-End Account Reconciliation, Beginning Balance Discrepancies & Corrections
Key Takeaways
- The bank reconciliation mathematically verifies that every cleared transaction on the official bank statement matches the general ledger register, with an absolute requirement that the final Difference equals exactly $0.00.
- The core reconciliation formula is: Beginning Balance + Cleared Deposits/Credits - Cleared Payments/Debits = Cleared Balance; subtracting the Statement Ending Balance from the Cleared Balance must yield zero.
- Beginning balance discrepancies are triggered when a previously reconciled transaction is deleted, voided, modified in amount, or manually un-reconciled (changing 'R' to 'C' or blank) in the account register.
- The Reconcile Discrepancy Report identifies exactly which historical transactions were altered, showing the original reconciled amount, the modified current amount, and the user responsible, allowing direct correction.
- QuickBooks Online Accountant (QBOA) provides accounting professionals with an exclusive 'Undo' reconciliation tool to roll back entire reconciliation periods in batch, a capability unavailable to standard client users.
Last updated: September 2026
Month-End Account Reconciliation, Beginning Balance Discrepancies & Corrections
Quick Answer: The month-end account reconciliation in QuickBooks Online is an indispensable internal control that proves the mathematical integrity of the general ledger against independent bank and credit card statements. Users navigate to Accounting > Reconcile (or Gear icon > Reconcile), enter the Statement Ending Balance and Statement Ending Date, and clear matching transactions until the Difference is exactly $0.00. If the opening balance does not match the statement, a Beginning Balance Discrepancy exists—caused by a previously reconciled transaction being deleted, edited, or un-reconciled in the register. ProAdvisors resolve these issues using the Discrepancy Report or by executing a full period rollback using the accountant-exclusive Undo reconciliation tool in QuickBooks Online Accountant (QBOA).
The Core Purpose and Philosophy of Reconciliation
Many inexperienced bookkeepers believe that maintaining an active, daily bank feed eliminates the need for monthly bank reconciliations. This assumption is completely false.
- Why Bank Feeds Do Not Equal Reconciliation: Bank feeds only download what the bank cleared; they do not detect transactions that were entered manually in duplicate, transactions that were accidentally excluded, timing differences that linger indefinitely, or unauthorized register modifications.
- The Definition of Reconciliation: Reconciliation is the formal process of comparing the general ledger cash or liability balance against the third-party financial institution's official closing statement. It proves that every dollar of cash, debt, and interest is accounted for, providing audit-ready assurance for tax filings and financial statements.
- Applicable Accounts: Reconciliations must be performed monthly for all cash and liquid asset accounts (Checking, Savings, Money Market, Payroll clearing, Petty Cash) and all debt/liability accounts (Credit Cards, Lines of Credit, Commercial Term Loans).
The Reconciliation Interface & Workflow
To initiate a reconciliation, navigate to Accounting > Reconcile in the left navigation menu (or click Gear icon > Reconcile).
┌─────────────────────────────────────────────────────────────────────────────┐
│ Reconcile Checking (1234) [Edit info] [Save]│
├─────────────────────────────────────────────────────────────────────────────┤
│ Statement Ending Balance: $15,450.00 Statement Ending Date: 08/31/26│
│ Beginning Balance: $12,100.00 │
├─────────────────────────────────────────────────────────────────────────────┤
│ Cleared Balance: $15,450.00 DIFFERENCE: $0.00 │
│ 22 Payments cleared: -$8,650.00 Target Difference must be ZERO│
│ 14 Deposits cleared: +$12,000.00 │
├─────────────────────────────────────────────────────────────────────────────┤
│ [ All ] [ Payments (22) ] [ Deposits (14) ] [ Filters ▾ ] │
│ │
│ [✔] Date Type Ref No. Payee Category Amount │
│ [✔] 08/02/2026 Check 1041 Pacific Power Utilities $450.00 │
│ [✔] 08/05/2026 Deposit Multiple Undeposited $3,200.00 │
│ [✔] 08/12/2026 Expense Staples Office Supplies $84.20 │
└─────────────────────────────────────────────────────────────────────────────┘
1. The Reconcile Setup Screen
Upon selecting the target account, QBO prompts the user for statement parameters:
- Account: Select the bank or credit card account to reconcile.
- Beginning Balance: Automatically populated by QBO. It represents the cumulative sum of all transactions previously marked as reconciled ("R") in that account's history. Note: This field cannot be typed into or edited directly on this screen.
- Ending Balance: The final cleared balance printed on the official bank or credit card statement as of the closing date.
- Ending Date: The closing date printed on the official statement.
- Service Charges & Interest Earned (Optional Fields): While QBO provides fields to enter bank fees and interest on this setup screen, ProAdvisor best practice is to leave these blank and instead add them directly from the bank feed or register prior to reconciliation, ensuring proper payee and class tagging.
2. The Reconciliation Workstation Header
Clicking Start reconciling opens the interactive workstation. The top banner displays the critical mathematical equation:
\text{Beginning Balance} & \quad (\$12,100.00) \\ +\ \text{Cleared Deposits / Credits} & \quad (+\$12,000.00) \\ -\ \text{Cleared Payments / Debits} & \quad (-\$8,650.00) \\ \hline =\ \text{Cleared Balance} & \quad (\$15,450.00) \\ -\ \text{Statement Ending Balance} & \quad (\$15,450.00) \\ \hline =\ \mathbf{Difference} & \quad \mathbf{\$0.00} \end{aligned}$$ ### 3. Workstation Navigation & Clearing Controls * **Filters:** Users can toggle between **All**, **Payments**, or **Deposits**, or apply filters by transaction date, cleared status, or payee to locate specific items rapidly. * **Auto-Clearing Feature:** Transactions that were accepted from the bank feed display an initial cleared status (marked with a green checkmark or pre-selected) because QBO recognizes they cleared the bank electronically. * **The Finish Now Button:** Located in the top right corner. It should **only be clicked when the Difference is exactly $0.00**. --- ## Troubleshooting Non-Zero Reconciliation Differences When the Difference is not zero, the reconciliation contains errors that must be systematically investigated and resolved before finishing. ``` Reconciliation Difference Troubleshooting Protocol: [ Non-Zero Difference Detected ] │ ├─► 1. Verify Statement Inputs: Click [Edit info] to verify Ending Balance & Date. │ ├─► 2. Test Rule of 9s: Is the difference divisible by 9? If yes, look for transposed digits! │ ├─► 3. Compare Count & Totals: Compare statement total debits/credits against QBO header. │ ├─► 4. Check for Uncleared Past Items: Look for old checks/deposits accidentally cleared. │ └─► 5. Identify Unrecorded Bank Items: Bank fees, merchant fees, interest, or returned checks. ``` ### Diagnostic Checklist for Out-of-Balance Reconciliations 1. **Verify Statement Inputs:** Click **Edit info** in the top right corner. Check for transposed digits or clerical errors in the entered Ending Balance or Ending Date (e.g., entering `$15,540.00` instead of `$15,450.00`, or selecting August 30 instead of August 31). 2. **The "Rule of 9s" for Transpositions:** If the reconciliation difference is evenly divisible by 9 (e.g., `$90.00 / 9 = 10`), a digit transposition is almost certainly the culprit. For example, a check written for `$782.00` entered as `$728.00` creates a `$54.00` discrepancy (`$54 / 9 = 6`). 3. **Compare Aggregate Debits and Credits:** Look at the bank statement summary box. It states: *"Total Deposits: $12,000.00 (14 items); Total Checks/Debits: $8,650.00 (22 items)"*. Compare these exact counts and totals against the QBO header cards. If the QBO payments total is `$8,750.00`, you know the error lies exclusively within the payments ledger, isolating the search. 4. **Inspect for Prematurely Cleared Future Transactions:** Ensure no transactions dated *after* the statement ending date have been accidentally checked off. 5. **Look for Duplicate Entries:** An expense that was manually entered and subsequently added (rather than matched) from the bank feed will appear twice in the reconciliation list. 6. **Identify Missing Bank Items:** Look for monthly maintenance fees, incoming wire charges, credit card annual fees, or returned NSF check adjustments that appear on the statement but were never recorded in QBO. --- ## Beginning Balance Discrepancies: Causes & Resolution A **Beginning Balance Discrepancy** occurs when the beginning balance shown on the QBO reconciliation setup screen does not match the opening balance printed on the official bank statement. ### The Anatomy of Beginning Balance Calculation QuickBooks Online does **not** store the beginning balance as a static text number. Instead, the beginning balance is a **dynamic calculation**: it is the sum total of every single transaction in the account's history that currently holds an **"R" (Reconciled)** status. ### The Four Causes of Beginning Balance Discrepancies 1. **A reconciled transaction was deleted:** Someone deleted a check or deposit that was part of a prior month's reconciled balance. 2. **A reconciled transaction was voided:** Voiding changes the transaction amount to `$0.00`, reducing the historical reconciled total. 3. **The dollar amount of a reconciled transaction was modified:** A user opened a previously reconciled bill payment and edited the amount from `$500.00` to `$450.00`. 4. **A transaction was manually un-reconciled in the register:** A user opened the account register and clicked the reconciliation status column, changing an **"R"** to a **"C" (Cleared)** or blank. ### The Reconcile Discrepancy Alert & Report When a beginning balance mismatch occurs, QBO displays a prominent warning banner across the screen: > *"We can help you fix it. Your beginning balance is off by $150.00."* Clicking the blue link **"We can help you fix it"** launches the **Discrepancy Report**. ``` ┌─────────────────────────────────────────────────────────────────────────────┐ │ Reconcile Discrepancy Report — Operating Checking │ ├─────────────────────────────────────────────────────────────────────────────┤ │ Total Discrepancy: -$150.00 │ ├─────────────────────────────────────────────────────────────────────────────┤ │ Type Date Ref Payee Reconciled By Reconciled Amt Current Diff │ │ Check 07/15/2026 1022 Acme Supply John Doe (User) $500.00 $350.00 -$150│ │ *Change detected: Amount was edited from $500.00 to $350.00 on 08/18/2026*│ ├─────────────────────────────────────────────────────────────────────────────┤ │ [Fix in register] │ └─────────────────────────────────────────────────────────────────────────────┘ ``` ### How to Read and Resolve the Discrepancy Report The Discrepancy Report provides complete forensic audit detail: * **Type & Date:** Identifies the specific altered transaction. * **Reconciled By & Date:** Identifies the user who executed the original reconciliation and when. * **Reconciled Amount vs. Current Amount:** Displays the original verified amount versus the altered value. * **Action / Resolution:** * If an amount was edited: Click the transaction link to open it, re-enter the original reconciled amount, and save. * If a transaction was un-reconciled: Open the register, locate the transaction, and click the status column until it displays **"R"** again. * If a transaction was deleted: Review the Audit Log to retrieve the exact transaction details (date, payee, category, amount) and re-create it in the register, manually marking it **"R"**. Once all discrepancies on the report are corrected, the discrepancy total becomes `$0.00`, the warning banner disappears, and the Beginning Balance aligns perfectly with the bank statement. --- ## Undoing Reconciliations: QBOA Tool vs. Register Editing Circumstances occasionally arise where an entire historical reconciliation must be rolled back—such as when multiple wrong transactions were forced, fraudulent transactions were discovered, or an inexperienced user reconciled against an incorrect statement date. ### 1. The QuickBooks Online Accountant (QBOA) "Undo" Tool Accounting professionals accessing client files through **QuickBooks Online Accountant** possess an exclusive administrative superpower: the **batch Undo tool**. * **Navigation:** Inside the client company, go to **Accounting > Reconcile > History by account**. * **Operation:** Locate the specific reconciliation period in the historical table. In the Action column, click the dropdown and select **Undo**. * **System Impact:** * QBO completely rolls back that specific reconciliation in a single click. * All transactions cleared in that statement period have their **"R" status reverted back to "C"**. * The beginning balance for the subsequent month adjusts automatically. * **No transactions are deleted or removed from the register.** * **Sequential Reversal Requirement:** Reconciliations must be undone in **reverse chronological order**. To undo July, the user must first undo September and August. ### 2. Standard Client Interface Limitation Standard small business users logging into QBO directly (without QBOA accountant credentials) **do not have access to the Undo tool**. * If a client user needs to undo a reconciliation without an accountant, they must open the register and manually click the reconciliation column on every single transaction, changing each **"R"** to blank one by one. * This manual process is tedious, error-prone, and frequently creates beginning balance discrepancies. --- ## Reconciliation Adjustments: The Cardinal Sin of Bookkeeping When a user attempts to click **Finish now** while a non-zero difference remains (e.g., a difference of `-$45.20`), QuickBooks Online displays a blocking dialog warning: > *"There's a difference of -$45.20. Do you want to adjust it and finish?"* If the user clicks **"Auto-adjust"** (or *"Issue an adjustment"*), QBO forces the reconciliation to balance by automatically creating a journal entry that debits or credits an expense account named **Reconciliation Discrepancies**. ``` System Auto-Generated Adjustment Entry: Date: 08/31/2026 (Statement Ending Date) Account: Operating Checking Debit: $45.20 Account: Reconciliation Discrepancies Expense Credit: $45.20 Memo: Auto-adjustment to balance reconciliation ``` ### Why Auto-Adjustments Represent an Audit Failure ProAdvisors must understand that forcing a reconciliation adjustment is an unacceptable bookkeeping practice: 1. **Hiding Offsetting Catastrophes:** A seemingly trivial `$50.00` discrepancy might not be a single missing `$50.00` receipt. It could be the net result of an unrecorded `$10,050.00` customer deposit offset by an unrecorded `$10,000.00` vendor bill payment! Forcing an adjustment permanently buries `$20,050.00` of gross transactional errors. 2. **IRS & Tax Audit Red Flag:** Tax authorities and forensic auditors actively scrutinize the *Reconciliation Discrepancies* account. High or frequent balances signal poor internal controls, unreliable books, and potential negligence. 3. **GAAP & Internal Control Violation:** GAAP requires books to be accurate and substantiated. Auto-adjusting creates unverified income or expense that distorts taxable net margin. 4. **ProAdvisor Standard of Care:** A Certified ProAdvisor should never force a reconciliation adjustment without explicit client sign-off and an exhaustive investigation. The difference must always be resolved to **$0.00** through legitimate correction of the underlying records.Loading diagram...
Test Your Knowledge
An accountant opens the reconciliation screen for a client's operating checking account and notices an alert stating that the beginning balance is off by $600. Which of the following events could have caused this beginning balance discrepancy?
A
B
C
D
Test Your Knowledge
A certified bookkeeper discovers that a client's former employee incorrectly reconciled the last three months of bank statements against internal spreadsheet estimates rather than actual bank statements. The bookkeeper is logged in through QuickBooks Online Accountant (QBOA). What is the most efficient and proper method to reset the account?
A
B
C
D
Test Your Knowledge
What is the mathematical formula used by QuickBooks Online to determine the 'Difference' during a bank account reconciliation, and what must that difference equal before completing the workflow?
A
B
C
D
Test Your Knowledge
A bookkeeper reconciling a corporate credit card account has a remaining difference of -$32.50. Pressed for time, the bookkeeper clicks Finish Now and selects 'Auto-adjust' to force the reconciliation to balance. Why is this action considered a severe accounting and audit violation?
A
B
C
D