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.
Cash Bank Status Query
Click on Cash Bank Book – Report & Queries – Cash Bank Status Query icon for the following screen.
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.
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 – Bank/Cash Summary for the following screen.
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
A 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 usingis thealso applicable to the issue date, post date, Bank-in from and Cheque No to pull up a transaction.