HomeLibraryServicesCase studiesBlogAbout
consultance.ai
Book a discovery call →

Services

  • AI consulting
  • AI implementation
  • AI agents
  • Workflow automation
  • RAG systems
  • Voice AI
  • Custom AI development
  • All services

Library

  • AI build library
  • Finance AI automation
  • AiToEarn content agent
  • Fincept Terminal
  • ERPNext
  • SEO + GEO Claude skill
  • Claude for Legal
  • Free Claude Code proxy

Resources

  • Case studies
  • Blog
  • Industries
  • Locations
  • Guide: AI for property management
  • Guide: AI for marketing agencies
  • Guide: AI agents vs Zapier
  • AI glossary
  • vs traditional consulting

Company

  • About
  • Book a call
  • Contact
  • Privacy
  • Terms

© 2026 consultance.ai · AI, implemented.

audit → build → deploy

← Libraryconsultance.ai
Book a build call
Finance and data

Finance Back Office Prompt Pack

10 Claude prompts that draft journal entries, run variance analysis, write the board pack, and model the annual plan. Big 4 rigor for CFOs and controllers, without the $90K analyst seat.

Free — runs in your own ClaudeMedium setup · 4 steps10 ready-to-run prompts
Set it up free — takes 3 minutes ↓Or have us wire it in →
Step 1 · setup
Three minutes, four steps, nothing to install by hand

Claude sets it up for you. You just paste.

Never used Claude? It is free and takes 30 seconds to open. Copy the instruction below, paste it into Claude, and it reads this page and walks you through everything, one question at a time.

  1. 1

    Tell Claude how to talk to you

    One tap. It changes how much Claude explains, and how slowly it goes. You can change it any time.

  2. 2

    Copy your setup instruction

    A short instruction plus a link to this page lands on your clipboard. First copy asks for your email once. That unlocks every button across the whole library.

  3. 3

    Open Claude in a new tab

    Free account, no card, 30 seconds. This tab stays open so you can come back.

    Open claude.ai ↗
  4. 4

    Paste, send, and answer one question

    Claude reads this page, asks one question about your work, then guides you step by step until your first output is right. If anything looks wrong, tell Claude what you see, and it fixes it with you.

▸Prefer the full prompt instead of the link? (optional)
Click to copy
I am comfortable copy-pasting and following instructions, but I am not a developer.
There is nothing to install for this one and no commands to type: it all happens inside Claude. If any instruction below implies a Terminal, translate it into the equivalent click path for me instead.
- Plain English. Define jargon the first time it appears.
- One step at a time, then wait for me to confirm before the next one.
- Tell me what success looks like at each step, and diagnose any error before moving on.

Follow the instructions below with those rules applied.

I want to INSTALL the real setup so Claude runs my back-office finance work on actual data, not just a chat demo. Walk me through it step by step, do not skip the setup. Treat me like a CFO, controller, or founder who has never built a Claude Project or installed an Office add-in, and define every term once.

This is NOT a Terminal or coding install. There is nothing to compile. It is two clicks-and-paste paths. Recommend Path 1 if I want my journal entries, variance table, and plan to live in real Excel formulas; Path 2 if I just want to run the prompts on uploaded exports.

## Path 1 (RECOMMENDED for the close and the plan) — Claude for Excel add-in
This puts Claude inside Excel so the JE register, the variance table, the board KPIs, and the annual plan recompute as real formulas I own.

Walk me through ONE step at a time, waiting for me to confirm each, against the CURRENT Excel UI (labels move, so look, do not guess):

1. **What I need.** Excel for Microsoft 365 (desktop or web) and a Claude account. Claude for Excel is generally available. If my company manages Office and I do not see add-ins, I will check Excel on the web first before assuming it is blocked.
2. **Install the add-in.** In Excel: **Home** or **Insert** tab, then **Add-ins** / **Get Add-ins**, search **"Claude"**, click **Add**. Tell me exactly where the button is in my version and what to click if I do not see "Get Add-ins."
3. **Sign in.** Open the Claude add-in (it docks as a side panel), sign in. Confirm I see the Claude panel inside Excel.
4. **Build the finance workbook.** New workbook named for the period. Tabs: Trial Balance, Journal Entries, Variance, Board Pack, Plan, Exceptions.
5. **Load data.** Paste or import the trial balance and GL detail, export your budget file, and drop any prior board pack or RFP into a Claude Project (see Path 2) for the read.
6. **Run the vault.** Run prompt 01, pick data source (C) Excel add-in. Then prompt 02: "Write the journal entries into my workbook as real formulas, with a check that total debits equal total credits." Run prompt 03 for the variance table, prompt 06 for the plan, and prompt 08 for the tie-out, in formulas, so any mismatch is a cell error to fix, not a guess.
7. Pin **Opus 5** for the journal entries, the plan, the board pack, and the RFP. A named human signs every output.

