Bank Reconciliation Report

Bank Reconciliation Report Overview

The Bank Reconciliation Report function within SapphireOne General Ledger Reports Menu enables the printing of completed Bank Reconciliations. The SapphireOne Bank Reconciliation report lists all transactions, both un-posted or posted, which have been entered against the selected bank accounts.

How to Create a Report

When the Bank Reconciliation Report is selected from the General Ledger Reports menu, the user is presented with the below dialog screen displaying the Bank Account IDs and Account Names. The user may select any Account and select OK

There may be a subset of accounts linked to the selected account. In this case, the user will be presented with a similar pop up screen that lists the linked subset accounts. The user may then select the subset account they would like to report on. In the example below, the ‘Main Bank’ has been selected and the linked subset main bank accounts are displayed. 

The Foreign Currency Bank Accounts are displayed in the second dialog screen as seen below. From here the user can choose the required Account, which in this example is the Currency, then select Edit

Next the user is offered the option to select the order in which the transaction data is to be sorted within the Bank Reconciliation Report.

Report Example

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

Accounts-General Ledger-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

SapphireOne’s implementation of both Dictation (MacOS) and Speech to Text (Windows) is a game changer for anybody doing data entry within SapphireOne. Any data entry field that the user can type into using a keyboard, they can use this feature.

They can also use this functionality on all inquiry screens within SapphireOne. For example, the user is in a Contact within a Client and they have just made a phone call to that particular client using the Softphone technology, this will automatically date and time stamp the contact and the phone number you called to. As soon as the call is completed or finished, the user has the ability to use the Speech to Text (Windows) function or Dictation (MacOS) function and dictate into the memo field of the CRM contact, adding as much description as they require.

This functionality applies across every single Data Entry screen. For example, if the user is entering a Vendor Invoice (VI) and they want to add a memo within the Vendor Invoice (VI), the user can simply dictate the memo. Another example is if the user wants to add additional lines to the General Ledger account, within each General Ledger account when the user is completing data entry using a General Ledger, there’s always a unique memo field for each General Ledger account line, the user can utilise this feature to quickly add the information they need to add. Additionally, if you’ve got an interview with an employee and after the interview process is completed the user is able to make notes about the employee.

Speech to Text or Dictation is an extremely powerful tool and it’s something that we at SapphireOne as well as our clients utilise daily. It is a massive timesaver. 


You can review our Blog and YouTube channel for additional information and resources on SapphireOne ERP, CRM and Business Accounting software.

Was this helpful?

Previous Article

FX Details Report

Next Article

Bank Audit Report