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.|
Output Options (On Screen Only) and Header Information
|Matter||The name of the matter with the matter ID in parentheses.|
|From||The first date of the report period. Will generate as today's date.|
|To||The Period end date selected in the configuration options|
|Expand/contract display button||
This button controls the on-screen display of the report.
When the arrows face out and the button is clicked, the report will span the width of the window.
When the arrows face in and the button is clicked, the report will display with space on both sides of the screen.
Expanding the display can be useful for longer text values in some table rows to avoid them spilling over to the next line.
|Show report settings/Hide report settings||
When the report is generated, the configuration options are hidden from view.
Selecting the Show report settings button displays the report settings. This allows the settings to be updated and, allows the report to be re-generated.
Selecting the Hide report settings button hides the report settings, so only the report information displays on screen.
The reload button refreshes the report. This is useful to include any data that has changed since the report was generated.
The report is stamped with the date for reference.
|Launches dialog to print the report.|
|EXCEL||Downloads the report in xls format|
|Downloads the report in PDF format|
|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.|