BimpBlog

Wholesale Accounting for Manufacturers: Price Lists, Reserves and Shipments From One Warehouse

Wholesale accounting for manufacturers: three price lists (dealer, wholesale, web), orders with a reserve and shipments from one warehouse. Sample with margins.

DO
Dmytro ObukhovCo-Founder & CEO
Table of contents
In short
  • A manufacturer that sells wholesale from its own warehouse keeps several price lists, and a reserve divides the balance between buyers. In Bimp each price level is a separate price list, a customer order reserves the goods, and the warehouse balance goes down only at shipment.
  • In the hypothetical example a cutting board costs €18 and sells for €26 (dealer), €30 (wholesale) and €38 (web). The margins are 30.8%, 40.0% and 52.6%. A wholesale order for 300 pcs gives €9,000 of revenue and €3,600 of gross profit.
  • A warehouse of 500 pcs, of which 120 are already reserved for a dealer, leaves 380 pcs available. A reserve of 300 pcs for wholesale leaves 80 pcs, and the first shipment of 200 pcs does not change that number.
  • Bimp does not change the price by itself depending on volume or customer: the price level is set by the price list that the manager chooses in the order or that is marked as the main one.

Wholesale accounting for manufacturers rests on three things: a separate price list for each price level, a customer order that reserves the goods, and shipment with one document from the finished goods warehouse. Then a dealer, a wholesale customer and the website see the same availability, and the margin of each level is visible before the deal is made.

A manufacturer of kitchen cutting boards sells part of its output to dealers, part to wholesale buyers and part through its own website. A sales manager takes an order for 300 pieces and promises shipment on Friday, but 120 boards have already been promised to a dealer. The warehouse does not know about either promise. Below is a hypothetical example with figures showing how Bimp handles this. The company is invented.

How many price lists does a manufacturer that sells wholesale need?

As many as the price levels the company uses. A manufacturer with its own wholesale usually has three: dealer, wholesale and a website price list. A price list in Bimp is a set of product prices for a certain group of customers, and a separate one is set up for each level.

In the price list card you enter the name, the currency, the type (main or non-main) and add prices with a start date. The main price list is filled into documents automatically, and the manager chooses the rest in the customer order. Prices can be entered by hand, loaded from Excel or changed in bulk.

The hypothetical manufacturer’s figures are as follows. The cost of a board is €18 (including material, shop work and packaging).

Price listPrice, EURGross margin, EURMargin on price
Dealer2626 - 18 = 88 / 26 = 30.8%
Wholesale3030 - 18 = 1212 / 30 = 40.0%
Website3838 - 18 = 2020 / 38 = 52.6%

A dealer buys in large batches and gets the lowest price and the lowest margin. This is visible in the table before the manager promises a discount. How to calculate a price from cost is described in the article about cost-plus pricing for manufacturers. A step-by-step price list setup is in the help article Price lists.

How does wholesale accounting for manufacturers handle an order with a reserve?

A wholesale order is entered with the Customer order document: the manager chooses the customer, the warehouse and the “Wholesale” price list and adds the goods. The quantity in the “Reserve” column assigns the boards to this order, and other managers can no longer sell them.

The hypothetical situation: the warehouse holds 500 boards, and 120 are reserved for a dealer order. Available is 500 - 120 = 380. A wholesale customer orders 300 boards at €30.

IndicatorValue
Order amount300 × 30 = €9,000
Cost of the order300 × 18 = €5,400
Gross profit9,000 - 5,400 = €3,600 (40.0%)
Warehouse balance500 pcs
Reserve after the order120 + 300 = 420 pcs
Available500 - 420 = 80 pcs

A reserve lasts a set number of days, and a zero in the “Reservation days” field means an unlimited reserve. For wholesale with a prepayment, set the date by which the customer must pay, and Bimp will release the reserve itself. The rules are described in the help article Reserving goods.

If the wholesale customer asks for 400 boards and 380 are available, the reserve is placed only for the 380 on hand. The other 20 pcs can be covered by production: a production order is created from the customer order. How to do it is covered in the article about the production order.

How do you ship an order in parts from one warehouse?

Shipment is the Sales of goods and services document. It is created from the order with the “Create based on” button, takes the customer, the prices and the lines from it, writes the goods off the warehouse and releases the reserve for the shipped quantity. Several sales can be created for one order, changing the quantity.

Suppose the shop makes the boards gradually, so 200 pcs ship on Friday and the other 100 pcs the next week. The customer made a prepayment of €4,500. Here is how the numbers change.

StepBalance, pcsReserve, pcsAvailable, pcs
Start (reserve for the dealer 120)500120380
Wholesale order for 300 pcs50042080
Shipment of 200 pcs30022080
Shipment of 100 pcs20012080

Available stays at 80 pcs at every step after the order, because a shipment reduces the balance and the reserve by the same quantity. The dealer’s batch of 120 pcs stays in reserve the whole time.

