ValteraTools CFO services
  1. Valtera
  2. Tools
  3. Excel templates
  4. Cash flow statement
Excel template · Cash flow

Cash flow statement template

A statement that shows, month by month, where cash came from and where it went across three activities: operating, investing and financing.

Updated:
Valtera_Cash_flow_statement_EN.xlsx · 11 KB · Sheets: Guide, Cash flow
Format: .xlsx · Excel, Google Sheets, LibreOffice · No sign-up required
Other languages: Azerbaijani · Russian
Valtera_Cash_flow_statement_EN.xlsx — Cash flow · Preview with sample data
Cash at start of year30,000
Line itemJanFebMarAprMayJunJul
OPERATING ACTIVITIES
Receipts from customers62,00058,00070,00074,00079,00072,00066,000
Other operating receipts400400400400400400400
Payments to suppliers34,10031,90038,50040,70043,40039,60036,300
Payroll payments11,00011,00011,00011,00011,00011,00012,000
Taxes and social contributions5,2004,8005,6006,1005,9005,8006,000
Other operating payments4,2004,2004,2004,2004,2004,2004,200
Net cash from operating activities7,9006,50011,10012,40014,90011,8007,900
INVESTING ACTIVITIES
Purchase of fixed assets--18,000----
Sale of fixed assets-------
Net cash from investing activities--(18,000)----
FINANCING ACTIVITIES
Loans received--20,000----
Loan repayments---1,8001,8001,8001,800

What the template includes

  • Operating activities: receipts from customers; payments to suppliers, for salaries, taxes and other.
  • Investing activities: purchase and sale of fixed assets.
  • Financing activities: loans, capital contributions, dividends.
  • Monthly net cash flow and balance, annual totals.

Profit vs cash flow

The profit and loss statement records a sale when goods are shipped; cash flow records it when payment arrives. Buying a fixed asset appears in cash flow as one large outflow, but in profit as depreciation over several years. Taking a loan does not change profit, but it increases cash. That is why you need to keep both statements side by side: P&L template.

How to use it

  1. Enter the cash balance at the start of the year (all accounts and the cash desk).
  2. Each month, copy receipts and payments from bank statements as positive numbers.
  3. Reconcile the month-end balance with the bank statement: if there is a difference, a transaction is missing.

For a weekly forecast: 13-week cash flow forecast.

Let us run the numbers

Valtera keeps the books and tax records of small and mid-sized companies and, as an outsourced CFO, takes responsibility for revenue growth and cash flow.