The model audit and formatting toolkit, on the second ribbon tab
ZAF Tools ships two ribbons. ZAF AI runs the FDD workflow. ZAF Tools carries the utilities you use all day: Model Audit and Error Scan, Quick Map colour coding, Consolidate Sheets and Files, Flatfile, Concentration analysis, Clean Text, Fix Dates, Apply Font, Neg () Format and more: 38 tools, free, no subscription.
Reviewers still catch hardcodes and broken ranges by eye, and analysts still spend the last hour of every deliverable on formatting.
- Audit scorecard with links to every issue
- Formula map
- Consolidated workbook
- Customer and revenue concentration analysis
How it works
- Quick Map colours formulas, hardcodes and cross-sheet links in one pass.
- Model Audit runs consistency, range, reference and hardcode checks with a clickable scorecard.
- Consolidate Files pulls a folder of monthly files into one workbook.
- Reset View prepares the file for sending: A1, groups closed, filters cleared.
Questions about 38 free excel tools & model audit
Do the utilities need the AI subscription?
The ZAF Tools ribbon works offline. The ZAF AI ribbon uses the managed backend.
Related
- EBITDA Bridge — Period-to-period bridge with waterfall chart and a cross-check to the P&L.
- Build financial statements — From mapped TB to P&L, balance sheet, NWC, net debt and cash flow schedules.
- Find adjustments & anomalies — AI scans any sheet for one-offs, outliers and inconsistencies.
- EBITDA bridge Excel template — template
- ZAF Tools vs Macabacus
See it on your own trial balance
Book a 30-minute live demo on your own trial balance, or request a trial for your team.