Related topics

About Bank Reports

Using the Reconciliation Status Report

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

Information on the report

For each bank:

  • Lists of transactions and subtotals for all transactions that display on the Reconcile Statements window.
  • 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 HRMS), 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 use the Print Deposit Details option, any deleted deposits display as empty deposits on the report, showing “Deleted” in the status column and zeroes in the other columns. If you used the Print Deposit Details option, deleted deposits do not display on the report.
  • A summary by bank for all selected banks displays at the end of the report.

When to print

  • When reconciling a bank account, review this report to help you determine why your reconciliation does not balance.
  • During Payroll setup, print the report before posting opening balance entries.

To print the report

  1. From the Navigation Pane, select Reports > Payroll > Bank Reports > Reconciliation Status.
  2. Specify the bank or a range of banks to include on the report.
  3. Specify criteria for selecting transactions to include on the report, including:
    • The range of dates to which transactions were posted.
    • The source application (or a range of applications) that sent the transactions to Bank Services.
    • Reconciliation Status options for withdrawals.

      An outstanding check is one that has not yet been paid by the bank.

      All posted checks (other than alignment checks, continuation checks, or incorrect or damaged checks that the subledger voided during posting), as well as transfers and transfer charges, initially appear with a status of Outstanding.

      A payment that has been reversed because it was returned by the bank or vendor, or for another reason such as a stop payment on a lost check. When you change a payment status to Reversed, then post the item, the subledger reinstates the associated original documents (for example, invoices and credit notes) to their amounts prior to the payment being issued.

      You assign this status to a withdrawal or a transfer from the bank that appears on the bank statement exactly as issued.

      The total amount of cleared withdrawals appears on the Totals tab of the Reconciliation window.

      You assign this status to a payment or withdrawal that cleared the bank with an amount different from its issued amount, if the error is greater than the spread specified in the bank record.

      When you post the reconciliation, the error is carried forward as an outstanding transaction for the next reconciliation.The Totals tab of the Reconcile Statements window shows the total amount of withdrawal bank errors for the current reconciliation.

      On the Reconciliation Status Report, a withdrawal bank error appears:

      • In the withdrawals section, if it will reduce the bank balance when it is corrected. Such errors include:
      • Payments and withdrawals that cleared the bank with an amount less than the actual amount.
      • Deposits that cleared the bank with an amount greater than the actual amount.
      • In the deposits section, if it will increase the bank balance when it is corrected. Such errors include: 
      • Withdrawals that cleared the bank with an amount greater than the actual amount.

      Assign this reconciliation status to withdrawals that clear the bank for amounts different from their issued amounts, where the difference is less than the error spread specified in the bank record.

      The Totals tab of the Reconcile Statements window shows the total amount of withdrawals cleared with a write-off.

    • Reconciliation Status options for Deposits.

      Not Posted status is used for:

      • Bank entries that you have saved, but not yet posted.
      • Accounts Receivable deposits that include unposted receipt batches. (The batch total is zero in Bank Services.)

      Once you post a bank entry or a deposit batch, its status changes to Outstanding.

      A deposit (receipt batch) or transfer that has been posted but not cleared has Outstanding status.

      Assign this reconciliation status to a deposit that cleared the bank with the same amount as the deposit recorded in Sage HRMS.

      The total amount of cleared deposits appears on the Totals tab of the Reconciliation window.

      Assign this status to a deposit that cleared the bank with an amount different from the deposit total posted in Sage HRMS, if the error is greater than the spread specified in the bank record.

      When you post the reconciliation, the error is carried forward as an outstanding transaction for the next reconciliation.

      The Totals tab of the Reconcile Statements window shows the total amount of deposit bank errors for the current reconciliation.

      On the Reconciliation Status Report, a deposit bank error appears:

      • In the deposits section, if it will increase the bank balance when it is corrected. Such errors include:
      • Deposits that cleared the bank for an amount less than the actual amount.
      • Payments and withdrawals that cleared the bank for an amount greater than the actual amount.
      • In the withdrawals section, if it will reduce the bank balance when it is corrected. Such errors include:
      • Deposits that cleared the bank for more than the actual amount.

      Assign this reconciliation status to deposits that clear the bank for amounts different from their posted amounts, where the difference is less than the error spread specified in the bank record.

      The Totals tab of the Reconcile Statements window shows the total amount of deposits cleared with a write-off.

      Deleted status is available only if all the receipt entries for the deposit were deleted. You change the Not Posted default status to Deleted on the Reconcile Statements window.

      Reconciliation Status report:  "Deleted" is an option in the Deposit Reconciliation Status area.

      This status is available for selection only when the Print Deposit Details option is not selected. The resulting report displays Deleted in the Status column of an empty deposit, with zeroes across the other columns. 

      Reconciliation Posting Journal: When you do not select Print Deposit Details as one of the options, the report will display an empty deposit on the report with a status of Deleted and zeroes across the other columns. 

  4. Select the Print Deposit Details option to print details of individual receipts in a deposit.
  5. Click Print.