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 Viewor 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
- Future Amount Current Period + 1
- Future Amount Current Period + 2
- Future Amount Current Period + 3
- Future Amount Current Period + 4
- Future Entered Amount
- Overdue (per quarter)
- Current Balance
- Future Balance (per quarter)
- Future Entered
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:
- Show Future Balances - Yes (Default) or No
- 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
Generating a Creditor Trial Balance Report
-
From the Home menu, select
Home > Reports > Financial Reports > Creditor Trial Balance.
-
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 (Supplier) Analysis Tab.
- Check the completed screens.
- 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.
- 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 to CSV.
-
To print from NX, click
Print.
About Creditors Trial Balance Parameter Fields
Calendar Period - This will default to the Creditors 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 Supplier.
Supplier From and To - The report can be based on a specific Supplier or for a range of Suppliers by using the drop-down selections.
Branch - Multi select list of (Transaction Analysis) branch is available.
Department - Multi select list of (Transaction Analysis) department is available.
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.
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 check box. Default is checked.