Construction WIP schedule
“build the work in progress schedule for each job: percent complete from costs to date over estimated costs, earned revenue, and over or under billing against what we billed”
Build the work in progress schedule for each job: percent complete from costs to date over estimated costs, earned revenue, and over or under billing against what we billed from QuickBooks Job List and QuickBooks Job Totals to Date.
What the agent built
4 steps, each one an ordinary Mammoth step you can open and change.
- FileQuickBooks Job ListCSV export · 10 rows
- FileQuickBooks Job Totals to DateCSV export · 10 rows
- StepPrepare job match keyStep 2
- StepPrepare totals match keyStep 1
- JoinJoin job totals10 of 10 paired
- StepCalculate job progressStep 4
- ResultJob WIP Schedule10 rows
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 10 rows came out, and the join paired 10 of 10 rows.
- Download QuickBooks Job List sample (10 rows)QuickBooks: Reports > Jobs, Time & Mileage > Job Profitability Summary > Customize > Export
- Download QuickBooks Job Totals to Date sample (10 rows)QuickBooks: Reports > Jobs, Time & Mileage > Job Profitability Summary > Customize > Export
What you get back
The result of that run, the rows to look at first.
| Job | Percent Complete | Earned Revenue | Over / Under Billing | Billing Status | Cost To Date | Estimated Cost | Contract Value | Billed To Date |
|---|---|---|---|---|---|---|---|---|
| 1200 Elm St - North Wing Renovation | 0.6% | 515,703.13 | 59,296.88 | Overbilled | 402,500 | 640,000 | 820,000 | 575,000 |
| 44 Harbor Dr - Office Fitout | 0.5% | 255,153.85 | -95,153.85 | Underbilled | 214,000 | 390,000 | 465,000 | 160,000 |
| 17 Pine Ave - Retail Shell Build | 1.1% | 1,211,538.46 | -366,538.46 | Underbilled | 980,000 | 910,000 | 1,125,000 | 845,000 |
| 88 Cedar Rd - Warehouse Expansion | 0.9% | 1,369,400.78 | -274,400.78 | Underbilled | 1,128,000 | 1,285,000 | 1,560,000 | 1,095,000 |
| 301 Maple Blvd - Site Utilities | 0.8% | 210,000 | -32,000 | Underbilled | 168,000 | 220,000 | 275,000 | 178,000 |
| 9 Birch Ln - Roof Replacement | 1% | 205,800.00 | -54,800.00 | Underbilled | 171,500 | 165,000 | 198,000 | 151,000 |
| 72 Lakeview Ct - Lobby Remodel | 0.6% | 349,200.00 | -144,200.00 | Underbilled | 291,000 | 450,000 | 540,000 | 205,000 |
| 640 Spruce St - Tenant Improvements | 0.9% | 630,875 | -160,875 | Underbilled | 515,000 | 600,000 | 735,000 | 470,000 |
| 15 Aspen Way - Parking Lot Rehab | 0.7% | 285,600 | -71,600 | Underbilled | 238,000 | 325,000 | 390,000 | 214,000 |
| 500 River Rd - Mechanical Upgrade | 0.8% | 750,506.33 | -190,506.33 | Underbilled | 605,000 | 790,000 | 980,000 | 560,000 |
How it works
How to use the Job WIP Schedule 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.
Job WIP Schedule: questions
How do you build a WIP schedule from QuickBooks exports?
Which QuickBooks export should you use?
What happens if a row does not match?
How do you change the rules?
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.
Workflows like this
Consolidate entities, compare budget to actual, build a trial balance, review month-on-month moves and work out commission.
- Profit and loss by monthBuild a monthly profit and loss statement from a QuickBooks general ledger export, with revenue, COGS, gross profit, expenses, and net income.See the workflow Built by the agent
- Real estate commission splitWork out real estate commission on each closed sale and split it between the listing agent, buying agent and brokerage.See the workflow Built by the agent
- Loan amortization from statementsBuild a monthly loan amortization schedule from an Excel export, with interest, principal, and remaining balance for each loan.See the workflow Built by the agent
- Accrued expenses scheduleBuild an accrued expenses schedule from QuickBooks exports. Match purchase orders to vendor bills, calculate unbilled amounts, and flag items that need accrual.See the workflow Built by the agent
- Cash conversion cycle by monthWork out cash conversion cycle each month from QuickBooks exports, using month-end balances and monthly sales.See the workflow Built by the agent
- Expense report from card transactionsTurn Amex card exports into an expense report per employee, with category totals and missing receipts flagged.See the workflow Built by the agent