Wholesale Account Tracker Template: See Which Retailers Are Due to Reorder

A free three-tab wholesale account tracker for small brands, with copy-ready Google Sheets and Excel formulas that show each retailer's reorder-due date and status, plus a 15-minute weekly routine.

Chris Gunnels Nov 17, 2026 6 views
Wholesale Account Tracker Template: See Which Retailers Are Due to Reorder

To track wholesale accounts, keep one sheet with a row per account and one with a row per order. Find each account's usual days between orders, add that to its last order date to get a reorder-due date, and give every account a status. Each week, start with whoever is most overdue.

Small brands rarely lose a wholesale account in one dramatic moment. The store just goes quiet. The buyer gets busy, a rep from another brand stops by, the shelf empties, and nobody on your side notices until the next season. A simple account tracker fixes most of that. It shows you who usually orders when, and who has gone past that point.

This guide gives you the full template: the columns, the formulas for Google Sheets or Excel, some example rows, and a 15-minute weekly routine to go with it. If you're new to how a wholesale order moves from PO to invoice to reorder, start with our guide to how a B2B wholesale order works, then come back here.

Why a wholesale account tracker matters for small brands

Big brands have sales reps who visit stores, check shelves, and write the next order. Most small brands don't. That leaves three common gaps:

  • No one notices the timing. A store that ordered every 60 days is now at day 95, and nobody on your side has looked.

  • Account details are scattered. Terms, minimums, the buyer's name, and the last conversation sit in five inboxes and a notebook.

  • Follow-ups depend on memory. "I'll check in after the holidays" turns into never.

A tracker doesn't replace a relationship. It just tells you which relationships need attention this week.

Want this done for you? Ordrly's forecast-based low-stock alerts are live. They email connected retailers when your products are running low and give them a link to reorder. Create a free brand account, or if you're a retailer, join free.

The wholesale account tracker template: three tabs

Keep it to three tabs. More than that, and the sheet stops getting updated.

  1. Accounts: one row per store, with contact, terms, and the reorder math.

  2. Orders: one row per order. Paste in or type every wholesale order as it comes in.

  3. Follow-ups: one row per touchpoint (an email, call, sample, or visit) and what happened.

Tab 1: Accounts columns

Column

Field

What goes in it

A

Account

Store name, written exactly the same way as on the Orders tab

B

Buyer and contact

Buyer name, email, phone

C

Stage

Prospect, Sample sent, First order, Active, Paused, Closed

D

Terms and minimum

For example, "Net 30, $250 reorder minimum"

E

Orders (12 months)

Formula, counted from the Orders tab

F

First order date

Formula

G

Last order date

Formula

H

Usual interval (days)

Formula, or your default for one-order accounts

I

Reorder due

Formula: last order plus interval

J

Days since last order

Formula

K

Status

Formula: On track, Due soon, Due, Overdue, Lapsed

L

Last order value

Formula, or typed in

M

Usual SKUs

The three to five items they always reorder

N

Next action and date

"Email Thursday with spring restock list"

Tab 2: Orders columns

Keep this one plain: Order date (column A), Account (B), PO number (C), Order value (D), SKUs (E), and Order type (F: opening, reorder, prebook, or at-once). If you sell on terms, add Invoice due date and Paid? columns too, so one sheet shows who's due to reorder and who still owes you. Every formula on the Accounts tab reads from here, so the account names have to match exactly.

Tab 3: Follow-ups columns

Date, Account, Channel (email, call, visit, text), What you said or sent, Outcome (ordered, not yet, overstocked, slow seller, switched brands, no reply), and Next step. The Outcome column is where you find out why an account went quiet, and that tells you more than the dates do.

The reorder-due formulas (Google Sheets and Excel)

These formulas go in row 2 of the Accounts tab and copy down. They assume the Orders tab layout above. Set one default interval for accounts with only one order. Use your typical gap across all accounts. If you don't know it yet, start with 90 days and adjust once you have real data.

  • Orders in the last 12 months (E2): =COUNTIFS(Orders!B:B,A2,Orders!A:A,">="&EDATE(TODAY(),-12))

  • First order date (F2): =IF(COUNTIF(Orders!B:B,A2)=0,"",MINIFS(Orders!A:A,Orders!B:B,A2))

  • Last order date (G2): =IF(COUNTIF(Orders!B:B,A2)=0,"",MAXIFS(Orders!A:A,Orders!B:B,A2))

  • Usual interval (H2): =IF(COUNTIF(Orders!B:B,A2)>1,ROUND((G2-F2)/(COUNTIF(Orders!B:B,A2)-1),0),90)

  • Reorder due (I2): =IF(G2="","",G2+H2)

  • Days since last order (J2): =IF(G2="","",TODAY()-G2)

  • Status (K2): =IF(G2="","No orders yet",IF(J2>=2*H2,"Lapsed",IF(J2>=1.5*H2,"Overdue",IF(J2>=H2,"Due",IF(J2>=H2-14,"Due soon","On track")))))

