A blanket purchase order template is a ready-made Excel or Word layout for managing repeat, long-term buying from one trusted supplier under a single PO number. It records the pre-agreed prices, a validity period of up to a year and a not-to-exceed spending ceiling.
A blanket purchase order (BPO), also called a standing order or blanket order, is one approved order number that covers many purchases from the same supplier over an agreed period, usually a year or less. Instead of raising a PO every time you need toner, courier collections or maintenance visits, you fix prices and a spending ceiling once, then call items off as needed.
Procurement teams use it for low-value, high-frequency spend where the items and prices are known but the exact quantities and dates are not. It cuts PO volume, locks in pricing for the term and gives AP one reference number to match every invoice against.
The template captures the agreement on one page and logs each release beneath it, with a running balance against the limit.
Buyer and supplier names, addresses and contacts, the issue date and a unique blanket PO number quoted on every invoice.
Clear start and end dates, often no more than twelve months. Releases dated outside this window are not covered.
The ceiling on the total value of all releases, which keeps departmental spend under control. Going over needs an approved amendment.
Each item or service with its description, pre-agreed unit price and estimated quantity for the term.
Payment terms, a fixed-schedule or draw-down invoicing schedule, release rules and how either side can cancel.
A log of every call-off with its date, value, cumulative spend and remaining balance.
Ready to use in Word, Excel, Google Sheets and PDF. Fill it in, save it, reuse it.
Settle items, unit prices, term and an estimated annual volume with the supplier.
The budget owner approves the not-to-exceed amount once, instead of approving every order.
Send the signed blanket PO to the supplier with the list of people allowed to release orders.
Authorised staff call off items against the BPO. Each release gets its own number and is logged.
Track spend against the limit each month, then close or renew the BPO at expiry.
Start with one page: BPO number, supplier, start and end dates, agreed prices, not-to-exceed amount, plus a release log with a running balance.
Use these tables as the template itself: copy the fields into Word or Excel in this order. The example column shows an illustrative 12-month blanket order from Orbit Analytics to Acme Office Supply for office consumables.
| Field | What to enter | Example |
|---|---|---|
| Blanket PO number | Unique number the supplier quotes on every invoice | BPO-2026-007 |
| Issue date | Date the blanket PO is approved and sent | 28 Sep 2026 |
| Buyer name, address and contact | Your legal name, address and the person managing the BPO | Orbit Analytics Ltd, 4 Canal Street, Priya Shah |
| Supplier name, address and contact | Legal name, address, order contact and your internal vendor number | Acme Office Supply, 12 Mill Road, orders@acme.example, V-0087 |
| Bill-to address | Where invoices go, usually an AP inbox | ap@orbit.example |
| Field | What to enter | Example |
|---|---|---|
| Start and end dates | The validity period, usually twelve months or less; nothing outside it is covered | 01 Oct 2026 to 30 Sep 2027 |
| Not-to-exceed amount | Ceiling on the total of all releases; going over needs an approved amendment | 24,000.00 excluding tax |
| Item | Description | Unit | Agreed price | Est. qty | Est. value |
|---|---|---|---|---|---|
| AOS-PA4 | A4 copier paper, 80gsm | box of 5 reams | 28.00 | 240 | 6,720.00 |
| AOS-TN2 | Toner cartridge, black, high yield | each | 64.00 | 120 | 7,680.00 |
| AOS-CAT | Kitchen and cleaning supplies, catalogue | list less 10% | Varies | 6,000.00 | |
| Estimated spend | 20,400.00 |
Illustrative pricing. The not-to-exceed limit is set at 24,000.00 to allow for higher usage.
| Field | What to enter | Example |
|---|---|---|
| Authorised releasers | Names or roles allowed to call off orders | Office manager, facilities lead |
| Release method | How orders are placed and numbered | Email to orders@acme.example quoting BPO and release no. |
| Delivery terms | Lead time and delivery location | Next working day to 4 Canal Street |
| Payment terms | When each invoice is due | Net 30 from invoice |
| Invoicing schedule | Fixed schedule (set amounts on set dates) or draw-down (one invoice per release) | Draw-down, one invoice per release |
| Price adjustment | Whether prices are fixed or can change, and how | Fixed for the term |
| Commitment | Whether you must buy a minimum quantity | No minimum; estimates are not commitments |
| Cancellation | Notice either side must give to end the BPO, and what happens to open releases | 30 days' written notice; open releases honoured |
Log every call-off. The running balance shows what is left of the limit.
| Release | Date | Description | Amount | Cumulative | Remaining |
|---|---|---|---|---|---|
| REL-01 | 05 Oct 2026 | Paper, toner | 1,840.00 | 1,840.00 | 22,160.00 |
| REL-02 | 02 Nov 2026 | Toner, kitchen supplies | 2,215.50 | 4,055.50 | 19,944.50 |
| REL-03 | 01 Dec 2026 | Paper, cleaning supplies | 1,960.00 | 6,015.50 | 17,984.50 |
| REL-04 | 05 Jan 2027 | Paper, toner, kitchen | 2,402.75 | 8,418.25 | 15,581.75 |
Illustrative releases against a 24,000.00 not-to-exceed limit.
Works in Excel and Google Sheets. On the BPO tab, the end date is in B4 and the not-to-exceed amount in B5.
| Col | Header | Entry or formula | What it does |
|---|---|---|---|
| A | Release no. | Text, e.g. REL-01 | Quoted on the supplier's invoice |
| B | Date | Date | When the call-off was placed |
| C | Description | Text | Items or service called off |
| D | Amount | Currency | Value of this release |
| E | Cumulative | =SUM($D$2:D2) | Total released so far |
| F | Remaining | =BPO!$B$5-E2 | What is left of the limit |
| G | Status | =IF(F2<0, | Flags 80% use and any overrun |
| H | Date check | =IF(B2>BPO!$B$4, | Catches releases after the end date |
Releases are what make a blanket PO quick to use, so keep the form short. The supplier should reject any release that does not quote a valid BPO number, and AP should match each invoice to a release rather than to the blanket PO alone.
Subject: Release [REL-05] against Blanket PO [BPO-2026-007] To: [Acme Office Supply], [orders@acme.example] From: [Name], [Office manager], [Orbit Analytics Ltd] Release date: [DD Mon YYYY] Deliver by: [DD Mon YYYY] to [4 Canal Street, 3rd floor] Items: [AOS-PA4] [A4 copier paper] [10] x [28.00] = [280.00] [AOS-TN2] [Black toner, high yield] [6] x [64.00] = [384.00] Release total: [664.00] excluding tax Prices and terms as agreed in Blanket PO [BPO-2026-007]. Please quote both the BPO and release number on your invoice.
Most blanket POs sit under your standard PO terms or a framework agreement, with a few extra clauses specific to blanket orders. The most important one says that estimated quantities are not a commitment, so you are not liable for volume you never ordered.
Start and end dates, and whether the BPO can be extended.
The maximum value of all releases, and that the supplier must not deliver beyond it.
Estimates are for planning only and are not a commitment to buy.
Prices fixed for the term, or the index and notice period for any change.
Who may release, how releases are placed and numbered, and that unauthorised orders are not covered.
Lead times, delivery points and how goods or services are accepted.
Payment terms, and whether the supplier bills on a fixed schedule or draws down with one invoice per release quoting the BPO and release numbers.
Standards the goods must meet and how faulty items are returned or credited.
Notice to cancel the BPO early, any costs the supplier may recover, and that open releases are honoured.
Which document wins if the BPO, a release and the master terms conflict.
| Invoicing schedule | How it works | Best for |
|---|---|---|
| Fixed schedule | The supplier invoices an agreed amount on agreed dates, such as the first of each month | Planned maintenance, retainers, steady deliveries |
| Draw-down | Each release is invoiced as it is delivered, drawing the balance down toward the limit | Consumables, courier collections, call-outs with varying volume |
Pick one in clause 7 so AP knows what to expect.
2. Not-to-exceed limit The total value of all releases under this Blanket Purchase Order shall not exceed [24,000.00] excluding tax. The Supplier shall not accept a release, or deliver goods or services, that would take the total above this amount without a written amendment signed by [Company name]. 3. Estimated quantities Quantities stated in this Blanket Purchase Order are estimates for planning purposes only. [Company name] is not obliged to order any minimum quantity and is liable only for releases issued in accordance with clause 5.
Illustrative wording. Replace every bracketed entry with your own.
Blanket POs rarely fail on day one; they fail in month nine, when the limit runs out and invoices start arriving with nothing to match against. A monthly check of these formulas gives you a quarter's notice. Read more in the blanket purchase order guide.
| Measure (BPO tab: start B3, end B4, limit B5) | Formula |
|---|---|
| B6 Released to date | =SUM(Releases!D:D) |
| B7 Remaining | =B5-B6 |
| B8 Share of limit used | =B6/B5 |
| B9 Share of term elapsed | =(TODAY()-B3)/(B4-B3) |
| B10 Projected spend at expiry | =B6/(TODAY()-B3)*(B4-B3) |
| B11 Projected date the limit runs out | =B3+B5/(B6/(TODAY()-B3)) |
Illustrative. Spend is slightly ahead of time, so the limit runs out 17 days before expiry unless usage drops.
The test is repetition: if you would otherwise raise the same PO to the same supplier every month, a blanket order saves effort on both sides. If each order is different, use a standard PO; see blanket PO vs standard PO for the choice.
| Purchase | Blanket PO? | Why |
|---|---|---|
| Office and cleaning consumables | Good fit | Same items, frequent orders, stable prices |
| Courier and freight collections | Good fit | Rate card agreed, volume varies week to week |
| Planned maintenance visits | Good fit | Fixed visit rate, dates set through the year |
| New laptop fleet | Poor fit | One large purchase; use a standard PO |
| Consulting project | Avoid | Scope and deliverables need a statement of work |
A blanket PO is only as good as the approval behind it. Spendflo runs intake and approvals first.
See how it worksA single order placed against the blanket PO for the items needed now.
The ceiling on the total value of all releases. Also called the commitment limit.
The dates between which releases are allowed, often 6 or 12 months.
Another name for a blanket order, common in the UK and the public sector.
Invoicing each release as it is delivered, so the balance against the limit falls with every call-off.
Invoicing an agreed amount on agreed dates, whatever is called off between them.
| PO type | Items and prices known | Quantities and dates known | Best for |
|---|---|---|---|
| Standard PO | Yes | Yes | One-off purchases |
| Planned PO | Yes | Yes, scheduled | Regular deliveries on a fixed plan |
| Blanket PO | Yes | No | Repeat buys with varying volume |
| Contract PO | No, terms only | No | Agreeing terms before specific orders |
Add headroom of 10-20% for growth rather than guessing a round number.
List the people or roles who can call off orders, and tell the supplier.
A release number on each invoice makes matching and duplicate checks simple.
Compare limit used with term elapsed, so overruns surface months early.
Release the unused balance from the budget and review the supplier before renewing.
No end date and no limit means no control over what is bought.
One blanket PO per supplier, or invoices cannot be matched reliably.
Say in writing that estimated quantities are not a promise to buy.
Large or unique purchases need their own approval and a standard PO.
Total last year's POs and invoices with the supplier to size the limit and the item list.
Get unit prices fixed for the term in writing, with lead times and payment terms.
Have the budget owner approve the not-to-exceed amount, then send the signed BPO and releaser list.
Record each call-off in the release log the day it is placed, and check the tracker monthly.
Kestrel Data set a 12-month blanket PO with Northwind Logistics for courier collections, with an 18,000.00 limit. By month 6, releases totalled 11,700.00, a pace that would reach 23,400.00 by expiry. The budget owner approved a 6,000.00 amendment in month 7, before the limit was hit. Illustrative figures.
Every part on this page, in Word, Excel, Google Sheets and PDF, with the examples filled in.
List each item with a unit price, or a catalogue discount for long ranges. Add delivery lead times and a returns clause.
Replace items with a rate card: per collection, per hour or per call-out. Ask for timesheets or proof of service with each invoice.
Add the visit schedule and a fixed price per visit. Reactive call-outs go on a separate rate line within the same limit.
Best for the blanket PO you sign and send.
Best for the release log and spend tracker.
Best for the signed copy the supplier keeps.
$3.7B in software spend processed through Spendflo, at 30% average savings.
See your savingsA blanket PO template saves raising the same order every month while keeping prices fixed and spend capped. It only works if every release is logged and the balance is checked before the limit runs out.
Quick answers to what people ask most about the blanket purchase order template.
Fill in the header with both parties and a unique PO number, set the start and end dates, agree unit prices and a not-to-exceed limit, then add payment, invoicing and cancellation terms for the budget owner to approve. Download the template to get the form, release log and terms in one place.
A 12-month order to an office supplier for paper, toner and kitchen supplies at fixed prices, capped at 24,000.00, with staff releasing orders as stock runs low. That illustrative example is filled in on the download so you can see each field in use.
It is one long-term purchase order that covers repeated buys from a single supplier at pre-agreed prices, up to a set limit, over a set period. The download includes the form plus a release log that tracks each call-off against the limit.
The main risks are spend creeping up unnoticed, releases placed by people without authority, prices going stale over a long term and suppliers treating estimates as a commitment. The download limits each one with a not-to-exceed ceiling, a named releaser list, an expiry check and a clause saying estimates are not a promise to buy.
You can download the Excel version from this page, with the blanket PO form, release log and spend tracker on separate tabs. The release log formulas calculate the running balance and flag releases after expiry or above the limit.
Purchase orders
Contracts
Vendor management
Sourcing and RFx
Budgets and business cases
Procurement
Accounts payable
Purchasing
Software buying
Supply chain
Spendflo runs intake, approvals and purchase requests, and issues POs for software renewals, so orders match what was approved. Reporting is coming soon.
Enter your work email and we'll unlock every format.
Didn't start, or need another format? Pick one below.
