Skip to content

Help

What to send, and how

Main works from exports you already produce. Any CSV or Excel (.xlsx, no macros) file works; column names do not need to match ours — you confirm the mapping once and it is saved.

Step-by-step export guides for specific products (Siteline, Clearstory, Procore, Sage, Viewpoint, QuickBooks) will be added only after each one is checked against that vendor’s own documentation. Until then, use the column list below with your product’s standard export or report.

Guides

  • Approved but unbilled change ordersAn approved change is only money once it is on the schedule of values and billed. Here is how to find the ones that never got there.
  • Underbilling vs. lost revenueUnderbilling is an accounting position: earned revenue you have not billed yet. It is not money anyone owes you today. Here is the difference.
  • Pay-app reconciliationA pay application has to agree with itself: the continuation sheet, the summary page and the previous application. Small breaks add up.
  • RetainageRetainage is earned money held back from each payment. It is easy to lose track of once a job winds down.
  • Change-order documentation gapsA change that is approved in one system and missing or different in another is hard to bill and easy to dispute.
  • A/R agingAging shows how long each invoice has been open. The useful part is knowing why each old one is still unpaid.

What columns we need

DatasetColumns
Change-order logProject, change number, description, amount, status (pending / approved / rejected / void), date submitted, date approved
Schedule of valuesProject, line number, description, scheduled value; which lines are change orders and which change each one carries, if your tracker records it
Payment application linesProject, application number, period end, line number, description, scheduled value, previously billed, this period, materials stored, completed to date, % complete, retainage, balance to finish
Payment application summaryProject, application number, period end, original contract sum, net change by changes, contract sum to date, completed and stored to date, retainage, earned less retainage, previous payments, current amount due, retainage rate
A/R aging or invoice registerProject, invoice number, invoice date, due date or terms, amount, amount paid, related application number, customer (GC)
Payments receivedProject, invoice number, payment date, amount
Retainage ledgerProject, as-of date, retainage held, released, balance, release terms or notes

Not every dataset is required. With only a change-order log and payment-application lines, Main can already check whether approved changes reached billing.

Optional: WIP and job-cost data

The assessment works fully without these. If you send them, Main checks your WIP schedule against the inputs on it and against your change-order log and billing. Main does not estimate cost to complete and does not choose a revenue-recognition method; it works under the percent-complete method you tell it you use.

ExportRequired columnsOptional columns
WIP / job-cost schedule (per period)Project, accounting periodPercent-complete method, original contract, approved changes, pending or unpriced changes, original budget, current budget, cost to date, committed cost, PM estimated cost to complete, % complete, earned revenue, billed to date, over billings, under billings, retainage, A/R
Trial balance (year-to-date, month end)Accounting period, accountAccount name, debit, credit. Tell us which accounts hold contract revenue, billings in excess of costs and costs in excess of billings; Main does not guess this from account names
Period-readiness checklist (per period)Accounting periodA/R posted, AP cutoff complete, payroll posted, change orders updated, commitments updated, PM cost-to-complete submitted (yes / no); you can also confirm these in the app

One row per project per accounting period (for example 2026-07). Send each month you want compared; earlier months are kept, never overwritten. Also tell us your percent-complete method (cost-to-cost, units, labor hours or other) and, for each period, whether A/R, the accounts-payable cutoff, payroll, change orders, commitments and the PMs’ cost-to-complete estimates were posted or submitted. If any are missing, the analysis is marked partially complete and margin conclusions for the affected projects show “Cannot assess”.

Do not upload

  • Tax returns and tax workpapers
  • Taxpayer identification numbers (EINs, ITINs)
  • Social Security numbers
  • Bank account details (account and routing numbers)
  • Driver’s license numbers
  • Employee medical information
  • Passwords, API keys or other credentials
  • Employee-level payroll detail (send job-cost totals instead)

Files with columns like these are refused at upload. Remove the columns and send the rest.

Before every upload

Each person who uploads confirms:

I confirm my organization is authorized to provide these records to Main for this engagement.

Main records who confirmed it and when.

Terms we use

Schedule of values (SOV)

A schedule of values (SOV) splits your contract amount into line items. Each pay application bills a share of each line, so the SOV is the base for every bill you send.

Pay application (pay app, G702/G703)

A pay application (pay app) is your monthly bill to the general contractor. On the AIA forms, the G702 is the summary page and the G703 is the continuation sheet that lists each line of the schedule of values.

Retainage

Retainage is the part of each bill that the general contractor holds back until the work, or a stage of it, is finished. It has been billed but not paid yet, and it is released under the terms of your contract.

Main never counts retainage as cash delayed. A retainage finding is a record conflict when your records disagree about it, or commercial exposure when its release depends on contract terms. Its source rows usually come from your retainage ledger and pay applications.

WIP schedule

A WIP (work in progress) schedule is a report on each project, usually made monthly. It shows the contract value, cost to date, estimated cost to complete, percent complete and amount billed. It also shows whether each job is over-billed or under-billed.

Change order (CO) and pending change order (PCO)

A change order (CO) is an approved change to the scope or price of your contract. A pending change order (PCO) is a change you have asked for that is not approved yet. Main checks that approved change orders reach your schedule of values and your bills, and shows PCOs that stay pending as commercial exposure.

Over-billing and under-billing

Over-billing means you have billed more than the work you have earned so far. Under-billing means you have billed less. Both come from comparing what you billed to date with the revenue you earned on the WIP schedule.

A/R aging

An A/R (accounts receivable) aging report lists the invoices that are not paid yet and groups them by how many days they are past due. Past-due invoices that were billed properly appear in Main as cash delayed.

Main review

Main review is the check a person at Main does on the findings the engine raises, before they are released to you. The reviewer can approve, edit, downgrade or dismiss each finding. Your team still confirms or dismisses each finding for your business.

Evidence levels

Each finding has 1 of 3 evidence levels. Strong evidence: the records clearly disagree, and no other line plausibly explains it. Probable match: very likely, with a single detail to confirm, because a common, legitimate reason may exist. Needs your input: we can’t tell without information only you have, so Main cites what it found and leaves the call to you.

Next to every finding, Main shows its evidence level and the source rows behind it: the file, the row and the value Main read.

FAQ

Do I need to connect any system?

No. Exports are enough to start. Read-only connections are optional and come later.

What does “Strong evidence” mean?

The records themselves demonstrate the gap and no other line plausibly explains it. It still requires your business confirmation.

Can I hide GC and project names?

Yes. Choose anonymized upload: names are replaced with tokens (GC-1, Project A) in your browser before the file is sent, and the key stays with you.

Why are the four amounts never added up?

Because they are different kinds of money: work that was not billed, two records that disagree, exposure whose status depends on context, and cash that is simply late. Adding them would overstate what is at stake.

Will Main contact my GC?

Never without you. Main prepares drafts; you decide whether to send them. Nothing goes out until you press send.

Is this legal or accounting advice?

No. Main is an operational technology and service provider.