We build the Sage Intacct Power BI layer commercial contractors actually trust — a real data warehouse underneath your ERP, with every number reconciled to your general ledger instead of approximated from it.
None of this is a competence problem. It's a plumbing problem — and it compounds every month it goes unfixed.
Three haven't replied. The WIP schedule can't close until they do, and everyone knows which three.
The model works. It's also a single point of failure nobody wants to say out loud.
Nobody can tell you the total outstanding, or how long the oldest one has been sitting there.
By the time the schedule lands, the decisions it should have informed have already been made.
They're built on top of the ERP instead of underneath it. Point a report writer at Sage Intacct and you'll get something that renders fast and reconciles badly — because the hard part was never the visualisation. It's the ledger. Which book you're reading. Whether the posted date or the entry date governs the period. Whether a change order that was reversed and re-entered gets counted once or twice. Whether the sync connector's key column is stable enough that a transaction doesn't quietly appear in your data twice.
We connect read-only and tie your WIP schedule, revenue and cash position line-by-line to your general ledger. Ten structured tests covering ledger tie-out, transaction integrity, contract values, estimate quality, over and under billing, backlog and dimensional hygiene. Every discrepancy gets a dollar figure and a root cause.
A star schema in your own Azure tenant with slowly-changing dimensions on projects and project managers, and monthly WIP snapshots stored permanently rather than overwritten. Orchestrated pipelines with incremental sync, dependency management, retry logic and an audit log recording row counts for every run.
WIP schedule, over and under billing, revenue backlog, cash position, gross margin by project manager and profit centre, change order aging — with drill-through to the underlying transaction and row-level security so PMs see their jobs and executives see everything.
Contract, cost to date, estimated total cost, percent complete, earned revenue and billing position for every active job — assembled automatically instead of chased across a dozen inboxes.
Net position across the portfolio and job by job, tied to the balance sheet WIP asset and liability accounts. You know which jobs are financing your client and which are financing you.
Bank position from the general ledger sitting next to remaining-to-bill across the portfolio. The two numbers a contractor's board asks about first, on one screen instead of two systems.
Gross margin by job tracked month over month against where it started. Jobs eroding quietly show up as a trend line rather than as a surprise at closeout.
Total outstanding, days outstanding, and which jobs are carrying the balance. Unapproved client change orders and subcontractor change orders tracked separately.
Margin, billing discipline and backlog by PM and profit centre, with row-level security so each manager sees their own book and leadership sees the whole portfolio.
These figures come from completed Nexus Data Works engagements across construction, freight and financial services, built on the same Sage Intacct Power BI and Azure architecture described above. The pattern holds across industries: when the data layer is built properly underneath, the reporting problem stops being a monthly emergency.
Figures from completed NDW client engagements — not projections or industry averages.
The measure of a reporting engagement isn't the number of dashboards delivered. It's whether leadership changed how they make decisions — and whether they still trust the numbers six months later.
That trust is built in the reconciliation, not the visuals. It's the least glamorous part of the work and the only part that determines whether anyone opens the dashboard on the third of the month.
Start With a TeardownSend your two most recent WIP schedules and the matching income statement. No system access, no NDA, no IT ticket.
Two weeks, fixed fee, read-only access. We reconcile your WIP schedule, revenue and cash position line-by-line against your general ledger.
Eight to twelve weeks. Azure data warehouse, orchestrated ETL and the executive dashboard — scoped from what the audit actually found.
Commercial general contractors and specialty contractors between roughly $40M and $150M in revenue, running Sage Intacct — or Vista, Sage 300 CRE or Acumatica — with 15 to 40 active jobs, no dedicated BI headcount, and a WIP schedule that lives in Excel. If that's you, a Sage Intacct Power BI build pays for itself in the first margin surprise it prevents.
Every engagement is led by a principal consultant who writes the SQL, not a partner who sells the work and hands it to a junior. The person on your discovery call is the person in your warehouse. Forty-seven completed projects, zero failed engagements.
The warehouse, the pipelines, the stored procedures, the model and the documentation all live in your Azure tenant. There's no platform to stay subscribed to and nothing to migrate if you stop working with us. That's deliberate.
Thirty minutes, no system access, no pitch. Send your two most recent WIP schedules and the matching income statement, and we'll walk you through what we find. You get the written summary either way.
Files you already have on your desktop
We walk you through what we found
Yours whether you engage or not
Zero pressure, full clarity