Unallocated Cash Report
The unallocated cash report enables users to report on:
- Fully allocated receipts or
- The allocated values only or
- The display of unallocated values only.
NOTE: An 'Allocated' amount is an amount that has been allocated against the unallocated receipt while it is still in an open period. An 'Applied' amount is an amount applied to the unallocated receipt when the original unallocated receipt is in a closed period.
The report provides the following detail:
- Agent (Code).
- Tran(saction) Date.
- Receipt Type.
- Transaction Item.
- (Transaction) Reference.
- Apply Reference.
- Currency.
- Allocated (Amount).
- Unallocated (Amount).
- Applied (Amount).
- Exchange Rate.
- Base Allocated.
- Base Unallocated (Amount).
- Base Applied (Amount).
Generating Unallocated Cash Reports
-
From the Home menu, select
Home > Reports > Financial Reports > Unallocated Cash.
-
On the blank Unallocated Cash List Parameters screen, the Accounting Tab will open. Select the required parameters for the Unallocated Cash Report.
- Check the completed screen.
- Click on the Other Tab. Select how the results are to be ordered and filtered in the report from the dropdown selections or checkboxes available.
- Select how the report is to display.
-
To view the report, click
View.
-
To Download the report to a PDF file, click
Download PDF.
-
To Download the report to a CSV file, click
Download CSV.
About Unallocated Cash Parameter Fields
Transaction Period From/To
A specific transaction period or range of transaction periods can be used.
Transaction Date From/To
Transaction date (or range of).
Agent From/To
View transactions for a range of agents.
Entered Period From/To
The financial accounting period the transaction was entered (or range of).
Date Entered From/To
Booking date entered (or range of).
Input Currency
Multi select options for available (transaction) input currency.
Transaction Order By
Report data can be selected by using the dropdown to order by:
- Agent Transaction Date (Default).
- Currency, Agent, Transaction Date.
Report Currency
Selection of Base, Branch or Foreign can be used to produce report in a particular currency (base is the default).
Show Fully Allocated Receipts
Checkbox for the report to show receipts fully allocated.
Only Show Unallocated Values
Checkbox for the report to generate data for unallocated transactions.
Branch
Multi select options for available (booking) branches.
Department
Multi select options for available (booking) departments.