Skip to content
Workflow · Finance close · Opening soon

Construction WIP schedule

Export your job list and job totals to date from QuickBooks, then use them to build the WIP schedule. The workflow matches jobs, joins totals, and calculates percent complete, earned revenue, and over or under billing.

Early access opens shortly. Check back soon.

Someone typed

“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”

The agent read it as

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.

  1. File
    QuickBooks Job List
    CSV export · 10 rows
  2. File
    QuickBooks Job Totals to Date
    CSV export · 10 rows
  3. Step
    Prepare job match key
    Step 2
  4. Step
    Prepare totals match key
    Step 1
  5. Join
    Join job totals
    10 of 10 paired
  6. Step
    Calculate job progress
    Step 4
  7. Result
    Job WIP Schedule
    10 rows
  8. Schedule
    Runs when you say
    Proposed

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

What you get back

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

Job WIP ScheduleSample data10 rows
JobPercent CompleteEarned RevenueOver / Under BillingBilling StatusCost To DateEstimated CostContract ValueBilled To Date
1200 Elm St - North Wing Renovation0.6%515,703.1359,296.88Overbilled402,500640,000820,000575,000
44 Harbor Dr - Office Fitout0.5%255,153.85-95,153.85Underbilled214,000390,000465,000160,000
17 Pine Ave - Retail Shell Build1.1%1,211,538.46-366,538.46Underbilled980,000910,0001,125,000845,000
88 Cedar Rd - Warehouse Expansion0.9%1,369,400.78-274,400.78Underbilled1,128,0001,285,0001,560,0001,095,000
301 Maple Blvd - Site Utilities0.8%210,000-32,000Underbilled168,000220,000275,000178,000
9 Birch Ln - Roof Replacement1%205,800.00-54,800.00Underbilled171,500165,000198,000151,000
72 Lakeview Ct - Lobby Remodel0.6%349,200.00-144,200.00Underbilled291,000450,000540,000205,000
640 Spruce St - Tenant Improvements0.9%630,875-160,875Underbilled515,000600,000735,000470,000
15 Aspen Way - Parking Lot Rehab0.7%285,600-71,600Underbilled238,000325,000390,000214,000
500 River Rd - Mechanical Upgrade0.8%750,506.33-190,506.33Underbilled605,000790,000980,000560,000
10 rows in the result. Sample data: illustrative figures, not business results.

How it works

How to use the Job WIP Schedule workflow

  1. 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.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 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?
Export your job list and job totals to date from QuickBooks, then use them to build the WIP schedule. The workflow matches jobs, joins totals, and calculates percent complete, earned revenue, and over or under billing. It gives you a Job WIP Schedule file.
Which QuickBooks export should you use?
Use the job list export and the job totals to date export. These give the job names or IDs and the costs and billing totals needed for the WIP schedule.
What happens if a row does not match?
Rows that do not match stay out of the joined result for that step. You can review them, fix the key fields in the export, and run the workflow again.
How do you change the rules?
You change the rules by editing the matching fields and the calculation steps in words. For example, you can change which job fields match, or change the formula used for percent complete and earned revenue.

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.

Early access opens shortly. Check back soon.

Workflows like this

Consolidate entities, compare budget to actual, build a trial balance, review month-on-month moves and work out commission.

All finance close templates →