Creditor trial balance

Creditor trial balance

Prints a Trial balance showing the amounts outstanding from a particular Creditor or all Creditors and also BSP. This assists you in evaluating what Creditors are owed money.
The Creditor Trial Balance should be run in Summary either once a week or once a fortnight and the Grand total should agree to the General Ledger Creditor Control account for the same date. If this does not agree then reconciliation between the two accounts needs to be done to find the discrepancy. One reason may be due to mispostings on a list/update or Journal entries. At the end of the month a Detailed Creditor Trial Balance should be run so you have a record of the Creditor entries.

Click on Accounting | Creditor Ledger | Creditor Trial Balance.

  • The date defaults to today’s date.
  • Select Summary to get initial totals, Detailed if needing to see individual entries associated with each Creditor. The Reconciliation option is run for a particular period in time to reconcile to the General Ledger Creditor Control account for the same period in time.
  • Select either Account Code or Account Name
  • Select the ageing cycle
  • Ageing periods can be All balances or if you want Non Zero Balances select the button to Gre en on Non
  • Zero as in example below.
  • Enter Account type Both.
  • Reports to print – these are additional reports to the Creditors Ledger. The red cross can remain as this indicated that these reports would print.
  • Select Class is optional.
  • Enter Starting Creditor Account and Ending Creditor. Choose from drop down boxes. To run a Trial
  • Balance for just one Creditor put the same Creditor name in starting and ending Creditor account.
  • Click on Start. The Print Preview option is to print the report to the screen