Column balances customer

The Column balances customers report type allows you to list all customer accounts, or only those accounts with balances.

This will list the debit and credit balances for the customer 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).

Created with the Personal Edition of HelpNDoc: Easy CHM and documentation editor