Complete Pack
Finance Systems Toolkit Pack
All workbook templates bundled in one `.zip`, ready for Excel with separate files by use case.
- Editable assumptions
- Sample actuals / source rows
- Protected formulas and outputs
Finance Systems Toolkit
Battle-tested checklists, models, frameworks, and AI prompts built from 25+ years in global banking and real startup finance. No theory. No bloated dashboards. Just disciplined, capital-efficient tools you can copy today and run tomorrow.
We created this hub because great finance does not need complexity. It needs clarity, speed, and ownership. Start with the free Capital Efficiency Checklist below, then move into rolling forecasts, variance bridges, capital scoring matrices, and ready-to-paste AI prompts that cut real time from the month-end cycle.
Every tool here is built for CFOs and finance teams that want tighter systems without the consulting fluff. Adapt to your context. These are starting points built for speed and clarity.
Every workbook download now includes pale-gold editable inputs, protected formula cells, sample data, and a clean instructions tab. Interactive scoring still lives below, and you can print the executive summary after rating your current state.
Download Library
The pack below is built around current driver-based planning, scenario, liquidity, and reporting practices. Each file uses highlighted editable inputs, protected formulas, sample data, and simple sheet structure so the team can actually run it next month.
Complete Pack
All workbook templates bundled in one `.zip`, ready for Excel with separate files by use case.
Diagnostics
Three fast workbook downloads for capital efficiency, FP&A health, and AI readiness inside finance.
Planning Models
Three linked workbook templates for rolling plans, 13-week liquidity, and hiring / capacity decisions.
Variance & Capital
Decision-ready workbooks for bridge logic, driver decomposition, capital ranking, and cash conversion.
Leadership & AI
Download the board one-pagers and the structured prompt library as workbook files too.
Detailed Tool Pages
Use this directory when you want the standalone version of a model with structure, sample tables, formulas, setup notes, and implementation guidance. The toolkit hub stays the index. The pages below do the deeper work.
Forecast Model
Detailed tab structure, driver logic, sample outputs, scenario rules, and finance-team setup notes.
Cash Model
Weekly cash structure, alert logic, runway framing, and the operating cadence that makes the file useful.
Capacity Model
Role-level capacity logic, productivity ramps, payroll impact, and hiring decision discipline.
Variance Template
Bridge logic, movement categories, commentary cues, and sample management-ready output.
Decomposition Tool
Segment, volume, price, mix, and timing logic for turning a miss into a clear action view.
Narrative Template
Structured narrative blocks, tone rules, action framing, and examples that travel well to CEOs and boards.
Allocation Tool
Weighted scoring, gating rules, kill-list logic, and sample investment ranking for finance teams.
Working Capital Tool
Cash conversion structure, owner-based levers, DSO / DPO / inventory logic, and improvement sequencing.
Core Checklists & Diagnostics
The highest-leverage starting point is not another dashboard. It is a sharper diagnostic. Rate the finance system you have, spot the weak control points, and use the summary to focus the next 30 days of work.
01
This expands the original 24-point checklist into a scored operating review. Rate each item from 1 to 5, watch the section flags update, and use the auto-generated executive summary to tighten the next management review or board prep cycle.
Cash visibility and runway
Working capital discipline
Spend control and approvals
Capital allocation quality
Reporting and decision support
AI controls in finance
02
An 18-question self-audit that pressure-tests model structure, ownership, reporting cadence, scenario logic, and decision usefulness. Use it when the forecast technically exists but nobody trusts it enough to act fast.
| Band | Maturity score | Typical fix |
|---|---|---|
| Reactive | 0-35 | Rebuild around drivers and ownership |
| Functional | 36-70 | Tighten cadence and commentary logic |
| Decision-ready | 71-100 | Add sharper scenarios and exception tracking |
When this tool shines: when leadership keeps asking for one more version of the forecast because the current one is not trusted.
03
A quick audit that separates promising finance AI use cases from risky shortcuts. It is built to help teams decide where AI adds real value and where it is likely to create review noise, control gaps, or bad confidence.
| Workflow | Value | Risk | Recommendation |
|---|---|---|---|
| Variance commentary draft | High | Low | Automate with reviewer |
| Board pack final numbers | Medium | High | Keep human-controlled |
| Vendor term review notes | High | Medium | Pilot with audit trail |
When this tool shines: when the team is excited about AI but has not yet drawn the line between a useful workflow and a governance problem.
Forecast & Planning Models
These models are built to be touched by real finance teams, not trapped with one analyst. Keep the inputs tight, show the drivers clearly, and make scenario changes fast enough to matter.
01
Available in Google Sheets or Excel structure. Built around the tabs finance teams actually need: Assumptions & Drivers, Revenue Build, Expense Build, 3-Statement Output, Scenarios, and Dashboard.
| Driver | Example input | Why it matters |
|---|---|---|
| INR / USD FX | 83.40 | Reprices overseas tooling and USD-linked contracts |
| GST rate on billings | 18% | Shapes cash timing and output tax planning |
| Paid social CAC | INR 42,000 | Connects growth spend to payback discipline |
| Sales headcount ramp | +1 in Jul, +2 in Oct | Links bookings capacity to cost and ESOP dilution |
When this tool shines: when the annual budget is too slow and finance needs a rolling view that can absorb hiring, FX, and margin shocks without a full rebuild.
02
Weekly cash visibility with burn scenarios, covenant watchpoints, and funding-gap alerts. This is the file you open before leadership asks, "What happens if collections slip by two weeks?"
| Week | Opening cash | Net movement | Closing cash | Signal |
|---|---|---|---|---|
| Wk 1 | INR 6.4 Cr | INR -0.38 Cr | INR 6.02 Cr | Normal |
| Wk 4 | INR 5.46 Cr | INR -0.71 Cr | INR 4.75 Cr | Watch collections |
| Wk 9 stress | INR 3.82 Cr | INR -0.94 Cr | INR 2.88 Cr | Funding gap alert |
When this tool shines: when you need sharper control over runway, debt timing, payroll risk, or supplier negotiations in a fast-scaling quarter.
03
Links hiring to revenue capacity, payroll cost, and cash impact. Helpful when the business keeps discussing headcount in isolation rather than as a capital deployment decision.
| Function | Opening HC | Planned hires | Fully loaded monthly cost | Capacity note |
|---|---|---|---|---|
| Sales | 12 | +3 | INR 2.8 L each | Supports INR 1.1 Cr new ARR per quarter |
| Customer success | 8 | +2 | INR 1.9 L each | Protects retention above 93% |
| Product / engineering | 24 | +4 | INR 3.4 L each | Includes ESOP pool refresh assumption |
When this tool shines: when the hiring plan feels optimistic but finance cannot yet show the cash and capacity trade-off cleanly.
Variance Analysis Arsenal
Good variance analysis reduces ambiguity and speeds ownership. Each template below is designed to pull teams away from generic narrative and toward specific movement, cause, and action.
01
A bridge view that moves from plan to actual using a clean waterfall logic. Pair it with the commentary builder to explain which levers mattered and which did not.
| Bridge item | Impact | Commentary cue |
|---|---|---|
| Opening budget EBITDA | INR 2.4 Cr | Baseline |
| Volume miss in enterprise | INR -0.7 Cr | Deals slipped by 3-4 weeks |
| FX gain on USD billing | INR +0.2 Cr | Rate moved from 82.8 to 83.5 |
| Cloud cost overrun | INR -0.18 Cr | Usage spike on data workloads |
When this tool shines: when management wants a faster read on whether the month was a timing issue, pricing issue, mix issue, or execution issue.
02
Breaks a miss into segment, volume, price, mix, churn, and timing. Useful when a headline number is obscuring which part of the business actually changed.
| Segment | Volume | Price | Mix | Action |
|---|---|---|---|---|
| SMB SaaS | INR -18 L | INR +4 L | INR -3 L | Refocus paid search and onboarding |
| Enterprise | INR -42 L | INR +11 L | INR +6 L | Fix deal slippage and legal cycle |
When this tool shines: when the team keeps saying "revenue missed budget" without being able to say which segment, which driver, and which action matters.
03
A structured story template that forces tone, cause, confidence level, and next actions into one short block. Good for board packs, CEO updates, and lender communication.
What moved: Revenue landed INR 0.9 Cr below plan, mostly from enterprise timing.
Why: Two contracted deals moved from March to April due to customer procurement delays.
What we are doing: Rephasing enterprise close assumptions, tightening collections, and pausing one discretionary hiring wave.
Confidence: Medium. Pricing remains intact; timing risk remains elevated.
When this tool shines: when finance has the numbers but the message is still too long, too soft, or too defensive.
Capital Allocation Frameworks
These frameworks push teams toward explicit trade-offs. They help finance compare projects, defend a stop decision, and free working capital without hand-waving.
01
A weighted decision tool for competing projects. Use Strategic Fit, Expected ROI / Payback, Capital Efficiency, Risk, and Execution Speed to compare bets that normally get sold on separate narratives.
| Project | Weighted score | Payback | Decision |
|---|---|---|---|
| Collections automation | 8.6 / 10 | 7 months | Fund now |
| New fintech sales pod | 7.4 / 10 | 14 months | Fund in phases |
| AI close assistant pilot | 6.8 / 10 | 10 months | Pilot with controls |
| Warehouse expansion | 4.9 / 10 | 29 months | Kill list |
When this tool shines: when multiple projects feel "important" but capital is tight and the team needs a common language for saying no.
02
A diagnostic plus action log tailored to Indian operating realities: vendor terms, GST timing, collections discipline, inventory pockets, and operating seasonality.
| Lever | Current | Target | Impact |
|---|---|---|---|
| DSO | 74 days | 58 days | INR 1.2 Cr release |
| DPO | 38 days | 50 days | INR 0.6 Cr release |
| Inventory days | 49 days | 35 days | INR 0.8 Cr release |
When this tool shines: when cash feels tighter than EBITDA suggests and the business needs working capital owners, not just one more report.
AI Prompts for Finance
Each prompt below follows a simple RCTF structure: Role, Context, Task, Format. Copy them directly, paste in your numbers, and keep a human reviewer on anything that influences management or board decisions.
Forecasting & Scenario Planning
When to use it: after a weak month when you need a disciplined reset instead of a hand-wavy reforecast.
Role: You are my CFO-level FP&A partner. Context: We are a Series B SaaS company in India with INR reporting, some USD-linked costs, and a board update in 5 days. I will give you actuals, current forecast, headcount plan, CAC by channel, and collections timing. Task: Rebuild the next 6 months into base, downside, and stress cases. Identify the 5 drivers that explain most of the change, quantify runway impact, and highlight 3 decisions leadership should make now. Format: Return a concise table for each scenario, then a short management note with what changed, why, and what action is required.
Stress case reduces runway from 11.2 months to 8.7 months, driven mainly by slower enterprise collections and a delayed hiring productivity curve.
Do not let the model reforecast every line. Force it to name the handful of drivers that actually moved the month.
When to use it: when the CEO asks how much room exists before a hiring pause, fundraise, or cost reset becomes unavoidable.
Role: Act as a disciplined startup finance operator. Context: I will share opening cash, monthly burn, collections risk, committed hires, and any debt or covenant limits. Task: Build a scenario ladder showing runway under current plan, 10 percent revenue shortfall, 20 percent collections delay, and a combined downside case. Tell me which operating levers preserve the most runway with the least strategic damage. Format: Output a 4-row scenario table, then a ranked list of levers with estimated runway benefit and likely business downside.
Deferring the Q3 sales pod extends runway by 1.4 months with lower strategic damage than reducing customer success capacity.
Always ask for lever impact in months of runway and business damage, not just absolute rupees.
When to use it: before a board pack, when you want the model challenged for driver inconsistency and hidden optimism.
Role: You are an experienced board-facing finance reviewer. Context: I will provide a draft forecast with assumptions for bookings, retention, headcount, gross margin, CAC, and FX. Task: Challenge the forecast. Find assumption conflicts, unsupported optimism, and missing downside triggers. Then suggest the minimum changes needed to make the forecast board-ready. Format: Return three sections: red flags, questions for management, and a cleaner forecast assumption set.
The plan assumes faster enterprise conversion and lower CAC at the same time, but no change in sales capacity or market mix supports that view.
Use this before the pack leaves finance. It is cheaper to be challenged internally than by the board.
Variance Analysis & Commentary
When to use it: after closing the month when you need crisp commentary that follows the actual bridge logic.
Role: You are an FP&A lead who writes sharp monthly commentary. Context: I will provide plan, actual, and bridge line items for revenue, gross margin, EBITDA, and cash. Task: Write a short monthly variance note that explains the main drivers, separates timing from structural issues, and names the immediate actions by owner. Format: Output three paragraphs: what changed, why it changed, and what happens next. Keep the tone board-ready and direct.
Revenue landed below plan due mainly to two enterprise deals moving into April, while pricing and retention remained stable.
Push the model to call out timing versus true deterioration. That distinction changes decisions.
When to use it: when "revenue missed" is too vague and you need segment-level explanation with clear next moves.
Role: Act as a commercial finance analyst with strong business judgment. Context: I will share actual versus plan by segment, along with volume, price, mix, churn, and timing data. Task: Decompose the miss into the few drivers that matter most, identify which are recoverable this quarter, and recommend 3 actions for sales, marketing, and finance. Format: Return one driver table followed by a short action memo with named owners and expected impact.
Sixty percent of the miss sits in enterprise timing, while the more important structural issue is rising CAC in SMB paid social.
If the model cannot propose a recoverable plan and a non-recoverable plan, it has not really decomposed the miss.
When to use it: when costs are drifting and the team needs a sharper explanation than "higher than expected spend."
Role: You are a disciplined finance business partner. Context: I will provide actual versus budget operating expenses by department, highlighting headcount, software, travel, and professional fees. Task: Explain the overspend, separate one-off and recurring items, identify any approval or renewal control failures, and recommend corrective actions by owner. Format: Return a short memo with a table for overspend drivers and a final section called "what we stop, what we keep, what we review."
Recurring overspend is concentrated in cloud tools and professional fees, with one renewal approved without a refreshed business case.
Ask for the control failure, not just the cost category. That is what prevents repeat leakage.
Capital Efficiency & Allocation
When to use it: when two or more projects all sound compelling but capital is tight.
Role: You are my capital allocation partner. Context: I will provide 3 to 5 proposed projects with expected spend, strategic rationale, payback, risks, and execution demands. Task: Score each project on strategic fit, expected ROI, capital efficiency, risk, and execution speed. Then recommend which to fund now, phase, or stop. Format: Output a score table, then a direct recommendation memo explaining the ranking and the most important trade-offs.
Collections automation ranks first because it improves cash within one quarter and requires less execution drag than a new expansion pod.
Ask the model to name what should not be funded. Good capital discipline needs a kill list.
When to use it: when a project is consuming money but nobody wants to confront whether it still deserves funding.
Role: Act as a hard-nosed but fair investment reviewer. Context: I will share the original business case for a project, money spent so far, actual outcomes, revised timeline, and strategic value today. Task: Recommend whether we kill, continue, or reset the initiative. Explain the sunk-cost risk, what new evidence matters, and the decision rule leadership should use. Format: Return a one-page memo with recommendation, rationale, and next action.
Reset rather than continue. Strategic fit remains, but original payback assumptions no longer hold and the scope must be reduced.
Make the model restate the original underwriting case first. Otherwise sunk cost bias sneaks in quietly.
When to use it: when EBITDA looks acceptable but cash conversion is weak.
Role: You are a CFO advisor focused on cash conversion. Context: I will provide DSO, DPO, inventory days, top overdue accounts, vendor terms, and any GST or billing constraints. Task: Identify the 5 biggest working capital release levers, estimate the likely cash impact, and recommend owners plus weekly tracking metrics. Format: Output a ranked action table and a short note on what can move in 30 days versus what needs structural negotiation.
Reducing DSO by 12 days releases more cash than stretching all vendor terms by one week, with less relationship damage.
Force the model to separate timing wins from permanent process fixes. Both matter, but they behave differently.
Narrative & Board Reporting
When to use it: when you need a concise board page that surfaces only the metrics and decisions that matter.
Role: You are an experienced CFO preparing a board one-pager. Context: I will provide the latest KPIs, actual versus plan, cash position, runway, and 3 to 4 major business developments. Task: Turn this into a one-page board summary with headline metrics, key insights, emerging risks, and decisions required from the board or leadership. Format: Return a tight one-page layout in bullet format with a direct, calm tone and no unnecessary jargon.
Cash remains adequate at 10.4 months of runway, but collections slippage in enterprise is now the main pressure point to monitor.
Good board pages do not try to sound comprehensive. They try to sound useful.
When to use it: when the CEO needs a short, action-led finance note instead of a dense report.
Role: Act as a finance chief of staff to the CEO. Context: I will give you actuals, forecast changes, cash position, hiring updates, and any open capital decisions. Task: Draft a short CEO update that explains what changed, what it means, and which two to three decisions need attention this week. Format: Return a short memo with headings: headline, why it matters, decisions required.
Headline: plan remains achievable, but only if enterprise collections recover in the next 3 weeks and Q3 hiring is sequenced more tightly.
The CEO usually needs finance compressed into decisions, timing, and risk. Keep the prompt aligned to that.
When to use it: when finance needs one sharp memo to support a budget reset, capital request, or resource reallocation.
Role: You are preparing a finance decision memo for senior leadership. Context: I will provide the situation, the capital requested or forecast change proposed, expected return, risks, and alternatives considered. Task: Write a decision memo that states the ask, business rationale, financial impact, downside case, and recommendation. Format: Use a simple structure with sections: decision required, business case, financial case, risks, recommendation.
Recommendation: approve the collections automation spend now, defer the expansion pod by one quarter, and revisit after DSO improvement is visible.
A good memo makes the downside case explicit. Otherwise the recommendation sounds less disciplined than it is.
Workflow Automation Ideas
When to use it: when month-end feels heavy but nobody has mapped where the actual delay and rework live.
Role: You are a finance operations designer. Context: I will share the month-end close calendar, handoffs, owners, recurring delays, and manual tasks. Task: Identify the biggest bottlenecks, which steps are candidates for automation, and where control risk means the task should stay manual. Format: Return a process map table with columns for step, pain point, automation potential, control risk, and recommendation.
Variance commentary prep is a strong automation candidate because it is repeatable, source-based, and reviewer-controlled.
Do not start by asking where AI can help. Start by asking where rework keeps appearing.
When to use it: when a use case looks promising but you need a control design before the pilot expands.
Role: You are a finance governance and controls advisor. Context: I will describe a proposed AI workflow, the source data used, the output created, and who will consume it. Task: Design the minimum controls required so the workflow can run safely inside finance. Cover data inputs, reviewer responsibility, version control, exception handling, and audit trail. Format: Return a control checklist plus a simple operating policy for the team.
Require locked source files, named reviewer sign-off, stored prompt versions, and exception logging before output reaches management.
The most useful AI workflows often need boring controls. That is not a flaw. That is what makes them scalable.
When to use it: when you want AI to flag weird patterns in vendor, customer, or GL data before close review.
Role: Act as a finance data quality analyst. Context: I will provide exported transaction or master data with vendor names, GL codes, departments, dates, and amounts. Task: Flag unusual duplicates, missing fields, coding inconsistencies, and transactions that deserve human review before close. Format: Return a prioritized exception list with reason codes and a suggested reviewer for each exception group.
Eight vendors appear under variant spellings across two departments, creating spend fragmentation and approval noise.
This works best as a pre-review screen, not as the final judgment on what is wrong.
Board & Leadership One-Pagers
These templates are built for busy leadership teams. They cut reporting clutter and force the finance message into metrics, insights, and decisions.
01
A single-page leadership snapshot with six core metrics and a short insights block. Useful for monthly reviews, founder updates, or lender communication when you want clarity without a 30-page pack.
| Metric | Actual | Plan | Signal |
|---|---|---|---|
| Revenue | INR 9.8 Cr | INR 10.4 Cr | Down on enterprise timing |
| Gross margin | 63% | 61% | Better due to mix and FX |
| Net burn | INR 1.7 Cr | INR 1.5 Cr | High due to cloud and hiring |
| Cash runway | 10.4 months | 11.1 months | Watch collections |
Insight 1: Commercial demand is intact, but enterprise closure timing weakened March output.
Insight 2: Margin quality improved, which gives room to protect customer success capacity.
Insight 3: Cash discipline needs tighter collections follow-through before Q3 hiring expands.
02
Use this for capital requests, forecast resets, or a funding decision that needs a clean record of the ask, the economics, and the downside case.
Decision required: Approve or defer the INR 75 L collections automation build.
Business case: Reduce DSO by 10-12 days and free collections team capacity.
Financial case: Estimated payback in 7 months with INR 1.2 Cr cash release potential.
Downside: Implementation drag for 6 weeks; success depends on sales and finance adoption.
Recommendation: Approve now, phase the rollout, and review results after 8 weeks.
How to Use These Tools
These tools are designed to expose the actual bottleneck, not create a new layer of finance theatre. Most teams get immediate clarity from the first forecast rebuild or variance deep-dive. The real value comes from naming owners, fixing cadence, and simplifying the path from numbers to decisions.
Pick the issue slowing judgment right now: runway, budget confidence, spend drift, or capital prioritization.
Use a small number of visible assumptions that leaders can challenge and finance can own.
Prompts save time when the task is repeatable and the sign-off path is named in advance.
If the output does not change weekly or monthly behavior, the tool is still only half-built.
If you want us to help
Book a focused strategy call and we will diagnose the highest-leverage gap in 30 minutes. The aim is not to sell complexity. It is to find the smallest useful rebuild that improves finance judgment fast.
Ready for More?
The toolkit is deliberately practical. It should give you quick wins, clearer judgment, and a better sense of where the real finance bottleneck sits. When you need a sharper implementation push, we can help with focused workshops, diagnostics, or a full finance systems rebuild.