Vendor Records Cleanup Checklist: Tidy a Messy Supplier Document Pile in One Pass

The cleanup pass

How to run the one-time vendor cleanup, step by step

Set aside one focused block of time. Work through the pile vendor by vendor rather than file by file, so you make decisions in context. The three core moves are dedupe, rename, and archive dead vendors, in that order, because removing duplicates first means you rename and judge fewer files.

1. 1

   1. Gather the whole pile into one view

   Pull every loose and misfiled vendor document into a single working area first, for example a folder named Vendor-Cleanup-Inbox. Drag in stray files from the top level, from a generic Documents folder, and from any one-off vendor folders. You can only triage what you can see in one place. Do not build a new permanent structure yet; that is a separate job covered by the per-vendor folder template.

2. 2

   2. Find and remove duplicates

   Sort the view by name and by date so identical or near-identical items sit next to each other. A duplicate is the same document: same vendor, same invoice or receipt number, same date, same amount. When you find two copies, keep one clean canonical copy and delete the rest. If two files look alike but differ (an original invoice versus a revised one), keep both and rename them so the difference is obvious. Cash Workspace does not detect duplicates for you, so compare them by eye.

3. 3

   3. Rename survivors to a consistent format

   Give every remaining file a name a human can read at a glance. A reliable pattern is VendorName_DocType_YYYY-MM-DD_Reference, for example UlineShipping_Invoice_2025-03-14_INV-88210. Rename "scan_0042.pdf" to what it actually is. Apply one format across the whole pile so the same vendor always sorts together and searches work. Pick one spelling per vendor and use it everywhere.

4. 4

   4. File each survivor with its vendor

   Move each renamed document to its correct vendor folder or attach it to the right record. If a receipt belongs with an expense record, attach it there. Resolve split vendors now: merge "ABC Supply" and "ABC Supply Co" into one. The goal of this pass is that nothing useful is loose or misfiled anymore.

5. 5

   5. Archive dead vendors

   Identify suppliers you no longer buy from. Create an Archived-Vendors folder and move each dead vendor's complete folder into it, so the records stay retrievable but leave your active list. Do not delete them; you may still need an old invoice for reference. This keeps the suppliers you actually use front and center.

6. 6

   6. Do a final sweep and note the date

   Confirm the Vendor-Cleanup-Inbox is empty, every active vendor folder holds correctly named files, and the Archived-Vendors folder holds the rest. Add a short dated note recording that the cleanup was done and what you decided (for example which vendors you archived), so the next person, or future you, understands the state of the pile.

Example setup

An example layout after the cleanup pass

Here is what a vendor area can look like once you have deduped, renamed, and archived. Active suppliers sit together with clean names; dead vendors are tucked into an archive; the working inbox is empty; and a note records what you did.

How it helps

How Cash Workspace helps with this cleanup

FAQ

Vendor cleanup questions

How is this different from setting up vendor folders from scratch?

This page is about fixing a pile you already have: removing duplicates, renaming inconsistent files, and archiving dead vendors. Building a fresh, empty per-vendor folder structure is a separate task covered by the vendor document folder template. Do this cleanup first if you already have a mess, then clone the template to keep things tidy going forward.

Will Cash Workspace find the duplicates for me?

No. Cash Workspace does not read your documents, extract their contents, or detect duplicates automatically. You find duplicates yourself by sorting the view and comparing vendor, date, reference number, and amount by eye. The workspace gives you the folders, renaming, and archive tools to act on what you decide.

Should I delete dead vendors entirely?

No. Archive them instead. Move a dead vendor's complete folder into an Archived-Vendors area so it leaves your active list but stays retrievable. You may still need an old invoice for reference later, so deleting is usually a mistake.

How often should I run this cleanup?

This is a one-time triage pass for an existing mess, not a routine. Once you have cleaned up and adopted a consistent naming format and folder template, ongoing tidiness comes from filing things correctly as they arrive and from a periodic structure audit, rather than from repeating a full cleanup.