Bank Reconciliation
Use the Bank Reconciliation screen to reconcile the transactions that have been cleared through your bank.
The Bank Reconciliation screen can be accessed Financial Management > General Ledger > Bank Reconciliation.
Topics in this section are:
Overview
Bank Reconciliation records every entry made to the bank to the bank's statement. This is the recommended method to perform reconciliation. See Performing a Bank Reconciliation.
Note: The Bank Reconciliation option only appears if the Reconciliation Type is set to Bank Reconciliation. This field is password protected however, so if you want to change the value of the field contact your system administrator.
The Bank Reconciliation listing screen shows all of the bank accounts configured as Special Accounts on the Configuration > General Ledger > G/L Accounts > Special Accounts screen.
When bank reconciliation is enabled any miscellaneous entries to a bank account general ledger account, such as bank fees or interest, should be made using General Invoicing or Vouchers. For making bank deposits, use Vouchers.
Screen Description
The fields on the Bank Reconciliation screen are:
| Field | Description |
|---|---|
| Account Number | The account number. |
| Description | A description of the account. |
To open an account and reconcile it, hover over the Account Number and select Edit.
To print the Bank Reconciliation Outstanding Checks report (BNKRC08), hover over the Account Number and select Outstanding Checks.
To print the Log of Check Numbers Assigned report (BA0002) you must update your cash receipt batch file. Use this report to generate a list of duplicate check numbers.
To reverse a check, click the Reverse a Check link. See Check Reversal.
To create a positive pay file, click the Create Positive Pay File link. See Download.
To upload a check reconciliation file, click the Upload a Check Reconciliation File link. See Check Reconciliation.
Data Source: PFWTAB (SPECACCT table)
Security: 602 -Financial Management - General Ledger
Revision: 2025.07