You're Tracking 40 Wholesale Customers on Net-30 Terms With a Spreadsheet That Breaks Every Month — Here's the Free AR Aging System That Actually Works

Ryne Bandolik · July 1, 2026 · 10 min read

You know the moment. It's Friday afternoon, you scroll through your bank transactions, and something doesn't add up. A retailer who ordered 24 units of your starter kit six weeks ago still hasn't paid. You check your spreadsheet — the one with columns for Retailer Name, Invoice #, Amount, and Paid? (Y/N). It says "N." No follow-up was sent. No reminder. Just silence. The invoice is now 60 days old and you're starting to wonder if that $1,200 is ever coming back.

This isn't a hypothetical. It's the exact position hundreds of small CPG brands find themselves in when wholesale crosses the 20-retailer threshold. The spreadsheet that worked when you had 8 accounts becomes a liability at 40 — not because you're bad at tracking payments, but because the tool was never designed for this job.

You've probably looked at wholesale management platforms. JOOR, RepSpark, OrderWerks — the demos are slick. But they start at $200-500/month, and when you're only adding 5 more retailers this year, that math doesn't pencil out. Here's what nobody in the platform ecosystem will tell you: you don't need their software yet. You need a better spreadsheet — one purpose-built for AR aging, not a generic "Invoice Tracker" template from Etsy.

Why every generic payment tracker fails at 20+ retailers

The problem isn't the spreadsheet format — it's what most templates leave out. Here's what breaks:

1. The "Paid? Y/N" column is a trap

A binary paid/unpaid flag tells you nothing about urgency. A retailer who's 5 days late is different from one who's 55 days late, but a "Y/N" column treats them identically. By the time you scroll through 40 rows and notice the three "N"s buried among the "Y"s, the oldest one is already approaching 90 days — the point at which collection probability drops below 50%.

2. No aging means no prioritization

AR aging — bucketing receivables into 0-30, 31-60, 61-90, and 90+ day groups — is the single most important feature of any payment tracking system. It tells you who to call first, who gets the firm email, and who needs a "final notice" letter. A generic spreadsheet has no aging logic. You're sorting manually, which means you're acting on the invoices you happen to notice, not the ones that are most urgent.

3. Payment history disappears into the void

When a retailer pays, you mark the invoice as "Y" and... that's it. Three months later, when the same retailer is late again, you can't see that they've been late 4 of the last 6 cycles. A retailer who's habitually 10-15 days late is fundamentally different from one who's late once because their AP person was on vacation — but without a payment log, you can't tell the difference.

4. The follow-up process is manual and inconsistent

You send "just checking in!" emails when you happen to notice a late payment. Sometimes it's day 32, sometimes it's day 67. The language is different each time. Some retailers get friendly reminders. Others get nothing because their N is buried on row 34 of a spreadsheet you only look at when you're wondering why cash is tight this month.

The 4-Tab AR Aging Spreadsheet System (Free, Built in 2 Hours)

Here's the system. It's four Google Sheets tabs, takes about 2 hours to build, and handles 40-75 retailers reliably. When you cross 75 active wholesale accounts, you'll know it's time to evaluate platform options — but until then, this is all you need.

The 20-Minute Friday AR Review Protocol

The spreadsheet is the tool. The protocol is what makes it work. Here's the Friday routine — it takes 20 minutes once you've done it a few times:

1. Open Tab 3 (AR Aging Summary). Look at the aging buckets. If 90+ is above zero, that's your first priority. If 61-90 is growing week-over-week, your follow-up process isn't working.
2. Open Tab 1 (Active Orders). Sort by Days Overdue, descending. Work top to bottom — the oldest overdue invoices first.
3. For each overdue invoice, cross-reference Tab 2 (Payments Received). Did the money come in and you forgot to mark it? It happens. Check your bank before sending a reminder.
4. Send templated emails to the 3-5 retailers who are actually late. Use the templates below. Don't customize — the consistency is the point. Retailers learn that you follow up reliably.
5. Update the Last Follow-Up Date column in Tab 1. This prevents double-emailing and lets you see at a glance who hasn't been contacted.
6. Log any payments received this week in Tab 2. Update Tab 1 statuses. Move paid invoices to a "Paid Invoices" archive tab if you want to keep Tab 1 clean (optional — keep them if you want to track payment velocity).
7. Check DSO. Is it trending up? Down? Flat? This single number tells you whether your collection process is improving or degrading.

Email Templates: The Right Words at the Right Time

These are designed to be copied, pasted, and filled in. No rewriting, no overthinking. The power is in the consistency — retailers learn that day 31 means an email, day 61 means a call, and day 91 means collections.

When to Cut Off a Retailer: The 3-Strike Rule

Not every wholesale relationship is worth saving. Use this framework:

• Strike 1: Payment is 60+ days late. Send the final notice. Document it in the Retailer Directory notes.
• Strike 2: A second payment in the same 12-month period goes 60+ days late. Place the account on prepaid or COD terms — no more net-30 until they demonstrate 6 months of on-time payment.
• Strike 3: A third late payment, or any single invoice that goes 90+ days without communication from the retailer. Cut off future orders. Send to collections for outstanding balances above $500. For smaller amounts, write it off and redirect your energy to retailers who pay on time.

The hardest part of this rule isn't enforcing it — it's accepting that some retailers will leave. But a retailer who doesn't pay you on net-30 isn't a customer. They're an interest-free lender you didn't agree to be.

Integrating With QuickBooks or Xero

The AR spreadsheet and your accounting software don't need to be disconnected. Here's the bridge:

1. Create invoices in QuickBooks/Xero as normal. This is your official record. The spreadsheet is your operational dashboard — faster and more visual than any accounting software's AR module.
2. Export open invoices from QuickBooks to CSV once a week (Reports → Customers & Receivables → Open Invoices → Export). Paste new invoices into Tab 1 of the spreadsheet.
3. When payments come in, record them in QuickBooks first (this is your books of record), then log them in Tab 2 of the spreadsheet.
4. Once a month, reconcile Tab 3's total outstanding against QuickBooks' open AR report. They should match within 1-2 days' timing difference. If they don't, you missed logging a payment or closing an invoice.

This dual-system approach exists because QuickBooks' built-in AR reporting is slow, hard to scan, and doesn't have aging-by-retailer at a glance. The spreadsheet is your Friday operations tool. QuickBooks is your month-end accounting record.

How to Know When You've Outgrown the Spreadsheet

The system works until it doesn't. Here are the triggers that mean it's time to evaluate a wholesale management platform:

• You've crossed 75 active wholesale accounts. At this volume, the 20-minute Friday review becomes 45 minutes, then an hour. The time cost approaches platform pricing.
• You're tracking purchase orders, inventory allocation, AND payments. Three separate spreadsheets that need to reconcile = the spreadsheet architecture is now your bottleneck, not your solution.
• Your retailers are asking for a portal. When 3+ retailers ask "can we check our order status online?", it's time to look at B2B wholesale platforms that include a retailer-facing portal (JOOR, RepSpark, NuORDER).
• Your DSO is trending up despite following the protocol. This means the problem isn't tracking — it's your credit policy or your retailer quality. The spreadsheet can't fix that.

When you hit these triggers, the platform math becomes rational: $300/month for JOOR vs. 4 hours/week of spreadsheet wrangling at $50/hour effective rate = the platform is cheaper. But until you hit these triggers? The spreadsheet is free, it works, and it's already better than what you're doing now.