Workflow · Finance close · Opening soon

Cash flow forecast from AR and AP

Build a weekly cash forecast from your QuickBooks exports. Start from today’s bank balance, then track expected invoice cash and bills due over 13 weeks.

Book a demo

Someone typed

“build a 13-week cash forecast from our quickbooks bank register, open invoices, and open bills by due date, starting from today’s bank balance, and show weekly cash, invoices expected, bills due, and ending balance”

The agent read it as

Build a 13-week cash forecast from our QuickBooks bank register, QuickBooks open invoices, and QuickBooks open bills by due date, starting from today’s bank balance, and show weekly cash, invoices expected, bills due, and ending balance, including overdue invoices and bills in week one.

What the agent built

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

File

QuickBooks bank register

CSV export · 12 rows

File

QuickBooks open invoices

CSV export · 15 rows

File

QuickBooks open bills

CSV export · 15 rows

Step

Set the 13 forecast weeks

Step 1

Step

Group invoices by due week

Step 2

Step

Group bills by due week

Step 3

Join

Add expected invoice cash

13 of 13 paired

Join

Add bills due

13 of 13 paired

Step

Calculate weekly cash balances

Step 6

Result

13-Week Cash Forecast

13 rows

Schedule

Runs when you say

Proposed

File
QuickBooks bank register
CSV export · 12 rows
File
QuickBooks open invoices
CSV export · 15 rows
File
QuickBooks open bills
CSV export · 15 rows
Step
Set the 13 forecast weeks
Step 1
Step
Group invoices by due week
Step 2
Step
Group bills by due week
Step 3
Join
Add expected invoice cash
13 of 13 paired
Join
Add bills due
13 of 13 paired
Step
Calculate weekly cash balances
Step 6
Result
13-Week Cash Forecast
13 rows
Schedule
Runs when you say
Proposed

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

Download QuickBooks bank register sample (12 rows)QuickBooks Online: Accounting > Chart of accounts > View register > Export CSV
Download QuickBooks open invoices sample (15 rows)QuickBooks Online: Sales > Invoices > Filter Open > Export
Download QuickBooks open bills sample (15 rows)QuickBooks Online: Expenses > Vendors > Bills > Open > Export

What you get back

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

13-Week Cash ForecastSample data13 rows

Week	Weekly cash	Invoices expected	Bills due	Ending balance	Starting balance
2026-11-11	16,045	21,145	5,100	117,633.20	101,588.20
2026-11-18	1,890	9,680	7,790	119,523.20	117,633.20
2026-11-25	-7,910	3,340	11,250	111,613.20	119,523.20
2026-12-02	2,770	15,040	12,270	114,383.20	111,613.20
2026-12-09	2,680	13,110	10,430	117,063.20	114,383.20
2026-12-16	795	5,380	4,585	117,858.20	117,063.20
2026-12-23	-5,110	2,140	7,250	112,748.20	117,858.20
2026-12-30	-18,125	3,975	22,100	94,623.20	112,748.20
2027-01-06	9,100	14,400	5,300	103,723.20	94,623.20
2027-01-13	0	0	0	103,723.20	103,723.20
2027-01-20	0	0	0	103,723.20	103,723.20
2027-01-27	0	0	0	103,723.20	103,723.20

13 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How do you build a weekly cash forecast from open receivables and payables by due date, starting from today's bank balance?

Export your QuickBooks bank register, open invoices, and open bills. Mammoth groups invoices and bills by due week, includes overdue items in week one, and calculates a 13-week ending balance from today’s bank balance.

How it works

How to use the 13-Week Cash Forecast workflow

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.
2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

13-Week Cash Forecast: questions

Which QuickBooks export should you use?

Use exports of your bank register, open invoices, and open bills. The files need to include due dates and amounts so rows can be grouped by week.

What happens to rows that do not match a week?

Rows are kept as they are if they can be read. If a row cannot be placed into a due week, it will not be counted in the forecast until you fix the source data or the rule that assigns it.

How do you change the forecast rules?

Change the rules in words, then rerun the workflow. For example, you can change how weeks are defined, which date field is used, or how overdue items are assigned to week one.