How is a price list archive different from a supplier quote folder?

A standing price list or rate sheet is the supplier's published pricing that applies to many orders until it's replaced. A quote is a negotiated, one-off offer tied to a specific prospective purchase. This page covers only the standing lists; file per-deal quotes in the supplier quote records folder so the two don't blur together.

Should I keep old price lists after a new one arrives?

Yes. The whole purpose of the archive is to find the pricing that was in force on a past date, so superseded versions are kept, not deleted. Mark the old one Superseded, fill in its effective-to date, and optionally move it to an Archive subfolder so the current sheet stays easy to spot.

Does Cash Workspace read the prices out of the price list?

No. Cash Workspace does not use OCR and does not extract or interpret any numbers from your documents. It stores the file you attach and the version and date fields you type in yourself. Finding a past price means locating the right dated record and opening the file you saved.

Where do I record a mid-quarter surcharge or single-line increase?

Add it as its own dated record in the same supplier's Price Lists folder, and note in the title which base list it amends and its effective-from date. That keeps the "true price in force" complete when the catalog plus an amendment together define the rate.

Can I track minimum order quantities or lead times here too?

Keep those in a separate supplier ordering-terms reference rather than in the pricing archive. This page is scoped to standing pricing documents only, so ordering constraints like MOQ live elsewhere to avoid mixing pricing history with ordering rules.

Cash Workspace

Use the Freelancer template

Vendor & supplier records

Supplier price list archive: keep every rate sheet version on file

Suppliers reissue their price lists constantly: a new catalog every quarter, a mid-year fuel surcharge, an effective-date letter that bumps a whole product line. Months later, when an invoice looks wrong or you need to check what a unit actually cost in March, the price list that was in force then is long gone from your inbox. This page shows how to build a clean archive of suppliers' standing price lists and rate sheets in Cash Workspace, each one stamped with its version and effective date, so the pricing that applied to any past order is always one click away. This is record organization only, not procurement or pricing advice, and Cash Workspace does not read or extract numbers from your documents.

Start a free workspace See the per-vendor folder template

The problem

Why a past price is so hard to find when you need it

A standing price list is a document that quietly governs dozens of orders until it is replaced. The problem is that the replacement rarely announces itself cleanly: a new PDF lands as an email attachment named "PriceList_FINAL_v2.pdf," the old one is still sitting in a download folder, and neither carries an obvious date. When you later need to confirm what the catalog said on a given day, you are guessing which file was live. An effective-dated archive turns that guess into a lookup.

Price lists arrive as undated attachments with names like "2026 pricing.pdf" that overwrite each other in a download folder, so you can't tell which version was active for a March order.
A supplier raises prices mid-quarter by letter or email, but the surcharge notice gets separated from the catalog it amends, so the real "price in force" is split across two documents.
When an invoice price looks off, you have nothing to compare it against because the rate sheet that applied that week was never saved.
Several suppliers send tiered or volume-bracket price grids; without the dated version filed, you can't reconstruct which bracket applied to a past purchase.
Old and current price lists sit in the same folder with no "current" marker, so a buyer pulls a superseded sheet and orders against stale pricing.

Step by step

Build the price list archive, version by version

The goal is a per-supplier home where every standing price list is filed as a dated record, the active version is obvious, and superseded versions stay retrievable rather than deleted. You add each new price list manually as it arrives; Cash Workspace does not sync with supplier portals or pull files automatically.

1
Make one Price Lists folder per supplier
Inside each supplier's folder, create a subfolder named Price Lists (for example, Suppliers / Atlas Packaging Co / Price Lists). Keep it separate from invoices and from per-deal quotes so standing pricing documents don't get mixed with one-off negotiated offers.
2
Create one record per price list version
When a price list arrives, add a record named so the version and date lead: "2026-Q1 Price List (eff. 2026-01-01)". Attach the PDF or spreadsheet the supplier sent. One record holds one version, so the history stays in order.
3
Fill the version and effective-date fields
On each record, record the version label, the effective-from date, and the effective-to date once the next version supersedes it. This closed date range is what lets you answer "which sheet was live on March 14?" without opening every file.
4
Mark the current version and retire the old one
Tag the active sheet "Current" and re-tag the prior one "Superseded" with its effective-to date filled in. Don't delete the old version: a superseded price list is the proof of what a past order should have cost.
5
File mid-cycle surcharge or price-change notices against the version they amend
If a supplier sends a fuel surcharge or a single-line increase between full catalogs, add it as its own dated record in the same folder and note in the title which base list it modifies ("Surcharge 8% (eff. 2026-04-15, amends 2026-Q1 List)").
6
Confirm coverage has no gaps
Periodically scan the records so each effective-from date picks up where the previous effective-to date left off. A gap means a version is missing, and you can re-request it from the supplier before you need it for an order check.

Record structure

Fields to record on each price list version

These are the metadata fields that turn a pile of PDFs into a findable archive. You enter them by hand; Cash Workspace stores and displays them but does not read values out of the attached file.

Supplier name: The supplier the price list belongs to, matching the parent folder, e.g. "Atlas Packaging Co."
Version label: The supplier's own version or edition marker, e.g. "2026-Q1", "Rev C", or "Spring Catalog 2026."
Effective-from date: The date this pricing started to apply, e.g. 2026-01-01. This is the anchor for any past-order lookup.
Effective-to date: The day before the next version took over, filled in when the list is superseded. Left blank while the version is current.
Status: Current or Superseded, so a buyer can see at a glance which sheet to order against today.
Document type: Full price list, rate sheet, tiered/volume grid, or surcharge notice, so amendments are distinguishable from base catalogs.
Received date and channel: When and how the list arrived (e.g. "emailed 2025-12-18"), useful for confirming you have the latest the supplier sent.
Scope note: A short plain-language note on what the list covers, e.g. "corrugated boxes and mailers only; pallets priced separately."

