Skip to main content

Cashbook Reports

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

Cashbook Reports

From the menu bar, select Reports and then choose Cashbook and make a selection from the sub menu.

mceclip0.png

Select from the following reports:

Dishonoured Cheques Report

This report lists all dishonoured cheques entered into the Cashbook.

  • To produce a Dishonoured Cheques Report, select this item from the submenu.
  • Transaction date from/to
    • Enter the date range to be view.
  • Agency
    • Select the Agency the use wishes to run this report for.

mceclip1.png

  • Click on the Retrieve button to display the report data. Click the Print, Preview or Save As buttons if required.

Account Trial Balance

This report produces an itemised debit and credit balance for each Cashbook account with a final total balance. The Last Year Account Trial Balance report shows all GL accounts as totals.

  • To produce an Account Trial Balance Report select this item from the submenu
  • Complete the following fields if required:
    • Trial Balance
      • This provides a summarised report listing only total balances for each General Ledger account code.
    • Detailed Trial Balance
      • This provides a detailed report listing all transactions on each General Ledger account code, plus any transaction remarks.
    • Last Year’s Trial Balance
      • This will provide account balances of all General Ledger accounts as at the end of the previous financial year, including end of year adjustments.
    • Account
      • Select a General Ledger account code to report on one specific account only. If this field is left blank a list of all accounts is displayed.
    • Start Date:/End Date
      • Input the date range to be reported.
    • Agency
      • Select the Agency the user wishes to view this report for.
  • Tick the Suppress Zeros box with the Trial Balance and Last Year’s Trial Balance Reports.
  • Click on the Retrieve button to display the report data. Click the Print, Preview or Save As buttons if required.

Note:  Additional parameters allow users to retrieve report based on a defined set of accounts. The user is able to filter accounts of a particular type based on the number series. For instance, income accounts can be retrieved based on the number series starting with 10000. Expense accounts can be retrieved based on number series starting with 20000.

This functionality is applicable to both Trial Balance and Detailed Trial Balance.

mceclip2.png

 

Payment Listing Report

Provides a report giving full details of all payment types requested for all agencies attached to the Account selected.

  • To produce a Payment Listing Report select this item from the sub-menu.
  • Complete the following fields if required:
    • Transaction date - Enter a date range.
    • FOP Type
      • Select a specific Form of Payment to be reported. Leave blank to report on all Forms of Payment.
    • Cheque Nbr
      • Enter a cheque number or range of numbers.
    • Transaction Status
      • Select a specific transaction status code to report only on those transactions. Leave blank to report on all status codes.
    • Account Id
      • Double click in this field to display a window where the required account can be selected. Only General Ledger accounts are displayed.
  • Click on the Retrieve button to display the report data. Click the Print, Preview or Save As buttons if required.

General Ledger Export Report

This report shows the monetary movement within each Cashbook account for a specified monthly period and provides the necessary data for input into an external accounting package. The system does not export the data; it simply provides a printed listing of the required figures.

  • To produce a General Ledger Export Report, select this item from the Cashbook submenu.

mceclip3.png

  • Account Period ID
    • This field automatically defaults to the current period. Click this field to open a drop down scroll and select another period if required.
  • Click on the Retrieve button to display the report data. Click the Print, Preview or Save As buttons if required.

Back Office Report

This report shows the monetary movement within each Cashbook account for a specified period and provides the necessary data for input into an external accounting package. The system does not export the data; it simply provides a printed listing of the required figures.

If the user prefers to update an external accounting system more regularly than once a month, the Back Office Report should be used to obtain Cashbook Account figures.

The Back Office Report allows the entry of a date range and shows the movement within each CCTE Cashbook Account since the last time this report was generated and saved to file.

mceclip4.png

After the Back Office Report has been run and saved to file, CCTE transactions cannot be back-dated into the reporting period that ends with the To date used to create the most recent Back Office Report.

The fields in the Back Office Report screen are:

  • Report Type
    • Select from the following options:

mceclip5.png

  • From (Date)
    • This report prints the incremental change in the balance in each account, therefore the From date field cannot be changed. This ensures that all transactions in the current reporting period will be included in the report totals. This field defaults to a date after the last date that the report was run
  • To (Date)
    • The To date field defaults to yesterday’s date. This date can be changed to any date between the From date and today's date
  • Account Export Version
    • Leave this field with the default setting as it no longer has an impact on the data.

Click on the Retrieve button to display the report.

mceclip6.png

 

Saving the Report

After the Back Office Report is displayed on your screen, click on the Save As button to begin the transfer process.

The Text file will then be saved on a local hard drive in your office. A default directory will be shown but any accessible place within your network can be located to save the file about to be created.

mceclip7.png

 

Warning Prompt

A warning prompt will remind the user that after this report has been run and saved to file, CCTE transactions cannot be back-dated into the reporting period that ends with the To date used to create the most recent Back Office Report. This will guarantee that the data in the Back Office system is a reflection of the same figures appearing in CCTE.

mceclip8.png

If the user selects No, the file is not generated and may exit the report screen.

If Yes is selected, a file is created containing the information displayed in the report and all users of CCTE are unable to backdate into this reporting period.

Related articles