ReferralKnow a company that should run on Procura? Refer it and get rewarded for every signed client.Refer a company, get rewardedDiscover the programmeDiscover
Free Excel templates / ABC Spend Analysis
Free Excel template

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.

Procura
Download

Your country's version.

Each country has its two files: one fully French, one fully English. Direct download, no sign-up.

FRANCE

France

Multi-rate VAT 20/10/5.5/2.1, euro amounts. Currency, decimals and rates editable in the Settings sheet.French ↓English ↓

QUEBEC

Québec and Canada

5% GST and 9.975% QST computed on net, dollar amounts. Currency, decimals and rates editable in the Settings sheet.French ↓English ↓

AFRIQUE

Africa

18% WAEMU VAT, no-decimal FCFA amounts. Currency, decimals and rates editable in the Settings sheet.French ↓English ↓

By e-mail, optional

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.
Contents

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

Print

Portrait, repeated headers

How to use it

Up and running in minutes.

  1. 01

    Export annual net spend by supplier or category from your accounts.

  2. 02

    Paste names and amounts into the Spend sheet, in any order.

  3. 03

    Rank, cumulative share and class compute; the Ranking sheet shows the Pareto-sorted table.

  4. 04

    Focus negotiation on class A, simplify class C (catalogue, consolidation).

FAQ

Your questions, answered.

Yes: direct download, no sign-up or e-mail. Use it freely internally and duplicate it each month or fiscal year. If you prefer, you can also get it by e-mail.
A ranking of suppliers or categories by spend: class A holds the few items making about 80% of spend, class B the next 15%, class C the long tail. It shows where to negotiate first and where to simplify.
The spreadsheet shows its limits: email approvals, re-entry, duplicates. Procura automates the same cycle (requests, POs, AI 3-way matching, taxes, payments) and is usually deployed within a week.

The same cycle, automated.

Procura replaces the spreadsheet as the team grows: online approvals, AI 3-way matching, taxes filed from the books.