Bank Reconciliation Status Report

Overview

Note: Depending on how your system is set up, this desktop screen may also be available as a web screen. For more information, see the Web Screens Getting Started Guide or the help for Sage 300 web screens.

The Bank Reconciliation Status report lists the status of all transactions for a bank account, with amounts stated in the bank's statement currency.

When to Print

Print this report:

  • When reconciling a bank account, to help you determine why your reconciliation does not balance.
  • During Bank Services setup, before posting opening balance entries.

Information Printed on This Report

The report includes the following information:

  • For each bank:

    • Lists of transactions and subtotals for all transactions that appear on the Bank Reconcile Statements screen.
    • The bank total (the sum of all transactions that increase the bank balance, less the transactions that decrease it).
  • For each transaction:

    • The reconciliation status (for deposits, checks, or returned customer checks), or the transaction type description (for bank statement entries).
    • The document amount (that is, the item amount recorded in Sage 300), the cleared amount (entered when you reconciled the bank account), and the amount of the clearing difference. If the item has not been reconciled, the cleared amount is zero.
    • If you did not select the Print Deposit Details option, any deleted deposits appear as empty deposits on the report, showing “Deleted” in the status column and zeroes in the other columns. (If you selected the Print Deposit Details option, deleted deposits do not appear on the report.)
    • A summary by bank for all selected banks appears at the end of the report.