The Expected Incoming Cash Report displays payments that are expected to be received in the near future. This report is useful for informing adjustments that can be made to organization expenses in the short-term by considering the expected timeline for receiving payments.
Accessing the Expected Incoming Cash Report
The Expected Incoming Cash Report is located in Reports > Accounting Reports in the Accounting Banking category.
Report Configuration Options
There are four filters r settings you can apply to the Expected Incoming Cash report to control the result that you get. These are:
|Period end date||The cut-off date for the report. No items with a date later than the Period end date will be displayed.|
Controls the grouping for the display of the report. There are three options.
|Invoice due date|
The date used in the Expected Date column on the report. There are two options.
|Sales Pipeline/Sold||Controls whether sales pipeline/bill schedule data is displayed on the report.|
Producing the Expected Incoming Cash Report
|Generate report (on-screen)|
Below the configuration options is a Generate report button. This button will generate and display the report on the current screen. It will also display further output options.
The Print button will launch your browsers print dialog. This will adhere to your browser and workstation settings to print the report.
The EXCEL button will download the report in xls format.
The PDF button will download the report in PDF format.
Understanding the Output of the Client Profitability Report
|Note: Using the three output options will generate the same information in the selected format. This section of the guide will use images from the On Screen (HTML) output.|
|Note: All detail tables display the same data, regardless of grouping. The descriptions of columns apply to all detail tables. The Summary table when grouped by due date is not a detail table.|
There are 4 types of tables that can be displayed on the report.
|Note: All detail tables display the same data, regardless of grouping. The descriptions of columns apply to all detail tables. The Summary table is not a detail table.|
|Expected From||The debtor from which the payment is expected|
|Source||The item for which the payment is expected. This can be an invoice or a sales pipeline item.|
|Description||The specific item for which the payment is expected|
|Expected Date||The date payment is or was expected.|
|Matter ID||The ID of the matter with which the row item is associated|
|Matter Name||The name of the matter with which the row item is associated|
|Amount||The amount of the expected payment|
|Date||Date of the expected payments|
|Total Amount||Total of the expected payments for the corresponding date. Below the line, there is a sum total of this column.|