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
  • Transaction 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. From the Home menu, select .
    1. Click the Reports menu to expand it:

    2. Click the Financial Reports menu option to expand it:

    3. Click Unallocated Cash to go to the Unallocated Cash Parameters screen:

  2. On the blank Unallocated Cash List Parameters screen, the Accounting Tab will open. Select the required parameters for the Unallocated Cash Report
  3. Check the completed screen.
  4. Click on the Other Tab. Select how the results are to be ordered and filtered in the report from the drop down selections or check boxes available.
  5. Select how the report is to display.
    1. To view the report, click .

    2. To Download the report to a PDF file, click .

    3. To Download the report to a CSV file, click .

    4. To print from NX, click .

About Unallocated Cash Parameter Fields

Accounting Tab

Transaction Period From and To - A specific transaction period or range of transaction periods can be used.

Transaction Date From and To - Transaction date from and to.

Agent From and To - Transaction for a range of agents.

Entered Period From and To - Transaction date entered from and to.

Date Entered From and To - Booking date entered (or range of).

Input Currency - Multi select transaction list input currency.

Other Tab

Transaction Order By - Report data can be selected by using the drop down 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 - Check box.

Only Show Unallocated Values - Check box.

Transaction Type - Multi select booking branch. (The heading for this field has been updated to reflect heading and field selections for 'Branch' in NX Version 1.2. Previous versions may show Transaction Type).

Department - Multi select booking department. (The heading for this field has been updated to reflect heading and field selections for 'Department' in NX Version 1.2. Previous versions may show Input Currency).