Overview
When forecasting receivables, many users assume a certain number of payment days. To simplify this, Francis offers thereceivables()
function.
Basics
Thereceivables()
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.