Skip to main content

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.

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.

IDStructural check (S01 to S18)
S01Hard-coded numbers inside formulas (excluding structural function arguments and standard unit constants)
S02Typed constants interrupting a row of formulas
S03Inconsistent formulas along a row or column detected via R1C1 signature comparison
S04Excel error values (#REF!, #DIV/0!, #VALUE!, #NAME?, #N/A, #NUM!) and cells that inherit them
S05Formula references pointing to blank or text cells
S06Circular references detected across the workbook dependency graph
S07External workbook links
S08Hidden and very-hidden sheets, rows and columns
S09Numeric values stored as text strings
S10Volatile functions (OFFSET, INDIRECT, NOW, TODAY, RAND, RANDBETWEEN)
S11Long or deeply nested formulas
S12Dollar-sign ($) anchoring copy errors
S13SUM ranges that omit an adjacent populated row, include their own total, or double count a subtotal
S14Unused input cells and orphaned calculation rows
S15Inconsistent time axis across period columns
S16Unexpected sign flips along a numeric row
S17Merged cells inside calculation areas
S18Duplicated or near-duplicated row labels
IDFinancial reconciliation check (F01 to F14)
F01Balance sheet balances (Total assets equal Total liabilities and equity within tolerance)
F02Cash flow statement closing cash equals balance sheet cash
F03Retained earnings roll-forward reconciles opening, net income, dividends and closing
F04PP&E roll-forward reconciles opening, capex, depreciation, disposals and closing
F05Debt roll-forward per tranche reconciles opening, drawdowns, repayments and closing
F06Total debt across schedules agrees to total debt on the balance sheet
F07Interest expense reasonableness against stated tranche interest rates
F08DSCR independently recomputed from CFADS and total debt service
F09Covenant compliance tests independently recomputed against covenant thresholds
F10Working-capital days consistency (receivables, inventory, payables)
F11Income tax expense reasonableness against profit before tax and stated rate
F12Subtotals equal the plain sum of their constituent rows
F13Opening balances equal prior-period closing balances
F14Other mapped roll-forward blocks reconcile period by period