BimpBlog

Consignment Inventory Tracking at Partner Stores: Who Sold What While We Waited for the Excel Report

A fictional garment maker passed 1,500 T-shirts to ten stores, and 210 sold in a week for €1,470. How to see partner sales in the Bimp Ecosystem without Excel.

DO
Dmytro ObukhovCo-Founder & CEO
Table of contents
In short
  • A manufacturer passed 1,500 T-shirts to ten stores on consignment. In a week the partners sold 210 pcs, and a debt of €1,470 (210 × €7) appears in the books on the day the sales report is issued.
  • Goods transfer, sales from the shared warehouse and the "Sales report" document are kept in the "Ecosystem" section. The transfer price becomes the manufacturer's revenue and the partner's cost.
  • The stock in every store is visible by size and color, and the partners' debt is shown by the "Customer settlements" report.

The company is fictional. Every action in Bimp is a real product feature. Names, quantities and prices in the example are invented, and the arithmetic can be checked on a calculator.

Consignment inventory tracking at partner stores is needed so that a manufacturer learns about a sale on the day of the sale, without waiting for Monday’s Excel. For a fictional garment maker this is 210 T-shirts in a week, €1,470 of partner debt and 1,290 T-shirts still lying in the stores.

The accountant of “Cherry Fox” put together ten spreadsheets in different formats every Monday. One store sent a photo of a notebook, another a file without sizes. Entering the data took a whole day, and meanwhile the manager decided whether to print the next batch without knowing what exactly was selling.

Why do partner reports arrive late?

“Cherry Fox” (a fictional company) sews basic clothing and has 25 employees. It sells through its own online store and through ten partner stores, to which it passes T-shirts on consignment. Ownership of the goods stays with the manufacturer until the buyer pays at the partner’s till.

The partner prepares the sales report once a week, which is understandable: the partner has its own till, its own customers and its own worries. For the manufacturer this means three gaps:

  • whether something sold is known only from a file that somebody has to enter by hand;
  • the partner’s debt appears in the books late, so the amount receivable is inaccurate;
  • fast-moving sizes can be added to a store only after the report, when they have already run out.

Here is the weekly picture of the network that the accountant assembled by hand:

IndicatorValue
Passed to partners, pcs1,500
Sold in the week, pcs210
Left in the stores, pcs1,290
Transfer price, €7
Partners’ debt, €1,470

Calculation: 1,500 - 210 = 1,290 pcs left, and 210 × 7 = €1,470 of debt. The whole transferred batch costs 1,500 × 7 = €10,500 at the transfer price, so 14% of the batch was sold in the week (210 / 1,500).

How do you set up consignment inventory tracking in the Bimp Ecosystem?

The partners work in Bimp too, so the “Ecosystem” section fits. Below are six steps, with a help link next to each.

Step 1. Connecting two accounts. The partner turns on the switches “Keep goods records by batches” and “Receiving goods for sale” in the accounting settings. The manufacturer turns on “Transferring goods for sale”. Then the parties exchange company IDs and add each other as counterparties. This is set up once for a pair of companies: Ecosystem setup, general description: Ecosystem.

Step 2. Transferring a batch. The manufacturer creates a document in Ecosystem → Goods transfer: the goods are written off the main warehouse and arrive in the shared warehouse. The partner automatically gets a “Receipt of goods” document with the status “New”. The partner matches the goods with its own directory, creates batches and sets “Received”. Until that moment the transfer can be rejected, after it the transfer can no longer be cancelled. No debt arises at this stage: Transferring and receiving goods.

Step 3. Sale and the “Sales report”. The partner makes an ordinary sale from the shared warehouse, chooses the supply batch and saves the document. Then in the “Ecosystem” section the partner creates a “Sales report” based on that sale. Bimp pulls in the supplier, the warehouse, the goods and the transfer price by itself. After saving, the cost price appears, along with the debt to the manufacturer and an automatic “Supplier order” that the partner pays: Consignment sales.

Step 4. Two prices. The price in the transfer document is the selling price for the manufacturer and the purchase price for the partner, from which its cost price is calculated. The partner sets the retail price in the sales document, and it stays in the partner’s database: Prices and cost price in the Ecosystem.

Step 5. Size and color. A T-shirt is kept as one product with modifications by size and color. In the list each modification stands on a separate row with its stock, so you see that exactly M and L in black ran out in the store: Modifications.

Step 6. The partners’ debt. The “Customer settlements” report shows the columns “Shipped”, “Paid” and “Closing balance” for each partner. A positive balance means the partner’s debt: Customer settlements report.

What does the manufacturer see for the week in numbers?

Challenge

Ten stores sold 210 T-shirts out of 1,500 passed to them, but the manager learns about it from the weekly Excel, and the accountant spends a day on manual entry.

