Source import and field mapping
Offline Excel workpapers, Lark sheets and ERP exports come in as they are; column names with stray spaces or different orders still map.
Finance & P&L Analyst
Consolidates media spend, service fees, ERP expenses, budgets and historical results, computes revenue, rebates, gross and net margin, project profit and budget variance by your own definitions, and reports them by client, channel, project and company with charts. Visibility is per person and every report passes a human check before it goes out.
01
What it does
ERP and expense validation
Cross-checks account balances, dimension combinations and cross-entity department expenses; every gap is listed.
Metric calculation
Revenue, service fees, rebates, gross and net margin, project profit, budget variance — formulas follow your definition profile.
Multi-dimensional queries
"How did we do this month" or "top ten clients" answered directly, always on the same definitions.
Template consolidation
Several business sheets merged into one by a fixed template; ratio metrics recomputed from merged numerators and denominators, conflicts listed rather than smoothed over.
Analysis reports
Quarterly and monthly analysis with inline trend and comparison charts, exported to Word or Excel.
02
How you ask
Plain language works. These are real requests.
Consolidate these business sheets into one by a fixed template: the template header is the output column order, recompute ratio metrics from merged numerators and denominators, and list every conflicting cell instead of smoothing it.
Build this quarter's company analysis: revenue, cost, gross margin and margin rate by client, channel and project, with trend and comparison charts, exported as a document.
How did we do this month? Revenue, gross and net margin, what changed versus last month, and the top ten clients.
03
How you keep it in check
- Every metric is computed by a deterministic engine from the definition profile; the model explains, it does not do arithmetic.
- Financial data is scoped to the CEO and finance lead; nobody else can query it.
- Definition conflicts are surfaced for a person to resolve, never auto-resolved.
What acceptance looks like
- Match rate against manual calculation
- Field mapping and definition accuracy
- Cross-entity expense consistency
- Budget variance detection accuracy
- Auditable report figures
04
Questions people ask
Our definitions are different from everyone else's.
Definitions live in a per-company profile: how rebates are computed, which entity a cost belongs to, whether margin includes service fees. Calibrated once, reused after.
Our ERP has no API.
The ERP export template is the bridge: you export, it reads and validates, then produces a sheet in the same template you can import back.
Does our data leave the company?
Calculations run on your machine and the workpapers are never uploaded; the cloud only stores the definition profile.
Put it to work today.
Free credits on sign-up. For enterprise delivery, book a walkthrough and we will map your process to a job description.
Free credits on signup · No credit card · Mac and Windows