Skip to main content

Bank Reconciliation

www.trestechnologies.com
© Tres Technologies. All Rights Reserved.

Bank Reconciliation

From the menu bar, select Reports then choose Bank Reconciliation and a sub menu will be displayed.

mceclip0.png

Select the report required:

 

Detailed Bank Reconciliation

This report gives a system generated statement, showing unpresented deposits and cheques, in order to facilitate reconciliation.

To produce a Detailed Bank Reconciliation:

  • From the menu bar, select Reports, then choose Bank Reconciliation and choose Detailed Bank Reconciliation.

mceclip1.png

  • Complete the following fields as required:
    • Bank Account ID
      • Double click this field to display a window where the required account can be selected.
    • Statement Page
      • Enter the statement page number for the statement to be viewed.
    • To ACCTE Period
      • Double click this field to display a window showing account periods.
      • Highlight the required period and click OK.

  • Click the Retrieve button to display the report data.

  • Click on the Print, Preview or Save As buttons if required.

Bank Statement Report

This report prints a system generated Bank Statement based on the statement reconciliations that have been completed through the Cash Book.

To produce a Bank Statement Report:

  • From the menu bar, select Reports, then choose Bank Reconciliation and choose Bank Statement Report.

mceclip2.png

  • Complete the following fields as required:
    • Bank Account - Select the bank account required.
    • Statement Page Number from/to
      • Select a single statement, or a range of statements, by entering the required page numbers. The page numbers are listed on the Statement Tab screen of the Cash Book.
    • Statement Date - Input a statement date to print a specific statement.
    • Summary - Select Summary to show totals only.
    • Detailed - Default - Select Detailed to print an itemised list of all transactions.
  • Click on the Retrieve button to display the report data.
  • To print the report click on the Print button.

Unbatched Receipts Report

This report produces a list of all receipts which have not been batched into a bank deposit.

  • To produce an Unbatched Receipts Report select this item from the submenu.

mceclip3.png

  • Complete the following fields as required:
    • Transaction date from/to
      • Input a date range to report on Files with accounting transactions within the specified range.
    • Account Id
      • Select the account required for this report.
    • Agency
      • Select the Agency the user wishes to run this report for, and if this is the Transaction Agency or the Created In Agency.
  • Click on the Retrieve button to display the report data.
  • To print the report, click the Print button.

Unpresented Cheques Report

This report provides a list of all cheques that have been issued but not as yet shown as presented on the Bank Statement.

  • To produce an Unpresented Cheques Report select this item from the submenu.

mceclip4.png

  • Bank Account
    • Double click this field to display a window where the required bank account can be selected. Only General Ledger accounts are displayed.
  • Click on the Retrieve button to display the report data. Click on the Print, Preview or Save As buttons if required.

Deposit Batch Report

This report allows production of a list of either all Deposit Batches that have been reconciled to a Bank Statement, or all Unreconciled Deposit Batches.

  • To produce a Deposit Batch report, select this item from the sub-menu.

mceclip5.png

  • Bank Account
    • Double click in this field and select the required account for this report.
  • Report Type
    • Select either:
      • Unreconciled Deposit Batches (default)
      • Reconciled Deposit Batches
  • Click on the Retrieve button to display the report data. Click the Print, Preview or Save As buttons if required.

 

Related articles