Sintra AI
Home
Live Feed
Automation Hub
Prompt Library256
AI News554
Weekly Digest
Topic Hubs
AI History
AI Labs
Research
Learning Paths
Guides
Resources
Concepts
Videos
AI Tools74
Models
Claude
Google AI
Cost Calc
Back to Sintra/Finance & FP&A
advanced·Finance & FP&A·3-4 hours

Chart of Accounts Rationalisation & Mapping

A complete legacy-to-target CoA mapping table with confidence ratings, a dormant/duplicate kill list, and a short human-decision queue with precise questions.

⬡
Recommended modelClaude Sonnet 4.6

Long context for multi-document FP&A analysis

What you need to fill in

[current count][paste][e.g., max 400 accounts, IFRS statement mapping, no company-specific accounts]

Tools used

ClaudeExcel

The prompt

"We are rationalising our chart of accounts from [current count] accounts to a leaner group CoA, and mapping legacy accounts to the new structure. Here is the current CoA with account, description, last-12-month activity (count and value): [paste] Target structure principles: [e.g., max 400 accounts, IFRS statement mapping, no company-specific accounts] Please: 1. Flag dormant accounts (no postings in 12 months) and near-duplicate accounts by description 2. Propose the target account for every legacy account with a confidence rating 3. List accounts that need a human decision (mixed usage, P&L/BS ambiguity) with the specific question to resolve 4. Output the mapping as a two-column table ready for the migration load file"
Open in Claude

Sample output

**Kill list:** 214 dormant accounts (no postings ≥12m) · 38 near-duplicates (e.g., 60110 'Travel - Air' / 60111 'Airfare'). | Legacy | Description | Target | Confidence | |---|---|---|---| | 60110 | Travel - Air | 6410 Travel | High | | 60111 | Airfare | 6410 Travel | High | | 71200 | Consulting - Mixed | ? | **Decision needed** | **Decision queue:** 71200 has 60% opex consulting, 40% capitalisable project spend — split into 6520/1810, or keep single with project-code discipline? Ask group accounting policy owner.

Try with these tools

claudechatgptclaude code
financechart-of-accountsmaster-dataerp-migration

More in Finance & FP&A

Headcount & Workforce Cost Planning Model

A driver-based headcount plan: FTE roster logic, fully-loaded cost, hiring ramp, and scenario toggles.

advanced

CAPEX Investment Appraisal Builder (NPV / IRR / Payback)

A complete capex appraisal: cash-flow layout, NPV/IRR/payback with formulas, and a decision memo.

intermediate

Gross Margin Bridge & Price-Volume-Mix Analysis

A period-over-period margin bridge decomposed into price, volume, mix, cost, and FX effects.

advanced