Creditors Trial Balance Report

The Creditors Trial Balance report shows a summary of the amounts owed to a selection of Suppliers 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 in View or PDF, the information available in the generated report is:

  • (Supplier) Code.
  • (Supplier) 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 (Amount).
  • Future (Amount Current Period) + 1.
  • Future (Amount Current Period) + 2.
  • Future (Amount Current Period) + 3.
  • Future (Amount Current Period) + 4.
  • F(uture) Entered (Amount).

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

The report can be generated with the following parameters:

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

 

Example Creditor Trial Balance Report:

Generating a Creditor 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 Creditor Trial Balance to go to the Creditor Trial Balance Parameters screen:

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

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

  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 dropdown selections or checkboxes 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 .

About Creditors Trial Balance Parameter Fields

Balance Tab

Periods In Year

This will default to the Creditors Ledger current accounting period.  The dropdown selection provides a list of available financial periods.

Currency

Selection of available currencies can be made by using the dropdown selection Supplier.

Supplier From/To

The report can be based on a specific Supplier or for a range of Suppliers by using the dropdown selections.

Branch

Multi select options for available (transaction) branches.

Department

Multi select options for available (transaction) departments.

Analysis Tab (Supplier Analysis)

Analysis Codes 1-6

Multi select list of Supplier 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, Outstanding Transactions.

Show Future Balances

Show Future Balances checkbox (by default this is checked).