Consolidating Multi-Entity Spend at Quarter-End with Claude
Groups with 3+ entities spend hours consolidating their Spendesk data every quarter-end. With the MCP, Claude does it in a single question.
The Problem
Every quarter-end, the same routine plays out: export data from the France entity, then Germany, then the UK. Open three separate Excel files, align the columns, convert currencies at today's rate, and attempt to produce a coherent consolidated view. This typically takes between two and four hours — and half that time is spent just verifying that the totals add up correctly.
The problem isn't the complexity of the data: it's that the data lives across separate Spendesk instances, and aggregation is entirely manual. Any last-minute change — an invoice approved at the wire, a payment pushed back — means partially starting over.
The result: a Q2 consolidation ready on July 8th, based on data frozen as of July 5th. For a CFO who needs to present numbers to the board, that's a permanent risk of discrepancy between reality and reporting.
What the Spendesk MCP Changes with Claude
With the Spendesk MCP, Claude connects directly to all entities configured within your organisation. A single question is enough to get the full consolidated view, with per-category breakdown and built-in currency conversion.
Here is the Q2 2026 spend consolidation (April–June) across your 3 entities:
| Category | France (EUR) | Germany (EUR) | UK (GBP→EUR) | Consolidated Total |
|---|---|---|---|---|
| SaaS / Software | 184,200 € | 96,400 € | 71,300 € | 351,900 € |
| Contractors & Consulting | 112,500 € | 43,800 € | 38,600 € | 194,900 € |
| Cloud Infrastructure | 67,800 € | 51,200 € | 29,100 € | 148,100 € |
| Marketing & Events | 48,300 € | 18,900 € | 14,400 € | 81,600 € |
| General Expenses | 32,100 € | 22,600 € | 17,800 € | 72,500 € |
| Q2 Total | 444,900 € | 232,900 € | 171,200 € | 849,000 € |
GBP/EUR conversion: ECB rate on July 9, 2026 — 1 GBP = 1.175 EUR
Entity breakdown:
Would you like the same table for Q1 to track quarter-on-quarter progression?
Going Further: 2 Additional Use Cases
Identifying which entity is most over budget
At quarter-end, knowing which entity has drifted furthest from its budget is critical for calibrating Q3 forecasts. Claude can pinpoint relative overruns in a single question.
Budget vs Actual Analysis — Q2 2026
| Entity | Q2 Budget | Q2 Actual | Absolute Variance | % Variance |
|---|---|---|---|---|
| France | 420,000 € | 444,900 € | +24,900 € | +5.9% |
| Germany | 210,000 € | 232,900 € | +22,900 € | +10.9% |
| UK | 165,000 € | 171,200 € | +6,200 € | +3.8% |
Would you like a supplier-level breakdown of the Germany overrun?
Negotiating group contracts for shared suppliers
Paying Salesforce or AWS separately across each entity means leaving money on the table. Claude can identify in seconds which suppliers appear across all three entities — prime candidates for a consolidated group contract.
I found 6 suppliers present across all 3 entities over the past 12 months:
| Supplier | France | Germany | UK | Group Total | Negotiation Potential |
|---|---|---|---|---|---|
| Salesforce | 68,400 € | 31,200 € | 24,800 € | 124,400 € | ⭐⭐⭐ High |
| AWS | 42,100 € | 28,600 € | 18,300 € | 89,000 € | ⭐⭐⭐ High |
| Notion Enterprise | 8,400 € | 4,200 € | 3,600 € | 16,200 € | ⭐⭐ Medium |
| Figma | 6,800 € | 3,100 € | 2,900 € | 12,800 € | ⭐⭐ Medium |
| Docusign | 4,200 € | 2,800 € | 1,900 € | 8,900 € | ⭐ Low |
| Zoom | 3,600 € | 2,100 € | 1,800 € | 7,500 € | ⭐ Low |
Would you like me to compile a summary of these contracts with their renewal dates to help plan the negotiations?
Key Takeaways
- The multi-entity consolidation that used to take 2–4 hours now happens in a single question to Claude
- Currency conversion is built in and automatically applies the ECB rate for the day
- Claude surfaces not just totals, but relative overruns across entities
- Suppliers present across all entities are instantly identifiable for group negotiation
- All data comes directly from Spendesk — no exports, no risk of version mismatches
Related skills