Model Auditor
Inspect an .xlsx or .xlsm workbook locally inside your browser tab. Your file never leaves your machine, and its SHA-256 hash is checked before and after reading.
1Local browser pass
Select an .xlsx or .xlsm file to run the instant browser structural pass (error values S04, external workbook links S07, hidden sheets S08, volatile functions S10, long formulas S11 and merged cells S17) with SHA-256 verification. Password-protected files, .xls and .xlsb are refused.
Waiting for a local workbook. Open your browser's network panel to verify that zero bytes are transmitted.
SHA-256 before . After .
| Check | Location | Finding |
|---|
2What each of the 32 checks tests
The full Model Auditor engine passes 145 automated tests on invented models with planted errors. Structural checks S01 to S18 are model-agnostic. Financial checks F01 to F14 require mapped rows and record "not tested" when a row cannot be mapped with confidence.
| ID | Structural check (S01 to S18) |
|---|---|
| S01 | Hard-coded numbers inside formulas (excluding structural function arguments and standard unit constants) |
| S02 | Typed constants interrupting a row of formulas |
| S03 | Inconsistent formulas along a row or column detected via R1C1 signature comparison |
| S04 | Excel error values (#REF!, #DIV/0!, #VALUE!, #NAME?, #N/A, #NUM!) and cells that inherit them |
| S05 | Formula references pointing to blank or text cells |
| S06 | Circular references detected across the workbook dependency graph |
| S07 | External workbook links |
| S08 | Hidden and very-hidden sheets, rows and columns |
| S09 | Numeric values stored as text strings |
| S10 | Volatile functions (OFFSET, INDIRECT, NOW, TODAY, RAND, RANDBETWEEN) |
| S11 | Long or deeply nested formulas |
| S12 | Dollar-sign ($) anchoring copy errors |
| S13 | SUM ranges that omit an adjacent populated row, include their own total, or double count a subtotal |
| S14 | Unused input cells and orphaned calculation rows |
| S15 | Inconsistent time axis across period columns |
| S16 | Unexpected sign flips along a numeric row |
| S17 | Merged cells inside calculation areas |
| S18 | Duplicated or near-duplicated row labels |
| ID | Financial reconciliation check (F01 to F14) |
|---|---|
| F01 | Balance sheet balances (Total assets equal Total liabilities and equity within tolerance) |
| F02 | Cash flow statement closing cash equals balance sheet cash |
| F03 | Retained earnings roll-forward reconciles opening, net income, dividends and closing |
| F04 | PP&E roll-forward reconciles opening, capex, depreciation, disposals and closing |
| F05 | Debt roll-forward per tranche reconciles opening, drawdowns, repayments and closing |
| F06 | Total debt across schedules agrees to total debt on the balance sheet |
| F07 | Interest expense reasonableness against stated tranche interest rates |
| F08 | DSCR independently recomputed from CFADS and total debt service |
| F09 | Covenant compliance tests independently recomputed against covenant thresholds |
| F10 | Working-capital days consistency (receivables, inventory, payables) |
| F11 | Income tax expense reasonableness against profit before tax and stated rate |
| F12 | Subtotals equal the plain sum of their constituent rows |
| F13 | Opening balances equal prior-period closing balances |
| F14 | Other mapped roll-forward blocks reconcile period by period |