Wholesale ERP: stock, pricing, credit and costs

What a wholesale ERP must do

A wholesale ERP, also called distribution ERP, runs the whole trade cycle of a business that buys in bulk and sells to other businesses: purchasing, stock across warehouses, customer price lists, orders, delivery, invoicing, credit control and the ledger, in one system. You need one when margins, stock and customer credit can no longer be managed safely from separate spreadsheets and packages.

The difference from retail is the customer. A wholesaler sells on credit to known trade customers, at prices that differ by customer, in quantities that can empty a warehouse location in one order. So credit limits, payment terms, price groups and reliable stock availability matter more than till speed.

This guide covers what wholesalers and distributors should require, how to compare systems and what they cost, with UK examples and a note for distributors trading in Saudi Arabia. The last section explains how Skyline Nexus ERP handles wholesale.

Signs your current tools have run out

Most wholesalers and trading companies move to an ERP when several of these happen every week, not once a quarter:

• Sales staff ring the warehouse to check stock before confirming an order.
• Customer prices live in a spreadsheet, and invoices regularly go out at the wrong price.
• Nobody can say what the margin was on yesterday's orders until the month is closed.
• Customers over their credit limit still receive deliveries because the order desk cannot see their balance.
• Stock moves between warehouses on paper, so one location shows stock that is actually on a lorry.
• The VAT return and the month-end take days of copying between the order system and the accounts.

Requirements checklist for a wholesale ERP

Use one list for every vendor. The first five items are essential for almost every wholesaler; the rest depend on what you sell and where you buy it.

• Stock per warehouse, with transfers between locations and a status for goods in transit.
• Customer price groups and price lists, plus a way to import a new price list in one file.
• Quotations, sales orders, delivery notes and invoices linked to each other.
• Credit limits and payment terms per customer, ageing reports and statements of account.
• Purchasing: supplier orders, receipts, supplier bills, purchase returns and debit notes.
• FIFO costing, with margin per invoice, product and customer.
• Lot and expiry tracking if you sell food, chemicals or anything else with a shelf life.
• Invoices in foreign currencies if you import or export, and automatic posting of every document to the general ledger.

Pricing and margin control

Wholesale pricing is usually cost-plus with negotiated exceptions: a list price, a trade price group, a few key accounts on special terms, and volume breaks. Every exception must live in the system, not in a salesperson's memory, or margin leaks quietly order by order.

Margin also depends on what you count as cost. Under IAS 2 the cost of purchase includes import duties and transport needed to bring the goods to their present location, so landed cost, not the supplier's invoice price, is the right base. Watch credit notes as well: a 5% rebate given after the invoice reduces margin as surely as a lower price.

Review margin per customer every quarter. Large customers on low prices with long payment terms can cost more to serve than they contribute, and the margin and ageing reports read together show which ones.

Credit control: limits, terms and ageing

Selling on account is a loan to your customer. A wholesale ERP should hold each customer's credit limit and payment terms, show the open balance when an order is taken, and produce an ageing report in buckets such as current, 1 to 30, 31 to 60, 61 to 90 and over 90 days.

Send statements of account every month, chase from the ageing report every week, and stop supplying customers who are over their limit and overdue until a manager approves. A rule built into the order process works better than a rule written in a policy nobody reads, and the system should show who released each held order and why.

Stock across warehouses

Distribution ERP is often chosen for its warehouse side. At minimum you need stock by location, transfers with a status, cycle counts that post differences as adjustments, and reports for stock value, movement, ageing and dead stock. Food and chemical distributors also need lot numbers and expiry dates captured on receipt and reported before goods go out of date.

On valuation, IAS 2 and FRS 102 allow FIFO or weighted average cost and do not allow LIFO. FIFO is a common choice for wholesalers whose purchase prices rise over time, because closing stock is then valued at the most recent costs.

A transfer between your own warehouses is not a sale. It changes where stock is, not what it is worth, so it should never create revenue or margin. Ask each vendor how stock in transit appears at month-end, and count it.

VAT and e-invoicing for UK wholesalers

A wholesaler sells mostly to VAT-registered businesses, so sales normally need a full VAT invoice; the GBP 250 simplified invoice is mainly useful to retailers. The standard rate is 20%, with 5% and 0% rates for some goods, so the system must carry the rate on each invoice line and report sales and purchases by rate for each return.

