Skip to content
NewAI dashboards.See how →
Open MammothTry free
Workflow · Finance close · Opening soon

Collections forecast from AR

Use your open invoices and customer records to forecast cash collections for the next 8 weeks. See which invoices land in each rolling seven day block, and which ones sit outside the window.

Early access opens shortly. Check back soon.

Book a demo
Someone typed

“forecast the next 8 weekly cash collection blocks from quickbooks open invoices and customers using usual days late to estimate when each invoice gets paid; show each invoice with forecast week and status Agrees if it lands in the 8 weeks, otherwise Out of window”

The agent read it as

Forecast the next 8 weekly cash collection blocks from QuickBooks Open Invoices and QuickBooks Customers using usual days late to estimate when each invoice gets paid; show each invoice with forecast week and status Agrees if it lands in the 8 weeks, otherwise Out of window, using rolling seven-day blocks from today.

What the agent built

2 steps, each one an ordinary Mammoth step you can open and change.

  1. File
    QuickBooks Open Invoices
    CSV export · 16 rows
  2. File
    QuickBooks Customers
    CSV export · 8 rows
  3. Join
    Bring in usual days late
    16 of 16 paired
  4. Step
    Forecast invoice collection weeks
    Step 2
  5. Result
    Weekly Cash Forecast
    16 rows · 6 flagged
  6. Schedule
    Runs when you say
    Proposed

Checked on the sample files: every step ran, 16 rows came out, and the join paired 16 of 16 rows.

What you get back

The result of that run, the rows to look at first.

Weekly Cash ForecastSample data16 rows
10 agrees6 out of window
InvoiceCustomerForecast weekStatusOpen balanceDue dateEstimated payment date
INV-10411Fable Fitness·Out of window6402026-10-182026-10-21
INV-10405Beaconline Studio·Out of window2,1402026-10-102026-10-22
INV-10421Alder & Moss·Out of window1,2802026-10-182026-10-24
INV-10408Driftwell Labs·Out of window1,8952026-10-152026-11-02
INV-10419Eastforge Supply·Out of window2,6702026-10-292026-11-07
INV-10465Horizon Atelier·Out of window8902026-12-082027-01-12
INV-10412Cedar Peak FoodsWeek 1.0Agrees3,4252026-11-082026-11-12
INV-10414Garnet HarborWeek 1.0Agrees4,0102026-10-212026-11-14
INV-10462Fable FitnessWeek 2.0Agrees5202026-11-182026-11-21
INV-10417Horizon AtelierWeek 3.0Agrees2,3602026-10-262026-11-30
INV-10444Alder & MossWeek 4.0Agrees9502026-11-282026-12-04
INV-10457Driftwell LabsWeek 5.0Agrees9802026-11-262026-12-14
16 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How do you forecast collections from AR?

Export your open invoices and customer list from QuickBooks, then bring both files into the workflow. It uses each customer's usual days late to estimate when each invoice will be paid, then groups the forecast into rolling seven day blocks from today. Each invoice is marked Agrees if it lands in the 8 week window, otherwise Out of window.

How it works

How to use the Weekly Cash Forecast workflow

  1. 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Weekly Cash Forecast: questions

What export should you use from QuickBooks?
Use an open invoices export and a customers export. The invoices file gives the outstanding balances and due dates, and the customers file gives the usual days late field used for the forecast.
What happens to rows that do not match?
Rows that cannot be matched to a customer, or that do not have the fields needed for the rule, do not get a forecasted week. They stay outside the matched result until you fix the source data or the matching key.
How do you change the forecast rule in words?
Edit the rule that estimates payment timing from each customer's usual days late. You can say things like use a different late-days field, change the time block size, or forecast a different number of weeks.

Get early access to this workflow

It will open already built and checked on the sample files. Swap in your own exports and see your result.

Early access opens shortly. Check back soon.

Book a demo

Workflows like this

Consolidate entities, compare budget to actual, build a trial balance, review month-on-month moves and work out commission.

All finance close templates →

Keep reading

Read nextAll workflowsDescribe yours, or start from one the agent already built.Take a lookProductData EngineConnected sources, cleaning and scheduled refresh.Take a lookConnectorsConnectorsBring the data in from the tools you already use.Take a look