Blog

Operations

A single source of truth for business data, in plain terms

A POS, a stock sheet, an accounting package and a WhatsApp group give you four versions of the same week. Here's what one looks like, and how to get there.

A single source of truth for business data means every figure, from yesterday's sales to the stock on the shelf, is entered once and linked to the document behind it. Then the till, the stock and the books always agree. A business that runs on a POS, a stock spreadsheet, an accounting package and WhatsApp has four versions of the same week, and someone matches them by hand.

What does running on separate tools cost you?

In an invented example, the owner asks on Monday how last week went at the Marina branch, and gets three answers.

  • The till says AED 96,600. The week's sales, with VAT.
  • The accountant's file says 92,000. The same sales, without VAT.
  • The manager's WhatsApp says 82,800. Sent a day early, so the last day's 13,800 isn't in it.

All three are right, but none answers the question, and working out why they differ takes the first hour of the week. The stock sheet was last updated at the count, so the milk order is placed from memory.

In this example the manager spends three hours every week matching the till to the sheets. That's 156 hours a year, nearly four working weeks, spent checking numbers instead of acting on them.

Decisions wait too. When the books close weeks after the month ends, prices and orders are set on numbers that are already a month old.

Why do the numbers never agree?

Because each tool keeps its own copy, on its own clock, by its own rules.

  • The POS knows what sold and when, but not what it cost or what's left on the shelf.
  • The stock sheet knows what was counted, on the day it was counted, and nothing since.
  • The accounting package knows money. It sees a bill paid, not the milk it bought or the drinks the milk went into.
  • WhatsApp knows the wholesale orders nobody typed in, until someone scrolls back to find them.

Between them, a person retypes figures, and each retype is a chance for a typo, a delay or a different definition: with VAT or without, by sale date or by payment date.

What is a single source of truth for business data?

Each event is entered once, where it happens, and everything else reads from it. Stock, sales and the books move together, because they are the same data seen from three sides.

Take one invented cup at the Marina branch. A flat white sells for AED 19.00. The sale arrives from the till, and with it:

  • Stock falls by 18 g of coffee, 150 ml of milk, a cup and a lid.
  • The cup's cost is known: AED 2.47, from the supplier bills and the roast that made the coffee.
  • The books show 18.10 of sales, 0.90 of VAT and 2.47 of cost of sales.

No one retyped anything, and each number can be traced back: from the cost of sales to the cup, from the cup to the recipe, from the coffee to the roast and the supplier's bill. That trail behind each figure matters, because a number alone tells you very little.

The difference shows in the questions you ask every week.

Question On separate tools On one source
How did last week go? Three figures and an hour of matching One figure per branch, with VAT shown apart
What is the stock worth? Whatever the last count said Today's stock, at real cost
Why did margin fall? A guess, then a week of digging Traced to the bill or recipe that moved it
Who owes us? The accountant's file, if it's current Every open invoice, as of today

Does one version of the truth mean one system for everything?

No. Your tills, your online store and your WhatsApp chats can stay as they are. What changes is where their data goes.

The till stays where the sale happens, and each sale is sent on line by line, dated the day it happened. WhatsApp stays where you talk to customers, and an order sent there is entered once as a sales order instead of staying in a chat.

In Seyaqi, for example, sales arrive line by line: from Foodics and Shopify every hour, and from Sapaad in the day sheet you upload. The tills keep running as they are.

What are the signs you've outgrown separate tools?

  • The same week has more than one sales figure, and explaining the gap is a weekly job.
  • A supplier raised a price and nobody noticed until the margin fell.
  • The count and the sheet disagree, and nobody can say where the difference went.
  • A wholesale order was missed or sent twice, because it lived in someone's chat.
  • Month-end takes longer every month, and the numbers arrive after the decisions they were meant for.
  • One person knows how the files connect, and the business slows down when they're on leave.

Two of these are a nuisance. Four are a cost you pay every week. If you're deciding what comes next, read our guide to what an ERP is and whether you need one.

How do you move to one source without stopping the business?

  1. Keep the tills running. Sales arrive line by line from the day you start: from Foodics and Shopify every hour, or from Sapaad's day sheet, and any other system is quoted as an integration. Nobody at the counter has to learn anything new.
  2. Start from the files you have. Price lists, supplier invoices and the stock sheet, as they are, with no templates to fill in first.
  3. Start on the first of a month. Count the stock that day, and take opening balances from your last trial balance.
  4. Run the old way alongside for one month. Where the old sheet and the new system differ, trace the new figure back to see why.
  5. Retire the sheets one at a time. Stock first, because it goes wrong fastest. Then the WhatsApp orders, then the month-end workbook.

Seyaqi is built on this idea. Stock, production, purchasing, sales, cash, payroll and the books run in one system, and every journal entry links back to the document that caused it. See everything Seyaqi runs, or get a quote.

Common questions

Why don't my POS sales match my accounting software?

Usually because they count different things: the POS shows sales with VAT, on the day of the sale. The accounts may show them without VAT, by payment date or later. When both read from one source, the gap disappears or is explained line by line.

Do I have to replace my POS to get a single source of truth?

No, your tills keep running as they are. Foodics and Shopify sales arrive in Seyaqi line by line every hour. Sapaad sales are read from the day sheet you upload.

How do I switch systems without stopping the business?

Keep the tills running and connect them. Start from the files you already have, on a clear date such as the first of a month. Run the old way alongside for a month, then drop the spreadsheets one at a time.

What is the difference between a single source of truth and a data warehouse?

A data warehouse copies data from several systems into one place for reports, so the sources can still disagree. A single source of truth records each event once, where the work happens. Stock, sales and the books then agree from the start.

Every number in your business, in context.

Seyaqi runs stock, production, purchasing, sales, people and the books in one system, with an AI Advisor that reads it all every night and tells you what needs you.

Book a demo Get a quote

Read next