ABC Spend Analysis
Free Excel ABC (Pareto) spend analysis: rank, share, cumulative share and A, B, C class computed from an unsorted list of suppliers or categories, an automatically sorted table and a summary by class.
Your country's version.
Each country has its two files: one fully French, one fully English. Direct download, no sign-up.
Get the template by e-mail, and its updates.
Keep the six files of « ABC Spend Analysis » in your inbox, to find or share them later. The direct download stays free, no sign-up.
- The France, Québec and Africa versions, in French and English.
- If you wish: three e-mails of tips over ten days, once you confirm, then nothing more.
- Your details are never sold, one-click unsubscribe.
What the workbook contains.
Spend
Unsorted list, share, rank, cumulative share, class
Ranking
The same table sorted by decreasing spend
Dashboard
Count, spend and share by class
Settings
Currency, A (80%) and B (95%) thresholds
Instructions
Get started in 3 minutes, cells protected without password
Portrait, repeated headers
Up and running in minutes.
- 01
Export annual net spend by supplier or category from your accounts.
- 02
Paste names and amounts into the Spend sheet, in any order.
- 03
Rank, cumulative share and class compute; the Ranking sheet shows the Pareto-sorted table.
- 04
Focus negotiation on class A, simplify class C (catalogue, consolidation).
Your questions, answered.
In the same category.
The same cycle, automated.
Procura replaces the spreadsheet as the team grows: online approvals, AI 3-way matching, taxes filed from the books.