Bank Reconciliation Report - Empower Your Financial Analysis

Bank Reconciliation Report Overview

The Bank Reconciliation Report function, found within the SapphireOne Accounts > General Ledger > Reports Menu, facilitates the generation of completed Bank Reconciliations. The report compiles a comprehensive list of all transactions, whether they are un-posted or posted, that have been recorded against the chosen bank accounts in SapphireOne.

How to Create A Bank Reconciliation Report

First Alert

When you select the Bank Reconciliation Report from the General Ledger Reports menu, an alert will appear, presenting a list of various Bank Accounts along with their corresponding IDs and Names. From this list, you have the option to choose any desired Account by either clicking on it and then selecting OK or by double-clicking on the selected bank account. This user-friendly interface allows you to easily specify the bank account for which you wish to generate the Bank Reconciliation Report.

Second Alert

There may be a subset of accounts linked to the selected account. In this case, the user will be presented with a second similar alert that lists the linked subset Bank Accounts.

Within this second alert, the user has the flexibility to choose between the main local bank account or any of the FX bank accounts, which are subsets of the main bank account. To make a selection, simply pick the desired local or FX Bank Account, and then click the OK button. This intuitive interface allows users to specify the exact bank account they want to access for the Bank Reconciliation Report, whether it’s a local or foreign currency account.

Sorting Alert

Report Example (Bank Reconciliation Report)

Below is an example of the first page of the SapphireOne Bank Reconciliation Report. 

Transaction Status Codes

Posted	Description	Posted	Description
Err	Transaction has an error.	Yes	Transaction is Posted.
Ent	Transaction is Entered but not Posted.	Rec	Transaction is Reconciled.