What don’t I know that I don’t know?

Why unknown unknowns cause the biggest business failures

Known problems are manageable. You see declining revenue, you work to fix it. You notice cash getting tight, you cut expenses or collect receivables. Even blind spots, once revealed, become known problems you can address.

Unknown unknowns are different. These are the risks and patterns you are not even aware exist. Your largest client's industry is entering a downturn, and they will cut your contract in 90 days. Your cost per lead has been rising 5% per month for a year, and you have never calculated it because the data lives in two different systems. A new competitor is offering your core service at half the price, and three of your clients have already started evaluating them.

You cannot eliminate unknown unknowns entirely. But you can dramatically shrink the territory where they hide.

A framework for finding what you do not know you are missing

Unknown unknowns hide in three places. By systematically checking each, you convert unknowns into known items you can act on:

• In the gaps between systems. Your accounting knows revenue. Your CRM knows pipeline. Your ad platform knows cost per click. But nobody is looking at the relationship between all three. A rising cost per acquisition only shows up when you connect ad spend to actual closed deals.
• In longer time horizons than you normally check. Most owners look at last month vs. this month. Trends that develop over 6-12 months are invisible at that zoom level. A slow 2% monthly margin decline is nothing in any single month, but it is a 24% annual decline that changes everything.
• In metrics you have never calculated. Customer lifetime value. Cost per acquisition. Revenue per employee. Gross margin by service line. These are not in any default report. They require combining data from multiple reports, and most owners have never computed them.

How to search for unknown unknowns in QuickBooks Online (5 steps)

This exercise is deliberately different from a normal financial review. You are looking for things you do not normally look at. Set aside 40-60 minutes.

1. 1
   Go to Reports → Profit and Loss (12-month view)

   Set the range to the last 12 months. Click Customize, change “Display Columns By” to Months. Now look for patterns you have never noticed: which month had the lowest revenue? Which expense category has grown the most over the full year? Calculate the percentage change from the oldest to the newest month for every major expense line.

2. 2
   Calculate metrics you have never calculated

   From the 12-month P&L: divide total revenue by the number of employees (revenue per employee). Divide total advertising spend by the number of new customers acquired (cost per acquisition, if you track new customers). These numbers often reveal surprises.

3. 3
   Go to Reports → Sales by Customer Summary (12 months)

   Look at your full customer list for the year. How many clients from 12 months ago are still active? How many stopped ordering and you did not notice? Calculate your retention rate: customers active now divided by customers active 12 months ago.

4. 4
   Look at revenue by income category

   If you have multiple income categories (different services or product lines), calculate gross margin for each by allocating COGS proportionally. You may discover one service line has much higher margins than another, or that a growing service line is actually your least profitable.

5. 5
   Cross-reference with your CRM and ad platform

   Open your CRM and check: how many deals are in your pipeline right now vs. 3 months ago? Open your ad dashboard: what is your cost per click or cost per lead now vs. 6 months ago? These numbers often tell a completely different story than your P&L.

How to search for unknown unknowns in Xero (5 steps)

Same discovery framework, using Xero's reporting tools.

1. 1
   Go to Accounting → Reports → Profit and Loss

   Set the range to the last 12 months and use the comparison feature to display all months. Scan every expense category for gradual changes you never noticed. Calculate the year-over-year change for each major line item.

2. 2
   Calculate derived metrics

   Revenue per employee. Total ad spend divided by new customer count (if available). Average transaction size (total revenue divided by number of invoices). These numbers often reveal patterns invisible in standard reports.

3. 3
   Go to Accounting → Reports → Income by Contact

   Set the range to 12 months. Compare the client list to 12 months ago. Who stopped ordering? Who reduced their order frequency? Calculate your customer retention rate.

4. 4
   Break down profitability by tracking category

   If you use Xero's tracking categories for different departments or service lines, run the P&L by tracking category. This reveals which parts of the business are actually profitable and which are being subsidized.

5. 5
   Cross-reference with external systems

   Check your CRM pipeline count and velocity, your ad platform cost per lead, and your payment processor chargeback rate. Each of these tells you something your books cannot.

What it takes to systematically reduce your unknown unknowns

This is the hardest financial exercise for a business owner. Here is why:

• You are looking for things you do not know to look for. Unlike a routine financial check where you know which reports to pull, this exercise requires creativity and pattern recognition. It is hard to systematize.
• Cross-system analysis requires manual work. Connecting your accounting data to your CRM data to your ad platform data means exporting from three systems, aligning the data, and looking for relationships. There is no button for this.
• Derived metrics require calculation. Revenue per employee, cost per acquisition, and customer lifetime value are not in any standard report. You need to build them from raw data every time.
• The biggest unknowns are often non-financial. Market shifts, competitive moves, changing customer needs. Your accounting data can hint at these (declining orders from a segment) but cannot explain them.

Or let cross-system analysis reveal what you are missing

Bottomline connects to your QuickBooks or Xero account, your CRM, your ad platforms, and your payment processor. It automatically cross-references data across all of these systems to surface patterns, correlations, and anomalies that would take hours of manual analysis to discover.

None of these three insights exist in QuickBooks, Xero, your CRM, or your ad platform individually. They only appear when you connect the data across systems. That is what Bottomline does automatically, every month, without you needing to know what to look for.