Resources
Practical Excel templates, checklists and finance guides.
PDF previews available for every resource.
Choose from Free, Standard and Premium resources.
Free templates download straight away. Standard and Premium templates and books open our store in a new tab.
13-Week Cash Flow Forecast
Weekly receipts and payments view with base, best and worst case switch.
- Weekly input grid with opening and closing cash
- Scenario selector for collection and payment timing
- Chart of cash headroom against a minimum balance
The AI-Powered Finance Function
A CFO's playbook for adopting AI across planning, accounting, treasury and reporting. 69 pages, 16 chapters and 4 appendices.
- Use cases across FP&A, close, treasury, reporting, tax, audit, P2P and O2C
- A 90-day adoption roadmap with pilots, baselines and scale-up
- Sample AI usage policy, roadmap checklist and vendor scorecard
300 Prompts for Finance Professionals
300 tested AI prompts for forecasting, cash, the month-end close, board reporting, tax, audit and modelling. 128 pages.
- Ready to copy, with clear placeholders for your own data
- A tip and a check on every prompt, so the output is safe to use
- Beginner to advanced, with guidance on safe use of financial data
The 13-Week Cash Flow Playbook
A step-by-step guide to the rolling 13-week cash flow forecast: build it, run it weekly and present it to boards and lenders. 68 pages.
- Direct-method forecasting for receipts, payments and financing
- A one-hour weekly routine and variance analysis
- Scenarios, stress tests and a full worked case study
E-Invoicing Readiness Checklist and Tracker
Free Excel tracker for UAE e-invoicing readiness: works out your phase, ASP deadline and go-live date, and tracks every task and invoice data field you need before go-live.
- Phase, ASP deadline and go-live date worked out from revenue and entity type
- 46 readiness tasks in 9 workstreams with owner, priority, due date and status
- 34 key invoice data elements mapped to source systems (available, partial, missing)
Monthly Reporting Package: Real Estate Investor / Owner
Monthly management report for property owners: rent roll, occupancy, NOI, arrears, WALE, fair value and debt covenants, property by property.
- Rent roll, occupancy, WALE and lease expiries
- NOI, service charges and arrears by property
- Fair value, loans, DSCR and LTV with selectors
100 Excel Formulas Every Finance Professional Needs
A free 62-page guide to the 100 Excel formulas finance professionals use most, each with its syntax, a finance example with the result and the common mistake to avoid.
- 100 formulas in 10 chapters, grouped by use
- Finance example and result for every formula
- Common mistakes, version notes and error guide
Monthly Reporting Package: Real Estate Developer
A project-by-project monthly management report for property developers: off-plan sales, collections, revenue recognised over time, escrow and cost to complete, rolled up into company profit and cash against budget.
- Project-wise sales, collections and POC revenue
- Escrow, retention and cost to complete by project
- Company P&L, cash and budget with selectors
Monthly Reporting Package: Renewable Energy
Monthly management report for renewable power producers: generation against P50 and P90, availability, PPA revenue, EBITDA and DSCR, site by site.
- Generation vs P50 and P90, curtailment, availability
- PPA and merchant revenue, site EBITDA, receivables
- CFADS, DSCR covenant, P&L and cash, with selectors
Budget vs Actual Variance Analysis
Compare actuals to budget by month and year to date, with favourable and unfavourable flags.
- Paste-in sheets for budget and actuals
- Variance in value and percent with thresholds
- Summary charts for the largest movers
Month-End Close Checklist and Tracker
Track close tasks by owner, working day and dependency, with sign-off status.
- Task list from working day minus 3 to plus 10
- Owner, reviewer and status columns with progress bar
- Blocker log for open items
Financial Ratio Analysis Template
Enter statements once and read liquidity, profitability, leverage and efficiency ratios.
- Input sheet for income statement and balance sheet
- Ratio library with plain-English definitions
- Year-on-year trend table
Working Capital Dashboard
See receivable, inventory and payable days and the cash they tie up.
- DSO, DIO and DPO calculations
- Net working capital trend chart
- Target versus actual days
Receivables Ageing and Collections Tracker
Age invoices into buckets and log collection actions by customer.
- Ageing buckets from current to 90+ days
- Promise-to-pay and follow-up log
- Top overdue customers summary
Finance KPI Dashboard
A one-page view of the finance KPIs leadership asks for every month.
- KPI input sheet with definitions
- Trend charts with red, amber, green status
- Commentary box for each KPI
Break-Even and Contribution Analysis
Find break-even volume and test price, cost and mix changes.
- Fixed and variable cost inputs
- Contribution margin by product
- Sensitivity table for price and volume
Fixed Asset Register and Depreciation Tracker
Register assets and compute straight-line depreciation by month.
- Asset register with category and location
- Monthly depreciation and net book value
- Additions and disposals roll-forward
Cash Flow Statement Template
Prepare an indirect-method cash flow statement from two balance sheets and a P&L.
- Operating, investing and financing sections
- Working capital movement schedule
- Reconciliation of closing cash
Monthly Management P&L Template
A monthly management income statement with budget and prior-year comparison.
- Monthly and year-to-date columns
- Margin and cost ratios
- Variance commentary column
Expense Analysis and Cost Tracker
Classify spend by department and category and spot cost creep early.
- Expense log with category and cost centre
- Summary by department and month
- Top cost drivers chart
Sales and Revenue Tracker
Track revenue by product, customer and month against targets.
- Sales log with product and customer
- Target versus actual by month
- Top customers and products summary
Accounts Payable Ageing Tracker
Age supplier balances and plan payments around cash and due dates.
- Ageing buckets by supplier
- Payment plan by week
- Early-payment discount check
Debt Repayment Schedule
Monthly schedule for reducing-balance loans with optional extra repayments.
- Inputs for amount, rate, tenure and start date
- Monthly and yearly schedule
- Interest versus principal chart
Financial Dashboard Starter Template
A clean starting dashboard for revenue, margin, cash and headcount cost.
- Data input tabs
- Chart-ready summary tables
- Print layout for monthly review
Capital Expenditure (CAPEX) Tracker
Track approved, committed and spent capex by project.
- Project list with approval status
- Budget, commitments and actuals
- Forecast to complete and variance
Monthly Finance Reporting Checklist
Standard checklist for the monthly reporting cycle, from ledger lock to pack release.
- Pre-close, close and reporting task groups
- Review and approval sign-off lines
- Printable one-page PDF version
Finance Team KPI and Activity Tracker
Plan workloads, track deliverables and measure team performance.
- Activity log by person and process
- Turnaround and error KPIs
- Monthly team scorecard
AI Prompt Library for Finance Professionals
Tested prompt patterns for variance commentary, reconciliations, policy summaries and board papers.
- Prompts with placeholders and review notes
- Do and do-not list for confidential data
- Checklist to validate AI output
Three-Statement Financial Model
Linked income statement, balance sheet and cash flow with built-in checks.
- Driver-based revenue and cost assumptions
- Working capital, capex and debt schedules
- Balance and cash checks with error flags
Annual Budget and Rolling Forecast Model
Build the annual budget and roll a 12-month forecast each month.
- Department and cost centre budget inputs
- Rolling forecast with actuals feed
- Version comparison and approval log
Integrated Financial Planning Model
Connect sales, operations, headcount and capex plans into one financial plan.
- Linked operating plans feeding the financials
- Headcount and capex schedules
- Plan summary with key ratios
Driver-Based Budgeting Model
Budget from operating drivers such as volume, price and headcount instead of last year's numbers.
- Driver library with assumptions
- Automatic cost and revenue build-up
- Driver sensitivity view
Scenario Planning and Sensitivity Analysis Model
Compare base, upside and downside cases and test the effect of key assumptions.
- Scenario selector
- Sensitivity tables on price, volume and cost
- Side-by-side scenario summary
CFO KPI Dashboard and Monthly Management Pack
A one-page monthly pack with margins, cash, working capital and cost KPIs.
- KPI definitions and data input sheet
- Trend charts with status flags
- Commentary section for each KPI
Board Financial Reporting Pack
Standard board finance pages: results, cash, covenants and risks.
- Summary P&L, balance sheet and cash
- Covenant compliance tracker
- Risk and outlook commentary page
Group Consolidation Model
Consolidate several entities with eliminations, minority interests and currency translation.
- Entity input sheets and mapping
- Elimination journals
- Consolidated statements with checks
Multi-Entity Financial Reporting Model
Produce standard reports across entities from one trial balance structure.
- Trial balance import and mapping
- Entity and group views
- Management reporting outputs
Intercompany Reconciliation and Elimination Model
Match intercompany balances, list differences and generate elimination entries.
- Intercompany matrix by entity pair
- Difference log and ageing
- Elimination journal output
Advanced 13-Week Cash Flow and Liquidity Model
Detailed weekly liquidity forecast with facilities, covenants and scenarios.
- Receipts and payments by category
- Facility headroom and covenant checks
- Scenario and stress cases
Working Capital and Cash Conversion Model
Model receivable, inventory and payable days and see the cash effect of each lever.
- DSO, DIO and DPO calculations
- Cash released or absorbed by each lever
- Scenario table for target days
Debt and Loan Portfolio Management Model
Manage several facilities with repayment schedules, interest and maturity profile.
- Facility register with terms
- Combined repayment schedule
- Maturity and interest cost summary
DCF Business Valuation Model
Discounted cash flow valuation with a WACC build-up and sensitivity grids.
- Free cash flow forecast and terminal value
- WACC calculator
- Sensitivity tables for growth and discount rate
Investment Appraisal Model: NPV, IRR and Payback
Compare projects using NPV, IRR, payback and profitability index.
- Cash flow inputs for several projects
- Side-by-side ranking
- Sensitivity on discount rate and cash flows
M&A Acquisition Analysis Model
Assess a target: valuation, purchase price, funding and post-deal effect on earnings.
- Target valuation and deal structure
- Sources and uses of funds
- Accretion and dilution analysis
Project Finance Model
Model construction, debt sizing, operations and returns for a project.
- Construction and operating phase timelines
- Debt sizing and coverage ratios
- Equity returns and sensitivity
Advanced Month-End Close and Balance Sheet Reconciliation Pack
Run the close and reconcile every balance sheet account with evidence and review status.
- Close calendar and task control
- Account reconciliation register
- Reconciling item ageing and sign-off
UAE Corporate Tax Computation Workbook
Bridge accounting profit to taxable income, with adjustments and a return-ready summary.
- Trial balance mapping to tax lines
- Adjustment schedules and disallowed items
- Tax payable, losses and due-date tracker
CFO Financial Planning and Reporting Suite
A connected suite: plan, forecast, monthly pack and board reporting in one workbook set.
- Integrated plan, forecast and actuals
- Monthly management and board outputs
- Scenario and KPI modules