Using the Reconciliation Posting Journal Report

This report is an audit trail of all transactions posted during bank reconciliation. It includes checks and deposits that cleared the bank, as well as entries that Bank Services created to account for clearing differences, exchange gains and losses, and bank errors. All transactions are shown in the bank's statement currency.  

Information on the report

• A list of deposits, payments, bank entries, and transaction for which the reconciliation status changed during posting.
• Deposit amounts that remain outstanding.
• Payment amounts that remain outstanding.
• Deposit and payment amounts written off during bank reconciliation posting.
• If you selected the Print G/L Summary option, you see a summary, by posting sequence, of general ledger entries that were posted during reconciliation.
• Deleted deposits display as empty deposits with a Deleted status, and with zeroes across the other columns (if you cleared the Print Deposit Details option).

After posting a reconciliation, you should print this report and keep it as part of your audit trail.

To print the report

1. From the Navigation Pane, select Reports > Payroll > Bank Reports > Reconciliation Posting Journal.
2. Select the range of posting sequence numbers to include in the report.
3. Select the following report options, as needed:
• Reprint Previously Printed Journal

  Select this option if you want to include information from posting journals that you printed before.

• Clear All Printed Journals

  Select this option if you want to clear the posting journals for all posting sequences after printing them.

  Note that you must print the report to a printer or file if you want to clear the posting journals.

• Print Deposit Details

  Select this option to print details about each receipt that made up the deposit.

  Do not select it if you want to see only deposit totals for deposits that have Outstanding or Cleared With Bank Error status.

• Print G/L Summary

  Select this option to print a summary page that shows the G/L accounts and the amounts that were debited and credited when you posted the reconciliation.

4. Click Print.

Additional information

Published: May 17, 2017
© 2017 The Sage Group plc or its licensors. All rights reserved. Privacy Policy | Copyright/Trademarks