## Path 2 (QUICK START, no install) — run the prompts in a Claude Project
1. Open Claude, pin **Opus 5**, create a private Project "Finance Ops". Your ledger, plan, comp, and board materials stay in your own tenant.
2. Drop the trial balance, GL detail, budget file, prior board pack, and any RFP into the Project knowledge.
3. Run prompt 01, choose data source (A) upload. Run 02 to 10 in chat. **Important:** because the math is in chat here, prompt 08 (reconciliation self-check) is your guard, run it before any pack ships and fix any FAIL.
4. When you can, move to Path 1 so the JE register, variance, and plan live in real formulas.

## Where to start (the Customer Zero move)
Do not automate everything at once. Run prompt 07 (process teardown) first, let it rank your workflows, pick the ONE highest-return one, and pilot it with prompt 10 (the 30-day scorecard) in parallel with your current process. Prove it on yourself before you trust it anywhere. That is exactly what PwC did as "Customer Zero" before scaling Claude to clients.

## Rules for walking me through this
- One step at a time. Define every term once: add-in, ribbon, side panel, Project, journal entry, variance, accrual, board pack, `<review_gate>`, `{{TOKEN}}`.
- Do NOT tell me a step is "not possible." If the add-in is missing, check: Excel for Microsoft 365 (not old Office), try Excel on the web, or AppSource directly.
- Never paste live comp detail or client PII into a public Claude window. Use a Claude Project with your tenant controls.
- A named human signs the close, the plan, the board pack, and the RFP. Claude does the grind; a person owns the number.

First message: ask me "Path 1 (Claude for Excel add-in, your numbers live in formulas) or Path 2 (no-install, run in a Claude Project)? And are you on Excel desktop or web, company-managed or personal?" Then start step 1.
Step 2 · run it on your data

Step 1 set it up. These 10 prompts do the work.

the vault

The 10 prompts

Grab the whole pack as one file, or tap any prompt below to copy it on its own. Placeholders that look like {{THIS}} get swapped for your own numbers — and if you ran Step 1, Claude fills them in for you.

One .md file · all 10 prompts, numbered, in order · nothing left out.
Click to copy
<role>You are a CFO's office in one: a Controller who has closed 200+ months, an FP and A director who builds the plan and the board pack, and a finance-transformation lead who ran the same playbook as "Customer Zero" before rolling it to a 364,000-person firm. You run finance operations with the rigor of a Big 4 controls review and the speed of an AI-native team.</role>

<onboarding>
Before any work, set up the engagement. Ask me to confirm each block. Offer the options. Do not assume.

1. WHAT ARE WE RUNNING — pick all that apply?
   (A) Journal entries: draft, code, and document support
   (B) Variance analysis: actuals vs budget / forecast / prior
   (C) Management reporting and the board pack
   (D) RFP or proposal response (the work a partner usually writes)
   (E) Annual plan / budget build
   (F) CFO-office runbook: which workflows to put on Claude first and how to scale without headcount

2. WHERE IS YOUR DATA? Pick all that apply. This decides how the next prompts run.
   (A) I will upload exports (trial balance, GL detail, budget file, board deck, prior RFPs) into this Claude project's knowledge.
   (B) I will paste raw rows (ledger lines, P and L, plan assumptions) into the prompt.
   (C) I have the Claude add-in for Microsoft Excel — work directly in my workbook.
   (D) I export from my system (NetSuite, QuickBooks, Xero, SAP, Workday Adaptive, Anaplan) and load the file.
   (E) Mix of the above.

3. CONTEXT — fill what you have:
   Entity / entities: {{ENTITY}}
   Chart of accounts / GL structure: {{GL_STRUCTURE}}
   Reporting period: {{PERIOD}}
   Budget / forecast reference: {{BUDGET_REF}}
   Board pack format: {{BOARD_FORMAT}}
   Sign-off owner (the named human who owns the number): {{SIGNER}}

4. OUTPUT BAR — confirm: every figure traces to a source total, every journal entry balances, every variance over the materiality threshold gets a one-line driver, and every assumption is labeled ASSUMPTION, not stated as fact.
</onboarding>

<rules>
- Never invent a figure, account, or transaction. Work only from my uploaded data or input. If a number is missing, ask or label ASSUMPTION.
- Match every later prompt to the data source I chose in step 2.
- Separate what you computed from what you assumed, always.
- Always end with "Next step:" and the next prompt to run.
</rules>

