Workflow · Finance close · Opening soon

13-week cash flow

Turn QuickBooks exports into a 13 week cash flow. Bucket invoices and bills by due week, then show weekly net and running balance.

Book a demo

Someone typed

“13-week cash flow from the quickbooks open invoices and open bills plus checking register, bucket cash by due week with overdue items in the current week, show weekly net and running balance”

The agent read it as

13-week cash flow from the QuickBooks open invoices and QuickBooks open bills plus QuickBooks checking account register, bucket cash by due week with overdue items in the current week, show weekly net and running balance, with Monday-start weeks.

What the agent built

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

File

QuickBooks open invoices

CSV export · 14 rows

File

QuickBooks open bills

CSV export · 13 rows

File

QuickBooks checking account register

CSV export · 12 rows

Step

Bucket invoice cash

Step 1

Step

Bucket bill cash

Step 2

Step

Make 13 cash weeks

Step 3

Join

Add invoice cash

12 of 13 paired

Join

Add bill cash

11 of 13 paired

Step

Show weekly cash flow

Step 6

Result

13-Week Cash Flow

13 rows

Schedule

Runs when you say

Proposed

File
QuickBooks open invoices
CSV export · 14 rows
File
QuickBooks open bills
CSV export · 13 rows
File
QuickBooks checking account register
CSV export · 12 rows
Step
Bucket invoice cash
Step 1
Step
Bucket bill cash
Step 2
Step
Make 13 cash weeks
Step 3
Join
Add invoice cash
12 of 13 paired
Join
Add bill cash
11 of 13 paired
Step
Show weekly cash flow
Step 6
Result
13-Week Cash Flow
13 rows
Schedule
Runs when you say
Proposed

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

Download QuickBooks open invoices sample (14 rows)QuickBooks Online: Sales > Invoices > Filter Status = Open > Export
Download QuickBooks open bills sample (13 rows)QuickBooks Online: Expenses > Bills > Filter Status = Open > Export
Download QuickBooks checking account register sample (12 rows)QuickBooks Online: Accounting > Chart of accounts > Checking account > View register > Export

What you get back

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

13-Week Cash FlowSample data13 rows

Week	Weekly net	Running balance	Cash in	Cash out
2026-11-09	-1,600	22,240	4,820	6,420
2026-11-16	530	22,770	2,380	1,850
2026-11-23	3,860	26,630	7,150	3,290
2026-11-30	12,135	38,765	14,590	2,455
2026-12-07	5,700	44,465	12,060	6,360
2026-12-14	-6,215	38,250	2,745	8,960
2026-12-21	2,850	41,100	5,400	2,550
2026-12-28	805	41,905	4,525	3,720
2027-01-04	4,535	46,440	6,180	1,645
2027-01-11	850	47,290	2,040	1,190
2027-01-18	0	47,290	0	0
2027-01-25	4,270	51,560	9,850	5,580

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

How do you build a 13 week cash flow?

Export your open invoices, open bills, and checking account register from QuickBooks. Mammoth buckets each item by the week it is due, puts overdue items in the current week, and shows 13 Monday-start weeks with weekly net and a running balance.

How it works

How to use the 13-Week Cash Flow 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 Flow: questions

Which QuickBooks exports should you use?

Use exports of open invoices, open bills, and the checking account register. Those files give the due dates and cash activity needed for the 13 week view.

What happens to rows that do not match?

Rows that do not match the rules are left out of the result. You can review the source file and change the matching rules if you want them included.

How do you change the rules?

Edit the rules in words, then run the workflow again. You can change how dates are bucketed, what counts as overdue, and which rows are included in each step.