Foundation Software + Go Fig

AccountingERP Premium

Connect FOUNDATION to Go Fig for daily job cost, committed cost, and payroll-driven labor visibility reconciled against the general ledger and loaded into the Excel your finance team already uses.

FOUNDATION is the construction accounting, job-cost, and payroll backbone for thousands of contractors, but the answers a controller actually needs (actual vs estimate by job and cost code, labor burden against budget, committed costs against the GL, and a current WIP schedule) usually mean running a Foundation report, exporting to Excel, and keeping a private workbook that goes stale within days. Go Fig does not replace FOUNDATION. It connects to your Foundation data, syncs the Job Cost, General Ledger, Accounts Payable, Accounts Receivable, and Payroll detail, reconciles it against your other systems, and loads fresh, traceable job-cost data into the Excel your project accountants already use, automatically, every day. Celeste, Go Fig's AI analyst, can then answer 'which jobs are over on labor this period' with a real audit trail back to the cost code and payroll entry. Your financial data stays in your environment. It is never pasted into a public chatbot and is never used to train an outside model. Celeste works only on your data, with a full audit trail.

Connect Foundation Software See All Integrations

Key facts

System role: Connects to FOUNDATION, does not replace it
Sync grain: Cost code, payroll, and transaction level
Reconciliation: Committed cost and labor vs GL and budget
Historical backfill: Multi-year Job Cost, GL, and payroll detail
Auth: Read-only SQL Server service account

SOC 2 Type II · All integrations

What you can do with Foundation Software data in Go Fig

Actual vs estimate by job, phase, and cost code

Foundation Job Cost estimate, committed, and actual amounts pulled together so a project accountant sees remaining budget by job, phase, and cost code every morning, instead of running the JC reports and rebuilding the variance in a private spreadsheet. Overruns surface early, not at close.

Labor and burden against budget from payroll

Foundation's certified payroll and labor distribution joined to job-cost budgets so labor hours, burden, and union fringes are tracked against estimate by cost code. The controller sees labor overruns as they accrue, not after the period closes.

Committed cost, WIP, and retainage daily

Open commitments and AP invoices reconciled against the GL, then combined with AR billings and retainage into a WIP schedule that refreshes every day. Percent complete, earned revenue, and over/under billing stay current so bonding capacity is sized off a live schedule.

Data available from Foundation Software

Go Fig extracts and normalizes the following data from your Foundation Software account:

Jobs, phases, and cost codes

Job Cost estimates, committed, and actual amounts

General Ledger accounts and transactions

Accounts Payable invoices and vendors

Accounts Receivable and AIA contract billings

Payroll, labor distribution, and certified payroll

Commitments, subcontracts, and change orders

Retainage held and released

Equipment cost and units

Cash receipts and payments

How to connect Foundation Software

Provision a read-only SQL service account

Create a dedicated read-only service account on the Foundation SQL Server database scoped to the Job Cost, GL, AP, AR, and Payroll tables you want exposed. Keep it separate from your human operators so audit trails stay clean and confirm the database is reachable from the connector.

Confirm your company database

FOUNDATION organizes data by company database. Confirm which company contains the jobs and ledgers you want to sync. Multi-company contractors can run one connection per company database and consolidate across them in Go Fig.

Pick the historical window

Choose how far back to backfill. Three to seven years of Job Cost, GL, and payroll detail is typical for contractors rebuilding job-cost, labor, and WIP history before switching to daily incremental sync keyed on transaction date.

Wire up the job-cost and labor flows

Go Fig ships starter flows for actual vs estimate by job, labor against budget, committed-cost reconciliation, and a daily WIP schedule. Point them at your Foundation connection and the controller has a working monthly close pack on day one, with drill-down back to cost code, payroll, and transaction detail.

Authentication: FOUNDATION stores data in a Microsoft SQL Server database. Go Fig connects through that database using a dedicated read-only service account scoped to the Job Cost, GL, AP, AR, and Payroll tables you want exposed, separate from your human operators so audit trails stay clean.

Common Questions About Foundation Software Integration

Does Go Fig replace FOUNDATION?

No. FOUNDATION stays your construction accounting, job-cost, and payroll system of record. Go Fig connects to it, reconciles Foundation's Job Cost and GL data against your other systems, and loads fresh, traceable job-cost data into the Excel your finance team already uses. Your project accountants and payroll team keep working exactly as they do today.

Can Go Fig track labor and burden against budget?

Yes. Go Fig joins Foundation's labor distribution and certified payroll to job-cost budgets so labor hours, burden, and fringes are tracked against estimate by cost code. A typical view catches jobs running over on labor mid-period and crews charging time to the wrong cost code before it distorts the WIP.

Can Go Fig produce a daily WIP and handle retainage?

Yes. Go Fig combines cost-to-date and committed costs with AR contract billings and retainage held to produce a WIP schedule that refreshes every day. Over/under billing and retainage land in your Excel automatically, so you stop rebuilding the WIP by hand each month and bonding capacity is sized off a live schedule.

Is our financial data safe with Celeste?

Yes. Your financial data stays in your environment. It is never pasted into a public chatbot and is never used to train an outside model. Celeste, Go Fig's AI analyst, works only on your data and every answer carries a full audit trail back to the underlying job, cost code, payroll entry, or transaction.

How current is the Foundation data inside Go Fig?

Daily incremental sync is the default, keyed on transaction date, so each morning the finance team opens an Excel that already reflects yesterday's Job Cost, AP, AR, and payroll activity. Contractors in active billing or payroll cycles can sync more frequently if the on-call analyst needs near-real-time job-cost visibility.