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).
Example Unallocated Cash Report:

Generating Unallocated Cash Reports

  1. On the blank Unallocated Cash List Parameters screen, the Accounting Tab will open. Select the required parameters for the Unallocated Cash Report.
  2. Check the completed screen.
  3. 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.
  4. Select how the report is to display.

About Unallocated Cash Parameter Fields

Accounting Tab

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.


Other Tab

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.