Wholesale Distributor HQ
Small wholesale distributors and suppliers
For distributors: case stock and best-by dates, POs, routes, invoices and collections.
Wholesale Distributor HQ
Start here: how this workspace runs
Dashboard
From order to delivery
Reorder points and purchasing
Accounts and collections
Sales orders
Delivery dates follow each account's route day. Press Mark delivered when the slip is signed.
| Sales order | Status | Account | Item | Taken by | Cases | Order total (USD) |
|---|---|---|---|---|---|---|
| SO-4100 | Delivered | Abernathy Fine Foods | Rolled oats, 25 lb | Greta Ostrowski | 10 | $280 |
| SO-4103 | Delivered | Okafor Supper Club | Arborio rice, 20 lb | Greta Ostrowski | 6 | $234 |
| SO-4106 | Delivered | Castellanos Unified Schools | Balsamic vinegar, case of 6 | Beatrix Njoroge | 12 | $828 |
| SO-4109 | Delivered | Bronwyn's Bakehouse | Olive oil, 5 liter tin | Greta Ostrowski | 2 | $336 |
| SO-4112 | Delivered | Lowry's Corner Grocery | Strawberry preserves, case of 12 | Beatrix Njoroge | 4 | $248 |
| SO-4115 | Returned | Halvorsen Kitchen | Pasta, penne, 10 lb | Greta Ostrowski | 5 | $120 |
| SO-4118 | Cancelled | Riverbend Senior Living | Maple syrup, case of 12 | Beatrix Njoroge | 3 | $396 |
| SO-4121 | Picking | Larkspur Coffee House | Wildflower honey, case of 12 | Greta Ostrowski | 2 | $168 |
Products
Stock reads Reorder when cases on hand plus cases on order fall to the reorder point.
| Product | Item code | Category | Status | Case pack | Supplier | Cost per case (USD) |
|---|---|---|---|---|---|---|
| Olive oil, 5 liter tin | OIL-EV-5L | 4 x 5 L tins | Olivar Imports | $124 | ||
| Rolled oats, 25 lb | GRN-OAT-25 | 1 x 25 lb bag | Prairie Grain Mills | $17 | ||
| Wildflower honey, case of 12 | SWT-HNY-12 | 12 x 1 lb jars | Copperfield Preserves | $52 | ||
| Strawberry preserves, case of 12 | PRS-STR-12 | 12 x 12 oz jars | Copperfield Preserves | $38 | ||
| Arborio rice, 20 lb | GRN-ARB-20 | 1 x 20 lb bag | Prairie Grain Mills | $24 | ||
| Canned tomatoes, case of 6 | CAN-TOM-6 | 6 x #10 cans | Harborline Foods | $22 | ||
| Pasta, penne, 10 lb | DRY-PEN-10 | 1 x 10 lb bag | Harborline Foods | $14 | ||
| Balsamic vinegar, case of 6 | OIL-BAL-6 | 6 x 500 ml bottles | Olivar Imports | $46 |
Purchase orders
| Purchase order | Supplier | Status | Ordered | Expected at the dock | Received on | Cases |
|---|---|---|---|---|---|---|
| Prairie Grain - arborio and granola | Prairie Grain Mills | Confirmed | Nov 10, 2026 | Nov 22, 2026 | — | 70 |
| Harborline - penne restock | Harborline Foods | Sent | Nov 15, 2026 | Nov 24, 2026 | — | 60 |
| Olivar - autumn container | Olivar Imports | Partly received | Oct 9, 2026 | Nov 13, 2026 | — | 84 |
| Copperfield - maple and honey | Copperfield Preserves | Draft | Nov 18, 2026 | Dec 6, 2026 | — | 60 |
| Harborline - tomatoes | Harborline Foods | Received | Oct 24, 2026 | Nov 2, 2026 | Nov 2, 2026 | 80 |
| Prairie Grain - oats | Prairie Grain Mills | Received | Oct 19, 2026 | Oct 31, 2026 | Oct 30, 2026 | 100 |
Invoices
| Invoice | Account | Deliveries covered | Amount (USD) | Status | Invoiced | Due |
|---|---|---|---|---|---|---|
| INV-30418 | Abernathy Fine Foods | SO-4100 and two earlier deliveries | $1,062 | Paid | Nov 1, 2026 | Dec 1, 2026 |
| INV-30422 | Okafor Supper Club | SO-4103 | $249 | Overdue | Nov 5, 2026 | Nov 16, 2026 |
| INV-30427 | Castellanos Unified Schools | SO-4106, less 2 short cases | $690 | Sent | Nov 8, 2026 | Dec 8, 2026 |
| INV-30431 | Bronwyn's Bakehouse | SO-4109 | $336 | Paid | Nov 11, 2026 | Nov 11, 2026 |
| INV-30436 | Lowry's Corner Grocery | SO-4112 and SO-4148 | $527 | Sent | Nov 13, 2026 | Dec 13, 2026 |
| CN-30437 | Halvorsen Kitchen | SO-4115, torn bags | $120 | Credit note | Nov 12, 2026 | Nov 12, 2026 |
| INV-30440 | Tennant Table | SO-4127 and last week's delivery | $412 | Sent | Nov 15, 2026 | Nov 18, 2026 |
| INV-30395 | Lowry's Corner Grocery | Last month's deliveries | $1,385 | Overdue | Oct 9, 2026 | Nov 8, 2026 |
Accounts
| Account | Type | Buyer | Phone | Customer since | Route day | |
|---|---|---|---|---|---|---|
| Larkspur Coffee House | Kasia Sandoval | kasia.sandoval@inbox-mail.net | (816) 555-0173 | Oct 29, 2026 | ||
| Abernathy Fine Foods | Tobias Abernathy | tobias.abernathy@inbox-mail.net | (816) 555-0110 | Sep 16, 2026 | ||
| Halvorsen Kitchen | Greta Halvorsen | greta.halvorsen@inbox-mail.net | (816) 555-0147 | Aug 4, 2026 | ||
| Prescott Academy dining | Percival Prescott | percival.prescott@inbox-mail.net | (816) 555-0184 | Jun 22, 2026 | ||
| Bronwyn's Bakehouse | Bronwyn Zuberi | bronwyn.zuberi@inbox-mail.net | (816) 555-0121 | May 10, 2026 | ||
| Galloway Market | Idris Galloway | idris.galloway@inbox-mail.net | (816) 555-0158 | Mar 28, 2026 | ||
| Okafor Supper Club | Priyanka Okafor | priyanka.okafor@inbox-mail.net | (816) 555-0195 | Feb 13, 2026 | ||
| Riverbend Senior Living | Hamza Vasquez | hamza.vasquez@inbox-mail.net | (816) 555-0132 | Jan 1, 2026 |
Suppliers
| Supplier | Contact | Phone | Lead time (days) | Terms | Minimum order (USD) | |
|---|---|---|---|---|---|---|
| Prairie Grain Mills | Marisol Thackeray | orders@prairiegrainmills.net | (816) 555-0123 | 12 | $1,500 | |
| Olivar Imports | Teodor Zielinski | teodor@olivarimports.net | (816) 555-0160 | 35 | $4,000 | |
| Copperfield Preserves | Yara Eriksen | yara@copperfieldpreserves.net | (816) 555-0197 | 18 | $1,200 | |
| Harborline Foods | Desmond Jessup | desmond@harborlinefoods.net | (816) 555-0134 | 9 | $800 |
What lives where
An order's path
Who does what
Your rhythm
Making it yours
Replace the sample items and suppliers with your own price list, then your accounts and their route days. Delete the sample orders and invoices once real ones are in. Credit limits and what accounts owe are confidential.
| Sales order | Status | Account | Item | Taken by | Cases | Order total (USD) |
|---|---|---|---|---|---|---|
| SO-4100 | Delivered | Abernathy Fine Foods | Rolled oats, 25 lb | Greta Ostrowski | 10 | $280 |
| SO-4103 | Delivered | Okafor Supper Club | Arborio rice, 20 lb | Greta Ostrowski | 6 | $234 |
| SO-4106 | Delivered | Castellanos Unified Schools | Balsamic vinegar, case of 6 | Beatrix Njoroge | 12 | $828 |
| Invoice | Account | Deliveries covered | Amount (USD) | Status | Invoiced | Due |
|---|---|---|---|---|---|---|
| INV-30418 | Abernathy Fine Foods | SO-4100 and two earlier deliveries | $1,062 | Paid | Nov 1, 2026 | Dec 1, 2026 |
| INV-30422 | Okafor Supper Club | SO-4103 | $249 | Overdue | Nov 5, 2026 | Nov 16, 2026 |
| INV-30427 | Castellanos Unified Schools | SO-4106, less 2 short cases | $690 | Sent | Nov 8, 2026 | Dec 8, 2026 |
| Product | Item code | Category | Status | Case pack | Supplier | Cost per case (USD) |
|---|---|---|---|---|---|---|
| Olive oil, 5 liter tin | OIL-EV-5L | 4 x 5 L tins | Olivar Imports | $124 | ||
| Rolled oats, 25 lb | GRN-OAT-25 | 1 x 25 lb bag | Prairie Grain Mills | $17 | ||
| Wildflower honey, case of 12 | SWT-HNY-12 | 12 x 1 lb jars | Copperfield Preserves | $52 |
| Account | Type | Buyer | Phone | Customer since | Route day | |
|---|---|---|---|---|---|---|
| Larkspur Coffee House | Kasia Sandoval | kasia.sandoval@inbox-mail.net | (816) 555-0173 | Oct 29, 2026 | ||
| Abernathy Fine Foods | Tobias Abernathy | tobias.abernathy@inbox-mail.net | (816) 555-0110 | Sep 16, 2026 | ||
| Halvorsen Kitchen | Greta Halvorsen | greta.halvorsen@inbox-mail.net | (816) 555-0147 | Aug 4, 2026 |
Past-due invoices
| Invoice | Account | Deliveries covered | Amount (USD) | Status | Invoiced | Due |
|---|---|---|---|---|---|---|
| INV-30418 | Abernathy Fine Foods | SO-4100 and two earlier deliveries | $1,062 | Paid | Nov 1, 2026 | Dec 1, 2026 |
| INV-30422 | Okafor Supper Club | SO-4103 | $249 | Overdue | Nov 5, 2026 | Nov 16, 2026 |
| INV-30427 | Castellanos Unified Schools | SO-4106, less 2 short cases | $690 | Sent | Nov 8, 2026 | Dec 8, 2026 |
Items to reorder
| Product | Item code | Category | Status | Case pack | Supplier | Cost per case (USD) |
|---|---|---|---|---|---|---|
| Olive oil, 5 liter tin | OIL-EV-5L | 4 x 5 L tins | Olivar Imports | $124 | ||
| Rolled oats, 25 lb | GRN-OAT-25 | 1 x 25 lb bag | Prairie Grain Mills | $17 | ||
| Wildflower honey, case of 12 | SWT-HNY-12 | 12 x 1 lb jars | Copperfield Preserves | $52 |
Due at the dock in the next 7 days
| Purchase order | Supplier | Status | Ordered | Expected at the dock | Received on | Cases |
|---|---|---|---|---|---|---|
| Prairie Grain - arborio and granola | Prairie Grain Mills | Confirmed | Nov 10, 2026 | Nov 22, 2026 | — | 70 |
| Harborline - penne restock | Harborline Foods | Sent | Nov 15, 2026 | Nov 24, 2026 | — | 60 |
| Olivar - autumn container | Olivar Imports | Partly received | Oct 9, 2026 | Nov 13, 2026 | — | 84 |
Late deliveries
| Sales order | Status | Account | Item | Taken by | Cases | Order total (USD) |
|---|---|---|---|---|---|---|
| SO-4100 | Delivered | Abernathy Fine Foods | Rolled oats, 25 lb | Greta Ostrowski | 10 | $280 |
| SO-4103 | Delivered | Okafor Supper Club | Arborio rice, 20 lb | Greta Ostrowski | 6 | $234 |
| SO-4106 | Delivered | Castellanos Unified Schools | Balsamic vinegar, case of 6 | Beatrix Njoroge | 12 | $828 |
Taking the order
Picking
Loading the truck
Load in reverse stop order: the last stop goes in first. Keep cool items together near the door. Schools and senior living kitchens have the earliest windows, so they are usually first.
At the door
After the route
When something goes wrong
A missed delivery is called in by the driver before the end of the window, then by the order desk with a new time. A wrong item is collected on the next route and credited. Note what happened on the order, so the pattern shows if it happens again.
How the Stock column works
Each item has Cases on hand, Cases on order and a Reorder at number. When on hand plus on order falls to the reorder point, Stock reads Reorder. At zero on hand it reads Out.
Setting a reorder point
Reorder point = cases sold in a normal week x (lead time in weeks) + safety stock. Example: penne sells about 20 cases a week. Harborline takes 9 days (1.3 weeks). 20 x 1.3 = 26, plus 4 cases of safety stock makes 30. Review every reorder point each quarter, and raise them before the holidays and back-to-school.
Writing a purchase order
Receiving at the dock
Best-by dates
Open Best-by in the next 60 days every week. Offer those items to your biggest accounts first, as a deal if needed. Anything inside 14 days is pulled and donated to the food bank, with a note of the cases on the item page.
Freight
Freight is part of what an item costs you. When a purchase order arrives, divide the freight across the cases and check that Cost per case still reflects it. If freight has crept up, your margin has crept down.
Opening an account
Invoicing
Accounts on Net terms get one invoice a week covering every delivery that week; cash-on-delivery accounts pay at the door. Orders under 300 dollars carry a 15 dollar delivery charge. Invoice what was delivered, not what was ordered, and write the sales order numbers in Deliveries covered. The due date follows the account's terms. Any short or damaged cases come off the invoice, or go on a Credit note against the next one.
Each week
The credit check column
Monthly statements
On the first of the month, send every account a statement of open invoices. Many businesses pay from statements, not invoices.
When an account stops paying
After 60 days overdue, the owner calls. Agree a payment plan in writing and move the account to cash on delivery until it is cleared. After 90 days, stop deliveries. It is better to lose an account that will not pay than to keep delivering to it.
What's inside
7 tables · 21 views · 1 form · 2 row actions · 1 agent6 pages
- Wholesale Distributor HQ
- Start here: how this workspace runs
- Dashboard
- From order to delivery
- Reorder points and purchasing
- Accounts and collections
6 tables
- Suppliers2 views · 4 sample rows
- Products2 views · 10 sample rows
- Accounts2 views · 12 sample rows
- Sales orders7 views · 22 sample rows
- Purchase orders4 views · 6 sample rows
- Invoices4 views · 12 sample rows
Questions
- What is included in the Wholesale Distributor HQ template?
- 6 pages (Wholesale Distributor HQ, Start here: how this workspace runs, Dashboard, From order to delivery, Reorder points and purchasing and 1 more) and 6 tables (Suppliers, Products, Accounts, Sales orders, Purchase orders and 1 more), filled with 66 sample rows so every view opens with realistic data.
- Who is the Wholesale Distributor HQ template for?
- Small wholesale distributors and suppliers.
- Is the Wholesale Distributor HQ template free?
- Yes. Sign up free, press Use this template, and a full copy is added to your workspace.
- Can I change the template after I use it?
- Yes. Every page, table, column and view in your copy is yours to rename, edit or delete, and the sample rows can be cleared.
Related workspaces
Boutique Clothing Store HQFor clothing boutiques: sizes and stock, seasonal buys, markdowns, holds, consignment.
Florist ShopDaily orders and deliveries, wedding and event proposals, and the stem cooler.
Independent Bookstore HQFor bookstores: titles and stock, special orders, publisher orders and returns, events.
Online Store Operations HubFor online shops: SKUs and stock, purchase orders, fulfillment, returns, sales by channel.
Print on Demand Shop HQFor print-on-demand shops: designs, listings, print partners, production, reprints.
Subscription Box Business HQFor subscription boxes: monthly editions, subscribers, renewals, failed charges, pauses.