Debtors Trial Balance Report

The Debtor Trial Balance Report shows an aged summary of amounts owed by a selection of agents for the current accounting period and the 4 previous accounting periods. The option exists to display Future balances.

Current period or outstanding transactions can optionally be output.

NOTE: Listing outstanding transactions can be very resource intensive.

When the report is run to View or PDF the information available in the report is:

  • Agent Code
  • Agent Name
  • Currency
  • Overdue Amount Current Period - 4
  • Overdue Amount Current Period - 3
  • Overdue Amount Current Period - 2
  • Overdue Amount Current Period - 1
  • Current Period
  • Total
  • Future Amount Current Period + 1
  • Future Amount Current Period + 2
  • Future Amount Current Period + 3
  • Future Amount Current Period + 4
  • Future Entered Amount

When running the report to a CSV file the Debtor Analysis 1-6 fields are also output.

The report can be generated with the following parameters:

  • Show Future balances - Yes (Default) or No
  • Report Currency - Base (Default), Branch or Foreign Currency
  • Skip Nil Balances - Yes (Default), No or Include Future
  • Show transactions - No Transactions (Default), Outstanding Transactions or Current Period Transactions
The report will always order by Agent Code when selecting PDF or View, there is no option in the report parameters to order differently. To re-order the data, the report will need to be downloaded to CSV and any data re-ordering done from within Excel.

 

Example Debtor Trail Balance Report

Generating a Debtor Trial Balance Report

  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 Debtor Trial Balance to go to the Debtors Trial Balance Parameters screen:

  2. On the blank Debtors Trial Balance Parameters screen, the Balance Tab will open. Select the required parameters for the Debtors Trial Balance Report

    NOTE: There are 2 tabs available to select parameters from. They are: Balance Tab, and (Agent) Analysis Tab.

  3. Check the completed screens.
  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 .

Debtor Trial Balance Parameter Fields

Balance Tab

Calendar Period - This will default to the Debtors Ledger current accounting period.  The drop-down selection provides a list of available calendar periods.

Currency - Selection of available currencies can be made by using the drop-down selection.

Agent From and To - The report can be based on a specific Agent or for a range of Agents using the drop-down selections.

Branch - Multi select list of (Transaction Analysis) branch.

Department - Multi select list of (Transaction Analysis) departments.

Analysis Tab

Analysis Codes 1-6 - Multi select list of Debtor Analysis codes can be used to refine the report if necessary. To expand the fields use the +, and to minimise the analysis list use the -.

NOTE: Analysis codes in the above screen capture are used for training purposes. User company systems will have analysis fields and codes unique to their organisational requirements.

Other Tab

Report Currency - Selection of Base (Default), Branch or Foreign.

Skip Nil Balances - Selection of Yes (Default), No or Include Future.

Show Transactions - Selection of No Transactions (Default), Current Period Transactions or Outstanding Transactions.

Show Future Balances - Show Future Balances check-box. Default is checked.