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.

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.

FAQ

Do I need to connect any system?

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

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.

Will Main contact my GC?

Never. Main prepares drafts; you decide whether to send them.

What does “Strong evidence” mean?

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

Why are the three amounts never added up?

Because they are different kinds of money: a reconciliation problem, cash that is simply late, and exposure whose status depends on context. Adding them would overstate what is at stake.

Is this legal or accounting advice?

No. Main is an operational technology and service provider.