This report shows monthly totals of Invoices and Receipts and the monthly change in outstanding balance for the selected Customers for a specified calendar year.

Period: Paste Special Reporting Periods setting, System module; Enter the start and end date of the reporting period. This period should be a whole calendar year. If it is not, the figures in the report will be correct but the month numbers will be not.
Customer: Paste Special Customer register; If necessary, enter here the Customer Number of the Customer you wish to include in the report.
Category: Paste Special Customer Categories setting, Sales Ledger; If you want to restrict the report to Customers of a particular Category, specify that Category here.
Fwd Balance Date: Paste Special Current Date; For each Customer, the report calculates the amount owed at a specified date. This figure acts as an opening balance for the report: it is used to calculate the amount owed at the end of each month. Specify here the date for which this opening balance is to be calculated: usually it will be the first date of the report period. If no date is entered, the opening balance for each Customer will be zero, allowing the outstanding debt built up over the report period to be shown.
Show Balance on date: Paste Special Current Date; The report shows a closing balance for each Customer: the amount owed at a specified date. Enter that date here: usually it will be the last date of the report period. If no date is entered, the closing balance for each Customer will be zero.
Sort by Category: By default, the report is sorted by Customer Number. Check this box if you would like the report to be sorted by Customer Category.

Previous Next Top Entire Chapter in Printable Form