Solution with Bimp

A batch transfer in the Ecosystem, the partner’s sale from the shared warehouse and the “Sales report” create the debt on the day of issue. The stock is visible by size and color.

Result in numbers

210 pcs sold at a transfer price of €7, that is 210 × 7 = €1,470 of partners’ debt. 1,290 T-shirts remain in the stores, and the manufacturer plans a top-up based on the stock.

A notional breakdown across the ten partners after all of them issued sales reports. Each was passed 150 pcs.

PartnerSold, pcsDebt, €Left, pcs
Store 135245115
Store 228196122
Store 31284138
Store 418126132
Store 525175125
Store 622154128
Store 715105135
Store 830210120
Store 91070140
Store 1015105135
Total2101,4701,290

Check of the sums. Sold: 35 + 28 + 12 + 18 + 25 + 22 + 15 + 30 + 10 + 15 = 210. Debt: 245 + 196 + 84 + 126 + 175 + 154 + 105 + 210 + 70 + 105 = €1,470. Stock: 1,500 - 210 = 1,290, and every row equals 150 minus the amount sold.

The difference between the points is visible. Store 1 sold 35 pcs in the week, store 9 only 10. The first is worth topping up, while in the second the goods are probably lying where nobody buys them. The manufacturer decides on the next batch from this table.

How much does the partner earn, and how is it seen in Bimp?

The transfer price of €7 goes into the partner’s cost price. If the store sells a T-shirt for €14.75, its gross profit per unit is 14.75 - 7 = €7.75. For 210 pieces that is 210 × 14.75 = €3,097.50 of revenue and 210 × 7.75 = €1,627.50 of profit for the partner network. The manufacturer does not see these numbers: the retail price stays in the stores’ databases.

The manufacturer’s income from partners is built from the same transfer price, that is €1,470. The retail markup does not go to the manufacturer in this scenario, but the manufacturer keeps control of the stock and of how fast the goods turn over.

How do you control the partners’ debt every week?

The procedure for the economist is short.

  1. Open “Reports → Customer settlements”, set the period and generate the report.
  2. Group by customers and look at the “Closing balance” for each partner.
  3. For partners with the largest debt, check that a “Sales report” has been issued for all sales.
  4. Review the modification stock at the partner and decide on a top-up.

Debts show in one report instead of ten files. If needed, turn on “Show closed debts” to see movements across all documents. The weekly report remains for reconciliation.

A similar task for your own wholesale channel, where price lists, reserves and shipments come from one warehouse, is covered in the article Wholesale Accounting for Manufacturers. When the manager needs a general picture of profit, cash and debts, the article Manufacturing Management Reporting for the Owner will help.

What does this give a clothing manufacturer?

The partner’s debt appears in the books after the sales report is issued. There is no need to wait for the weekly Excel. The accountant does not enter the data of ten stores by hand, because the documents are created in the system itself from the partner’s sales.

For a manufacturer growing a network on consignment, visibility of stock is a decision about the next batch. If sizes M and L run out in a store, the manufacturer sees it in the modification stock and sends a top-up before buyers go to a competitor. Bimp is a Ukrainian cloud ERP for manufacturers, and this transfer of goods, the sale and the settlements sit in one database.

Scenario limits

The Ecosystem works when the partner also uses Bimp: documents are exchanged between two accounts. With a store that has no Bimp this scenario does not apply. The debt arises only after the partner has issued a “Sales report” and the manufacturer has confirmed it with the status “Received”, so the partner’s discipline with documents remains a condition of accurate records. Prices, volumes and the number of stores in the example are invented.

How this looks for garment production with sizes, colors and series is told on the page Software for clothing and textile manufacturing. The functions for sales and settlements with customers are collected on the page Sales in Bimp.

FAQ

Does the partner's debt arise when goods are transferred on consignment?

No. A transfer is not a sale, so there is no debt until the partner has sold the goods to the end customer and issued a "Sales report". That document records the debt to the manufacturer.

Does the manufacturer see the retail price at which the store sold the T-shirt?

No. The manufacturer sees the fact of the sale and its own transfer price. The retail price stays in the partner's database and forms the partner's revenue and markup.

Does the Ecosystem work with a store that does not use Bimp?

No. The link needs two Bimp accounts: the manufacturer's and the partner's. For stores without Bimp the usual consignment accounting with certificates and reports remains.

How do you see the T-shirt stock by size at a partner?

Size and color are kept as modifications of one product. The stock in the partner's shared warehouse is shown for each modification separately, so you can see which sizes are running out.

See the partner network on your own product

In a Bimp ERP demo a specialist walks through a transfer of a batch to a partner, the sale and the sales report with you, and then shows the debt in the report.

Book a demo
DODmytro ObukhovCo-Founder & CEO