Template · Finance close · Opening soon

Vendor spend analysis from your bills

See what you spend with every supplier over the last 12 months, its share of the total and how it moved on the year before, refreshed from your accounting system.

Book a demo

You bring

Bills273 rows

SupplierDateAmount

Mammoth does the work

You get

One table13 rows

Each supplier's spend over the last 12 months, its share, and the change on the 12 before.

SupplierCategoryLast 12 monthsPrevious 12 monthsChange %Share %Bills

Not a spreadsheet to fill inIt is a ready-made workflow in Mammoth. You bring the files, and it does the work.
Your files, as they areUpload a file or connect a source. Your column names do not have to match.
Runs again by itselfWhen new data arrives, every step runs again and the result updates.

What you get back

The real result of this template, run on sample data.

Vendor spend analysis: the resultSample data13 rows

Supplier	Category	Last 12 months	Previous 12 months	Change %	Share %	Bills
Office Space Co	Rent	81,828.77	81,102.30	0.9	36.9	12
AWS	Software	68,938.52	51,513.04	33.8	31.1	12
Northern Couriers	Postage	17,324.30	10,859.11	59.5	7.8	12
Peak Software	Software	11,721.75	5,696.43	105.8	5.3	12
British Gas	Utilities	9,055.34	7,318.39	23.7	4.1	12
Lumen Studio	Marketing	7,800	0	·	3.5	1
Clean Team	Facilities	6,720.59	6,290.74	6.8	3	12
PrintWorks	Marketing	4,477.20	8,623.96	-48.1	2	12

13 rows in the result · made from 273 input rows · first 8 shown. Sample data: illustrative figures, not business results.

What is vendor spend analysis?

Vendor spend analysis totals what a business pays each supplier, usually over 12 months, to show where the money goes, which suppliers are growing fastest and where a few suppliers carry most of the spend: the starting point for renegotiating.

How it works

How to use the vendor spend analysis template

1Bring your dataConnect a source, or upload a file.
2Check the columnsMammoth matches each column the template needs and asks only when it is unsure.
3Choose where it goesA table, a sheet, or a dashboard. It rebuilds on every refresh.

See the exact columns and steps ›

What it needs

Supplier bills or payments: supplier, date, amount (and category)

Bills

Supplier
Date
Amount
Category(optional)

The steps it runs

1Match columns
2Spend by supplier, this year and last

Every step is an ordinary Mammoth step you can open and change.

Vendor spend analysis: questions

Can I see spend by category too?

Yes. Point the template at a category or account column and each supplier's spend is split by it.

Does it update by itself?

Yes. The template becomes an ordinary workflow in Mammoth. When your data refreshes, from a connector, a scheduled pull or a new file, every step runs again and the result table updates.

Can I change the steps?

Every step is an ordinary Mammoth step you can open and edit. Mammoth remembers which steps came from the template, so an update never overwrites your changes.

Do my column names have to match?

No. You point the template at your columns once. Mammoth suggests a match for each one and asks only when it is unsure.