Forecasting Receivables

​

Overview

When forecasting receivables, many users assume a certain number of payment days. To simplify this, Francis offers the receivables() function.

​

Basics

The receivables() function accumulates revenue from previous months according to a specified number of payment days. It assumes each month has 30 days and looks back through earlier periods to identify revenue still owed.

Keep in mind:

• The payment days value must be a hardcoded number (not a cell reference).

• If you have multiple revenue streams with different payment terms, use separate receivables() functions for each revenue row.