● SALE  60% off every template in the Etsy shop, for a limited time Pinterest Instagram Threads Facebook TikTok Tumblr
Shop on Etsy
Home›Bookkeeping & Business Finance›Small Business Vendor Tracker
Small Business Vendor Tracker hero image showing the supplier tracker workbook
BOOKKEEPING & BUSINESS FINANCE

Small Business Vendor Tracker

Suppliers in old emails, orders in a notebook and payments in your head is a system that leaks money. This small business vendor tracker puts all three in one workbook, so you always know who delivers on time and who still needs chasing.

$3.00$7.5060% OFF

Sale price in our Etsy shop right now. Checkout, payment and instant delivery are handled by Etsy.

Instant DownloadExcel + Google SheetsPDF Guide Included

Know who to reorder from, and who to chase

The routine is simple enough to keep up. Add each supplier once to the Vendor Directory, with their category, contact person, email, phone, payment terms and usual lead time. From then on you log each purchase order as you place it, record the delivery when it lands and mark the payment when you pay. Order totals multiply quantity by unit price for you, and amounts due subtract what you have paid, so no figure depends on your memory.

Two tabs turn those everyday entries into decisions. Vendor Performance works out each supplier's on-time rate from your real deliveries, alongside totals ordered, totals paid and amounts still due, vendor by vendor. Spending by Vendor then shows each supplier's share of your total spending, which is exactly what you want in front of you before negotiating terms or lining up a backup supplier for something critical.

The Payments tab keeps part payments honest, updating each order to Paid, Partial or Unpaid with the balance visible at a glance, while the Deliveries tab compares promised and actual dates for you. Blank rows show 0 rather than errors, so a half finished tracker still reads cleanly. The EXAMPLE file is filled with ten orders across eight vendors, including late deliveries and part payments, and a five minute weekly review of the performance tabs is the whole upkeep routine.

Inside the workbook: 8 tabs

What you receive

  • Google Sheets Access PDF with a one-click link that copies the tracker into your own account
  • BLANK Excel workbook, clean and ready for your own suppliers
  • EXAMPLE Excel workbook filled with ten orders across eight vendors
  • Quick Start Guide PDF with setup in about 5 minutes and a weekly routine
  • Separate files, no ZIP to unpack

Good to know

  • Runs in Microsoft Excel, and in Google Sheets with a free Google account
  • No extra software and no subscription: Excel or Sheets is all you need
  • Spell a vendor name the same way on every tab so totals line up
  • A record-keeping tool only: it does not place orders or send payments for you
  • Questions after purchase? Message us on Etsy and we will help you get set up

Questions about this template

The things buyers ask us most.

How does the on-time rate get calculated?

The Deliveries tab compares each delivery's promised date with its actual date and marks it on time or late for you. The Vendor Performance tab then divides on-time deliveries by total deliveries for each supplier, giving a rate based on your real history rather than impressions. It is the quickest way to see who keeps you waiting.

What if I have more than eight vendors?

Eight is just the size of the EXAMPLE file, not a limit on your business. Add a row to the Vendor Directory, and to the first column of the Vendor Performance and Spending by Vendor tabs using the same formulas, and the new supplier is tracked exactly like the others, with their own totals, due amounts and on-time rate.

Can I change the categories and payment terms?

Yes. Categories, payment terms and status lists all live on the Settings and Lists tab. Edit those lists and then reuse the same words across the other tabs, and dropdowns stay consistent throughout the workbook. Keeping the wording identical, especially vendor names, is the one simple rule that keeps every total accurate.

Does it handle part payments?

It does, and that is one of its main jobs. On the Payments tab you record what you ordered and what you have paid so far, the amount still due is calculated for you, and the status updates itself to Paid, Partial or Unpaid. No more guessing which orders are settled and which still have a balance hanging over them.

More in Bookkeeping & Business Finance

All templates in this category →

Three more workbooks from the same shelf.

Accounts Payable Tracker

Track vendor bills and due dates, with a pay run check against the cash you actually have.

$7.50 $3.00
View on Etsy
Sales Commission Tracker by Rep

Commission worked out per sale, with rep totals, payouts due and monthly goals.

$7.50 $3.00
View on Etsy
Receipt and Mileage Expense Tracker Excel Spreadsheet

Receipts and business mileage in one workbook, with one combined total for tax time.

$7.50 $3.00
View on Etsy
View on Etsy · $3.00