Reports Menu > Creditors > Creditors Trial Balance |
The Creditors Trial Balance allows users to generate a report displaying the balances of creditor accounts using a selection of parameters.

Creditors Trial Balance Screen
Parameter Name |
Description |
Starting Vendor Ending Vendor Local/O'Seas Trade/Other |
Parameters to restrict the vendors you wish to see on the report. |
Creditors Period |
The Creditors Period in which to run the report. Selecting a period prior to the current actual date will run the report showing the creditors position as at the end of the period selected. |
Age By |
Invoice Date - Ageing will be calculated using the invoice date. Due Date - Ageing will be calculated using the invoice due date. G/L Period - Ageing will be calculated using the general ledger batch date (ie the date the invoice was posted to the general ledger.) |
Creditors Over 30/60/90/120 Days |
All - All ageing will be displayed for creditors using the selected parameters. 30 Days - Only creditors with balances in 30 Days or greater ageing will be displayed using the selected parameters. 60 Days - Only creditors with balances in 60 Days or greater ageing will be displayed using the selected parameters. 90 Days - Only creditors with balances in 90 Days or greater ageing will be displayed using the selected parameters. 120+ Days - Only creditors with balances in 120+ Days ageing will be displayed using the selected parameters. |
Show Credit Balance Accounts |
Yes - Creditor accounts with a negative balance will be included in the report. No - Creditor accounts with a negative balance will NOT be included in the report. |
Show Zero Balance Accounts |
Yes - Creditor accounts with a zero balance will be included in the report. No - Creditor accounts with a zero balance will NOT be included in the report. |
Invoices Due On or Before |
Will calculate and display creditor balances based on invoices due on or before the date entered. |
Sort By |
Vendor - The report will sort and display by Vendor Code. Trade/Other - The report will sort and display by Vendor Type, Trade or Other. Local/O'Seas - The report will sort and display by Local vendors and Overseas vendors. |
Summary/Detail/Totals Only |
Summary - Generates a summarised report of creditor balances. Detail - Generates a detailed report of creditor balances showing outstanding transactions. Totals Only - Generates a report showing ageing totals only. |
New page per Section |
Yes - When printed the report will print on separate pages when sorted by any of the Sort By parameters excluding Vendor. |
When the required parameters have been entered, the Creditors Trial Balance will be generated.

Example of Creditors Trial Balance - Detail

Example of Creditors Trial Balance - Summary

Example of Creditors Trial Balance - Totals Only