Financial models

AR Aging & Cash Forecast

When will my unpaid invoices actually turn into cash?

ar aging picture
Open invoices

Upload open invoices to see when the money should arrive. Add a Date Paid column and we learn how late each customer really pays.

AR Aging & Cash Forecast: When will my unpaid invoices actually turn into cash?

Open balances by 30, 60 and 90+ days late, and the cash to expect each week as customers pay. You need open invoices with due dates and customer names. Drop it in and the answer appears in your browser with no account, no setup and nothing uploaded. Download the result as a PDF report or an Excel workbook to send on.

Related models

About this model

Upload your open invoices to group them by how late they are and see the cash to expect each week. Add a Date Paid column and the forecast learns how late each customer really pays.

How to run it

  1. Export your open invoices with due dates.
  2. Upload the file.
  3. Pick how late customers usually pay, then read the weekly cash.

Frequently asked questions

What file do I need?

A list of open invoices with a customer, an amount and a due date. Accounting software exports this as an aged receivables or open invoices report.

How does it predict when customers pay?

It takes each due date and adds how late that customer usually pays. Invoices already late are given time for a chase, and the oldest ones count for less because some will never be paid.

Is anything uploaded?

No. Everything stays in your browser.