U.S. Bank research found that 82% of small business failures are caused by cash flow problems — not lack of customers, not bad products, just money arriving too late to cover expenses. This Profit And Loss shows you exactly when money comes in and when it goes out.

What’s inside this Profit And Loss template

• Revenue timing split — separate recurring revenue from one-off payments for cleaner forecasting
• Seasonal adjustment notes — flag months where cash flow is historically tighter
• Buffer target calculator — automatically shows how many months of runway you currently have
• Variance analysis — compare forecast to actual each month and adjust future predictions accordingly

How to use this Profit And Loss template

1. Get access using the button above, then copy it to your Drive.
2. Set up your income categories — recurring, project-based, and occasional revenue separately.
3. Enter all fixed outgoings first so the baseline cash position is always accurate.
4. Update actuals each week as invoices are paid and bills are settled.
5. Use the variance column to understand why forecast and actual differ, and improve next month’s accuracy.

Why Google Sheets for Profit And Loss?

Cash flow software tends to connect to your bank and automate the input — which sounds useful until the bank API breaks or the categorisation is wrong. This template keeps you in control of every number, which is exactly what cash flow management requires.

Frequently asked questions

Can my accountant access this?

Yes. Share the Google Sheets link with view access and your accountant sees the same live forecast you do. No file sending, no version confusion.

What is the difference between cash flow and profit?

Profit is revenue minus costs on paper. Cash flow is the actual money in your account. A business can be profitable but cash-flow negative if customers pay late — this template tracks the cash, not the paper profit.

How accurate will my forecast be?

As accurate as the assumptions you put in. The template includes a variance column so you can compare forecast to actual each week and improve the accuracy of future predictions over time.