How to See All Your Business Data in One Place
5 minutes What you get for it:
- Know why your reports disagree and which one to trust
- Wire the three sources that matter first, in order
- Run three questions that prove you have one place
The short answer. Copy your data from each tool into one shared store on a schedule. Give every number one definition. You keep QuickBooks, your ERP and your CRM. Wire sales first, then cash, then customers. Test it with three questions you can answer in under a minute.
By Harsh Patel. Updated .
Jump to a section
Why do three reports give me three different numbers?
Each report follows its own rule for what counts. Sales from the ERP, sales from QuickBooks and sales from the sheet your controller keeps can all be right and still disagree.
Here are the usual causes:
- One counts a sale at quote. One counts at order. One counts at invoice.
- One uses ship date and one uses invoice date.
- One includes freight, credits and returns. One does not.
- One was exported last Tuesday.
Owners put it this way: “I cannot get a single trusted picture of the business without chasing five people.” You are not chasing five people for data. You are chasing five people for their definition.
What does “one place” mean?
One place means one shared copy of your data with one written definition for every number. It refreshes on a schedule. It does not mean one new system.
You keep what you run today. QuickBooks keeps the books. NetSuite or your ERP keeps orders and inventory. HubSpot keeps deals. Shopify keeps web orders. Excel keeps what Excel keeps.
Think of a read-only mirror. Data flows from each tool into one store. Nothing flows back. Nobody retrains. Nobody migrates. If the mirror breaks, your business still runs.
The store matters less than the rules. “Revenue” gets one definition. “Active customer” gets one definition. “On time” gets one definition. Write each on a single page. That page is the real asset.
Which sources do I wire first?
Wire sales first. Wire cash second. Wire customers third. Three sources answer most owner questions, and each one builds on the one before.
- Sales and invoices. From your ERP or accounting tool. Every other number depends on it. Start with order date and customer. Add product, quantity, price and cost.
- Cash and receivables. From QuickBooks or your ERP’s AR aging. This tells you who owes you and for how long.
- Customers and deals. From your CRM or your inbox. This tells you who is quiet and which quotes are going stale.
Add inventory, purchasing and shipping next. Add the spreadsheets last, and only the ones that run something. Our guide on which spreadsheets to keep covers how to choose.
Do not start with the messiest source. Start with the one you trust most. A trusted first source gives you a number to check the others against.
What do I do before I wire anything?
Write the five definitions your company argues about. Do it on paper this week.
Use this template for each:
Number: Revenue
Counts when: the invoice is posted
Includes: freight, surcharges
Excludes: credits until they are applied, quotes
Owner of the definition: (one name)
Source tool: (one tool)Pick the five numbers that start a meeting with “which report is right.” The usual five are revenue and margin. Add active customers, open orders and past-due AR.
Get your controller and your ops lead to sign each one. If they disagree, you found your real problem. That argument is cheaper now than after the build.
What are the three questions that test it?
You have one place when you answer these three questions in under a minute. Use one screen and make no phone calls.
- Which customers ordered every month last year and have not ordered in the last 60 days? This tests sales history and customer data together.
- Who owes us more than 60 days, and what else did they buy this quarter? This tests cash and sales together.
- Which product sold below its usual margin last month, and to whom? This tests sales and cost together.
Each question crosses at least two tools. That is the point. A single tool can answer a single-tool question. One place answers the questions that live between tools.
Ask your team the same three questions today. Time them. A week and three people means you do not have one place yet.
If you want your numbers to start from a list, see the 12 numbers every owner should know. It tells you what to ask first.
What comes after one place?
Clean data comes next, then AI on top. AI on scattered data gives the wrong answer faster, so the order matters. We lay out the sequence in why AI gives wrong answers on messy data.
If you want this built for you, the Business Brain is the name we use for the one place plus the questions you can ask it. You can do the first step with a pen and this page.
Questions owners ask
Do I need to replace my ERP to see everything in one place?
No. You read from the ERP and the other tools and copy the data into one store. The tools keep doing their jobs.
Why do my sales numbers differ between reports?
Each tool counts differently. One report counts quotes as sales. Another counts by ship date. A third counts by invoice date. The numbers are all correct for their own rule.
Is a spreadsheet a place?
A spreadsheet is a place for one person. One place for the company needs a single copy of the data that every report reads from, with the rules written down.
How long does it take to wire the first source?
Sales and invoices from your ERP or QuickBooks are the first. Plan on days for the first source, not months. The slow part is agreeing on definitions.
Read next
The free Business Brain Audit. 45 minutes.
Want this running on your whole business?
An agent sees only what it can reach. The Business Brain wires your ERP, CRM, inbox and sheets into one place. In 30 days we find at least 1% of your yearly revenue in your own data, or month one is free.
For owners of $5M+ operations companies. Harsh takes every call.