Cash Receipt Forecast report

Use this report as part of your financial planning to help you forecast your near-term income and to later point out any discrepancies between planned and actual cash receipts.

This report displays expected cash receipts for each of the next six weeks, months, or quarters from the date you print the report. You can produce the report for either all projects or just one selected project.

At a glance, the report shows the period totals for expected cash receipts and a bar chart of those totals. You can drill down on Accounts Receivable and work-in-progress (WIP) totals to view bar chart summaries and corresponding detail.

How forecasts are calculated

The AR Cash Receipt Forecast is determined by collecting all outstanding client invoices and projecting a cash receipt date based on the client's average days-to-pay. When an invoice is outstanding for a new client, days-to-pay are based on a company average.

The WIP Cash Receipt Forecast is determined by collecting all outstanding WIP and first projecting an invoice date based on how quickly a transaction is invoiced on average for the company. The cash receipt date is then projected based on the client's average days-to-pay. If the client average cannot be determined, a company average is substituted.

For both AR and WIP, when the projected cash receipt date is earlier than the date you are printing the report, amounts appear in the first period in bold red.

Note:

When the average days for a client to pay an invoice goes beyond the range of the six periods being displayed, the outstanding amount does not add up to the totals of the six periods.

Audience

Principal

Project manager

Accounting

CPA

Producing the report

From the > Reports menu, click Client > Cash Receipt Forecast.

Report options

Option	Description
Company	Multi-company only. The report contains information for all companies in your organization, unless you select a specific company in this field.
Project	Produces the report for a specific project, or for all projects if left blank

Customize options

Option

Description

Report title

You can change the title of the report.

Sort order

Sorts the report information under the AR and WIP sections by project manager, principal-in-charge, billing manager, project type, client, department, or project. If you use multi-company, you can also sort by company.

Period basis

Select to include information on the report for each of the next six weeks, months, or quarters.

Note:

When selecting week,

First week is Today through Saturday.
Second week is Sunday through Saturday.

Include finance charges

Includes finance charges in the amounts on this report.

Use drilldown

If selected, you can drill down to further detail on the report. If cleared, all information, including the lowest level of detail, prints on the report.

Print customize options on report

Prints a list of the options that you select.

Report contents

Column	Description
Company Cash Receipt Forecast:
Outstanding AR	The total of all outstanding client invoices
Outstanding WIP	The total of all outstanding work-in-progress
Outstanding Report Total	The total of all outstanding client invoices and WIP
period amounts	The outstanding AR, WIP, and report totals for each of the reporting periods
Drill down - AR:
ID	The project ID
Project	The project name
Invoice	The invoice number
Invoice Date	The invoice date
Days to Pay	The average number of days it takes the client to pay an invoice. If no history is available for the client, it reflects your company’s average collection days.
Forecast Receipt	The forecasted date when you will receive payment based on the days-to-pay
Outstanding	The current remaining amount outstanding on the invoice. When the average days for a client to pay goes beyond the six periods being displayed, the outstanding amount does not add up to the totals of the six periods.
period amounts	The breakdown of the outstanding amount for the reporting periods you selected. It prints in red when the Forecast Receipt date is earlier than the date you print the report.
Drill down - WIP:
ID	The project ID
Project	The project name
Days to Bill	The average number of days it takes a transaction to be invoiced for your company
Days to Pay	The average number of days it takes the client to pay an invoice. If no history is available for the client, it reflects your company’s average collection days.
Outstanding	The current amount of WIP outstanding. When the average days-to-bill plus the average days-to-pay goes beyond the six periods being displayed, the outstanding amount does not add up to the totals of the six periods.
period amounts	The breakdown of the outstanding amount for the reporting periods you selected It prints in red when the WIP average days-to-bill plus days-to-pay is earlier than the date you print the report.