The Bank Reconciliation Report is a crucial financial document generated after you successfully complete a bank reconciliation in Aplos. It provides a detailed, date-specific summary of how your book balance aligns with your actual bank statement balance.

Book Balance vs. Bank Balance

You may notice that you have a list of uncleared transactions on your Bank Reconciliation Report. They’ll most likely be included in your reconciliation the following month. They also help you identify potential differences between your Bank Balance and Book Balance.

• Bank Balance is the ending balance appearing on a bank statement. For example, when an organization receives its June checking account statement from the bank, the June 30 balance will be the bank balance.
• Book Balance refers to the amount shown in the organization’s records. For example, the book balance listed in your current accounting solution as of June 30 refers to the balance in the general ledger account Cash or Checking Account.

It is typical for a bank balance to not agree with the amount in the organization’s records since some checks written will not have cleared yet or some money received may not have appeared yet on the bank statement. When you perform a bank reconciliation, you identify these uncleared transactions and ensure all cleared transactions were entered correctly.

Accessing the Report

There are two primary ways to access a completed Bank Reconciliation Report:

1. From the Reconciliation Screen (Easiest Method):
   • Navigate to the Bank Reconciliation screen.
   • Click on the Reconciled tab.
   • Select the specific reconciliation report you wish to view.
2. From the Reports Screen:
   • Go to the main Reports tab.
   • Find the report listed under the Other section (typically in the middle of the page).
   • If accessing the report this way, you must use the report filters to select the correct Register (bank account) and the specific Statement Date for the reconciliation you want to view.

Key Sections of the Report

The Bank Reconciliation Report is designed to provide a comprehensive paper trail of the reconciliation process, showing the adjustments between your records and the bank's records:
 

1. Reconciliation Overview

The top of the report summarizes the core details of the reconciliation:

• Reconciled Date: The date the reconciliation was completed in Aplos.
• Register: The specific bank account register the reconciliation was performed for.
• End Date of Statement: The ending date of the bank statement used for the reconciliation.
• Ending Balance: The ending balance as reported on your bank statement.

2. Summary of Balances

This section shows the mathematical breakdown of your book balance:

• Opening Balance: The starting balance carried forward from the previous reconciliation period.
• Payments & Deposits: A total of all cleared payments (checks) and deposits processed during this period.
• Ending Bank Balance: The final, verified balance.

3. Summary of Transactions

This section distinguishes between items that have been cleared and those that are still outstanding (uncleared):

• Cleared Amount: The total dollar amount of transactions cleared by the statement date.
• Uncleared Transactions: A summary of transactions that are in your Aplos register but have not yet appeared on your bank statement (cleared) by the statement date.

4. Detailed Transaction Breakdown

The bottom of the report lists all individual transactions organized by status and date:

• Cleared Transactions (Checks/Payments & Deposits): All transactions that were successfully matched and cleared by the end date of your bank reconciliation statement.
• Cleared Transactions as of Reconciled Date: This section shows all transactions cleared up to the actual date you ran the reconciliation.
• Uncleared Transactions Up to Date: This lists transactions that were recorded in your Aplos register but remained uncleared up to the date you completed the reconciliation.

This detailed report is invaluable for auditing and filing purposes, serving as the official record of the reconciliation for your chosen period. Many organizations download and file this report to ensure they maintain a complete paper trail.