Finance Templates

Professional Finance & Accounting Templates

Built from 15 years of corporate controlling at Dufry Group and Bomi (UPS Group). Not simplified academic exercises: end-to-end models that finance professionals actually use.

Featured — Best Value

The Complete Swiss CFO Finance Suite

Every template on this page in a single purchase. Nine Excel files covering the complete financial management cycle: full double-entry accounting simulation, KPI dashboard with HTML export, cash flow model, COGS and margin analysis, asset depreciation, loan and lease schedules, IFRS process flowcharts, and cash & credit card controls. Built as a coherent suite — files share the same chart of accounts, sign conventions, and IFRS treatment throughout. The most efficient way to build a complete finance infrastructure for a Swiss SME.

9 files IFRS-aligned Swiss VAT Fully unlocked Free updates 12 months
CHF 742 if bought individually — save CHF 243
CHF 499 one-time
What's included
Swiss SME Accounting Simulation (CHF 149 standalone)
KPI Intelligence Suite with HTML Dashboard + KPI Guide (CHF 99 standalone)
Cash & Credit Card Controls Dashboard (CHF 99 standalone)
Swiss CFO Cash Flow Model (CHF 79 standalone)
COGS and Margin Analyzer (CHF 79 standalone)
IFRS Process Flowcharts (CHF 79 standalone)
CapEx & Depreciation Waterfall (CHF 79 standalone)
Loan & RoU Schedule IFRS 16 Model (CHF 79 standalone)
Month-End Close Checklist Switzerland (free standalone)
All files fully unlocked · Same chart of accounts throughout · Free updates 12 months
Individual Templates

Standalone tools. One job each. Buy what you need.

Each template covers one specific controlling task — extracted from real corporate workflows at Dufry Group and Bomi (UPS Group), properly engineered, and ready to adapt to your chart of accounts.

Complete Simulation
Swiss SME Accounting Simulation
Swiss SME Accounting Simulation — 220-account chart of accounts
The most complete accounting model available for a Swiss SME. A 220-account chart of accounts feeds a 40,000-row double-entry journal that flows automatically into monthly balance sheet, P&L, direct and indirect cash flow, Swiss VAT quarterly settlement, and 28 KPIs with RAG benchmarks. IFRS 16 right-of-use assets, four loan amortisation schedules, year-end closing entries, and a two-pass financing model that resolves the circular dependency between interest and tax.
220 accounts 40,000+ journal rows Swiss VAT IFRS 16 28 KPIs
CHF 149 one-time
Controls & Reconciliation
Cash & Credit Card Controls Dashboard
Cash and Credit Card Controls Dashboard with RAG status tiles and monthly charts
A macro-driven management dashboard that reconciles credit card transactions against POS system data and cash against security company counts — in real time. One click exports a self-contained HTML dashboard with RAG-coded KPI tiles, five time-series charts, and a control status panel showing whether the period is ready to close. The HTML export works offline — no internet connection required after the first run.
Macro-driven HTML export RAG status Offline-capable
CHF 99 one-time
Buy Now — CHF 99
KPIs & Dashboard
KPI Intelligence Suite
KPI Intelligence Suite — Management Dashboard with RAG tiles and trend charts
28 financial KPIs across 9 sections — Profitability, Returns & Leverage, Liquidity, Working Capital Efficiency, Cash Flow, Debt & Covenants, Operational, Income Statement Decomposition, and DuPont — computed monthly and YTD with RAG benchmarks calibrated for Swiss manufacturing and retail SMEs. Includes a macro that exports a fully designed HTML management dashboard with live charts. Comes with the KPI Complete Guide: formulas, benchmarks, IFRS notes, and adjustments for all 28 metrics.
28 KPIs HTML dashboard export RAG benchmarks Includes KPI guide
CHF 99 one-time
Cash Flow
Swiss CFO Cash Flow Model
Swiss CFO Cash Flow Model — indirect and direct methods with reconciliation
Both direct and indirect cash flow methods built from the same journal source, with a reconciliation proving they match to 0.00 across every period. Uses balance sheet variations (ΔBS) rather than period-end balances — the correct approach for an integrated model. Covers all three activities: operational, investment, and financing. Includes a VAT reclassification line handling the structural difference between VAT on investments in the direct versus indirect method.
Direct & indirect 0.00 reconciliation ΔBS convention All 3 activities
CHF 79 one-time
Buy Now — CHF 79
Inventory & COGS
COGS and Margin Analyzer
COGS and Margin Analyzer — FIFO per-transaction calculation across 12,554 rows
Per-transaction FIFO cost of goods sold calculation across 12,554 sale rows, 38 products, and 11 months. Each sale is matched against the oldest available inventory layer at the actual cost that stock was received — not an average, not an estimate. Combines direct sales and export invoices with daily goods-received data and production output to produce an audit-ready COGS figure for every transaction. Includes a COGS estimated vs actual comparison column and daily inventory balance tracking.
FIFO 12,554 transactions 38 products Audit-ready
CHF 79 one-time
Buy Now — CHF 79
Process & Reference
IFRS Process Flowcharts
IFRS Process Flowcharts — Sales, COGS and Payment flow diagram
Six A3-ready process flowcharts covering the complete accounting cycle: Sales-COGS-Payment flow, Production and Sales process, RoU IFRS 16 lease accounting, Amortisation, Depreciation, and Cash Flow & Accounting flow. Each chart maps the full decision tree including journal entries, VAT treatment, inventory movements, and IFRS classification points. Built for controllers who need to document processes, train teams, or prepare for audit. All charts editable directly in Excel — no specialist diagramming software required.
6 flowcharts A3-ready IFRS 16 Editable in Excel
CHF 79 one-time
Buy Now — CHF 79
Fixed Assets
CapEx & Depreciation Waterfall
CapEx Depreciation Waterfall — multi-method depreciation schedule across 156 months
Multi-method depreciation and amortisation schedule covering up to 156 months (13 years) per asset. Supports straight-line, declining balance, sum-of-the-years, and units-of-production methods in the same file, with each asset assigned its own method. Monthly depreciation, cumulated balances, and net book value columns feed directly into the balance sheet and cash flow statement. Start year and start month inputs handle mid-year asset additions correctly.
4 depreciation methods 156-month horizon Mid-year additions GL-ready
CHF 79 one-time
Buy Now — CHF 79
Financing & Leases
Loan & RoU Schedule IFRS 16 Model
Loan and RoU Schedule IFRS 16 Model — amortisation and lease liability schedules
Four loan amortisation schedules and four IFRS 16 right-of-use asset schedules in a single file. Loans support both annuity (equal total payment) and fixed-principal structures with monthly effective rate conversion. Each RoU schedule calculates the lease liability at inception, monthly interest, principal, depreciation, and net book value — closing at exactly CHF 0.00 on the final payment. Current and non-current liability split is calculated automatically for balance sheet classification.
4 loans 4 RoU assets IFRS 16 0.00 close
CHF 79 one-time
Buy Now — CHF 79
Month-End Process
Free
Financial Closing Checklist — Switzerland

