Skip to main content

Reports & Queries

This is where all the bank/cash reports such as the cash bank status query, bank/cash summary and bank cheque dashboard. The available reports in the Reports/Queries also have the capability to be exported to Microsoft Word, Excel and PDF. Users can filter the reports according to whether it is a bank or cash and their preferred time period.

image.png

Cash Bank Status Query

Click on Cash Bank Book – Report & Queries – Cash Bank Status Query icon for the following screen.

image.png

You may seek by individual cash or bank code, and the date range you want to view. After this is done, the system will call out the filtered transactions.

Reports & Queries

Click on Cash Bank Book – Reports & Queries – Reports & Queries icon for the following screen.

image.png

These reports may be sent to a previewed to print, click on to Preview. You may seek an individual report, and the following data can in turn be drilled down to transaction level.

  • Mater Listing – Currency Rates
  • Bank Reconciliation (Local Currency)
  •          Bank Reconciliation (Foreign Currency)
  •         Cash Bank Book (Local Currency)
  •         Cash Bank Book (Foreign Currency)
  •         Bank Realized Listing
  •         Bank Unrealized listing
  •         Cheque Deposit listing

 

 

Bank/Cash Summary

Click on Cash Bank Book – Reports & Queries – BankBank/Cash Summaryicon for the following screen.

image.png

A Bank/Cash Summary provides an overview of a company's cash opening, closing and ledger balance during a specific period. It helps track the movement of funds and provides a clear snapshot of liquidity and available cash. This summary is essential for ensuring that a company can meet its financial obligations, manage working capital effectively, and reconcile its records with bank statements to ensure accuracy and avoid discrepancies.

Bank Cheque Dashboard

image.pngA Bank/Cheque Management Dashboard shows bank/cheque-related transactions for a business or organization. It consolidates essential data such as Trn, Ref No, Cheque Number, Type, Supplier/Customer, issue date, posted date, bank in/collected date. The dashboard can filter the status of cheque to posted, unposted or both.  Filter using the the issue date, post date, Bank-in from and Cheque No

Back to top