Sales Ledger Help
Use this report to forecast the receipts due now and in the forthcoming accounting periods. The application calculates the expected revenue dates based on the due date of the invoices, the average debtor days calculated for individual customer accounts, or the company debtor days calculated for all customers.
The account debtor days and company debtor days are available if three periods of transaction history exist. The history is created when the Sales - Utilities - Period End command is run.
Open the Sales Ledger
folder and then click Reports
- Revenue Forecast
or click the Financials tab
and then click Sales Ledger
- Reports
- Revenue Forecast
on the Ribbon Bar.
In the Sequence list, select the sequence option you want. You can produce the report in 'Account', 'Customer Type' or 'Balance' sequence.
Depending on the sequence you have selected, use the From and To lists to define the range of records you want included in the report.
Under Revenue By, click to select whether you want the application to use 'Due Date', 'Account Debtor Days' or the 'Company Debtor Days' to work out when revenues are due for invoices.
Click OK.
On the Publisher form, click the tab to select the output device you want to use and then complete any settings or options you want to apply to the output device. To process the output, click Publish.
To
save this report in Opera 3 as a Microsoft Excel spreadsheet, select Excel Report from the Report
Layout box on the Publisher
form.