Overview

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.
Report layout	Controls the grouping for the display of the report. There are three options. Group by date Each date will display a table. Every item with an expected payment date of the heading date will be displayed. Expected from Each debtor will display a table that only displays items and amounts owed by that debtor. No grouping Displays a single table containing all items, regardless of date or debtor.
Invoice due date	The date used in the Expected Date column on the report. There are two options. Payment due date The due date on the invoice Average days to pay Calculates the average days it takes for invoices to be paid in your system Displays the date your average days to pay after the invoice's AR date
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.
Print	The Print button will launch your browsers print dialog. This will adhere to your browser and workstation settings to print the report.
EXCEL	The EXCEL button will download the report in xls format.
PDF	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.
Reload	The reload button refreshes the report. This is useful to include any data that has changed since the report was generated.
Generated	The report is stamped with the date for reference.
Print	Launches dialog to print the report.
EXCEL	Downloads the report in xls format
PDF	Downloads the report in PDF format

Table Types

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.

Overdue	Displays when 'Report layout' is set to 'Group by Date' Contains items with expected payments past the due date defined in the 'Invoice due date' configuration option
Due date	Displays when 'Report layout' is set to 'Group by Date' Header date is the due date of all items listed in the table
Expected from	Displays when 'Report layout' is set to 'Expected from' Header name is the name of the debtor for all items listed in the table
Summary	Displays when 'Report layout' is set to 'Group by Date' or 'Expected from' Contains totals for each date, with a sum total at the bottom

Column Definitions

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.

Detail Tables

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

Summary Table

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.