Confirm my four blocks back to me, then wait for prompt 02.
Click to copy
<role>Staff accountant turning source documents into posting-ready journal entries.</role>

<task>
Using the data source I selected in prompt 01:
1. From the source items (accruals, prepaids, payroll, depreciation, reclasses, intercompany) draft each journal entry: date, account, debit, credit, memo.
2. Code every line to the right GL account from my chart ({{GL_STRUCTURE}}). For recurring entries, note the schedule (monthly, quarterly).
3. For every accrual, state the reversal period. For every prepaid, build the amortization line.
4. Output a JE register: entry ID, description, lines, total debit, total credit, supporting reference.
</task>

<constraints>Use the data source from prompt 01. Every entry must balance (debits = credits). Never post to an account that is not in my chart; flag it instead. Cite the source document for each entry.</constraints>

<review_gate>Show total debits and total credits for the full register and confirm they tie before moving on. Any out-of-balance entry stops the batch.</review_gate>

Then "Next step:".
Click to copy
<role>FP and A analyst explaining the month, not just reporting it.</role>

<task>
From the actuals and the comparison base in my data source:
1. Build the variance table: actual vs {{BUDGET_REF}} and vs prior period, by line and by department, in dollars and percent.
2. Flag every variance above the materiality threshold ({{MATERIALITY}} or default 5% and $10K).
3. For each flagged variance, write a one-line driver tied to a real number (volume, rate, timing, one-off). Separate timing from permanent.
4. Output a one-page variance commentary a CFO reads in two minutes, plus the three movers that need a decision.
</task>

<constraints>Use the data source from prompt 01. Every percentage ties to a dollar figure and a base total. Never explain a variance you cannot source; mark it "driver unknown, investigate".</constraints>

<review_gate>Confirm the sum of line variances equals total actual minus total base before writing commentary.</review_gate>

Then "Next step:".
Click to copy
<role>Controller writing the monthly board and management pack for the CFO.</role>

<task>
Synthesize the close into a reporting pack in my format ({{BOARD_FORMAT}}):
1. P and L, balance sheet, and cash summary with prior-period and budget columns.
2. The KPI page: the 6 to 8 metrics this business actually runs on, each with trend and target.
3. The variance narrative from prompt 03, tightened to board length.
4. A risk and watch-list block: what could move next period and the dollar exposure.
5. A three-line CFO summary: where we landed, what is at risk, what needs a board decision.
</task>

<constraints>Use the data source from prompt 01. Every figure traces to the close or the source data. No metric without a definition footnote on first use.</constraints>

<review_gate>List any figure in the pack that does not tie to an earlier prompt or source file, for a human to resolve before the pack goes out.</review_gate>

Then "Next step:".
Click to copy
<role>You are a proposal lead who has won eight-figure engagements. You write the response a partner would, fast.</role>

<task>
From the RFP or brief in my data source ({{RFP_DOC}}):
1. Extract every explicit requirement and every scored evaluation criterion into a compliance matrix (requirement, where we answer it, owner).
2. Draft the win themes: the three reasons we beat the field, each tied to a proof point I can verify.
3. Write the executive summary and the response to each scored section, in our voice, citing only proof I give you.
4. Flag every requirement we cannot meet and propose how to address or caveat it. Build the question list for the buyer where the RFP is ambiguous.
</task>

<constraints>Use only proof points, case references, and figures I provide. Never invent a client, a metric, or a certification. Mark every gap honestly; a fabricated capability loses the deal and the relationship.</constraints>

<review_gate>Show the compliance matrix with any unmet requirement flagged before drafting the full narrative. A named human owns every claim in the response.</review_gate>

Then "Next step:".
Click to copy
<role>FP and A director building the annual operating plan from drivers, not last year plus ten percent.</role>

<task>
From the historicals and assumptions in my data source:
1. Build the revenue plan from drivers (units, price, churn, pipeline conversion), not a flat growth rate. State each driver and its source.
2. Build the cost plan: headcount by function with fully-loaded cost, then non-people opex by category, tied to the revenue plan where variable.
3. Produce the three-statement view (P and L, simple cash, key balance sheet lines) by month for the plan year.
4. Run two scenarios (base and downside) and show the cash runway and the covenant or burn line under each.
</task>

<constraints>Use the data source from prompt 01. Every driver is labeled with its assumption and source. Separate committed cost from discretionary. Never present a single point estimate without the downside beside it.</constraints>

<review_gate>Confirm the plan ties: revenue build totals to the P and L, headcount cost reconciles to the people line, and cash flows from the P and L and balance sheet. List any tie break for a human.</review_gate>

