Wholesale Distributor Bookkeeping: Freight-In, Vendor Rebates, and Consignment Inventory

Your warehouse is full, your trucks are rolling, and last month's sales were the best yet. Then your accountant sends the draft financials: gross margin is down three points, inventory is up $80,000 for no obvious reason, and your line of credit is bumping against its limit even though the profit and loss says you made money.

If you run a wholesale distribution business, that disconnect is not a mystery — it is a bookkeeping classification problem. When 40 to 60 percent of your balance sheet is inventory sitting on racks and pallets, three innocent-looking decisions determine whether your books tell the truth: how you handle freight-in, how you book vendor rebates, and whether you know whose inventory is actually on your floor.

Get those three right and your monthly close answers the questions that matter: which product lines really make money, how much cash is actually tied up in stock, and what you can borrow against with confidence. Get them wrong and every report lies — margin looks random month to month, inventory is overstated or understated, and your lender stops trusting your balance sheet.

This guide walks through the three fault lines that quietly erode distributor profitability, with practical journal logic and a month-end checklist you can run even if you are not an accountant.

Why Wholesale Bookkeeping Breaks Generic Templates​

Most small-business bookkeeping assumes inventory is a side note. A retailer might carry 15 to 25 percent of assets in stock. A service business carries almost none.

A wholesale distributor is different:

• Inventory is the business. Industry surveys consistently show distributors hold 40 to 60 percent of total assets in inventory. A $2 million distributor routinely has $800,000 to $1.2 million in the warehouse. A 5 percent miscount swings net worth by $40,000 to $60,000.
• You buy on credit, sell on credit, and pay freight both ways. Purchase orders, vendor bills with freight separately stated, customer invoices with payment terms of 30 to 60 days, and freight-out to the customer all hit different accounts in the same week.
• Margin lives in the details. Freight-in that should be in inventory cost gets expensed. A 4 percent vendor volume rebate gets booked as "other income" instead of a reduction of cost of goods sold. Consigned goods you do not own sit on your balance sheet, inflating collateral.
• Lenders look at the balance sheet first. Your asset-based line of credit is collateralized by receivables and inventory. If inventory is misvalued by mishandling freight or rebates, your borrowing base certificate is wrong — and your bank will notice before you do.

Generic chart-of-accounts templates that put all freight into "Shipping Expense" and all vendor incentives into "Income" will make a distributor's books unusable within two quarters. You need three deliberate splits from day one.

1. Freight-In and Landed Cost: The Expense That Belongs in Inventory​

What freight-in actually is​

Freight-in is the cost to get purchased goods to your warehouse and ready for sale: inbound trucking, ocean or air freight, drayage, customs duties, brokerage, and insurance on the shipment. It is not freight-out, which is the cost to ship sold goods to your customer after the sale.

Accounting rules are clear: freight-in is part of inventory cost, not a period expense. Under generally accepted accounting principles, inventory is valued at cost, and cost includes all expenditures necessary to bring the goods to their existing condition and location. When you expense freight-in immediately, you understate inventory on the balance sheet and overstate cost of goods sold in the month the shipment arrives — even though you have not sold those goods yet.

A common real-world scale: a distributor paying $12,000 to $18,000 per month in inbound freight while expensing it will see gross margin swing 2 to 4 points simply because a container arrived on the 31st instead of the 1st.

The landed cost mindset​

Landed cost is the fully loaded per-unit cost after freight, duty, and handling are allocated to each SKU. Without it, you cannot know true product margin.

Simple landed cost allocation:

1. Start with purchase price per unit from the vendor invoice.
2. Add allocable freight, duty, and insurance for that shipment.
3. Allocate those add-on costs to units by a consistent driver — weight, cost, cube, or quantity. Weight works well for heavy goods; cost works when freight is roughly proportional to value; units works for uniform cartons.
4. The resulting per-unit landed cost is what hits inventory and, later, cost of goods sold when the unit sells.

Example: You buy 1,000 units at $20 each ($20,000). Inbound freight is $2,000 and duty is $600. Total landed cost is $22,600, or $22.60 per unit — not $20.00. If you sell 400 units that month, cost of goods sold should be $9,040 (400 × $22.60), and inventory should remain at $13,560 (600 × $22.60). Expensing the $2,600 immediately would have shown $8,000 in COGS plus a separate $2,600 expense, understating inventory by $1,560 and overstating expenses by the same amount in that month.

