Receivables

Overview

Many users forecast receivables based on an assumption of # payment days. We've created a function to make it easy.

Basics

The receivables() function accumulates revenue amounts from previous months based on an assumption of payment days. Based on the number of payment days, the function loops back through previous months to collect revenue as part of receivables.

The function assumes 30 days per month. The payment days input must be hardcoded and cannot reference a cell.

You can set up multiple receivable functions referencing different rows if you have multiple revenue streams with varying payment terms.