Example setup

An example archive layout

Here is how a small wholesale buyer might organize standing pricing for two suppliers. Folder names are concrete; substitute your own suppliers and version labels.

Suppliers / Atlas Packaging Co / Price Lists

2025-Q4 Price List (eff. 2025-10-01, to 2025-12-31, Superseded); 2026-Q1 Price List (eff. 2026-01-01, Current); Surcharge 8% (eff. 2026-04-15, amends 2026-Q1, Current). Each record holds the supplier's PDF plus version and date fields.

Suppliers / Northvale Textiles / Rate Sheets

Rate Sheet Rev B (eff. 2025-07-01, to 2026-02-28, Superseded); Rate Sheet Rev C (eff. 2026-03-01, Current). Volume-bracket grids attached to each; scope note: "per-meter cotton and linen pricing."

Suppliers / Northvale Textiles / Rate Sheets / Archive

Optional subfolder where Superseded versions are moved once two or three newer versions exist, keeping the main view focused on recent pricing while older sheets stay retrievable for past-order checks.

Suppliers / _Price List Index

An optional cross-supplier record listing each supplier and the effective-from date of their current list, so you can sanity-check at a glance that every active supplier has a current sheet on file.

Common mistakes

Common mistakes to avoid

Overwriting the old PDF with the new one. Replacing the file destroys the very thing you need to check a past order against. File the new version as a new record and mark the old one Superseded instead.
Leaving effective dates blank. A price list with no effective-from date can't answer "what was the price in March," which is the whole point of the archive.
Mixing per-deal quotes into the price list folder. A negotiated one-off quote for a specific purchase is not a standing price list; keep those in the supplier quote records folder so the archive stays a clean record of published pricing.
Storing MOQ and lead-time rules here. Ordering constraints belong in a supplier ordering-terms reference, not in the pricing archive; keeping them separate avoids confusion about what each record governs.
Letting surcharge notices float loose. A mid-cycle increase that isn't tied to the catalog it amends leaves you unsure what the true price in force was.

How it helps

How Cash Workspace helps

Folders and records built for versioning

Create a Price Lists folder per supplier and one record per version, each carrying its own version, effective-from, effective-to, and status fields, so the full pricing history sits in order.

Attach the actual document to the record

Attach the supplier's PDF, spreadsheet, or rate-sheet image directly to its dated record, keeping the source file and its metadata together rather than scattered across email and downloads.

Templates and checklists you can reuse

Set up a price-list record layout once and reuse it for every supplier, so each new version gets filed the same way with the same fields filled in.

Export when you need it elsewhere

Export the price list records and attachments to hand to a buyer, a colleague, or your accountant when a past order's pricing needs to be reviewed. Cash Workspace is free.

Supplier quote records folder

File per-deal negotiated quotes and estimates a supplier sends before a specific purchase, kept separate from standing published price lists.

Supplier minimum order and terms reference

Hold each supplier's ordering constraints, like minimum order quantity and lead time, as reference fields distinct from their pricing documents.

Vendor document folder template

Clone a reusable per-vendor folder skeleton with subfolders for agreements, invoices, statements, and price lists for every supplier you onboard.

Vendor order confirmation folder

File the supplier's returned order acknowledgement so you can match a confirmed order back to the price list version in force at the time.

Business document organization

The wider guide to structuring business documents into folders and records, the hub this supplier-pricing archive fits inside.

Finance organization library

Browse the full library of finance record-organization workflows, from vendor documents to invoices, receipts, and client records.

FAQ

Price list archive questions

How is a price list archive different from a supplier quote folder?: A standing price list or rate sheet is the supplier's published pricing that applies to many orders until it's replaced. A quote is a negotiated, one-off offer tied to a specific prospective purchase. This page covers only the standing lists; file per-deal quotes in the supplier quote records folder so the two don't blur together.
Should I keep old price lists after a new one arrives?: Yes. The whole purpose of the archive is to find the pricing that was in force on a past date, so superseded versions are kept, not deleted. Mark the old one Superseded, fill in its effective-to date, and optionally move it to an Archive subfolder so the current sheet stays easy to spot.
Does Cash Workspace read the prices out of the price list?: No. Cash Workspace does not use OCR and does not extract or interpret any numbers from your documents. It stores the file you attach and the version and date fields you type in yourself. Finding a past price means locating the right dated record and opening the file you saved.
Where do I record a mid-quarter surcharge or single-line increase?: Add it as its own dated record in the same supplier's Price Lists folder, and note in the title which base list it amends and its effective-from date. That keeps the "true price in force" complete when the catalog plus an amendment together define the rate.
Can I track minimum order quantities or lead times here too?: Keep those in a separate supplier ordering-terms reference rather than in the pricing archive. This page is scoped to standing pricing documents only, so ordering constraints like MOQ live elsewhere to avoid mixing pricing history with ordering rules.

Organization only, not procurement or pricing advice

This page describes how to organize suppliers' standing price lists and rate sheets as records. It is organizational guidance, not procurement, pricing, or negotiation advice, and it does not tell you what to pay or whether a price is fair. Cash Workspace stores the documents and the version and effective-date fields you enter; it does not sync with supplier portals, does not read or extract figures from your files, and does not classify documents automatically. You add and label each version yourself.

Start a free price list archive

Set up a Price Lists folder for each supplier, file every version with its effective date, and never lose track of which pricing was in force for a past order. Cash Workspace is free to start. Questions? Reach the team at info@helperg.com.