Please enable JavaScript to view this site.

 

mouse

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 

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 - Detail

 

Example of Creditors Trial Balance - Summary

Example of Creditors Trial Balance - Summary

 

Example of Creditors Trial Balance - Totals Only

Example of Creditors Trial Balance - Totals Only

  

Keyboard Navigation

F7 for caret browsing
Hold ALT and press letter

This Info: ALT+q
Page Header: ALT+h
Topic Header: ALT+t
Topic Body: ALT+b
Contents: ALT+c
Search: ALT+s
Exit Menu/Up: ESC