Then "Next step:".
Click to copy
<role>Finance-transformation lead who ran "Customer Zero" inside the firm before rolling it out. You find the workflows worth automating and the ones that are not.</role>

<task>
For the finance workflows I describe ({{WORKFLOW_LIST}}):
1. Map each workflow: trigger, steps, current owner, hours per cycle, cycle frequency, current tooling and cost.
2. Score each on automation fit: volume, rule-clarity, error cost, and how much a human signature is legally required.
3. Rank the workflows by annual hours saved and risk reduced. Name the top three to put on Claude first and why.
4. For each of the top three, write the target operating model: which prompt from this vault runs it, what stays human, and the control that proves it ran correctly.
</task>

<constraints>Be honest about what should NOT be automated (anything needing legal sign-off, judgment under uncertainty, or a regulated attestation stays human-led). Never recommend removing a control to save time.</constraints>

<review_gate>Present the ranked list and the human-stays-in-the-loop control for each before recommending any rollout.</review_gate>

Then "Next step:".
Click to copy
<role>You are a controls reviewer. Your only job is to catch arithmetic and logic errors before they reach the CFO or the board. You trust nothing; you recompute.</role>

<task>
Re-derive the key totals a SECOND way and reconcile against the earlier prompts. Do not copy earlier outputs — recompute, then compare.
1. JE balance: total debits = total credits across every entry from prompt 02. Show both and the delta.
2. Variance tie: sum of line variances (prompt 03) = total actual minus total base. Show both and the delta.
3. Board pack tie: every figure in the pack (prompt 04) traces to the close or source. Confirm none is orphaned.
4. Plan tie: revenue build, headcount cost, and cash (prompt 06) reconcile to the three-statement view. Show the breaks.
5. RFP compliance: every scored requirement (prompt 05) has an answer or an honest gap flag. Confirm none was dropped.
</task>

<output_format>
A RECONCILIATION TABLE: one row per check (1 to 5), columns = check, value A, value B, delta, PASS/FAIL. Then a one-line verdict.
</output_format>

<review_gate>Any FAIL stops the ship. Tell me what to fix; do not produce the final pack with an open FAIL. A FAIL caught here is the whole point — never force a number to balance.</review_gate>

Then "Next step:".
Click to copy
<role>You are the CFO writing the runbook that lets the office absorb more work without hiring. You ran it on yourself first.</role>

<task>
Turn the top workflows from prompt 07 into a standing runbook:
1. For each automated workflow: the cadence, the prompt that runs it, the data input, the human gate, and the control that evidences it ran.
2. The RACI: who runs, who reviews, who signs. Claude does the grind; a named human owns each output.
3. The capacity math: hours freed per month and what the team does with them (close faster, more analysis, fewer temps at quarter-end). Use only my real hour and cost inputs, never invented savings.
4. The exception path: what happens when a self-check FAILs or a number does not tie, and who gets escalated.
</task>

<constraints>Use only my real headcount, hour, and cost figures. Label any projected saving as a projection with its assumption. Never claim a headcount reduction I did not give you.</constraints>

<review_gate>Confirm every automated workflow has a named human gate and a control before the runbook is final. No workflow ships without a sign-off owner.</review_gate>

Then "Next step:".
Click to copy
<role>You are the program owner running the internal pilot before any wider rollout. PwC called this being "Customer Zero": prove it on your own P and L before you trust it anywhere else.</role>

<task>
Design and score a 30-day internal pilot for the top workflow from prompt 07:
1. Define the pilot: the one workflow, the baseline (current hours, current error rate, current cycle time), and the target.
2. Define success and failure criteria up front, in numbers, before the pilot runs. No moving the goalposts.
3. Build the daily/weekly log: what ran, what the self-check caught, what needed a human fix, time taken.
4. At day 30, score it: hours saved, errors caught vs missed, cycle time delta, and a GO / NO-GO / EXTEND verdict with the reason.
</task>

<output_format>
A pilot charter (one page) plus a scorecard table the program owner updates through the 30 days, ending in the GO / NO-GO / EXTEND verdict.
</output_format>

<review_gate>Lock the success and failure criteria with a named owner before day 1. A pilot graded after the fact proves nothing.</review_gate>

Then "Next step:".

Got the prompts. Want them wired into your actual stack? We map that on a free AI audit.

Book the free audit

Rent it forever, or own it once.

10 Claude prompts that draft journal entries, run variance analysis, write the board pack, and model the annual plan

Path A · free

You just did it

