Workflow · Finance close · Opening soon

Working capital by month

Use a monthly QuickBooks balance sheet export to calculate working capital for each month. Compare current assets and current liabilities, then track the change from the prior month.

Book a demo

Someone typed

“from the quickbooks balance sheet, use the current assets and current liabilities subtotal rows to calculate working capital as current assets minus current liabilities, show each month and month-over-month change, status Agrees, Sharp drop, or Negative working capital”

The agent read it as

From the QuickBooks Balance Sheet (monthly), use the current assets and current liabilities subtotal rows to calculate working capital as current assets minus current liabilities, show each month and month-over-month change, status Agrees, Sharp drop, or Negative working capital, counting a 20% month-over-month drop as sharp.

What the agent built

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

File

QuickBooks Balance Sheet (monthly)

CSV export · 13 rows

Step

Calculate monthly working capital

Step 1

Result

Working Capital Changes

12 rows · 2 flagged

Schedule

Runs when you say

Proposed

File
QuickBooks Balance Sheet (monthly)
CSV export · 13 rows
Step
Calculate monthly working capital
Step 1
Result
Working Capital Changes
12 rows · 2 flagged
Schedule
Runs when you say
Proposed

Checked on the sample files: every step ran, 12 rows came out.

Download QuickBooks Balance Sheet (monthly) sample (12 rows)QuickBooks: Reports > Balance Sheet > Customize Report > Columns: Months > Export to Excel

What you get back

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

Working Capital ChangesSample data12 rows

10 agrees2 negative working capital

Month	Working capital	Month-over-month change	Status	Current assets	Current liabilities
2026-04-30	-21,500	-104,500	Negative working capital	183,900	205,400
2026-08-31	-1,600	-82,600	Negative working capital	188,400	190,000
2025-11-30	81,500	·	Agrees	178,000	96,500
2025-12-31	84,300	2,800	Agrees	181,500	97,200
2026-01-31	80,750	-3,550	Agrees	179,250	98,500
2026-02-28	82,000	1,250	Agrees	182,100	100,100
2026-03-31	83,000	1,000	Agrees	184,300	101,300
2026-05-31	82,500	104,000	Agrees	185,500	103,000
2026-06-30	83,000	500	Agrees	187,200	104,200
2026-07-31	81,000	-2,000	Agrees	186,100	105,100
2026-09-30	82,950	84,550	Agrees	190,250	107,300
2026-10-31	83,300	350	Agrees	191,800	108,500

12 rows in the result. Sample data: illustrative figures, not business results.

How do you calculate working capital every month?

Export the monthly balance sheet from QuickBooks. Use the current assets and current liabilities subtotal rows to calculate working capital as current assets minus current liabilities, then show the month-over-month change and a status for each month.

How it works

How to use the Working Capital Changes 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.

Working Capital Changes: questions

What export should you use for this workflow?

Use a monthly balance sheet export that includes the current assets and current liabilities subtotal rows. The workflow reads those rows to calculate working capital by month.

What happens to rows that do not match the rules?

Rows that do not match the needed subtotal rows are not used in the calculation. The workflow only keeps the rows needed to compute working capital and the month-over-month change.

How do you change the rules in words?

Edit the rule text to say which rows to use, which figures to subtract, and how to label changes or exceptions. For example, you can change the status rules, the drop threshold, or the columns to compare.