Analytical Cash Flow
The 'Analytical Cash Flow' Export function in the Sales Ledger creates a file containing a forecast of future payments that it is anticipated will be issued and received during a specified period. The forecast will be based on the Due Dates of Purchase and Sales Invoices. You can specify whether the file will contain daily, weekly or monthly predictions. This Export function may therefore be a very useful tool for cash flow forecasting.
- Period
- Paste Special
Reporting Periods setting, System module
- Specify the period to be covered by the export. Please refer to the descriptions below for more details.
- Show
- Use these options to specify the number of lines that will be included in the export file, as follows:
- Daily
- The export file will contain separate lines for each day in the report period.
- Weekly
- The export file will contain separate lines for each week in the report period. The first column should contain week numbers: if it contains zeros, the probable reason is that there is no record in the Weeks setting in the System module, or the record that is there is incomplete. This setting should contain at least one record in which the Country Code is the same as that on the 'Reg' card of the Company Info setting.
- Monthly
- The export file will contain separate lines for each month in the report period.
- Include
- Use these options to specify the types of transaction that should be exported.
- The first column in the export file will contain the day/week/month identifier. This will be followed by separate columns for each of the Include options that you choose. There will then be columns for incoming and outgoing totals and the balance (incoming - outgoing). Outgoings will be shown as negative.
- These options will add columns to the export file containing daily/weekly monthly figures calculated from following:
- Sales Invoices
- Open (i.e. unpaid) Sales Invoices with Due Dates in the specified period.
- Purchase Invoices
- Open (i.e. unpaid) Purchase Invoices with Due Dates in the specified period.
- Sales Instalments
- Open (i.e. unpaid) Sales Invoice instalments with instalment Due Dates in the specified period. Invoices that are payable in instalments will not be exported if you choose the Sales Invoices option above, to avoid double-counting. Invoices are payable in instalments if they have Payment Terms that are connected to records in the Instalments setting.
- Purchase Instalments
- Open (i.e. unpaid) Purchase Invoice instalments with instalment Due Dates in the specified period. As on the sales side, Purchase Invoices that are payable in instalments will not be exported if you choose the Purchase Invoices option above, to avoid double-counting.
- Received Cheques
- Cheques whose Status is "Accepted" and with Estimated Cl. Dates in the specified period.
- Own Cheques
- Own Cheques whose Status is "Issued" and with Effect Dates in the specified period.
Click the [Run] button in the Button Bar to proceed. A dialogue box will open, allowing you to name the export file and specify where it is to be saved. Enter a name for the file, and click [Save] or press the Enter key. The export file will be created and saved. When the export finishes, you can close the 'Export' window using the close box.
---
Export functions in the Sales Ledger and Integration modules:
Go back to:
Introduction to Exports in the Sales Ledger