The setup rail and every prompt above are free and stay free. The cost is your time, and the risk of wiring it wrong on live data.

Back to the prompts ↑
Path B · done with you

We wire it into your business

We would deliver a private finance-ops workspace: the 10 prompts loaded into your Claude tenant, your chart of accounts and plan format wired in, a trial-balance and budget pipeline, an AI-governance brief (NIST AI RMF, ISO 42001) for your audit committee, and review gates so no untied number reaches your CFO or board. Done with you, then handed over so you own it.

Book a build call →
data safety

Before you use live numbers

  • • Run last quarter's numbers first. Live data is not a test bed.
  • • Nothing here uploads to us. It runs in your own Claude account, on your own machine.
  • • A named human reviews and signs every output before it reaches a board, lender, or client.
  • • Mask account numbers and names to the minimum the task needs.
the fine print

Straight answers on ownership

Prompt set authored by consultance.ai. PwC and Anthropic are referenced for the publicly announced Customer Zero alliance (14 May 2026); no affiliation or endorsement implied. Your finance data stays in your own Claude tenant; we never see it. A named human signs the close, the plan, the board pack, and the proposal.

Want this running in your business, not just your laptop? We build it and hand you the keys.

Book a build callBack to the library

Want this wired into your stack instead of running it yourself? That is our AI deal desk and finance automation service.

the newsletter

AI news worth opening.

The AI tools, launches, and shifts that actually matter, in plain English. New library drops the moment they land.

100% freeNo paywall, everUnsubscribe anytime

More like this

Other builds worth a weekend

All repos →
Finance and data

Free Portfolio Quant Research Desk

For family offices and serious individual investors: run a portfolio backtest, tax loss harvesting, and model risk checks on your own holdings, locally, in your own Claude. Replaces the $250k quant seat you would otherwise hire.

Setup guide →
Finance and data

Private Equity Deal Sourcing Playbook

For lower and mid market private equity origination teams: turn one mandate into a ranked, owner verified proprietary deal flow pipeline. Six Claude agents with Exa and Scrapling replace a rented deal sourcing subscription.

Setup guide →
Finance and data

Free Jira Alternative for Deal Teams

For PE deal teams and IC members still tracking a live process on a sprint board: a self hosted deal tracker your Claude can write to, plus 10 prompts that move a workstream only when the document actually lands.

Setup guide →
Get the free kitBook a call

Forward this to whoever owns the workflow.

The person drowning in this every week is the one who'll actually want it.

Forward by email
in one line

What is Finance Back Office Prompt Pack?

Finance Back Office Prompt Pack is a finance and data build in the consultance.ai AI Build Library. 10 Claude prompts that draft journal entries, run variance analysis, write the board pack, and model the annual plan. Big 4 rigor for CFOs and controllers, without the $90K analyst seat. It fits CFOs, controllers, and finance leaders at $5M to $500M who want journal entries, variance, the board pack, the annual plan, and proposal work run with Big 4 rigor on their own ledger, without the seat or the consultant. Setup difficulty is Medium, with 4 plain-English steps.

What does Finance Back Office Prompt Pack do?

10 Claude prompts that draft journal entries, run variance analysis, write the board pack, and model the annual plan. Big 4 rigor for CFOs and controllers, without the $90K analyst seat.

Who is Finance Back Office Prompt Pack for?

It fits CFOs, controllers, and finance leaders at $5M to $500M who want journal entries, variance, the board pack, the annual plan, and proposal work run with Big 4 rigor on their own ledger, without the seat or the consultant.

How hard is Finance Back Office Prompt Pack to set up?

Medium to set up — one guided setup instruction covering 4 plain-English steps, plus 10 ready-to-run prompts on the resource page.

How would consultance.ai build this out?

We would deliver a private finance-ops workspace: the 10 prompts loaded into your Claude tenant, your chart of accounts and plan format wired in, a trial-balance and budget pipeline, an AI-governance brief (NIST AI RMF, ISO 42001) for your audit committee, and review gates so no untied number reaches your CFO or board. Done with you, then handed over so you own it.

What are the licensing terms?

Prompt set authored by consultance.ai. PwC and Anthropic are referenced for the publicly announced Customer Zero alliance (14 May 2026); no affiliation or endorsement implied. Your finance data stays in your own Claude tenant; we never see it. A named human signs the close, the plan, the board pack, and the proposal.

Want this built into your workflow?

Finance Back Office Prompt Pack is the starting point. On a free AI audit we map where it fits your stack and what consultance.ai would build around it.

This build comes from our AI consulting and AI implementation practice — see the full AI in finance guide and how we work with CFO teams.

Book your free AI audit