A single source of truth for your business numbers means every number has exactly one system that owns it, and you read that number from that system (or from a view that pulls straight from it), never from a copy. For most small businesses that means money collected from the payment processor, orders from the store, website traffic from Google Analytics 4, the sales pipeline from the CRM and deadlines from the task tool.
The term comes from information systems, where a single source of truth is the practice of structuring data so that “every data element is mastered (or edited) in only one place” (Wikipedia: Single source of truth). You don’t need a data warehouse to apply it. You need two things: a decision about which system owns each number, and a one-line definition for each number. This guide gives you both.
What a single source of truth means for a small business
In a large company, a single source of truth is often a central database. In a small business, the systems you already pay for are the sources of truth. The job is to decide, number by number, which one wins.
Without that decision, the same question gets three answers. “How much did we make last week?” can mean the value of orders in Shopify, the charges that succeeded in Stripe, or the purchase revenue your site sent to GA4. All three are real numbers. They measure different things, so they will never match exactly.
With the decision made, “revenue” stops being a debate. You know where to look, and everyone who reports the number looks in the same place.
Which system should own each number
The owner of a number is the system where the underlying event actually happens. Money moves in the payment processor. Orders are created in the store. Page views are recorded by the analytics tag. Use this table as a starting point and adjust it to the tools you use.
| Number | Owner system | Why it owns the number | Official definition |
|---|---|---|---|
| Money collected, refunds, balance | Payment processor (Stripe) | It is where charges, refunds and payouts actually happen. | Stripe: Balance summary report |
| Recurring revenue (MRR) and churn | Billing system (Stripe Billing) | Stripe defines MRR as the monthly-normalized value of all active and past_due subscriptions, excluding taxes, free plans and metered products. | Stripe: Billing analytics |
| Orders and value of goods sold | Store (Shopify) | Shopify’s sales reports show the value of goods in each sale, not the money you received. Gross sales include pending, canceled and unpaid orders. | Shopify Help: Sales reports |
| Website traffic (sessions, users) | Google Analytics 4 | GA4 counts a session when a session_start event fires on your site. | Google Analytics: API dimensions and metrics |
| Sign-ups and other key events | Google Analytics 4 | You choose which events count as key events. Marking one only affects data from that moment on. | Google Analytics: API dimensions and metrics |
| Sales pipeline (open deals by stage) | CRM (HubSpot) | Deals, stages and stage probabilities live in the CRM pipeline. | HubSpot: Set up and manage object pipelines |
| Tasks and deadlines | Task tool (Trello, ClickUp or similar) | Due dates are set and changed on the task itself. | Trello: Add a due date or start date to a card |
| Channel views and subscribers | YouTube Analytics (YouTube Studio) | Views, watch time and subscribers gained are YouTube’s own metrics. | YouTube Analytics: Metrics |
| Profit, expenses and taxes | Accounting software (QuickBooks, Xero or your accountant’s system) | Only the books combine income with every cost. | Your accounting software’s own reports |
Two numbers need a tie-breaker because two systems both have a version of them:
- Revenue in a Shopify store paid through Stripe. Decide what the question is. “What did we sell?” belongs to Shopify. “What money came in?” belongs to the payment processor. Write down which one you mean when you say “revenue”.
- Revenue in GA4. GA4’s purchase revenue is whatever value your site’s tag sends with purchase events. Treat it as the owner of where sales came from (channels, pages), never as the owner of how much money you made.
Links checked September 28, 2026.
How to write a definition for every number
Owners settle where a number lives. Definitions settle what it means. Write one line per number and keep the list where you and anyone who helps you can see it. Each line has five parts:
- Name: the exact label you use in conversation, for example “Weekly revenue”.
- Owner: the one system you read it from.
- Rule: what is counted and what is left out, for example “succeeded charges minus refunds” or “orders, excluding canceled”.
- Period and time zone: Monday to Sunday or rolling 7 days, and one time zone for every tool.
- Who checks it and when: “me, Monday morning” is enough.
An example line: Weekly revenue = succeeded Stripe charges minus refunds, Monday to Sunday, in the business’s local time zone, checked by the owner every Monday. If a number can’t be written in one line, it usually means two different numbers are sharing one name. Split them.
What to do when two systems disagree
They will. When they do, the owner’s number is the one you report, and the difference becomes something to explain rather than something to argue about. Most gaps come from three causes: the tools count different events, they use different time windows, or they use different time zones.
For the step-by-step checks (checkout domains stealing credit in GA4, refunds that never reach analytics, key events that aren’t purchases, consent mode gaps), follow our guide to reconciling numbers when Stripe, GA4 and Shopify disagree. It includes a one-page reconciliation method you can run by hand.
Where Vexlynk fits
Vexlynk is not a new source of truth, and that is deliberate. It reads each number from the system that owns it and shows it as a live card on one board: Stripe for money, Shopify for orders, GA4 for traffic, HubSpot for the pipeline, Trello, Notion or ClickUp for work. Your data stays where it lives; nothing is migrated into a separate database. Most sources are read-only; a few (WhatsApp, Trello, ClickUp, Google Calendar) let you act from the card, only when you do it yourself — sending a message, or archiving, completing or deleting something, asks you to confirm first.
Accounting software such as QuickBooks or Xero is not a Vexlynk source, so profit stays in your books. The full list of 23 live sources shows which owners you can put on the board. The Free plan connects up to five.
Related guides
- Business dashboard examples by business type
- How to see your business numbers at a glance
- The research on app-switching costs
- What a visual workspace is
Frequently asked questions
What is a single source of truth, in simple terms?
It means each number has one official home. Revenue is read from one system, traffic from one system, and so on, and everyone uses that system’s figure instead of a copy in a spreadsheet or a screenshot.
Should Stripe or Shopify be the source of truth for revenue?
It depends on the question. Shopify’s sales reports show the value of goods sold, including pending and unpaid orders. The payment processor shows the money that actually came in. Pick one meaning of “revenue”, write it down, and use the other system only for its own question.
Why doesn’t my GA4 revenue match Stripe?
GA4 revenue comes from what your site’s tag sends, while Stripe records actual charges. Checkout redirects, refunds, ad blockers and consent choices all open gaps. Our guide to why dashboards show different numbers walks through the checks.
Do I need a data warehouse to have a single source of truth?
Not for most small businesses. Deciding which system owns each number and writing one-line definitions gets you most of the way. A warehouse starts to make sense when you need to combine raw data from many systems into custom reports.
Does Vexlynk become my source of truth?
No. Vexlynk reads each number from the system that owns it and shows it as a live card, so the owner stays the source of truth and you see every owner on one board.
Vexlynk
Vexlynk Team