5.4 Performing Bank & Credit Card Reconciliations in QBO

5.4 Performing Bank & Credit Card Reconciliations in QBO

Core Principle: The bank and credit card reconciliation is the ultimate verification control in bookkeeping. Reconciling guarantees that internal general ledger accounts mirror external banking records, substantiating asset and liability values for financial statement presentation.

---

1. Purpose & Governance of Account Reconciliations

Under GAAP and NACPB professional bookkeeping standards, every bank account (checking, savings, money market) and liability account (credit cards, lines of credit) must be reconciled at the close of every monthly statement cycle. Reconciliations serve critical internal control functions:

• Proves Cash Existence & Accuracy: Confirms that reported cash assets on the Balance Sheet exist and match institutional records.
• Detects Omissions & Timing Differences: Uncovers unrecorded bank fees, merchant processing charges, interest income, wire fees, or unauthorized automatic withdrawals.
• Identifies Fraud & Internal Theft: Highlights altered checks, unauthorized electronic disbursements, and duplicate payments.
• Substantiates Uncleared Items: Quantifies outstanding checks and deposits in transit for accurate liquidity management.

---

2. The QBO Reconciliation Workflow Step-by-Step

To initiate a reconciliation in QBO, navigate to Gear Icon (⚙️) -> Reconcile (or Accounting -> Reconcile).

+-----------------------------------------------------------------------------+
|                  THE 5-STEP QBO RECONCILIATION WORKFLOW                     |
+-----------------------------------------------------------------------------+
|  STEP 1: SELECT ACCOUNT                                                     |
|  - Choose the Bank or Credit Card account from the dropdown menu.           |
|                                                                             |
|  STEP 2: VERIFY BEGINNING BALANCE                                           |
|  - Verify that Beginning Balance matches the statement starting balance.    |
|                                                                             |
|  STEP 3: ENTER STATEMENT PARAMETERS                                         |
|  - Enter Statement Ending Balance from official bank PDF/paper statement.   |
|  - Enter Statement Ending Date (e.g., 10/31/20X6).                          |
|                                                                             |
|  STEP 4: ENTER OPTIONAL SERVICE CHARGES / INTEREST                          |
|  - Enter finance charges or interest earned (if not already downloaded).    |
|                                                                             |
|  STEP 5: CLICK 'START RECONCILING'                                          |
|  - Enter the interactive reconciliation workspace.                          |
+-----------------------------------------------------------------------------+

---

3. The Interactive Reconciliation Workspace Mechanics

Upon entering the reconciliation workspace, QBO displays a high-level summary banner across the top of the screen:

+-----------------------------------------------------------------------------------------+
| STATEMENT ENDING BALANCE  -  BEGINNING BALANCE  -  CLEARED AMOUNT  =  DIFFERENCE        |
|       $42,500.00                 $15,200.00           $27,300.00         $0.00          |
+-----------------------------------------------------------------------------------------+

$\text{Difference} = \text{Statement Ending Balance} - (\text{Beginning Balance} + \text{Cleared Deposits} - \text{Cleared Payments})$

$\text{Target Difference} = \mathbf{\$0.00}$

Register Status Indicators in QBO

Transactions in the QBO general ledger account register display one of three status markers in the checkmark column (✔):

Navigating the Workspace

• Tab Filters: Filter transactions by Payments (money out / debits), Deposits (money in / credits), or All.
• Clearing Items: Clicking the circular checkbox next to a transaction marks it cleared. If transactions were properly processed through the bank feed, most items will already display a C and be pre-checked.
• The Finish Button: The green Finish now button is disabled until the Difference reaches exactly $0.00.

---

4. Identifying & Resolving Reconciliation Discrepancies

If the Difference does not equal $0.00 after checking off all items on the statement, an error exists. The bookkeeper must systematically investigate the source of the variance:

