110 Analytics. We load a retail or distribution business's tills, trade orders, stock, online shop, purchasing, delivery, accounts and payroll data into one data warehouse held in the business's own cloud account. Margin at each level, stock cover and availability are each defined once and every report reads them, with AI testing each overnight load against them. We sell no till or stock systems and give no pricing or buying advice, so your systems, suppliers and buyers keep their roles.
What an owner or buyer might say
With sales, stock and costs in different systems, the week can start like this.
- A trade customer's margin is only known once the year is closed.
- We know our best sellers by takings. Their margin is a guess.
- Slow stock sits at the depot until someone happens to notice it.
- Online and in-store sales are reported separately, so nobody sees a product's whole picture.
- Delivery costs arrive as fuel, wages and van bills at month end, never as a cost per drop.
- Each branch manager has a different idea of what a good week looks like.
Each system knows one stage of a product's life
A retailer or distributor in Malta runs on systems that each record one stage. Purchasing records what was ordered and at what cost, the stock system what arrived and where it sits, and the tills and the online shop what sold, at what price and after which discount.
Trade customers add their own orders, price lists, credit terms and invoices. Deliveries live in route plans or drivers' sheets, and the accounts and payroll hold the costs that decide whether any of it paid.
The decisions that matter cut across those records. Which lines tie up cash without earning it? Which branch is short of a product the depot holds plenty of, and which trade customers cost more to serve than they bring in?
Every branch and channel, connected and checked overnight
Overnight, each agreed system's data is read and copied into a data warehouse created in your own cloud account. Till sales, online orders, stock positions, purchase orders, supplier invoices, deliveries and costs land in one place, current to yesterday.
There, every product is matched across systems by its code, barcode or supplier reference, and every sale is tied to a branch, a channel and, for trade sales, a customer. Margin at each level, stock cover, availability and returns are each defined once with your buyers, branch managers and finance. AI then checks the night's entries against them: a till code that maps to no product, a delivery with no customer, a supplier invoice that differs from its purchase order, a stock level that went negative. Each lands with whoever entered it, to put right at source.
The owners start each morning in the 110 Command Centre, with every branch and channel on one screen. Your tills keep taking payments and your stock system keeps running the depot; the warehouse only reads from them.
Questions no single till or stock report covers alone
Each one combines data from two or more of the systems a product passes through.
Margin by product, branch and customer
Till, online and trade sales set against the landed cost of each line, so margin reads per product, outlet and trade account, not as one total.
Stock cover and ageing
Stock on hand set against the rate it sells, by location, with lines that have stopped moving flagged before they tie up more cash.
Availability where it is needed
Lines missing at a branch or online, set against what the depot or another branch holds, day by day.
Returns and their reasons
Returns from the tills, the online shop and trade customers grouped by product, supplier, branch and reason, beside the sales they reverse.
Delivery cost per drop
Drops per route from the delivery records joined to fuel, vehicle costs and driver hours from the accounts and payroll.
Supplier performance
Purchase orders against what arrived and when: short deliveries, lead times, and the margin each supplier's lines earn.
A product's life, stage by stage
- 1PurchasingOrdered
- 2Stock systemReceived
- 3TransfersMoved to a branch
- 4Tills and onlineSold
- 5DeliveriesDelivered
An importer with shops, an online store and two vans
Picture a family business in Malta that imports household and food lines, sells them through four shops and an online store, and supplies trade customers from one depot with two vans. The tills feed a stock system, the online store has its own platform, trade orders go into the accounts, and a spreadsheet plans deliveries.
- The buyer checks the till reports, the stock system and the online store before every reorder.
- Margin is known for the business as a whole at month end, not by product, shop or trade customer.
- A product sells out online while cases of it sit at the depot.
- Trade customers' prices and credit terms sit in the accounts, apart from the cost of serving them.
- Tills, online orders, stock, purchasing, trade invoices and the delivery spreadsheet are copied each night into a data warehouse in the business's own cloud account.
- Margin reads by product, shop, channel and trade customer, at each agreed level.
- Slow lines and items running low are flagged each morning against levels the buyer set, and the decision to order stays the buyer's.
- Each van's costs sit against its drops, so the cost of serving each route is visible.
The tills, the stock system and the online platform stayed exactly as they were. The buyer, the shop managers and finance now open the morning on the same figures.
What has to line up before margin can be trusted
Buyers, branches and finance can each be right about margin on their own terms. The audit sets their versions side by side, and your team decides once which one each report leads with.
| Figure | Where it usually starts | What the business decides |
|---|---|---|
| Margin | Tills, purchasing and the accounts | Which level each report leads with: intake margin, planned when the line is bought; achieved margin, after markdowns and discounts; or net margin, once supplier rebates, stock loss and any freight not already in the landed cost are counted |
| Landed cost | Purchasing and the accounts | Which freight and other costs of landing the goods are added to each line, and when supplier rebates and settlement discounts are counted |
| Product | Tills, online shop, stock system and supplier lists | How a till code, an online code and a supplier code map to one product, and how cases and single units relate |
| Stock on hand | Stock system and stock counts | Which count stands, when transfers between branches take effect, and how returns and damaged goods come back into stock |
| Availability | Stock system and online shop | When a line counts as unavailable at a branch or online, and whether stock held at the depot counts |
| Cost per drop | Delivery records, accounts and payroll | How vehicle, fuel and driver time are spread across the drops on a route |
Four steps to the first report
- Strategy callHalf an hour with Glen, at no cost. Describe your shops, channels and systems and the question you keep asking; the call ends with a plain view on whether an audit is worth it.
- Data auditAround three hours with Glen and the owner, the buyer, finance and whoever runs the depot. Each source and spreadsheet is traced, and a quote follows.
- BuildAccess to each system you name, read-only wherever possible; loads every night; products and pack sizes matched; margin and stock definitions approved by your team. Expect a live screen three to four weeks after you sign off the quote.
- Fractional data teamA senior team then runs the loads and the checks, adds each new shop, channel or supplier feed, and answers the next question. Bigger programmes can bring in our partner network.
What we do not do
- We give no pricing, merchandising or buying advice; ranges, prices and orders stay your team's decisions.
- We do not sell, install or support tills, stock systems, e-commerce platforms or route planning tools.
- Nothing is ordered for you, and we never write into your systems.
- We do not run payroll; shop and driver costs are read as totals wherever possible, and pay detail reaches only the roles you clear.
Glen Sultana founded 110 Analytics after a career built where the numbers move daily. Our people have run analytics for tier-one companies, S&P 500 firms and high-growth technology businesses. Glen is the person on the first call, and he runs every data audit himself.
- Built in your environment, under your account
- Every connection approved by you first
- Based in Malta
Straight answers
Do our tills and stock system stay as they are?
Yes. The tills, the stock system and the online shop keep running as they do today; the reports are built on the copy taken from them each night.
Our till system already has dashboards. Why add a warehouse?
Keep using them for the till's own sales. Margin after freight and rebates, the cost of each delivery and comparisons with the online shop need data held in other systems, such as the delivery records and the accounts, and the warehouse is where they meet.
Our shops and our online store run on different systems. Can they be compared?
Yes. Both load into the same warehouse, products are matched across them, and the same margin definitions cover both, so a product's shop and online sales sit side by side.
Can it tell us what to reorder?
It can flag lines that fall below the levels your buyer sets, with stock elsewhere and recent sales beside them. The levels are your team's, and so is the decision to order.
Are the figures live during the day?
No. Loads happen overnight, which means each morning's reports cover yesterday and everything before it. What is happening on the shop floor today stays with the tills themselves.
How is the data read from our systems?
Each system is read the way it allows: through its interface, a connector, a link to its database, or a file it exports on a timetable. The audit picks the route, our access only reads wherever the system makes that possible, and nothing connects until you approve it.
What does it cost?
A quote follows the data audit and rests mainly on how many systems, shops and channels there are to join. The cloud provider charges warehouse running costs to your own account.
Retail and distribution terms, plainly
- Landed cost
- What a product costs once it is on your shelf: the supplier price plus freight and the other costs of getting it there.
- Achieved margin
- The margin on what actually sold, after markdowns and discounts, as opposed to the intake margin planned when the line was bought.
- Stock cover
- The number of days or weeks the stock on hand would last if sales carried on at the agreed recent pace.
- Cost per drop
- What one delivery to one customer costs once vehicle, fuel and driver time are shared across a route.
- Data warehouse
- Not a building with shelves. A copy of each system's data, held in your own cloud account, refreshed every night and organised for reporting.