Your business probably already generates records in five places: accounting software, payment or POS systems, banking, scheduling tools, and Google Business Profile. Depending on the platform and permissions, those records may reveal unpaid invoices, customer concentration, transaction patterns, cash timing, booked capacity, and local-search demand. You can test many in a spreadsheet without buying analytics software, although not every system provides a clean spreadsheet file or every field required for every metric.
If you run a small business, you have probably been told that getting value from data starts with new software: a dashboard subscription, a data warehouse, or an integration service. For most businesses with two to 25 employees, that is the wrong starting point.
The records already exist. Each time you send an invoice, run a card, clear a deposit, book an appointment, or get a call from your Google listing, a system you already use stores a date, an amount, and often a customer or status. The first job is not buying a tool. It is learning what those records contain, how to get them out, and which questions they can honestly answer.
What Business Data Do I Already Have Without Buying New Tools?
Your business already generates or controls access to financial, sales, scheduling, and customer-demand records. What you can learn from them depends on the fields, history, permissions, and export options each source provides.
Business data usually shows up in one of three forms:
- Dashboard summaries: The charts and totals on your software's home screen. They are useful for a quick check, but the numbers are already added up, so you cannot see which invoices, days, or customers drove them.
- Record-level reports and exports: Files where each row is one transaction, invoice, appointment, or interaction. This is usually the best starting point, because you can sort, filter, and total the rows yourself. They are often downloaded as a CSV (a plain-text file of rows and columns that any spreadsheet opens) or an Excel file.
- Portable archives: Backup or transfer formats such as Google Calendar's
.icsfiles. They preserve the records, but they open as raw text in a spreadsheet and need conversion before analysis.
The table below covers the five sources most small businesses already use.
The Existing Data Inventory Matrix
| Source Category | Example Records | Three Questions It May Answer | Example Export Path & Format | Important Limitation |
|---|---|---|---|---|
| Accounting and invoicing | Invoices, payments received, customer balances, vendor bills, expenses | 1. Who owes us money, and how overdue is it? 2. How much of our sales come from our largest customers? 3. Which vendor costs have changed over the past year? |
QuickBooks Online: Reports → Standard reports → open a report (e.g., A/R Aging Summary or Sales by Customer Detail) → Export/Print → Export as CSV or Excel | Report availability and customization vary by subscription and interface version. |
| Payment processor or POS | Transactions, items sold, refunds, fees, timestamps | 1. What is our average transaction value by day of the week? 2. Which hours bring in the most sales? 3. How much do refunds and processing fees take each month? |
Stripe: Reporting → Financial reports → Balance summary → Download (CSV) Square: Reports → select report → export icon (CSV) |
Some Square reports cannot be exported. Repeat-customer analysis requires a stable customer identifier (an ID that stays the same across visits). |
| Online banking | Deposits, withdrawals, descriptions, balances | 1. When does cash actually arrive? 2. Which charges recur every month? 3. Do deposits line up with processor payouts? |
Chase Connect (example only): Account Activity → Download Options → CSV, PDF, or Excel | Paths, formats, and history limits vary by bank and account. Bank activity shows cash movement, not revenue or profit. |
| Scheduling or booking | Appointment start and end, creation time, invitee status, service type | 1. How far ahead do customers book? 2. How many hours are booked each week? 3. Where do cancellations cluster? |
Google Calendar: Settings → Import & export → Export (ZIP file of .ics files) |
Not spreadsheet-ready, and permissions or an administrator may restrict export. No-show, capacity, and channel analysis require consistently recorded statuses, defined available hours, and a lead-source field. |
| Google Business Profile | Searches, views, calls, website clicks, direction requests | 1. How are people finding us? 2. Which interactions are rising or falling? 3. Which periods show stronger local demand? |
Business Profile Manager: select profile(s) → Actions → Insights → select timeframe → Download Report (spreadsheet) | Interactions are not confirmed leads, sales, or revenue. Available metrics vary by business. |
Each source describes a different step in the same cycle: people find you, book time, pay, get recorded in your books, and turn into cash in the bank. Because each system measures a different step, evaluate each one on its own terms before expecting them to agree.
What Can Accounting, Payment, and Bank Records Tell Me?
Accounting, payment, and bank records show what was invoiced, what was collected, what moved through your accounts, and when those events occurred. They all deal in dollars, but they answer different questions and should not be treated as interchangeable versions of revenue.
Accounting and Invoicing Records
Your accounting software is the system of record for what you billed and what you owe. Beyond the profit-and-loss statement, it supports three useful analyses:
- Customer concentration: Export Sales by Customer Detail for the last twelve months, total sales by customer, and calculate each customer's share. There is no universal danger threshold. The real question is whether losing your largest one or two accounts would affect payroll or debt payments.
- Unpaid invoices and payment timing: The A/R Aging Summary groups open balances by how overdue they are. If invoice dates and payment dates are both recorded reliably, you can also calculate average days to pay. When that number moves from 24 days to 41, cash tightens even while sales look healthy.
- Vendor cost changes: Compare the same vendor and expense category across matching periods, such as the first quarter of this year against the first quarter of last year. Before calling it a price increase, check quantity: higher spending on materials or tooling may reflect more jobs or more scrap, not higher prices.
Limitation: Report availability and customization vary by subscription and interface version. Confirm the report you need exists on your plan before building a routine around it.
Payment Processor and POS Records
Payment processors and point-of-sale systems such as Stripe and Square may record each sale with an amount and a timestamp. When those fields are available, these records are a useful source for patterns by day and hour:
- Average transaction value by day and hour: This requires record-level amounts and timestamps. In restaurants and other hourly businesses, it shows whether your busiest hours are also your highest-value hours, or only your busiest.
- Refund and fee burden: Define the calculation before running it. Fee rate is total processing fees divided by gross charges for the same month. Refund rate is total refunds divided by gross charges for the same month. A changing fee rate may reflect processor pricing, payment method, or transaction mix. A rising refund rate is a reason to investigate products, fulfillment, or service, not proof of a particular cause.
- Repeat purchase interval: If checkout captures a stable customer identifier, such as an email address, customer record, or member ID, you can calculate the median number of days between a customer's first and second purchase.
Limitation: Anonymous cash and guest transactions cannot support repeat-customer analysis. If your checkout does not collect an identifier, do not try to infer return visits from card types or amounts.
Online Banking Records
Your bank records the cash that actually posted to your accounts:
- Deposit timing: Comparing deposits with processor payout dates shows the lag between a sale and usable cash, including weekend and holiday delays. That helps you time payroll and vendor payments.
- Recurring outflows: Sorting withdrawals by description surfaces subscriptions, leases, and recurring fees. Treat the result as a follow-up list: contracts, invoices, or software administration records are needed to confirm whether a charge is still necessary or duplicated.
Limitation: Bank activity shows cash movement and nothing more. A deposit may be a loan disbursement, a customer deposit, or sales tax you collected. A withdrawal may be a loan payment or an owner draw rather than an expense. Download formats and history limits vary by bank.
Why These Three Systems Rarely Match
Your processor's monthly sales, your accounting revenue, and your bank deposits may not agree, and that does not necessarily mean your books are broken:
- A processor report may show gross charges, refunds, fees, net activity, or payouts, depending on the report selected.
- An accounting report may show invoiced or recognized revenue, depending on the report, configuration, and accounting method.
- A bank export shows posted deposits, whose amounts and dates depend on payout settings, fees, refunds, batching, and settlement timing.
Forcing these numbers to match in one spreadsheet without documented reconciliation rules creates more confusion than insight. For now, let each source answer its own question: accounting shows what was billed and owed, the processor shows how customers paid, and the bank shows when cash arrived.
What Can Scheduling and Local-Search Records Tell Me?
Scheduling records may show when work is booked and how far ahead customers reserve; Google Business Profile may show how people find and interact with your business. Both are demand signals, not proof of completed sales.
Scheduling and Booking Records
If you use a booking tool or shared calendar, your appointment records may support three analyses:
- Booking lead time: The time between when a booking was created and when the appointment starts. This requires both fields. If lead time shrinks from three weeks to four days, it may be an early sign of softening demand before revenue reflects it.
- Booked hours: The total duration of consistently categorized service appointments. This is booked time, not utilization. Utilization requires first defining your available hours, such as staffed hours minus breaks and administrative time.
- Cancellations and no-shows: These are available only when cancellation and attendance statuses are recorded consistently. Once they are, group them by weekday, service type, or staff member. Analyzing cancellations by marketing channel also requires a lead-source field.
Limitation: Statuses need to be recorded when they happen. If staff update appointments in a batch at the end of the day, timestamps cluster and distort the analysis. Google Calendar exports only .ics archives, so leave it out of your first spreadsheet test. Many booking tools offer appointment exports; check your tool's help documentation for the current path and format.
Google Business Profile
Google Business Profile shows how people find and interact with your listing, without installing any tracking code:
- Searches: How often your profile appeared in search results. The Performance view may also list the search terms that surfaced your profile; check whether your downloaded report includes them.
- Views: How many times people viewed your profile over the selected period.
- Interactions: Counts of calls, website clicks, direction requests, and other actions available for your business type.
Limitation: A tap on the call button does not prove a conversation happened, and a direction request does not confirm a visit. Compare consistent periods, such as month over month or the same quarter last year, and treat the results as demand trends rather than revenue inputs.
How Do I Test One Export in a Spreadsheet?
Choose one business question and one source, download a detailed CSV or Excel report, preserve the untouched file, and test whether its rows, dates, identifiers, and amounts can support the question.
The most common mistake is trying to build a master dashboard on day one: six months of bank records, four QuickBooks reports, and a Stripe file pasted into one workbook. The result is broken lookups, mismatched dates, and totals that disagree. Start with one source instead.
This is a manual, periodic process. You download a fresh file weekly or monthly; nothing updates on its own.
The 30-Minute Single-Source Test
Use whichever spreadsheet program you already have: Google Sheets, Microsoft Excel, or LibreOffice.
Step 1: Define One Question (5 Minutes)
Write down one question with a practical business consequence before opening any software. For example:
- Invoicing: "Which five customers accounted for the largest share of invoiced sales over the last twelve months?"
- Payments: "What was our average transaction value on Saturdays compared with Tuesdays last month?"
- Banking: "How much did we pay in recurring subscriptions over the last 90 days?"
Name the period and define your terms. For example, does "sales" include refunds and sales tax?
Step 2: Export and Preserve the Raw File (5 Minutes)
Use the platform's documented report or export menu, and choose CSV or Excel over PDF when both are available. Then:
- Save the file in a dedicated folder, such as
Data_Exports/2026-Q3/. - Rename it with the export date, source, and report, such as
2026-09-12_QBO_SalesByCustomerDetail_RAW.csv. - Record the source, report name, filters, date range, and export date in a short note saved beside the file.
- Open a copy and save it as a workbook, such as
..._WORKING.xlsxor a Google Sheet. A CSV file cannot store pivot tables or multiple tabs.
Never edit the raw file. An untouched original lets you retrace your steps if a formula or deletion goes wrong.
Step 3: Inspect Before Cleaning (10 Minutes)
Check the working copy against basic tidy data principles, as described by statistician Hadley Wickham: each variable in its own column, each observation in its own row.
- One kind of record per row: Each row should be one invoice, transaction, or appointment, not a group header or subtotal.
- One variable per column: Date, customer or ID, amount, and status should each have their own column.
- Presentation rows: Many exports, including QuickBooks reports, add title rows, blank separator rows, and totals.
- Duplicates and gaps: Sort by date and look for repeated rows or missing weeks and months.
- Dates: Confirm the spreadsheet recognizes dates as dates, not text, and note the format used.
Here is what that difference looks like, using invented sample data.
As exported:
| A | B | C | D |
|---|---|---|---|
| Sales by Customer Detail | |||
| January–December 2025 | |||
| Customer | Date | Invoice | Amount |
| Acme Supply | |||
| 01/14/2025 | 1041 | 2,400.00 | |
| 03/02/2025 | 1057 | 1,150.00 | |
| Total for Acme Supply | 3,550.00 |
Ready for analysis:
| customer | invoice_date | invoice_number | amount |
|---|---|---|---|
| Acme Supply | 2025-01-14 | 1041 | 2400.00 |
| Acme Supply | 2025-03-02 | 1057 | 1150.00 |
Step 4: Clean and Answer the Question (10 Minutes)
In the working copy:
- Delete title, blank, subtotal, and total rows so that row 1 holds only column headers.
- Fill down group values, such as the customer name, so every row carries its own customer.
- Give each column one unique header and unmerge any merged cells.
- Add a new date column in
YYYY-MM-DDformat and keep the original date column unchanged. - Insert a pivot table with customer in Rows and amount in Values (set to
SUM), then sort in descending order. To see each customer's share, show values as a percentage of the grand total. - Check the pivot table's grand total against the report's total. If they differ, find out why before trusting the answer.
Keep This Test Inside Your Spreadsheet
Do not paste unredacted customer lists, payroll data, or financial exports into consumer AI chatbots to clean or summarize them. Whether any AI tool is appropriate depends on the account type, its data settings, and your obligations to customers and employees.
Do Not Combine Sources Yet
Resist merging this file with exports from other systems. Combining sources requires agreed definitions, matching keys, and documented reconciliation rules, and that work belongs after a source audit. A well-structured single-source spreadsheet can answer a surprising number of small-business questions. For how far that can take you before you need specialist help, see Do You Need a Data Analyst or Better Spreadsheets?
If one export answers a real question in thirty minutes, you have confirmed that your existing systems hold usable records, with no new software purchase.
When Are the Records or Existing Tools Not Enough?
Existing tools are not enough when the required records are missing, inaccessible, too aggregated, inconsistently defined, or too difficult to maintain at the frequency and level of control the decision requires.
Native exports are a sound, low-risk starting point, but they are not a permanent answer for every business. Watch for these signs:
- You cannot get record-level data. The system offers only summaries or PDFs, or an authorized person cannot get access. A common example is an account owned by a former employee or an outside bookkeeper that the company cannot recover.
- Required fields are missing. The export lacks the date, status, amount, or stable identifier your question depends on.
- History is missing or definitions conflict. The platform keeps only limited history, or "sales" means one thing to the office and another to operations.
- Differences between systems cannot be explained. Gaps between processor, accounting, and bank totals cannot be traced to documented timing, fee, refund, or accounting-method rules.
- The process depends on one person. The report is late, or it breaks whenever the person who builds it is out.
- Control needs outgrow the workflow. Multiple locations, entities, or users edit the same file, or sensitive customer data travels by email attachment.
There is no universal row count or hours-per-week cutoff. Whether a spreadsheet is still the right tool depends on its formulas, how consistent the sources are, how many people use it, how often it must update, and what happens if it is wrong.
The Next Step: Audit Your Sources
If you recognize one or more of these signs, the answer is not to buy a business intelligence subscription right away. First, document what you have: which sources exist, who owns access, how much history each keeps, and which fields are complete. Take the inventory from this article and work through The Small Business Data Audit Checklist.