consultance.ai
Finance and data

The Tax Desk Pack

The income tax provision, the Pillar Two pull, the K-1 grind, and the restatement check a Big 4 tax desk bills six figures for, on your own numbers, in your own Claude. 13 prompts (9 core plus 4 bonus) build the ASC 740 current and deferred provision and ETR reconciliation, run the Pillar Two GloBE safe-harbor tests and top-up estimate, normalize messy K-1s into one schedule, tie every figure back to the trial balance, and run a hard self-check gate that independently re-derives the ETR and current tax and blocks the memo on any mismatch. Plus a live calculator that shows what your tax desk costs today. The grind a rented busy-season army and the partner advisory line get paid to babysit.

🔥 optional · live interactive tool

Open the Tax Desk Cost Calculator

Browser-based. No signup. Drop in your numbers and see the trade in real time. Opens in a new tab so the prompts stay where you left them.

Rent it forever, or own it once.

The income tax provision, the Pillar Two pull, the K-1 grind, and the restatement check a Big 4 tax desk bills six figures for, on your own numbers, in your own Claude

Step 1

Paste this setup prompt — Claude installs it for you

Easy mode · paste this into Claude

Claude installs it for you, step by step.

Never used Claude before? It is free to start. Open it in a new tab, copy the prompt, paste it in. It asks one question, then walks you through everything.

  1. Step 1
    Open claude.ai ↗

    Sign up free. No card. Takes 30 seconds.

  2. Step 2

    One click. Lands on your clipboard.

  3. Step 3
    Paste + send

    Claude asks what you need + guides you the rest of the way.

Open claude.ai ↗
Tune the prompt for your level (optional)
Preview the prompt (you do not need to read it)
I want to INSTALL the real setup so Claude runs the income tax provision on my actual books, not just a chat demo. Walk me through it step by step, do not skip the install. Treat me like a CFO, controller, or head of tax 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 paths: a private Claude Project for the tax records (recommended) and an optional Excel add-in for the provision, the reconciliation, and the rate math.

## Path 1 (RECOMMENDED) — a private Claude Project for the provision
This is where the trial balance, the entity list, the prior-year provision, and the K-1s live so every prompt reads from one governed place.

Walk me through ONE step at a time, waiting for me to confirm each:

1. **What I need.** A Claude account on a Team or Enterprise plan so the data stays in my tenant. Pin **Opus 4.8**. Nothing to install for this path.
2. **Create the tax desk.** In Claude, create a new **Project** named for the entity group and the period. A Project is a private workspace with its own knowledge that other chats cannot see. Your trial balance, entity list, provision, and K-1s stay in your own tenant.
3. **Load the records.** Drop the trial balance, the legal-entity list, the prior-year provision, any K-1s, and your fiscal-year and revenue facts into the Project knowledge. If you run several groups, keep one Project per group.
4. **Run the vault.** Run prompt 01, pick what you are running (quarterly or annual provision, Pillar Two / GloBE prep, K-1 intake, or the full provision-to-return cycle) and your data source (A) upload (or (D) a governed connector if you pull from your consolidation or tax engine). Run 02 to 09 in order: build the ASC 740 provision, run the Pillar Two top-up, normalize the K-1s, reconcile to source, cross-check jurisdictions, run the self-check, write the CFO memo, and true up to the return.
5. **Gate it.** Treat prompt 07 (the self-check that re-derives the ETR and current tax a second way) as a hard gate. A **GATE: FAILED** blocks the memo until the break is resolved. A named, licensed tax professional reviews and signs the provision and the return; a prompt cannot sign.
6. **Shadow run first.** Run one entity, then one full cycle, alongside your current process and tie out before you trust it or change anyone's scope. See the 90 day rollout in the bundle.

## Path 2 (OPTIONAL) — Claude for Excel add-in for the provision and rate math
If I want the provision, the reconciliation, and the ETR rate reconciliation to live in real formulas:
1. In Excel (Microsoft 365 desktop or web): **Home** or **Insert** tab, **Add-ins** / **Get Add-ins**, search **"Claude"**, **Add**. Tell me where the button is in my version.
2. Sign in to the docked Claude side panel.
3. In vault prompt 01 choose data source (B) Excel add-in. For prompt 02 (provision) and prompt 05 (reconciliation) say "build this into my workbook as real formulas," so the deferred roll-forward, the ETR reconciliation, and the tie-out recompute on live cells.
4. Pin **Opus 4.8** for the provision, the Pillar Two estimate, and the self-check.

## Rules for walking me through this
- One step at a time. Define every term once: Project, knowledge, ASC 740, current vs deferred tax, DTA and DTL, valuation allowance, ETR reconciliation, permanent vs temporary difference, Pillar Two / GloBE, top-up tax, safe harbor, K-1, Section 475(f), transfer pricing, UTP / FIN 48, true-up, `<review_gate>`, `{{TOKEN}}`.
- Do NOT tell me a step is "not possible." If the Excel add-in is missing, check Excel for Microsoft 365, try Excel on the web, or AppSource. For the Project path there is nothing to install.
- Never paste live taxpayer data into a public Claude window outside a Project. Use a Project with your tenant controls; follow IRS safeguarding and your data providers' terms.
- This moves the labor in-house. It does not replace the licensed tax professional who signs the return, the ASC 740 review controls, or your auditor. Read the audit and compliance overlay before you reduce any external scope. A named human signs the provision. Not tax, accounting, or legal advice.

First message: ask me "Path 1 (Claude Project for the tax records, recommended) and do you also want Path 2 (Excel add-in for the provision and rate math)? What are you running first (quarterly provision, annual provision, Pillar Two prep, K-1 intake, or the full cycle), and roughly how many entities and jurisdictions?" Then start step 1.
Step 2

Step 1 installed it. Now run these 13 prompts on your own data.

the vault

The 13 prompts

Tap a prompt to jump to it. Hit copy. Replace the tokens. Paste into Claude Opus 4.7.

where it breaks

Before you connect live data

  • • Run dummy data first. Real client data is not a test bed.
  • • API keys never go in a public repo. Use env vars and a secrets manager.
  • • Add logging, access control, monitoring, and a rollback path before launch.
  • • Read the license. Forking a repo without checking is how lawsuits start.
license note

Credit the original author

Prompt set authored by consultance.ai. Deloitte and the Big 4 are referenced as the standard the pack matches, no affiliation implied. Your tax data stays in your own Claude tenant; we never see it. This produces a first pass and decision-support, not a filed return; a named, licensed tax professional reviews and signs the provision, the GloBE return, and any memo, and ASC 740, SOX 404, and the OECD Pillar Two rules apply. Not tax, accounting, legal, or investment advice.

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

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