⚡ DrElectronics
💰 Small Business Spreadsheet

Profitable, but short of cash? See it coming.

Most businesses that run out of money were making a profit on paper. This spreadsheet shows where your cash is heading month by month, and lets you test a hire, a purchase or a slow-paying customer before it hits your bank account.

The problems it solves

Cash problems rarely announce themselves. They show up as a bill you cannot pay.

01

Profit is not cash

Sales are only money once customers pay. Tax bills, insurance and stock orders land in single months, so a profitable business can still hit zero.

02

Customers pay late

Unpaid invoices tie up money you have already earned, and you may not know how much is overdue or how it will affect next month.

03

Big decisions made blind

Hiring someone, buying a machine or losing a large client changes your cash for months. Few owners test it before they commit.

For context: a 2026 Intuit QuickBooks report found small businesses waiting on unpaid invoices were owed about $17,700 on average, and a 2026 Bluevine survey found nearly 3 in 10 owners had delayed paying themselves because customers paid late.

Four questions it answers

1. Will I have enough cash?

Where will my bank balance be in each of the next 12 months?

The problem

Averages hide the tight months. A quiet winter, a tax payment and a late customer can land together, and you only find out when the balance is gone.

How it helps

  • A clear verdict: Comfortable, Tight or Cash runs out
  • Your lowest balance and the month it happens
  • Seasonal sales, tax months and big payments built in
  • A buffer you set, so you get an early warning

2. Can I afford this?

What happens to my cash if I hire, buy equipment or lose a client?

The problem

Most decisions are judged on the price alone. The real question is whether your cash can carry the cost month after month, and whether it still can if something else goes wrong.

How it helps

  • Six "what if" ideas side by side, all editable
  • Test a new hire, a cash purchase, a loan-financed purchase, a lost client or late payers
  • Each idea answered Yes, Risky or No, with the month trouble starts
  • A chart comparing today's plan with any idea

In the included example business, a part-time hire would run the cash out within the year, and 40% of customers paying a month late would leave almost nothing in the bank in the first month.

3. What are late customers costing me?

Who owes me money, and who should I chase first?

The problem

Money you have earned sits in other people's accounts. Without a clear list, overdue invoices drift, and the cash you counted on does not arrive.

How it helps

  • Track unpaid invoices with due dates and expected pay dates
  • See what is overdue, what is 30+ days late and who owes the most
  • Expected payments feed straight into your forecast
  • Model slower payment across your whole customer base

4. Which weeks are tight?

What does the next three months look like, week by week?

The problem

Monthly numbers cannot show that payroll lands on Thursday and the big customer pays the following Tuesday. Cash crunches happen in weeks, not months.

How it helps

  • 13 weeks using the exact dates of your invoices and bills
  • Each week marked OK, Tight or Out of cash
  • The lowest week and when it starts, so you can act early

What is included

  • Works for product and service businesses in any currency
  • A Start Here tab with step-by-step instructions, plus example numbers to learn from
  • Yellow cells you type in; everything else is calculated for you
  • Space for 20 unpaid invoices, 25 upcoming bills and 8 big one-off payments
  • A glossary that explains every term in plain English
  • Formulas that were cross-checked against an independent calculation

How it works

  1. Buy once. One payment of $19.99 (USD).
  2. Download instantly. You get the Excel file straight after purchase.
  3. Enter your numbers. Replace the example business with yours, then read your forecast and test your decisions.

Questions

What do I need to use it?

Microsoft Excel on a computer is recommended. The file also opens in LibreOffice. Google Sheets can import it, but some formatting may look different.

How much information do I need to enter?

At minimum: your cash today, average monthly sales, how fast customers pay, your monthly costs and any big payments. The invoice and bill lists are optional but make the 13-week view much sharper.

Does it work for my kind of business?

Yes for most small businesses, product or service. You can set a seasonal sales pattern if your business has busy and quiet periods.

Does it calculate my taxes?

No. You enter the tax payments you expect, in the months you pay them. The spreadsheet shows the effect on your cash, not how much tax you owe.

Is this accounting or financial advice?

No. It is an educational planning tool. Results depend entirely on the numbers you enter and cannot guarantee any outcome. Please talk to an accountant or advisor before major decisions.

Is my business data sent anywhere?

No. Your numbers stay in your own copy of the spreadsheet.

Can I share the file?

It is licensed for your own business use. Please do not resell or redistribute it.

Who do I contact with a question?

Email apsopensun@gmail.com.

Know your cash before it runs short

One spreadsheet, one payment, instant download. Questions first? Write to apsopensun@gmail.com.

Get it for $19.99