First page of the Small Business Cash Flow TemplateExcel workbook preview

Startup and small business finance

Small Business Cash Flow Template

Cash flow template for a small business in Excel: 12-month forecast, actuals, variance, minimum cash alerts, year-end re-forecast and a chart.

Excel workbook · 25 KB General finance practice

3 free downloads per account. Just your email and a 6-digit code.

Need more than 3? Every template for $249, once. Lifetime access, including the templates we add later. See pricing

About this template

A cash flow template shows when money will come into and go out of the business bank account, month by month. It is needed for a bank loan or overdraft, before a large purchase, before hiring, and any time cash feels tight. It is different from a profit and loss statement: an invoice counts when the customer pays, and equipment, loan repayments, taxes and owner draws count in full when paid.

The workbook has a 12-month forecast with six cash in lines and seventeen cash out lines, an actual sheet in the same layout, a variance sheet and a summary. The summary re-forecasts year-end cash from the latest actual month, finds the lowest point of the year and counts the months below the minimum balance you set. It uses plain cash accounting arithmetic, with every total a live formula.

Who it is for

The owner or bookkeeper of a small business asked by the bank, an accountant or a partner for a monthly cash flow forecast.

What is inside

  • Settings sheet: first month, opening bank balance and the minimum cash balance to keep
  • Forecast sheet with 6 cash in lines and 17 cash out lines for 12 months, with totals, net cash flow and closing cash
  • Actual sheet in the same layout, worked with 10 months of figures for an invented joinery workshop
  • Variance sheet: actual minus forecast for every line and month that has actuals, with a year to date column
  • Summary sheet with 9 key figures, including the year-end cash re-forecast and the lowest forecast month
  • Year to date table by line: forecast, actual, variance and variance %
  • Red flags on every month below the minimum cash balance, and a chart of forecast cash, actual cash then re-forecast, and the minimum

How to use it

Enter the first month, opening bank balance and minimum cash balance on the Settings sheet, then fill in the Forecast sheet month by month.

Files

  • XLSXsmall-business-cash-flow-template.xlsx25 KB

Opens in Microsoft Word or Excel, Google Docs or Sheets, and LibreOffice. Based on general finance practice, not on one published standard. A template to adapt, not legal, tax or accounting advice.

Questions about this template

What is the difference between cash flow and profit?

Profit counts income when it is earned and costs when they are incurred. Cash flow counts money when it actually moves through the bank. A profitable business can still run out of cash if customers pay late, stock is bought ahead of sales, or loan repayments and taxes fall in the same month.

How far ahead should a small business forecast cash flow?

Twelve months by month is a common horizon for planning and for a bank. The template uses that horizon and then compares each month with the actual figures, so the forecast for the rest of the year starts from the real bank balance and stays useful after the first few months.

What minimum cash balance should a small business keep?

There is no fixed rule. Many owners keep at least one month of fixed costs, such as wages, rent and loan repayments, and more if sales are seasonal or customers pay slowly. The template lets you set your own minimum and turns every month below it red.