1. Home
  2. Blog
  3. Retail ERP: Branch Stock, Pricing, Shrinkage and E-Invoicing

Retail ERP: Branch Stock, Pricing, Shrinkage and E-Invoicing

  • 7 min read
  • Tranquil team

Retail ERP is the back office of a store chain, the system that holds one stock figure for every branch and warehouse, sets prices, buys and moves goods, and turns each day’s sales into accounting entries and VAT. The till, or point of sale (POS), records the sale in front of the customer. The ERP system is where that sale meets stock, cost, purchasing and the accounts.

For a retailer with one shop, a good POS and an accounting package are often enough. The problems start with the second branch and the online store. Each location keeps its own stock, prices drift apart, transfers between branches are agreed by phone, and at month end the finance team spends days reconciling sales, cash and stock from several systems.

What retail ERP covers, and what the POS does

It helps to be clear about the split, because many retailers buy one expecting the other. The POS handles the checkout, from scanning and payment by cash, card or wallet to the receipt and the cashier’s shift. The ERP system handles everything behind it:

  • the item master, with barcodes, units of measure and price lists;
  • stock by branch and warehouse, transfers and counts;
  • purchasing and receiving from suppliers;
  • cost of goods sold, margins and the general ledger;
  • VAT, e-invoicing and the reports management reads.

Some retailers run both in one product, and others connect a specialist POS to the ERP system. Either way, the test is the same. A sale at the till must reduce stock in that branch and reach the accounts without anyone keying it in again.

One stock figure across branches and the online store

A retailer’s stock problem is rarely the total. It is the location. The item is sold out in the Riyadh branch while twenty units sit in Dammam, and the online store shows it as available because nobody updated it.

The fix is to hold every location as a warehouse in the same system, with each sale, return and transfer posted to the location where it happened. Transfers should run as documents, with a request from the branch that needs the stock, a transfer from the branch or warehouse that has it, and a receipt at the other end. Stock on the truck then belongs to neither branch until it is received, and differences show up at the receiving branch the same day, not at the annual count.

Stock levels by branch in a retail inventory screen

Prices, promotions and the minimum price

Retail pricing breaks in two places. Branches change prices locally and the head office does not know, or a promotion runs longer than planned and sells goods below cost. Both are controlled in the item master rather than at the till.

Keep prices in price lists that are set centrally and assigned to branches or customer groups, and limit which users can change them. Give every item and unit of measure a minimum selling price, so that a discount entered at the till cannot go below it without an override by an authorized user. And decide once whether shelf prices include VAT. Prices shown to consumers normally include VAT, so the system has to work the VAT out of the price, not add it on top.

Shrinkage and stock counts in stores

Shrinkage is the difference between the stock the system says a store should have and what is actually on the shelves, from theft, damage, expired goods and receiving errors. It goes straight to margin, which is why it should be measured branch by branch, not across the chain.

A worked example

The figures are hypothetical. A branch sells 500,000 riyals before VAT in a quarter, at a cost of 350,000. Its gross margin is 150,000, or 30%. The quarterly count finds stock worth 7,500 riyals at cost missing, and the adjustment is charged to cost of sales. The margin falls to 142,500, or 28.5%. Spread across the chain, that 1.5 points disappears into the average, so look at the count results per branch and per category, and count the items most at risk more often than the rest.

The common error is posting count differences without a reason. A stock adjustment should name its cause and be approved by someone other than the branch manager, otherwise the adjustment becomes a way to make a shortage disappear. A regular counting routine is described in cycle counting.

Replenishment from the warehouse and suppliers

Store staff should not decide every order by looking at shelves. Set a minimum and reorder quantity per item, review them by season, and let the system propose transfers from the central warehouse or purchase orders to suppliers when stock falls below the minimum. Seasonal peaks, such as Ramadan, the school term and the end-of-year sales, need the levels raised weeks ahead, because suppliers face the same peak.

The reports that matter most are simple ones, such as sales and margin by branch and category, slow-moving and aging stock by branch, and the items most often out of stock. They tell the buyer what to move between branches before buying more. More on aging stock is in inventory aging.

E-invoicing at the till

Retail sales to consumers are simplified tax invoices under ZATCA’s e-invoicing rules. In the integration phase, simplified invoices are reported to ZATCA within 24 hours of being issued, while tax invoices to business customers must be cleared by ZATCA before they reach the customer. Every till that issues invoices has to produce them in the format ZATCA requires, so check that the POS and the ERP system together cover both invoice types before your wave starts. The background is in e-invoicing in Saudi Arabia.

Where Tranquil ERP fits

Tranquil covers the back office described above. Each branch and warehouse is a warehouse in the system, with locators for bins, and stock moves through Stock Transfer Request, Stock Transfer and Stock Transfer Receive. Items carry barcodes printed from Print Label, several units of measure each with its own price and minimum (limit) price, price lists, and a reorder and minimum quantity. Users can be limited to their own warehouse or price lists, and only authorized users can override the limit price.

Sales support cash sales, VAT-inclusive prices, bundles that deduct each component from stock, and customer rebates. Simplified invoices are signed with a QR code and reported to ZATCA, and Tranquil is ready for Phase 2 of e-invoicing.

Stock counts run through Stock Taking Management, and the sales reports include profit, top sales and salesman analysis. Tranquil’s documented features cover the back office, so if you need a till system or a connection to an online store, ask us what fits your setup. The inventory features are on the inventory management page, and if you want to see them with your own branches, request a demo.

Frequently asked questions

What is the difference between a POS and a retail ERP?

The POS runs the checkout, from scanning and payment to the receipt and the cashier’s shift. The ERP system runs everything behind it, including stock by branch, purchasing, transfers, costs, the accounts and VAT. A retailer needs both, either in one product or as a POS connected to the ERP system so that sales reach stock and the accounts automatically.

Does a retailer with one shop need ERP?

Usually not. A single shop with a good POS and accounting software is well served, as long as the two are connected. ERP becomes worth its cost with several branches, a central warehouse, an online store or imports, when stock has to be tracked by location and moved between them.

How should a retailer measure shrinkage?

Count stock regularly, value the difference at cost, and divide it by sales for the same period, branch by branch. Record a reason for every adjustment so that theft, damage, expiry and receiving errors can be told apart. A chain-wide average hides the branches where the problem is.

Do retail sales need e-invoices in Saudi Arabia?

Yes. Sales to consumers are simplified tax invoices, which must be generated electronically and, once the business is in the integration phase, reported to ZATCA within 24 hours. Sales to VAT-registered businesses are tax invoices that must be cleared by ZATCA before they are given to the buyer.

See what this article covers in Tranquil

In the demo we show what this article covers on Tranquil’s own screens and answer your team’s questions.

Dammam +966 13 848 8080, +966 13 817 7724, Riyadh +966 11 213 1330
[email protected]
Sunday to Thursday, 8 am to 5 pm.