Format columns F, G, and I as dates. MINIFS and MAXIFS work in Google Sheets and in Excel 2019 and later. If you're on an older version of Excel, use a pivot table to get each account's first and last order dates.

Why these status bands? "Due soon" gives you a two-week head start, which is when a helpful nudge works best. The 1.5x and 2x marks for Overdue and Lapsed are starting points, not rules. Our guide to missed wholesale reorders explains how to tune them and what to do once an account is lapsed.

Example rows (made-up sample data)

Here's how it looks with three example accounts. These stores and numbers are made up to show the math. They aren't real customers.

Account (example)

Orders

Last order

Interval

Reorder due

Days since

Status

Sample Shop A

4

Sep 20

45

Nov 4

58

Due

Sample Shop B

2

Jul 1

60

Aug 30

139

Lapsed

Sample Shop C

1

Oct 25

90 (default)

Jan 23

23

On track

Shop A is a few days past due, so a short note with its usual SKUs is the right move. Shop B is lapsed, so it needs a real conversation, not another reminder email. Shop C has only ordered once, and that's the riskiest group. Put a check-in on the calendar now, before it goes quiet.

How to use the tracker: a 15-minute weekly routine

  1. Update orders (5 minutes). Add every wholesale order from the past week to the Orders tab. If your orders already live in a system, export and paste them in.

  2. Sort by status (1 minute). Filter the Accounts tab to Due soon, Due, Overdue, and Lapsed. Sort by days since last order, highest first.

  3. Act on the top five (8 minutes). Send each one something specific: their usual SKUs, what's new, your ordering cutoff, or a question about how the line is selling. Our wholesale reorder email templates give you wording to start from.

  4. Log it (1 minute). Add a row on the Follow-ups tab and set the next action date on the Accounts tab.

Pick the same day every week. A tracker you update every Monday is worth more than a perfect one you open once a quarter.

Common mistakes with wholesale account spreadsheets

  • Names that don't match. "Pine & Co" on one tab and "Pine and Co." on the other breaks every formula. Pick one spelling and use it on every tab.

  • Ignoring seasonality. A ski shop that only orders in August and October isn't lapsed in March. Override the interval by hand, or note the season in column N.

  • Tracking dates but not reasons. If an account says "slow seller" twice, sending more reminders won't help. Something about the product, price, or placement needs to change.

  • Counting prebooks as reorders. A big prebook placed months ahead can make the next gap look huge. Tag order type so you can read the gaps correctly.

  • Only tracking active accounts. Prospects and one-order stores belong on the sheet too. That's where most of the growth is.

When a spreadsheet stops being enough

The sheet works well for a few dozen accounts. It starts to strain when you have more stores, more SKUs, and orders coming in from email, phone, and a portal at the same time. The real limit is simple: dates can tell you an account is due, but they can't tell you what's actually running low on that store's shelf.

That's the part Ordrly handles for brands. Connected retailers order from your live wholesale catalog at their own price, minimums, and brand-set net terms. Ordrly forecasts demand from order history, recommends which SKUs to replenish and how much, and sends retailers forecast-based low-stock alerts with a link to reorder. Those features are live now. For sales made through Ordrly, the next PO is built from what actually sold. If you sell on Shopify, the Reorder Radar app finds reorder opportunities in your Shopify data so you can invite those retailers onto Ordrly. Building POs from third-party sales data (Shopify, POS) is on the roadmap. You can see what's live on the Ordrly features page.

Try it with the accounts already on your sheet. Create your brand account and invite your current retailers. They join free.

FAQ

What should a wholesale account tracker include?

At minimum: account name, buyer contact, terms and minimums, order count, first and last order dates, usual days between orders, a reorder-due date, a status, usual SKUs, and the next action. A separate log of follow-ups and their outcomes makes it far more useful.

How do I calculate when a wholesale account is due to reorder?

Take the days between the account's first and last order, divide by the number of orders minus one, and add that interval to the last order date. For accounts with only one order, use your typical interval across all accounts.

Is a spreadsheet or a CRM better for wholesale accounts?

A spreadsheet is fine for a few dozen accounts and costs nothing. A general CRM handles contacts and tasks well but usually doesn't know your order history or stock. A wholesale ordering platform ties orders, pricing, and reorder timing together in one place.

How often should I review my wholesale accounts?

Once a week works for most small brands. Review "Due soon" accounts before they run out, not after, and look at lapsed accounts at least once a month.

Does Ordrly charge retailers?

No. Retailers join Ordrly free. For brands, the only required fee is the Network Fee, and all software is included in it.

Stop losing wholesale accounts to silence

Start with the template above this week. Add your orders, sort by status, and contact the five most overdue accounts. When you'd rather have reorder timing handled for you, with forecast-based alerts, live stock and pricing, and every account in one place, move those accounts onto Ordrly.