The money and the debt look like this:

EventAmount, EURCustomer debt, EUR
Prepayment4,500-4,500 (advance)
Shipment 200 × 306,0006,000 - 4,500 = 1,500
Shipment 100 × 303,0001,500 + 3,000 = 4,500

Check: the two shipments total 6,000 + 3,000 = €9,000, the prepayment is €4,500, and the debt is 9,000 - 4,500 = €4,500. Payment and shipment in Bimp do not depend on each other, so they can be entered in any order. The debt is visible in the Customer settlements report. The whole chain of documents is shown on the “Links” tab of the order.

The order is closed with the “Completed” status after shipment. If this status is set earlier, the reserve is released, and a shipment document with a reserve can no longer be saved.

How does a manager see what can be promised to a customer?

In Warehouse → Products and services three columns stand side by side: “Stock in warehouses”, “Reserve” and “Available”. For the hypothetical manufacturer before the wholesale order they read 500, 120 and 380. The manager promises the customer the available quantity, 380 pcs, although 500 physically sit in the warehouse. Click the balance figure, and Bimp shows the breakdown by warehouse, and the date field lets you see the balance and the reserve for a chosen day.

The same warehouse serves dealers, wholesale and website orders, so the available balance is one for all channels. A dealer order entered in the morning reduces the quantity available for wholesale in the afternoon. For planning there is the Stock with Reserve report: balance, reserve and the difference by warehouse and product for a chosen date.

What should you check in the contract with a wholesale customer?

The contract with the buyer sets the settlement currency and the payment deferral, and the manager chooses the price list in the order. For a regular customer it is convenient to create a separate contract with a 14-day deferral, and for a new one to keep a prepayment. Then the choice of contract in the order shows at once which terms apply, and receivables are controlled by payment terms.

For a hypothetical customer with a debt of €4,500 and a 14-day deferral, the manager sees the debt in the Customer settlements report, and control of payment terms is provided by the receivables section.

How do you raise wholesale prices without touching the dealer and website ones?

Change only one price list. In Sales → Prices select the products, click “Change prices”, choose the wholesale price list, the rule +X% and the “Effective from” date. Let us raise wholesale by 5%: 30 × 1.05 = €31.50. The margin on a board becomes 31.5 - 18 = €13.50, or 13.5 / 31.5 = 42.9%.

The dealer (€26) and website (€38) price lists stay as they were. The old prices do not disappear: the new price with another date is added alongside, and the history is kept. If prices are tied to a foreign currency and depend on the exchange rate, use the approach from the article about price recalculation when the exchange rate changes.

What Bimp does and does not do

Bimp is a Ukrainian cloud ERP for manufacturers. For wholesale it provides separate price lists with a price history, a customer order with a reserve and a reserve period, shipment in parts with the Sales of goods and services document, payments and advances, customer debt in the settlements report, contracts with payment deferral and bulk price changes. A general overview of the section is on the Sales and orders page.

The limits are these. Bimp does not guess the price level by itself: the main price list is filled in automatically, and the manager chooses the others in the order. A reserve is placed only within the available balance, so it cannot be placed on goods that are not there. A payment does not write off goods and does not release the reserve: shipment does that. There is no separate “Invoice” document, and the invoice for payment is a printed form of the order. Set the terms of volume discounts through a separate price list: the system does not calculate volume discount rules.

For the hypothetical manufacturer the result is this: three price levels with margins of 30.8%, 40.0% and 52.6%, a wholesale order for €9,000 with €3,600 of profit, a reserve that leaves 80 boards available, and a debt of €4,500 after two shipments.

FAQ

How do you keep wholesale accounts for a manufacturer?

Set up separate price lists for each price level, create customer orders with a reserve, ship with the Sales of goods and services document and watch the debt in the Customer settlements report. Production sales and trade sales go from one warehouse, so the balance is shared.

How many price lists does a wholesale manufacturer need?

As many as the price levels you use. Typically three: dealer, wholesale and a web price list. One of them is made the main one and is filled into documents automatically, and the manager chooses the rest in the order.

What if there is not enough goods in the warehouse for a wholesale order?

A reserve is placed only within the balance. You can enter the order for the full quantity, reserve what is available and create a production or purchase based on the order for the rest.

Can an order be shipped in parts?

Yes. Several Sales of goods and services documents are created for one customer order, with a different quantity in each. The reserve is released together with the shipped goods.

How do you raise wholesale prices by 5% across the whole range at once?

In Sales → Prices select the products, click "Change prices", choose the wholesale price list, the rule +X% and the "Effective from" date. The old prices stay in the history.

We will show wholesale sales on your range

In a Bimp ERP demo, a specialist sets up your price levels, enters an order with a reserve and shipments from the warehouse and shows the margin and the customer's debt.

Book a demo
DODmytro ObukhovCo-Founder & CEO