Bank Reconciliation Reports

Caroline Buckland Updated by Caroline Buckland

Bank Reconciliation Reports

Two reporting procedures are provided.

Period Reporting

The Bank Statement Report Process produces a suite of reports that mirror the Summary and Detailed Enquiry screens. The significant difference between the report and the enquiries is that the user can set a parameter date for the report. The enquiries are always produced with current balances. There will be times when the user is required to produce supporting documentation for Bank Reconciliations in prior periods.

For Example

The company has rolled the year over and set period 1 as the current year, yet the postings to the prior year have not been finalised. The final Bank Statements for the year also may not have been taken into the system, yet postings may already have been made for period 1.

Once the Bank Reconciliation is finalised, it will be necessary to provide supporting documentation for the bank reconciliation that does not include any processing from the New Year. The Bank Reconciliation Reports can provide this documentation.

The process EW8 will generate the following reports: -

  • Unpresented Payments List
  • Deposits Not Banked List
  • Miscellaneous Items Not Reconciled
  • Bank Items Not Reconciled
  • Bank Reconciliation Errors
  • Bank Reconciliation Summary

In addition to the reconciliation reports the bank reconciliation processes will also produce error reports where applicable. Bank Reconciliation Transactions are held on a table, and these transactions usually have a status of “R” for reconciled or “U” for unreconciled. In instances where the system generates General Ledger journals as part of the reconciliation process, e.g. Bank or GL adjustment journals (refer 5.3.4 Reconcile Transactions with a Mismatch in Values) or during the unmatching process, the reconciliation transactions are labelled with a temporary status of “A” or “B” until the system generated journal is successfully posted to the general ledger. If the bank, for which the user has requested the report, contains any transactions with a status of “A” or “B”, the error report will be produced.

To determine if adjustment transactions are unprocessed, it is suggested the user check the List Journals and select In Error batches (General Ledger>GL Process>GL Data Entry>List Journals) and then identify and correct any batches that contain postings for the selected bank account. The system will automatically change the transaction status to “R” (if matching) or “U” (if unmatching) once the GL batch processing has completed. The Bank Reconciliation Reports should now run successfully.

Bank Reconciliation Report Submission

The submission of the Bank Reconciliation Reports is accessed from the Bank Reconciliation Enquiries> Bank Reconciliation Reports

The following fields are required:-

User Defaults from User Login Details.

Schedule Leave Blank.

Process Defaults to EW8, can be changed to EW8A to run the current reports.

Request Leave Blank.

Company Enter the appropriate two character company code in this field. The company will only be valid if the Bank Reconciliation Company Controls exist.

GL Period Enter a valid GL period. Report details will be as at the period end date of the selected GL Period and Year.

GL Year Enter a valid GL Year. Report details will be as at the period end date of the selected GL Period and Year.

Select the ‘SUBMIT’ button to bring up the ‘confirm submit window – 1’ click the ‘submit’ button again, the Bank Statement Report process will now run and complete in the background without any further user intervention.

Access the following menu to review each report.

Bank Reconciliation Enquiries> Review Bank Reconciliation Reports.

Example report, opened from the paperclip.

Was this article useful?

Bank Reconciliation Enquiries

Contact