The Column balances creditor report type allows you to list all creditor (supplier) accounts, or only those accounts with balances.
This will list the net balances (debits minus credits) for the creditor (supplier) accounts.
It will list the transactions totals for each period.
This report cannot be printed but can be exported to a spreadsheet (e.g. OpenOfficeCalc / LibreOffice Calc or Microsoft Excel, etc.).
The periods are as follows:
1.Opening Balance Last Year - Period -1
2.Periods - This is last year periods - usually 1 to 12 (depending on the number of periods and descriptions specified and entered in Setup → Reporting dates).
3.Period Total - The total of the period totals for last year.
4.End Last Year - Opening Balance Last Year total and the Period Total.
5.Opening This Year - Period 0 - This should be the same as the End Last Year totals.
6.Periods - This is the current year (this year) periods - usually 14 to 25 (depending on the number of periods and descriptions specified and entered in Setup → Reporting dates).
7.Period Total - The total of the period totals for this year.
8.End This Year - Opening Balance This Year total and the Period Total (This Year).
You may double-click on an account and / or in a specific period to list and view the transaction details in the T-Account viewer. You may be print the transactions.
Created with the Personal Edition of HelpNDoc: Generate Kindle eBooks with ease