+-----------------------------------------------------------------------------+
|                   RECONCILIATION DISCREPANCY TROUBLESHOOTING                |
+-----------------------------------------------------------------------------+
|  COMMON ROOT CAUSE         | INVESTIGATION & REMEDIATION PROTOCOL           |
+----------------------------+------------------------------------------------+
|  Transposition Error       | Difference is divisible by 9 (e.g., $54 / 9 = 6)|
|                            | Look for inverted digits ($482 recorded as $428)|
+----------------------------+------------------------------------------------+
|  Omitted Bank Fee/Interest | Check statement for wire fees, service charges,|
|                            | merchant fees, or interest not entered in QBO. |
+----------------------------+------------------------------------------------+
|  Duplicate Transactions    | An entry was added from bank feeds when it was  |
|                            | already manually entered. Delete the duplicate.|
+----------------------------+------------------------------------------------+
|  Incorrect Statement Date  | Transactions dated 1 day after statement cutoff|
|                            | are hidden. Verify filter date range.          |
+----------------------------+------------------------------------------------+
|  Miscalibrated Ending Bal  | Typo in initial Statement Ending Balance input. |
|                            | Click 'Edit info' to verify and correct.       |
+-----------------------------------------------------------------------------+

The "Reconciliation Discrepancy" Auto-Adjustment Trap

If a bookkeeper attempts to click "Finish now" with an unresolved difference, QBO prompts: "Your account isn't ready on this date. There's a difference of $X.XX. Would you like to adjust?"

[!CAUTION] The Cardinal Rule of CPB Reconciliation: NEVER accept an automatic reconciliation discrepancy adjustment. Accepting an adjustment causes QBO to post an arbitrary journal entry to the Reconciliation Discrepancies account. Forcing an adjustment conceals underlying bookkeeping errors, creates inaccurate financial statements, and violates professional bookkeeping ethics.

5. Handling Beginning Balance Discrepancies

When opening the Reconcile window, QBO may display a warning: "Your beginning balance is off by $X.XX. We can help you fix it."

+-----------------------------------------------------------------------------+
|                  BEGINNING BALANCE DISCREPANCY MECHANICS                    |
+-----------------------------------------------------------------------------+
|  Why it Happens:                                                            |
|  - A transaction that was reconciled in a PRIOR period ('R' status) has     |
|    been modified, deleted, un-cleared, or re-dated.                         |
|                                                                             |
|  How to Fix It:                                                             |
|  1. Click the link: 'We can help you fix it'.                               |
|  2. QBO generates the Reconciliation Discrepancy Report detailing:          |
|     - Specific transaction modified                                         |
|     - Type of change (Amount change, Status changed from R to blank/C)      |
|     - Reconciled Amount vs. Current Amount                                  |
|     - User who modified the entry (from Audit Log)                          |
|  3. Correct the offending transaction in the register.                      |
|  4. Verify the Beginning Balance discrepancy returns to $0.00.              |
+-----------------------------------------------------------------------------+

---

6. Reconciliation Reports & Audit History

Once a reconciliation is finalized with a $0.00 difference, QBO locks the cleared transactions and compiles the official Reconciliation Report.

Structure of the Reconciliation Report

1. Statement Beginning Balance: Starting cash/card balance.
2. Cleared Transactions Summary & Detail: All checks, payments, deposits, and transfers cleared during the cycle.
3. Statement Ending Balance: The reconciled ending balance matching the bank statement.
4. Uncleared Transactions (Outstanding Items):
   • Uncleared checks and disbursements (Outstanding Checks): Subtracted from the bank balance in financial analysis.
   • Uncleared deposits (Deposits in Transit): Added to the bank balance in financial analysis.
5. Post-Reconciliation Modifications: Documents any changes made to reconciled transactions after the reconciliation was finalized.

Accessing Historical Reconciliation Reports

To view, print, or export historical reconciliation records for annual tax preparation or CPA audit review:

1. Navigate to Accounting -> Reconcile.
2. In the upper-right corner, click History by account.
3. Select the Account and review the list of historical reconciliation dates.
4. Click View report to display, print, or export the PDF report.