10 Places Cash Hides in Your Business Data

Where does cash hide in my business data?

Cash hides where one system holds half of a fact and nobody joins it to the other half. Owners say it this way: “I know we are leaving money on the table. I cannot see where.”

The ten places below are ranked by how fast you can act on them this week. Each has one question. Run it on an export from your ERP, QuickBooks or CRM. Any dollar figure in this guide is an example, and the arithmetic is printed under it.

The ten places

1. Aging AR with no chase order

Ask: “Who owes us over 60 days, and who has called them?” Rank by amount. The list tells you who to call first. Call this week.

2. Quotes aging out

Ask: “Which quotes from the last 90 days have no order and no follow-up?” These buyers asked for a price. Someone should own each one.

3. Customers who went quiet

Ask: “Who ordered on a regular rhythm and stopped?” Flag anyone past 1.5 times their usual gap between orders. See the 12 numbers for the formula.

4. Unbilled work and dropped line items

Ask: “Which shipped orders have no invoice or miss a line for freight or surcharges?” Compare the shipping log to the invoice lines.

5. Credits and returns never matched

Ask: “Which credit memos have no link to an original invoice?” Open credits can sit for months and drift into write-offs.

6. Price and margin drift

Ask: “Which customers still pay a price from two years ago, and which products sell below their margin floor?” Cost goes up and price stays put.

Example only, not a client result: a product costs $8.00 and sells at $10.00. Cost rises to $9.00 and the price stays. Margin falls from $2.00 to $1.00 a unit. At 5,000 units a month, that is $5,000 a month ($1.00 x 5,000).

7. Accounts with no touch

Ask: “Which active accounts had no call, email or visit in longer than their own order cycle?” A quiet account is easy to lose.

8. Slow and expiring inventory

Ask: “What stock has not moved in 90 days, and what expires in the next 60?” Sell it while it is sellable. A write-off loses the full cost of the stock.

9. Vendor overbilling

Ask: “Where do PO, vendor bill and receipt disagree on quantity or price?” This takes line-by-line matching. Start with your top five vendors.

10. Rebates and volume tiers earned but unclaimed

Ask: “Which vendor programs have a rebate or tier, and did we claim what we earned?” Read the program terms and compare to your year-to-date purchases.

How do I know how much to chase first?

Price each find with your own numbers and work the biggest first. A rough dollar figure beats a perfect list.

Use this small table in a sheet:

Place	Count found	Dollar value	Who owns it
Aging AR over 60 days
Quotes with no follow-up
Quiet customers

Do not wait to find all ten. Run the first three this week.

What should I do with each find?

Give each find one owner and one date. A list with no owner is a list that ages.

• A call list (AR, quotes, quiet customers): one person calls each name within a week.
• A fix list (unbilled work, credits, price drift): finance corrects it and bills what is owed.
• A decision list (slow stock, rebates, vendor bills): you or a manager decides what to sell, claim or dispute.

Review the three lists on a set day each week. Cross off what you closed. Add what you found. The habit is worth more than any one find.

Why is this hard to see?

Each question crosses two tools, and no standard report is shaped like that. Quotes sit in the CRM. Orders sit in the ERP. Payments sit in QuickBooks. The answer sits between them.

That is why one place for your data comes first. Once the tools feed one store, each question above becomes a saved query that runs on a schedule.

If you want these ten questions built and running weekly, the Business Brain is the finished version. You can run the first three by hand today.

What goes wrong when I run these?

Three things break first: duplicate customer names, stale exports and missing definitions. Fix duplicates before you trust any customer list.

Clean the list, then chase. A call to the wrong person costs you more than the cash you wanted. The spreadsheet guide covers how to stop copying data by hand.