Spend Analysis: How to Run One With Card, AP and ERP Data
Spend analysis is the process of collecting, cleansing, classifying, and analyzing a company's purchasing data to find savings, improve efficiency, and check controls and compliance. It tells you what the company is buying, from whom, and through which channels.
Many mid-size companies skip it because it sounds like a project for a procurement team they don't have. In practice, a useful first analysis takes a few weeks of a finance analyst's time. The hard part is that the data lives in three or four places, and none of them describe the same supplier the same way.
To run one, pull spend from every system that pays suppliers into one table. Clean up the vendor names and group the spend into categories. Then look for where spend is concentrated, where it's duplicated, and where it's escaping your contracts.
Key Takeaways
Spend analysis follows four steps, namely collect, cleanse, classify, and analyze.
The data usually sits in AP and the ERP, the card program, and the travel and expense system. Leaving any one out hides part of the picture.
Card data adds merchant category and, where merchants pass it, line-item detail that AP records often lack.
Vendor name cleanup is the most time-consuming step and the one that changes the results most.
Spend analysis works best as a repeatable process tied to budget and contract cycles, not a one-off project.
What is spend analysis?
Spend analysis is the structured review of what an organization spends with outside suppliers. It's commonly described as four steps:
Collect, pulling spend records from every system that pays a third party
Cleanse, fixing vendor names, removing duplicates, and correcting errors
Classify, grouping each transaction into a spending category
Analyze, looking for savings, risks, and control gaps in the classified data
A finished analysis should tell you which suppliers to consolidate, which categories to put under contract, and where purchases are escaping your procure-to-pay process.
Spend analysis is also different from the metrics it feeds. Spend under management, for example, is a single measure of how much spend runs through approved suppliers and contracts. The analysis is the work that makes measures like that possible.
What is a spend cube?
A spend cube is a way of organizing spend data in three dimensions so you can slice it from any angle. The usual axes are supplier, cost center, and spending category. Each cell holds the price and volume for that combination.
In practice, it's a pivot table with three fields. Choose a category and see which suppliers and departments buy it. Start from a supplier instead, and you see which categories and departments it serves. A department view shows everything that team buys and from whom. Most of the insight in a first analysis comes from rotating the cube this way.
How is spend analysis different from spend management?
Spend analysis looks backward at what was spent. Spend management covers the whole cycle of controlling, approving, paying, and reviewing spending going forward.
They feed each other. Analysis shows where controls are weak, and spend management tools put new controls in place. The next analysis then shows whether they worked.
Where does your spend data actually live?
Your spend data lives in every system that pays a third party. For most mid-size companies, that means AP, the card program, and the travel and expense system. The healthcare supply chain group AHRMM lists the main data sources for spend measurement as the AP system, often an ERP module, and the purchasing card system, plus any voucher, direct-pay, or travel and expense system.
Source | What it contributes | Common gaps |
AP and ERP | Supplier invoices, PO references, GL coding, payment method | Inconsistent vendor names, header-level detail only on many invoices |
Card program | Merchant name, merchant category, date, amount, sometimes line items | Merchant names that differ from legal supplier names |
Travel and expense | Employee-paid costs, trip and project codes | Often a separate system that never reaches the spend file |
Contracts | Negotiated prices and terms | Usually in a folder, not linked to transactions |
Both card and AP feeds matter because both carry real volume. Cards reached 79% of US noncash payments by number in 2024, according to the Federal Reserve Payments Study. Checks haven't disappeared either. US check payments fell to 9.2 billion by number and $24.45 trillion by value in 2024, down 1.8 billion payments and $1.92 trillion from 2021, per the same study. An analysis built only on AP misses card spend, and one built only on cards misses most supplier invoices.
What does card data add that AP data misses?
Card data adds a merchant category code on every transaction and, when the merchant passes it, line-item detail. Merchant category codes give you a first-pass classification for free, since each transaction arrives already tagged as office supplies, software, travel, or hundreds of other types.
Level 2 and Level 3 card data goes further, adding progressively more transaction detail, up to item-level descriptions when the merchant passes them. That detail lets you see what was bought on a card, not just where. It's often richer than an AP invoice entered at the header level.
Travel and expense data is easy to forget and large enough to matter. Global business travel spending was projected to reach a record $1.57 trillion by the end of 2025, according to GBTA's 2025 Business Travel Index Outlook. If employee-paid travel never reaches the spend file, airlines, hotels, and car rental companies look like small suppliers when they may be among your largest.
What gets lost between systems?
Supplier identity is what gets lost most. The same company appears as a vendor record in AP, as a merchant name on the card feed, and as a payee in the expense system, each spelled differently.
Category context gets lost too. AP codes to GL accounts, cards code by merchant category, and expense systems code by expense type. None of those match each other, so the classification step has to map all three into one scheme. Payment method is the third casualty. Unless you keep it, you can't see which suppliers you pay by check that would accept card or ACH. Corpay pays suppliers by virtual card, ACH, or check from one flow, so the payment method stays attached to each supplier.
How do you run a spend analysis step by step?
Run a spend analysis by working through the four steps in order, starting with 12 months of data so seasonal patterns even out. Here's how each step works in practice.
Collect 12 months of payments from AP, card statements, and the expense system into one table with the same columns, including date, supplier, amount, GL account or category, department, and payment method.
Cleanse the supplier names so each real supplier appears once, and remove duplicate records, such as a card charge also submitted on an expense report.
Classify each line into a category, using your own category list or a standard scheme.
Analyze by sorting categories and suppliers by spend, then looking for concentration, fragmentation, off-contract buying, and payment-method patterns.
Here's an illustrative example with round, hypothetical numbers. A company pulls $24 million of annual third-party spend from three systems, covering 1,800 vendor records. After cleansing, those collapse to 1,350 unique suppliers, because many suppliers appeared under two or three names. Classification shows office supplies spread across 14 suppliers, software across 60, and facilities services across 25. The first conversations write themselves. Why 14 office supply vendors, and which software subscriptions overlap?
How do you clean and normalize vendor names?
Clean vendor names by building a mapping table that links every variant to one standard name. Start with the obvious fixes, such as removing "Inc.," "LLC," punctuation, and capitalization differences. Then sort the list alphabetically and group near matches by eye.
Tax IDs and bank details help confirm matches in AP. Card merchant names are harder, because a supplier may process payments under a parent brand or a payment processor's name. When in doubt, leave two records separate and flag them for review rather than merging suppliers that only look alike. Keep the mapping table and reuse it. The second analysis takes a fraction of the time when the mapping already exists.
Which classification scheme should you use?
Use the simplest classification scheme that answers your questions. Many mid-size companies start with 20 to 40 categories of their own, aligned to how budgets and contracts are managed.
A standard scheme helps when you need to compare across entities or with outside benchmarks. The UNSPSC system, for example, uses an eight-digit, four-level code covering segment, family, class, and commodity. Its example code 44121706 identifies wooden pencils. That level of detail is more than most first analyses need, but it's worth knowing the option exists.
What should the first report show?
The first report should show where the money goes and where it's scattered. Keep it to a few views:
Top 20 categories by spend, with supplier count in each
Top 50 suppliers by spend, with payment method
Categories with many suppliers and no contract
Spend by department within the largest categories
The long tail, meaning suppliers below a set annual spend
Each view should end with a question someone can act on, and a name next to it. A chart without a decision attached tends to get filed and forgotten.
What does a first spend analysis usually turn up?
A first spend analysis usually turns up the same handful of issues. How often each appears varies, so treat these as things to look for rather than expected rates.
Duplicate vendor records, which hide true spend per supplier and invite duplicate payments
Off-contract buying, where departments use their own suppliers instead of contracted ones, also known as maverick spend
A long tail of small suppliers that each require onboarding, invoicing, and payment, the territory of tail spend management
Payment-method gaps, such as suppliers paid by check who would accept card or ACH
Vendor master cleanup is also a fraud control. 76% of US organizations experienced attempted or actual payments fraud in 2025, and just 17% use AI to fight it, according to the 2026 AFP Payments Fraud and Control Survey Report. The same survey found 74% of organizations were affected by business email compromise. Duplicate and stale vendor records are exactly what fraudsters impersonate.
Payment-method mix deserves its own view. Electronic payments keep growing, with B2B ACH payments reaching nearly 2.1 billion in the first quarter of 2026, up 9.4% from a year earlier, according to Nacha statistics reported by ABA Banking Journal. Sorting your suppliers by payment method usually shows a group still paid by check that would accept ACH or card, and that group is a quick win for both cost and fraud exposure. Corpay's single-use virtual cards suit that group, with one card number for each approved payment.
What should you act on first?
Act first on findings that are large, easy, and within finance's control. Consolidating a fragmented category where a contract already exists usually qualifies. So does moving check-paid suppliers who accept cards onto a card program, which can also feed rebate optimization on AP spend.
In my experience, the finding that changes behavior fastest is the department-level view of a fragmented category. Showing a department head that their team bought the same thing from six suppliers at six prices does more than any policy memo. Leave sourcing events for later, once the data is trusted and the quick wins are banked. A formal sourcing project on bad data tends to stall when suppliers dispute the volumes, and that costs credibility you'll need for the next round. Getting the vendor master and categories right first makes every later negotiation easier, because both sides start from numbers they accept.
How often should you redo a spend analysis?
Redo a spend analysis on a cadence tied to your planning cycles. That means a full refresh before annual budgeting, a category-level refresh before each major contract renewal, and a light monthly check on the long tail and new suppliers. There's no universal benchmark for frequency, so let your budget and contract calendar set it.
The cost of each refresh falls sharply once data capture is automated. 89% of organizations use at least some AP automation, yet half still push more than 5,000 invoices a month through workflows that are not fully automated, according to PYMNTS Intelligence and WEX. Customers of the AP solutions The Hackett Group assessed averaged a 60% touchless invoice processing rate, according to a November 2025 Hackett release. Touchless invoices arrive coded and structured, which is most of the collection and cleansing work already done.
Who should own the spend analysis?
In a company without a procurement team, finance usually owns the spend analysis, often an FP&A analyst or an AP manager with support from the controller. Finance already holds the AP and card data and the budget relationships needed to act on findings.
Ownership should include the vendor mapping table, the category list, and the refresh calendar. Department heads should review their own slices before results go wider. That review catches misclassified spend early, and it gives the people who control the budgets a stake in the findings.
What makes a spend analysis repeatable?
A spend analysis becomes repeatable when the mapping work is saved and the data arrives in a consistent format. Three habits make that happen:
Keep the vendor mapping table and category rules in one place, with an owner
Add new suppliers to the mapping when they're onboarded, not at analysis time
Track a few accounts payable KPIs monthly, such as spend with approved suppliers, so the full refresh confirms trends instead of discovering them
Card controls also make the next analysis cleaner. Department spend controls and merchant restrictions keep card spend in the categories and budgets you expect, so fewer surprises show up in the data.
How Corpay feeds a cleaner spend analysis
Spend analysis is only as good as the data feeding it. Corpay procure-to-pay captures invoice data with line-item detail, matches invoices to purchase orders and receipts, and syncs the coded result to your ERP. Fully managed AP pays suppliers by virtual card, ACH, or check, so payment method is recorded for every supplier.
Corpay purchasing cards add card transaction data with spending rules by merchant category and amount, and automated GL coding from merchant history. Corpay offers 100+ ERP integrations, with NetSuite and Sage Intacct among them alongside Business Central and Acumatica. Teams see about 40% time saved, and most programs are live in weeks.
Frequently Asked Questions
What is meant by spend analysis?
Spend analysis means collecting, cleansing, classifying, and analyzing purchasing data to understand what a company buys, from whom, and through which channels. The goal is to find savings, reduce risk, and improve controls.
How do you calculate spend analysis?
Spend analysis has no single formula. You build one clean dataset of spend and then measure it, for example total spend by category, supplier count per category, and the share of spend with approved suppliers.
What is an example of spend analysis?
A company combines a year of AP, card, and expense data and normalizes vendor names. It then finds office supplies spread across many suppliers, consolidates to two under contract, and moves small purchases onto purchasing cards.
What is the difference between spend analysis and spend analytics?
The terms are often used interchangeably. Spend analysis usually refers to the process, while spend analytics often refers to the software and dashboards that automate it.
Who offers corporate spend management with built-in spend analysis?
Many card, AP, and procurement providers include spend reporting. When comparing them, check which data sources they cover, how they normalize vendors, which classification they use, and how easily the data refreshes. The guide to spend management platforms covers evaluation criteria.
Switch to Corpay
Discover how making the move to Corpay streamlines payments and strengthens your business.
Talk to an ExpertSmarter payments. Stronger growth. Keep business moving.
Corpay powers payments for 800,000+ businesses worldwide. Let’s build what’s next for yours.