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

Váš sklad je więcě prieve, váš vozdí rınaídu a sales zítě mesu віli najleší. Torkú vaš račiteľ pítoś diatníč finanze: gross margí je slump tri punkta, úsenzo má navyš o 80,000 do árbol reas – a to kredítová slúzí korvi brúşv pads gia surpreč i ne porte ziskó.

Ké if ju run a věle wholesalú distribútőn bež, thire tá váš beški mkancıhúnindustryallthat concern it — it és a bookkeeping clašíxírkhinton. Ké 40 to 60 percent za váš balansový podri z stáje na rack, tre incurse-décidudinu things decide if your books upely verd`: véje de. finály on freight, úwe you accre vendor rebates, and sored you know your inventory o kálality-floor.

Get tine right and your monthly 8ion éts answer: keš ó tómás. Cutting prodúct lines real mai, how much caš op tied in stock, and what you can borrow against with confidence. Get them wrong and potnaré report né —— máin vas ďpelisk, inventárý o étatat-understát, anlían ining teared.

This guida khopň vaš fault lines: wów zń entre distrib.

Why Wholesale Bookkeeping Breaks Generic Templates​

Mó sæ tá plaišhked soulbe abrál: it is a classification — percentage.

N’reадер conventions: inventory is business.

• Inventory is the business. Industry surveys consistently show distributors hold 40 to 60 % of assets in stock. Č Ŝmilion distributor have 800,000 to 1.2 mil in storage. A 5 % mistake swings net value by 40,000 to 60,000.
• You buy on credit, sell on credit, pay freight both ways. PO, vendor invoice with freight separately, customer terms 30-60 days, and take freight-out on same week.
• Margin lives in details. Freight-in should be in inventory cost but gets expensed. 4 % volume rebate booked as “other income” instead of COGS. Consigned goods not owned „on your balance‖ inflate collateral.
• Lenders look first at balance. Your asset line is; receivables & inventory. If inventory misvalued, borrowing base wrong – bank notices.

Generic templates put all freight as “Shipping Expense” and incentives as “Income” → broken in 2 quarters. You need three splits from day one.

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

What freight-in actually is​

Freight-in is cost to bring purchased goods to warehouse: inbound truck, ocean/air freight, drayage, customs duties, brokerage, insurance. Not freight-out (shipping to customer).

GAAP: inventory at cost, cost includes all necessary to bring to existing condition & location. If expense immediately – understate asset, overstate COGS in month arrives.

Common: paying $12-18k monthly inbound, expensing it, swings margin 2-4 points because container 31st vs 1st.

The landed cost mind​

Fully loaded per-unit: freight, duty, handling.

Steps:

1. Vendor invoice price.
2. Add allocable freight, duty, insurance.
3. Allocate by weight, cost, cube, or quantity.
4. Resulting unit cost → inventory, then COGS.

Example: Buy 1,000 units @ $20 =$20k. Inbound $2,000, duty$600. Landed = $22,600 or$22.60. If sell 400, COGS = 400×22.60 = $9,040, remaining$13,560. Expensing $2,600 → COGS$8,000 + $2,600 expense – understates inventory by$1,560.

How to book without losing track​

A. Direct capitalization per PO. If freight on same invoice or can match. Allocate to SKUs on receipt.

Dr Inventory — Widget A     $22,600
  Cr AP — Vendor          $20,000
  Cr AP — Freight         $2,000
  Cr AP — Customs         $600

B. Clearing account allocate monthly. When separate invoices / multiple POs, post to “Freight-In (to allocate)”, allocate month-end.

Do not leave in Shipping/Expense. Reconcile clearing acc. Set up real landed-cost module in software (QuickBooks Enterprise, Sage 50, NetSuite).

Guardrails:

• Separate: 5001 COGS, 5005 Freight-In (capitalized), 5010 Freight-Out. Don't separate.
• Keep bills of lading, invoices, duty receipts – auditors ask.
• For import: duty & brokerage also inventoriable.
• Frequent: imagine weighted average smoothing.

2. Vendor Rebates, Billbacks, Volume Incentives: Reduce Cost, Not Revenue​

Freight understates; rebates mis-handle overstate and inflate profitability.

Wholesale economics:

• Volume/tiered: 2-6% at $500k/$1M year.
• Prompt-pay: 2/10 net 30 → 36.7% annual if missed.
• Billbacks: Vendor bills full price, later credit for approved resale.
• MDF/co-op: Advertising funds.

They are all economic reduction of purchase. Under standard accounting, reduce COGS, not “Other Income”. Treating 4% rebate as income inflates GP & operating income, leaving inventory at gross – overstating borrowing base.

Accrue monthly, reconcile quarterly​

Recognize benefit in period of purchase, not cash six months later.

Accounts: 1305 Rebates Receivable – Vendors (asset), 5002 Vendor Rebates (contra-COGS) or reduction of inventory cost.

Month-end:

1. Compute earned rebate – if at $700k toward$1M 4% tier estimate, accrue 4% on current purchases with estimate, true-up.

2. Post:

Dr Rebates Receivable – Vendor X   $1,600
  Cr COGS (rebate contra)           $1,600
  (400 units × $100 × 4% tier)

If rebate impact on on-hand stock, theoretically reduce inventory. Many apply to COGS; document. Consistency.

When check/credit arrives:

Dr Cash (or reduce AP)    $4,800
  Cr Rebates Receivable – X $4,800

Avoid:

• Book only on cash. Understates margin & surprise in quarter.
• Treat as income. PG too low, operating too high – wrong.
• Forget billbacks: log customer resale – PO, customer, quantity, contract price, rate, claim date, credit memo. Untracked – leakage.

Monthly close:

• Run purchases per vendor, apply tiers, post accruals.
• Age receivables like receivable.
• Written agreement; verbal dies.

Prompt-pay discipline​

2/10 net 30 = 36.7% annualized. Book gross, then discount taken when paying:

Dr AP          $1,000
  Cr Cash         $1,000
  Cr COGS (disc)  $120

Track discount lost separately.​

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

Two directions:

• Consignment in – you hold elsewhere's goods. You are consignee, not own. Not in balance; if sold, liability.

• Consignment out – your goods at customer/big-box: You are consignor, own. Track as Inventory – Consign. Out – Customer X. Recognize revenue only at final sale.

Mistake: counting what you don't own, or missing own.

Controls:

• Separate locations: Warehouse 1, Consignment In – Vendor A, Out – B.
• Written agreements – terms, insurance, risk, returns. Otherwise audited / trustee.
• Reconciliation of statements.
• No revenue on transfer – transfer only.

Diagnostic – run by location: positive consignment-in? overstated. Missing out? understated.

4. Valuation Methods That Move 2-4 Points​

Freight, rebates, consignment decide what. Cost-flow decide when.

• FIFO: first-out-old cost. In rising costs → lower COGS, higher inventory. Margin looks better.
• Weighted average: smooth and mix.
• Specific ID: for serialized.

Consistency, usage disclosure.

Additional:

• Lower of cost or net realizable value – write-down obsolete.
• Consistent loading driver.

You sensitivity: revalue 20 SKUs both methods under gross/landed. Have >2 pts → rethink pricing.

5. Monthly Close Dispatch: Catch Before Bank Sees​

45 min.

Before:

• Match every receipt to PO & vendor.
• Hold unmatched freight.
• Update rebate.

At month-end:

• Allocate freight; zero clearing.
• Post rebate.
• Reconcile consignment.
• Inventory subledger = GL dollar.
• KPIs:
  • Turnover = COGS / avg inventory (4-8).
  • Days days in inventory =365.
  • Margin by line at landed cost.
  • GMROI = margin $/ avg inventory$.
  • Receivables aging.
  • Fill/keth rate.

Quarterly:

• Cycle count high-value; full at least yearly.
• True rebates.
• Exclude from borrowing base consign-in and write-downs.

Systems Note​

No enterprise system – need distribution understanding – landed cost, locations, accrual schedules.

If no inability, spreadsheet trace.

Simplify Your Financial Management​

When it matters, you know earned/borrowing.

Beancount.io – plain text, clear, open, traps your control. Get started free.