Making Tax Digital for VAT requires specified records to be kept in functional compatible software, with digital links between programs, which rules out re-keying order data into the accounts. The government has also announced mandatory e-invoicing for VAT invoices from 2029, with a roadmap to follow, so ask any vendor how it will support structured e-invoices to your trade customers.

Distributors that also trade through a company in Saudi Arabia face ZATCA Phase 2 e-invoicing there: invoices must be issued in the required electronic format and integrated with ZATCA's Fatoora platform. ZATCA's 25th wave covers taxpayers whose VAT-able revenue exceeded SAR 187,500 in any year from 2022 to 2025, with integration by 1 February 2027.

Worked example: one trade order from quote to cash

A UK wholesaler of kitchen supplies holds two purchase lots of one item: 500 units bought at GBP 4.00 and a later 300 units at GBP 4.40. A customer in the Trade price group orders 600 units at GBP 6.50 each, excluding VAT, on 30-day terms.

Before confirming, the order desk checks credit. The customer's limit is GBP 10,000 and its open balance is GBP 6,200, so the new invoice of GBP 4,680 would take the balance to GBP 10,880. The order is held for a manager, who releases it after the customer pays GBP 2,000 of overdue invoices.

• Invoice: 600 x 6.50 = GBP 3,900 net; VAT at 20% GBP 780; total GBP 4,680.
• Posting: Dr Trade receivables 4,680 / Cr Sales 3,900 / Cr VAT output 780.
• FIFO cost: 500 x 4.00 = 2,000 plus 100 x 4.40 = 440, so cost of sales is GBP 2,440.
• Posting: Dr Cost of sales 2,440 / Cr Inventory 2,440.
• Gross margin: 3,900 - 2,440 = GBP 1,460, which is 37.4% of sales.
• Stock left: 200 units at GBP 4.40 = GBP 880.
• Credit after release: 6,200 - 2,000 + 4,680 = GBP 8,880, within the GBP 10,000 limit.
• Collection: the invoice sits in the current bucket of the ageing report until it is paid or falls due.

How to choose, and what a wholesale ERP costs

Ask each vendor to run your own scenario: a customer on special prices, an order that splits across two warehouses, a partial delivery, a credit note for damaged goods and a month-end. Watch how many screens it takes and whether the ledger is right at the end.

Wholesale ERP prices are usually per user per month, with extra charges for additional warehouses or companies, EDI connections, online-shop links and implementation days. Compare 12 paid months at the regular price after any offer, add set-up time, and ask what happens to the price at renewal. Free or free-download distribution software exists, mostly as self-hosted open source; count hosting, support and upgrade work before calling it free.

For reference, Skyline Nexus ERP Solo costs GBP 15 a month plus VAT for one user and one business location, which suits an owner-run trading company with one warehouse. A team with several users or warehouses needs a larger plan such as Core; prices are on the pricing page. Every plan starts with a free first month, and under the launch offer, valid until 31 January 2027, Solo costs GBP 7.50 a month for the first 3 months on monthly billing, so the first 12 paid months cost GBP 157.50 instead of GBP 180; on annual billing, GBP 150 covers 15 months. Prices were checked on 3 October 2026; confirm them on the pricing page.

Skyline Nexus ERP for wholesale and distribution

Skyline Nexus ERP covers the wholesale cycle in one cloud system. Quotations, sales orders, delivery notes and shipments lead to the invoice; purchases, purchase returns and debit notes cover the supply side; sales returns are credit notes. Each business location holds its own stock, its own invoice numbering and a default selling price group, and selling prices can be imported from a file. Customers carry payment terms and credit limits, which can be loaded with the contact import, and AR and AP ageing reports, customer ledgers and statements of account support credit control.

Stock is costed at FIFO, with reports for location stock, stock valuation, stock movement, stock ageing, dead and slow-moving items, lots and stock expiry. Stock transfers between warehouses carry a pending, in-transit or completed status. Roles decide who can see purchase prices and which locations each user can work in. With auto-posting switched on, sales, purchases, payments and expenses post to the general ledger in the background, with VAT computed per line; invoices can be issued in a foreign currency at a rate you enter, on a ledger kept in your base currency.

For a Saudi company, the ZATCA module handles Phase 2 onboarding, clearance and reporting. For UK VAT, VAT reports and a prefilled VAT return form give you the figures, which you submit through MTD bridging software or your accountant's MTD software while direct MTD filing is being rolled out. Start the free first month with your own price list and a week of real orders, or book a demo for a multi-user team.