A structured month-end closing checklist built from 15 years of corporate controlling at Swiss companies. Covers every step from pre-close preparation through management report delivery: Swiss-specific items (MWST reconciliation, AHV/BVG accruals, withholding tax), reconciliations, accruals, intercompany entries, variance checks, and sign-off. Owner, reviewer, and timing columns included.

Swiss-specific MWST AHV/BVG Pre-close to sign-off
Free
Download Free
For Consultants & Fiduciaries

Use these templates for your clients.

The standard licence covers personal and single-company use. If you work with multiple clients, the Commercial License extends your rights across all of them.

Commercial License
Commercial License

Commercial License — Unlimited Client Use

The standard licence on each template covers personal and single-company use. The Commercial License extends your rights to use any template in the suite for paid client engagements — with no per-client or per-project limits. Adapt, modify, and deliver files directly to clients as part of your service. One-time fee. No annual renewal.

What's included
Unlimited client engagements
Full adaptation rights for each client
Delivery rights — send completed files to clients
Multi-entity use within corporate groups
Does not cover
×Resale or redistribution of original files
×Publishing templates as your own products
Consultants Fiduciaries Fractional CFOs Unlimited clients One-time fee
CHF 299 one-time
Buy Commercial License — CHF 299

Need both the files and the licence? Buy the Full Suite (CHF 499) + Commercial License (CHF 299) = CHF 798 total — all 9 files, unlimited client use.

Why These Are Different

Not generic. Not broken. Not unsupported.

Most finance templates online are held together with manual overrides, broken links, and formulas nobody dares touch. These come from 15 years of real corporate operations, are properly engineered, and are supported by the person who built them.

Built from real operations.

Every structure comes from actual controlling work at Dufry Group and Bomi (UPS Group). Not theoretical exercises, not simplified teaching tools.

Properly engineered.

Named ranges, data validation, separation of inputs and outputs. They scale, they reconcile, and they don't break under pressure.

Supported.

Email me with questions. I built them: I can help you use and adapt them.

FAQ

Common questions about the templates.

Excel 2016 or later (Windows or Mac). Google Sheets compatibility is limited due to advanced formulas.
Yes. They're fully unlocked Excel files. Modify anything you need.
Yes. Template purchases include free updates for 12 months.
If a template doesn't work as described, I'll fix it or refund you. No questions.
Yes. The standard licence covers personal and single-company use. If you need to use the templates for multiple clients (consultants, fiduciaries), the commercial licence add-on covers unlimited client use. Contact me for details.
Custom Work

Need something custom?

If you need a tailored financial model, reporting template, or simulation built for your specific business: that's what I do as a controller too. Let's talk.

Book a Call to Discuss Or browse my consulting services →