How to book it without losing track​

You have two practical approaches:

A. Direct capitalization per purchase order. This is preferred when freight is invoiced on the same bill as goods or can be matched to a single PO. Allocate freight to the SKUs on that receipt and post inventory at landed cost.

Dr Inventory — Widget A     \$22,600
  Cr Accounts Payable — Vendor         \$20,000
  Cr Accounts Payable — Freight Carrier \$2,000
  Cr Accounts Payable — Customs Broker    \$600

B. Freight-in clearing account with monthly allocation. When freight invoices arrive separately or cover multiple POs, post them to a "Freight-In (to be allocated)" account, then allocate to inventory at month end by the same driver you use for landed cost, with a true-up after physical count.

Whichever you choose, do not leave freight-in sitting in "Shipping" or "Freight Expense" at month end. Reconcile the clearing account to zero allocation remaining, and reconcile it to carrier statements. If you use software that supports landed-cost features — QuickBooks Enterprise, Sage 50, NetSuite, or similar — turn that module on; it automates the allocation and keeps the audit trail by receipt.

Practical guardrails:

• Separate accounts: 5001 Cost of Goods Sold, 5005 Freight-In (capitalized to inventory), 5010 Freight-Out (customer shipping). Never co-mingle.
• Keep bills of lading, commercial invoices, and duty receipts attached to the inventory receipt. Auditors and lenders ask for them.
• For foreign suppliers, book duty and brokerage at the same time as freight — they are also inventoriable. Do not expense customs fees.
• If you import regularly, consider a weighted-average landed cost that smooths container-by-container spikes, and disclose the method consistently.

2. Vendor Rebates, Billbacks, and Volume Incentives: A Reduction of Cost, Not Revenue​

If freight-in quietly understates inventory, mishandled vendor rebates quietly overstate it — and make you look more profitable than you are until the rebate check arrives (or does not).

Wholesale economics run on incentives that rarely appear on the purchase invoice:

• Volume or tiered rebates: 2 to 6 percent back if you buy $500,000 or $1 million in a calendar year or quarter.
• Prompt-pay discounts: 2/10 net 30 (2 percent if paid in 10 days) that can be annualized to 36 percent if missed.
• Billbacks: The vendor bills you full price and later credits you when you prove you resold to an approved customer at a contracted price.
• Market development funds (MDF) or co-op: Payments earmarked for advertising or placement.

Every one of these is economically a reduction of purchase price. Under accounting guidance, vendor consideration that is not for a distinct service you provide should reduce cost of goods sold or inventory cost — not be booked as "Other Income" or "Rebate Revenue." Treating a 4 percent volume rebate as income inflates both gross profit and operating income while leaving inventory at gross cost, which overstates assets on a borrowing base.

Accrue monthly, reconcile quarterly​

The matching principle requires you to recognize the rebate benefit in the same period as the related purchases, not when cash arrives six months later. That means monthly accruals.

Set up two accounts: 1305 Rebates Receivable — Vendors (an asset) and 5002 Vendor Rebates (contra-COGS) or a direct reduction to inventory cost for bill-and-hold scenarios. At month end:

1. Calculate earned rebate to date based on purchases to date and tier probability. If you are at $750,000 toward a $1 million 4 percent tier and tracking suggests you will hit it, accrue at 4 percent on current purchases with a documented estimate and a true-up later.
2. Post:

Dr Rebates Receivable — Vendor X     \$1,600
  Cr Cost of Goods Sold (rebate contra)  \$1,600
  (400 units sold this month × \$100 × 4% tier)

For rebates that relate to inventory still on hand, the theoretically correct treatment reduces inventory cost rather than COGS. In practice many distributors apply the rebate rate to cost of goods sold for the period and true up at physical, disclosing the method. The key is consistency — pick one and document it.

When the rebate check or credit memo arrives:

Dr Cash (or Accounts Payable — net against future bill)  \$4,800
  Cr Rebates Receivable — Vendor X                        \$4,800

What to avoid:

• Booking rebates only on cash receipt. This understates margin all year and creates a 3 to 5 point surprise in the quarter the check lands.
• Booking rebates as income above gross profit. Your gross margin then looks 3 points too low and operating income looks inflated — exactly backward from economic reality.
• Forgetting billbacks: track them by customer resale with a simple log — PO number, customer, quantity resold at contract price, billback rate, claim date, and credit-memo number. Untracked billbacks are routinely left uncollected; 1 to 2 percent of sales is common leakage when no one owns the claim.

Monthly close tasks for rebates:

• Run a purchases-by-vendor report, apply each active tier, and post accruals with supporting calculation attached.
• Age the rebates receivable like receivables — follow up on anything expected more than 30 days past quarter end.
• Get each rebate agreement in writing and file it with the vendor record. Verbal "we always give 3 percent" does not survive a personnel change or an audit.

Prompt-pay discounts deserve their own discipline​

Terms of 2/10 net 30 are not a suggestion; they are a 36.7 percent annualized return if you borrow to pay early (360 ÷ 20 days × 2 percent). Book purchases at gross, then record discounts taken as a reduction of cost when you pay:

Dr Accounts Payable     \$10,000
  Cr Cash                          \$9,800
  Cr Cost of Goods Sold (purchase discounts)  \$200

Track discounts lost as a separate line (Discounts Lost) so you can see what you left on the table — and stop leaving it.

3. Consignment Inventory: Whose Stock Is Actually on Your Floor?​

Consignment is the third place distributors misstate inventory, and it is the one lenders care about most. In a consignment arrangement, one party owns goods held by another.

Two directions, two very different bookkeeping answers:

• Consignment in — you hold someone else's goods for sale. You are the consignee. You do not own the goods. They do not belong on your balance sheet at all. You hold them physically, you may have a consignment liability to the consignor when you sell, but you have no inventory asset until you sell and the title transfers.
• Consignment out — your goods sit at a customer's or at a big-box retailer's location. You are the consignor. You still own those goods. They remain your inventory, just at a different location. You should track them as Inventory — On Consignment at Customer X and recognize revenue only when the customer sells through to the end user or notifies you of usage.

The mistake in both directions is the same: counting goods you do not own, or failing to count goods you do own.

Practical controls:

• Physical segregation and system location. Create inventory locations such as Warehouse 1, Consignment In — Vendor A, and Consignment Out — Customer B. Your cycle count sheets should mirror those locations.
• Written consignment agreements. Consignment terms, insurance responsibility, who bears risk of loss, and return rights should be in a signed agreement. Without it, an auditor or bankruptcy trustee will treat the goods as yours — or not yours — in the worst possible way for you.
• Monthly consignment statement reconciliation. For consignment in, reconcile on-hand by SKU to the consignor's statement; for consignment out, request sell-through reports from the customer and reconcile to your shipped-not-yet-sold ledger. Differences get investigated before the borrowing base goes to the bank.
• No revenue on transfer. Moving goods to a consignment location is an inventory transfer, not a sale. Revenue, receivables, and commission are recognized only on proof of end-sale.

A quick diagnostic: run your inventory valuation by location. If Consignment In shows a positive value on your balance sheet, you are overstating assets. If Consignment Out is missing entirely, you are understating them. Both distort your collateral.

4. Valuation Choices That Move Margin 2 to 4 Points​

Freight, rebates, and consignment determine what cost you capitalize. Your cost-flow assumption determines when that cost hits profit and loss as you sell.

Three methods dominate distribution:

• FIFO (first in, first out). Oldest cost moves to COGS first. In rising-cost environments, FIFO keeps COGS lower and inventory higher — margins look better today, and the balance sheet reflects more recent, higher costs.
• Weighted average. All units in inventory share the same average cost after each purchase. This smooths spikes from a single expensive container and is simplest when SKUs are interchangeable commodities.
• Specific identification. You track the actual cost of each serialized unit — appropriate for high-value equipment, not bulk fasteners.

There is no single correct answer for all distributors, but you must be consistent and disclose the choice. Switching from FIFO to weighted average mid-year to manage a margin problem is a comparability and audit problem, not a solution.

Two additional valuation disciplines matter for every distributor:

