The short answer: The EXL Cloud modelling standard is a set of non-negotiable rules for driver-based financial models: zero hardcoding in calculations, blue inputs and black formulas, a fully reconciled three-way model (P&L, balance sheet and cash flow), a dedicated error and validation sheet, and a change log in every workbook. Every EXL Cloud Gen 2 workbook and every EXL Cloud AI skill is built to this standard.

Why standards, and why now?

I've reviewed a lot of models over two decades in banking, Big 4 and advisory. The models that failed rarely failed because of a complex formula. They failed because someone typed a number into a calculation row in 2019 and nobody noticed it was still there in 2023.

AI raises the stakes. Claude can now build and extend a model in minutes. Without standards, you just get bad models faster. With standards, AI becomes a force multiplier — because a model built to a known standard can be checked against that standard, by a human or by another skill.

The six rules

1. Zero hardcoding

No business number is ever typed into a calculation. Growth rates, prices, headcount, days — they all live in labelled input cells and are referenced. The only literals allowed in formulas are structural constants (12 months in a year, 1 for a flag).

Why it matters: a hardcode is invisible. It doesn't change when the assumption changes, and it's the single most common cause of models quietly giving the wrong answer.

2. Blue inputs, black formulas

Inputs are blue font. Formulas are black. Links to other sheets follow a consistent convention. Anyone opening the model knows instantly what they're allowed to change and what they shouldn't touch.

3. Driver-based, one direction

Inputs → calculations → outputs. Revenue is built from drivers (customers × price, jobs × average value), not typed as a total. Calculations flow one way, so a change to a driver ripples predictably through to the outputs.

4. Full three-way reconciliation

The P&L, balance sheet and cash flow statement are fully integrated. Net profit rolls into retained earnings. The cash flow statement reconciles to the movement in cash on the balance sheet. The balance sheet balances in every single period, not just the last one.

5. A dedicated error and validation sheet

Every check — balance sheet balances, cash ties, retained earnings rolls forward, inputs within range — rolls up to a single sheet with a single answer: errors = 0, or not. That status is displayed on the cover and on every output, so nobody can present a model that's quietly broken.

6. A change log in every workbook

Every structural change is logged: what changed, where, why, and who did it. When AI is involved, that's logged too. Six months later, the change log is the difference between understanding a model and reverse-engineering it.

What this looks like in an EXL Cloud workbook

The Gen 2 rebuild applied these standards to every EXL Cloud workbook. Each one now includes a dedicated Instructions sheet, consistent navigation and formatting, plain-English notes on formulas, and validation checks wired to a single status. The 3-Way Driver-Based Financial Model pulls actuals straight from Xero, so the forecast starts from real numbers, not a copy-paste.

Want to see it in action? Try the interactive 3-way model demo — move the drivers and watch the P&L, balance sheet and cash flow respond together.

Standards make AI trustworthy

This is the part most people miss. When a model follows known rules, AI can check it against those rules:

  • Skill 02 enforces the formatting and formula standards whenever Claude builds a sheet.
  • Skill 09 extracts every hardcoded assumption into a register — and finds the ones that shouldn't be there.
  • Skill 10 adds PASS/FAIL validation checks.
  • Skill 21 benchmarks the whole model and tells you exactly where it falls short. How the benchmark works →

Without a standard, an AI review can only tell you what it thinks. With one, it can tell you what's missing, where, and how long it'll take to fix.

Frequently asked questions

Is a single hardcode really a problem?

One hardcode in a model that nobody else will ever touch is a small risk. One hardcode in a model that's rolled forward monthly, shared with a lender and extended by AI is a time bomb. The rule is zero because "a few" never stays a few.

Do these standards apply to models built outside EXL Cloud?

Yes. They're consistent with recognised standards like FAST, SSRB and ICAEW guidance. EXL Cloud just makes them the default.

Where can I learn to build models this way?

Our free Lightning Lessons on Maven cover the fundamentals, and the AI-Powered Accountant program goes deep on building and reviewing models with Claude. EXL Cloud subscribers receive 45% off the program.

Go deeper: 3-Way Financial Model: Fundamentals, Driver Based Planning and Forecasting and Error Checks for Excel on the Model Citizn Knowledge Hub.


Every EXL Cloud Gen 2 workbook is built to these standards and connects to Xero in 8 clicks. Explore the workbooks →