Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.francis.app/llms.txt

Use this file to discover all available pages before exploring further.

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.