What We Do
When finance checks the number,it ties out.
Most analytics is built next to the accounting system, not against it, so sooner or later the dashboard and the ledger disagree and everyone trusts the dashboard a little less. We build the other way: models reconciled to the general ledger by construction, trued up every month, so a discrepancy means something real happened rather than two systems counting differently.
The problem
Analytics gets built next tothe books, not against them.
The dashboard pulls from the operational systems. The ledger records what the accountant booked. They count different things on different dates, and nobody notices until a board deck and a P&L disagree in the same meeting. From then on, every number from the dashboard carries an asterisk.
The other version of the problem lives in a workbook. The operating model the CFO built years ago still runs the planning cycle, it has grown past what Excel can hold, and exactly one person knows which cells to touch. It is not wrong. It is unownable.
We build financial models that reconcile to the general ledger by construction, and when the workbook has outgrown itself, we port it whole and prove the port to the penny before anyone relies on it.
What we build
Reconciled by construction, not by meeting.
Operating model ports
The planning workbook moves into the warehouse and keeps its logic. We validate the port against the original until the totals foot exactly, keep every version as it was published, and run it beside any forecast rather than instead of one.
Fees and costs at transaction grain
Payment fees, shipping, and cost of goods modeled per order from gateway and carrier actuals, then trued up to the ledger monthly. The placeholders that flatter the unit economics get replaced with what was actually paid.
Revenue the accountant recognizes
Deferred revenue, memberships, refunds and channel mix reported on the same definitions the close uses, so finance and operations read one number instead of negotiating two.
Manual finance work, retired
The invoices someone retypes, the spreadsheet someone reconciles, the report someone assembles for the auditor. Where the input exists in a system, the retyping can stop.
What changed
What it changed.
1.46 million rows, to the penny
The CFO's operating model had outgrown Excel, and only one person could open it safely. It runs in the warehouse now and foots to the consolidated P&L exactly, so a scenario question gets answered the day it is asked.
A monthly delta of zero
Payment fees modeled per order across every gateway and trued up to the ledger monthly. Because the reconciliation is exact by construction, a variance became something to investigate rather than something to argue about.
Retail revenue without the retyping
Retailer invoices arrived as PDFs and someone keyed them into a spreadsheet every month. They land as a table by retailer and product now, reconciled to the ledger, so the retail channel gets managed weekly instead of reconstructed at quarter end.
What else
This one rarely shows up alone.
Does your dashboard agree with your ledger?
If you are not sure, that is the finding.