Workflow · Finance close · Opening soon

Accrued expenses schedule

Build an accrued expenses schedule from QuickBooks exports. See which purchase orders are fully billed, and which still need accrual at month end.

Book a demo

Someone typed

“at 2026-11-30, show each quickbooks po with any related bill, use received minus bills dated on or before month end to get the unbilled amount, status Agrees when it’s fully billed, otherwise Needs accrual”

The agent read it as

at 2026-11-30, show each QuickBooks purchase orders with any related bill from QuickBooks vendor bills, use received minus bills dated on or before month end to get the unbilled amount, status Agrees when it’s fully billed, otherwise Needs accrual

What the agent built

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

File

QuickBooks purchase orders

CSV export · 12 rows

File

QuickBooks vendor bills

CSV export · 12 rows

Step

Calculate received amount

Step 1

Step

Total bills by PO

Step 2

Join

Bring in related bills

11 of 12 paired

Step

Calculate unbilled amount and status

Step 4

Result

Unbilled PO Accruals

12 rows · 6 flagged

Schedule

Runs when you say

Proposed

File
QuickBooks purchase orders
CSV export · 12 rows
File
QuickBooks vendor bills
CSV export · 12 rows
Step
Calculate received amount
Step 1
Step
Total bills by PO
Step 2
Join
Bring in related bills
11 of 12 paired
Step
Calculate unbilled amount and status
Step 4
Result
Unbilled PO Accruals
12 rows · 6 flagged
Schedule
Runs when you say
Proposed

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

Download QuickBooks purchase orders sample (12 rows)QuickBooks: Expenses > Vendors > Purchase Orders > Export
Download QuickBooks vendor bills sample (12 rows)QuickBooks: Expenses > Vendors > Bills > Export

What you get back

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

Unbilled PO AccrualsSample data12 rows

6 agrees6 needs accrual

PO Number	Unbilled amount	Status	Related bills	Billed through month end	Received amount	Vendor	PO Date	Item	Qty Received	Unit Cost
PO-2002	860	Needs accrual	B-8802 (2026-10-01 00:00:00)	1,720	2,580	lumen_fleet	2026-09-23	vehicle_service	3	860
PO-2005	-570	Needs accrual	B-8805 (2026-10-18 00:00:00), B-8812 (2026-11-10 00:00:00)	1,710	1,140	ironpeak_it	2026-10-06	laptop_imaging	12	95
PO-2006	45	Needs accrual	B-8806 (2026-10-18 00:00:00)	855	900	greenline_courier	2026-10-09	same_day_delivery	40	22.50
PO-2007	1,095	Needs accrual	·	·	1,095	summit_maintenance	2026-10-13	hvac_filter_set	60	18.25
PO-2009	360	Needs accrual	B-8808 (2026-10-30 00:00:00)	1,080	1,440	atlas_security	2026-10-21	camera_service_visit	8	180
PO-2012	256	Needs accrual	B-8810 (2026-11-08 00:00:00)	1,280	1,536	summit_maintenance	2026-11-07	boiler_parts	24	64
PO-2001	0	Agrees	B-8801 (2026-09-20 00:00:00)	920	920	northstar_packaging	2026-09-19	shipping_boxes	500	1.84
PO-2003	0	Agrees	B-8803 (2026-10-03 00:00:00)	2,160	2,160	harbor_cleaning	2026-09-30	deep_cleaning	4	540
PO-2004	0	Agrees	B-8804 (2026-10-12 00:00:00)	888	888	papertrail_printing	2026-10-02	brochure_run	1,200	0.74
PO-2008	0	Agrees	B-8807 (2026-10-24 00:00:00)	1,250	1,250	brightwater_utilities	2026-10-16	generator_test	1	1,250
PO-2010	0	Agrees	B-8809 (2026-11-04 00:00:00)	186	186	northstar_packaging	2026-10-27	label_rolls	300	0.62
PO-2011	0	Agrees	B-8811 (2026-11-09 00:00:00)	288	288	papertrail_printing	2026-11-02	postcards	600	0.48

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

How do you build an accrued expenses schedule from QuickBooks exports?

Export your purchase orders and vendor bills from QuickBooks, then load them into the workflow. It matches bills to each purchase order, totals what has been billed through month end, and compares that with what was received. The result shows each PO with an unbilled amount and a status of Agrees or Needs accrual.

How it works

How to use the Unbilled PO Accruals 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.

Unbilled PO Accruals: questions

Which export should you use from QuickBooks?

Use exported purchase orders and exported vendor bills for the month end you want to review. The workflow reads the rows in those files and uses the dates and PO references to match them.

What happens to rows that do not match?

Rows that do not find a matching purchase order or bill stay separate from the matched results. They do not change the totals for the rows that do match.

How do you change the accrual rules?

Change the rules in plain words, for example by changing the month end date, the fields used to match POs and bills, or the rule for how to calculate unbilled amounts and status.