Foodservice distribution financial analysis

Foodservice distribution financial analysis measures what each route earns after customer credits, recorded spoilage and delivery costs. Start with the same accounting period across sales, inventory and transport exports, then reconcile contribution to the ledger. Put receivables beside that result so a profitable route cannot hide a collection problem.

Assemble the files around route and customer

Export invoice lines with customer, site, route, ship date, product, quantity and invoiced value. Bring credit memos with original invoice references, sold-product costs, inventory adjustments with reason codes, and route delivery costs. Keep the month-end receivables report available for the cash check.

Use the delivered site as the operating account when a restaurant group has several locations. Keep its parent account as another field. Chain versus site foodservice share explains that distinction for account coverage; the financial review uses it to stop a weak location disappearing inside its parent total.

The first reconciliation is invoiced sales less sales credits equals net sales. The SEC's financial statement guide explains the deduction of returns and allowances in arriving at net revenue. Record collection losses separately rather than putting every customer adjustment in that sales-credit column.

Keep unique invoice and credit references. An invoice with several credit lines should not repeat its full sales value for each credit. Summarize credits to the invoice first or keep sales and adjustments as separate signed transactions.

Calculate contribution after perishability and service

Consider an illustrative US distributor's September 2026 route review. Sold-product cost is the inventory cost of goods actually sold, after any cost reversals for returned goods. Spoilage is a separate recorded charge, excluded from sold-product cost here. Delivery covers the recorded driver, vehicle and fuel costs assigned to these routes.

Put the first six columns below in A through F, starting the Metro route in row 2. Calculate net sales in G and route contribution in H. All amounts are USD.

The spreadsheet formulas are:

G2: =B2-C2
H2: =G2-D2-E2-F2
I2: =IF(G2=0,NA(),H2/G2)

Fill down through row 4 and format I as a percentage. The route contribution margins are 13.0% for Metro, 2.2% for Outer and 15.8% for Rural, rounded to one decimal place. The total is =SUM(H2:H4)/SUM(G2:G4), or 10.4%; do not average the route percentages.

The proof is 389,000 - 303,000 - 4,500 - 41,000 = $40,500. That amount is available for shared warehouse, sales and administrative costs. It is not company operating profit. If the ledger already includes spoilage in cost of sales, reclassify that component for this view rather than deducting it twice.

The broader distribution financial analysis covers the general distributor review. This page's additional work is tracing perishable losses and route service costs to the contribution result.

Explain the route difference before changing prices

Outer has the smallest contribution despite invoiced sales above Rural. Check its credit reasons, spoilage events and delivery schedule before proposing an across-the-board price increase. A short shipment, a quality claim and a pricing correction point to different owners and different remedies.

For spoilage, preserve product, lot, location, date, quantity, carrying cost and disposal reason. Compare the adjustment with the inventory movement report and the expense account. The IRS inventory guidance distinguishes goods that are damaged or unusable from normal saleable inventory. Have finance apply the company's approved valuation policy; an operational spreadsheet should not replace the accounting judgment.

For delivery, distinguish directly recorded costs from allocations. Allocate a shared route cost with a documented driver such as recorded stop minutes, and retain unassigned costs as a visible line. Sales value alone can obscure the cost of small, frequent stops. Treat allocated contribution as a review measure, not proof that removing an account would eliminate every assigned dollar.

The industrial distribution financial analysis uses a different emphasis: stocked-part complexity and service effort rather than perishable losses.

Reconcile the customer cash movement

Use a second worksheet for opening receivables, this month's net credit sales and cash receipts. Assume all sales in this example are on credit, with no write-offs, deposits or other receivable adjustments.

With these columns in A through E, closing AR in E2 is:

=B2+C2-D2

The total check is 80,000 + 389,000 - 376,000 = $93,000. Credits are already in net sales, so do not subtract them again. Tie closing AR to the aging report, then investigate overdue invoices and unresolved claims separately. Days sales outstanding provides the collection measure when the period's sales and balances are ready.

Where it goes wrong

• Spoilage counted twice. A separate loss column must exclude losses already left inside sold-product cost.
• Credits posted against the wrong site. Parent-level credits can distort route results unless their underlying delivery sites are identified.
• Costs allocated without evidence. A route with many short stops can look artificially cheap when all delivery cost follows sales value.
• Collections treated as revenue. Receipts can settle older invoices; they do not measure this month's selling performance.
• Unassigned losses hidden. Retain warehouse losses and unmatched credits in an explicit reconciliation row until their owner is established.

Review your route exports in Covirage

Bring your invoice, credit, spoilage and route-cost files or Google Sheet to Covirage. Covirage maps the columns, its tools compute and check the figures, and the external AI model explains the route and customer results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.

See Covirage for foodservice businesses for the supporting industry context.