• Lower of cost or net realizable value. At each reporting date, write down slow-moving, damaged, or obsolete stock to what you can actually realize net of completion and selling costs. Distributors who never write down obsolete inventory carry phantom assets that inflate the borrowing base and defer a loss that is already real.
• Consistent landed-cost driver. If you allocate freight by weight one month and by cost the next because it gives a preferred margin on a hot product line, you have lost comparability. Pick weight, cube, or cost — document it — and live with it.

Run this sensitivity once a year: revalue your top 20 SKUs under both FIFO and weighted average and under gross versus landed cost. If the margin difference exceeds 2 points, your product-line pricing is being set on whichever convention you happened to choose, not on economics.

5. The Monthly Close Checklist That Catches the Three Errors Before the Bank Sees Them​

Wholesale bookkeeping fails slowly, then all at once at the bank audit or year-end count. A 45-minute close routine prevents it.

Before month end:

• Match every inventory receipt to a PO and a vendor bill. Unmatched receipts are the number-one source of phantom inventory.
• Hold freight invoices with no matched receipt in the clearing account — investigate anything older than 15 days.
• Update rebate accrual workpapers by vendor and tier; attach agreements.

At month end:

• Allocate freight-in to inventory by your documented driver; reconcile the freight-in clearing account to zero remaining to allocate.
• Post rebate accruals (contra-COGS or inventory reduction per your policy) and age rebates receivable.
• Reconcile consignment in and consignment out locations to external statements or sell-through reports.
• Reconcile inventory subledger to general ledger. They must match to the dollar; a difference is a posting error, not a rounding.
• Run KPIs and look for stories that do not make sense:
  • Inventory turnover = COGS ÷ average inventory. A healthy distributor often turns 4 to 8 times per year; below 3 suggests overstock or dead stock.
  • Days in inventory = 365 ÷ turnover. If days jumped from 60 to 85, you bought ahead of sales or stopped writing down obsolescence.
  • Gross margin by product line at landed cost, not gross cost. If one line's margin drops exactly when inbound freight spiked, allocation is working; if margin never moves when freight doubles, it is not.
  • GMROI (gross margin return on inventory) = gross margin dollars ÷ average inventory dollars. This answers "for every dollar stuck on the shelf, how many margin dollars did I get back?"
  • Rebates receivable aging. Anything accrued more than one quarter past the earning period without a claim filed is at risk.
  • Fill rate and backorder dollars. Service failures predict the next month's sales and explain inventory that is "available" but not saleable.

At quarter end:

• Cycle-count high-value and high-velocity SKUs; full physical at least annually with a frozen count date, pre-numbered tags, and a write-down for net realizable value.
• True up rebate estimates to actual tier achievement; adjust COGS for the difference and document the reason.
• Provide your lender a borrowing base that excludes consignment-in inventory and obsolete write-downs — even if your system still shows them. Trust is the borrowing base you cannot see.

A Note on Systems​

You do not need an enterprise system to do this correctly, but you do need one that understands distribution. The features that matter are landed-cost allocation, location tracking for consignment, and a way to accrue rebates by vendor and tier — not just a generic inventory module that asks for quantity and average cost.

If your current software cannot allocate freight to receipts, at minimum use a manual allocation spreadsheet tied to receipts by PO number and post a summary journal each month with the spreadsheet attached. The spreadsheet is your audit trail. Similarly, if your system has no rebate accrual feature, track rebates in a separate schedule by vendor, with tier, rate, purchases to date, earned amount, received amount, and receivable balance — and post the accrual from that schedule, not from memory.

Simplify Your Financial Management​

When more than half your net worth is stacked on shelves and rolling on trucks, getting freight-in, vendor rebates, and consignment inventory right is not a technical footnote — it is how you know what you actually earned and what you can actually borrow. Clean allocation, disciplined accruals, and location-level tracking turn a noisy set of purchase orders and freight bills into trustworthy product-line margins and a balance sheet your lender believes.

Beancount.io gives you that clarity with plain-text accounting that is transparent, version-controlled, and ready for the analysis wholesale distribution actually requires. Your landed costs, rebate schedules, and consignment locations live in human-readable text you control — no black boxes, no vendor lock-in. Get started for free and see why distributors who want to own their numbers are switching to plain-text accounting.