How to Prepare a Cash Flow Statement in 6 Steps

Saim Jalees

A cash flow statement shows where a business's cash came from, where it went and how much was left at the end of a period. We've explained all of the steps to prepare a cash flow statement in this guide, covering everything from gathering your records to checking the closing balance.

We've also touched on how Wise Business can be used to manage your business's cash flow in the UK and globally.

wise-business-gb-local-global

wise-business-gb-local-global-mobile


Note: Wise Business offers a free Essential plan for basic spending and transferring. If you need to receive money, set up direct debits, or generate invoices, you'll pay a one-time £50 setup fee to unlock the Advanced features.

Wise services and features are not available in all regions, country and product restrictions apply. Visit wise.com to check availability, and for fee details and terms for your region, visit our pricing page for Wise Business.

This content is provided for general educational and informational purposes only. It is not intended to provide legal, tax, financial, investment or professional advice and should not be relied upon as such.


Summary of steps

StepWhat to do
1. Choose the period and what counts as cashSet the dates and identify the cash and cash equivalents you will report.
2. Gather and reconcile your recordsCollect the accounts and transaction records, then confirm the opening and closing balances.
3. Sort cash movements into three sectionsSeparate operating, investing and financing cash flows.
4. Choose an operating cash flow methodUse the direct or indirect method.
5. Calculate the net change in cashTotal the three sections and add the result to opening cash.
6. Check the closing balanceReconcile it to your accounts.

1. Choose the period and what counts as cash

Start by deciding whether the statement covers a month, a quarter or a financial year. Use the same start and end dates for every account you include. A monthly statement can help you manage cash, while statutory reporting requirements depend on the entity and its accounting framework.2,3

Next, identify cash and cash equivalents. Cash includes money held on demand, such as a current account balance. Cash equivalents are short-term, highly liquid investments that can be converted to a known amount of cash with little risk of changing in value.1,2 Check the treatment of overdrafts and restricted balances with your accountant rather than assuming every balance belongs in the total.

This gives you the opening and closing cash figures that the completed statement must connect.

2. Gather and reconcile your records

Collect the bank and payment-account statements, cash-book or ledger transactions, and the profit and loss account for the period. You will also need records for purchases and sales of long-term assets, loans, share capital and any other financing movements. If you use the indirect method, have the opening and closing balances for trade receivables, inventory and trade payables ready too.

Reconcile each account to the ledger before classifying transactions. For example, if a payment is recorded in the ledger on the last day of the month but appears on the bank statement the following day, check which reporting period it belongs to. Also identify transfers between accounts you own, so you do not count the same cash as both an outflow and an inflow for the business as a whole.

With the records checked, you can sort the actual cash movements by what caused them.

3. Sort cash movements into three sections

Cash flow statements group cash movements into operating, investing and financing activities.1,2 Classify each receipt and payment once, using the accounting policy that applies to your business.

SectionWhat it coversExample
Operating activitiesCash from the business's main trading activitiesCustomer receipts and payments to suppliers or staff
Investing activitiesCash used to buy, or received from selling, long-term assets and investmentsBuying equipment
Financing activitiesCash raised from, or repaid to, lenders and ownersTaking out or repaying a loan

Suppose a business receives a £10,000 bank loan and spends £18,000 on equipment. The loan receipt goes in financing activities, while the equipment payment goes in investing activities. Neither is a customer receipt or an ordinary supplier payment for day-to-day trading.

The treatment of items such as interest, dividends, tax and leases can depend on the reporting framework and your accounting policy. Check these rather than forcing them into a category based only on the payee's name.

4. Choose an operating cash flow method

Choose either the direct or indirect method for the operating section. The investing and financing sections stay the same.2

The direct method groups cash received from customers and cash paid to suppliers, staff and others. Total each category using your reconciled transactions.

The indirect method starts with profit or loss and adjusts for non-cash items, changes in working capital and cash flows classified elsewhere. Working capital here includes unpaid customer invoices, stock and unpaid supplier bills.2

For example, suppose profit is £40,000. Add back £8,000 of depreciation because it did not use cash, then subtract a £12,000 rise in unpaid customer invoices. With no other adjustments, operating cash flow is £36,000 (£40,000 + £8,000 − £12,000).

5. Calculate the net change in cash

Once you have the operating figure, total the investing and financing receipts and payments. Add the three section totals to find the net change in cash, then add that change to the opening balance.

The example below carries forward the £36,000 operating cash flow. It is illustrative, not a full statutory statement.

Cash flow itemAmount
Opening cash and cash equivalents£25,000
Net cash from operating activities£36,000
Equipment purchase: investing activities(£18,000)
New bank loan: financing activities£10,000
Loan repayment: financing activities(£6,000)
Net increase in cash£22,000
Closing cash and cash equivalents£47,000

6. Check the closing balance

Check that the £47,000 closing figure agrees with your reconciled cash and cash-equivalent accounts. If it doesn't, look for missing accounts, duplicated transfers or transactions recorded in the wrong period.

Under FRS 102, exchange-rate changes can alter the GBP value of cash held in another currency without moving cash. Show this effect separately when reconciling opening and closing balances.2

Compare the statement with your profit and loss account and cash-flow forecast. Profit can include unpaid invoices, while the forecast estimates future cash and the statement records what happened. Use any difference from the forecast to update the next one.

Prepare and monitor international cash flow statements with Wise Business

If your business pays overseas suppliers or receives money in another currency, Wise Business lets eligible UK businesses see those payments and receipts in their account alongside supported currency balances. You can also see conversions, related exchange rates and fees, then filter and export transaction history by date and currency.

You can also access currency statements and a dated audit report if needed to help your ifnance team check how much was held in each currency. Together, these records show your international cash flow, so your team can match movements to invoices and check the opening and closing balances used in the statement.

wise-business-gb-general-2

wise-business-gb-general-2-mobile

Wise Business offers a free Essential plan for basic spending and transferring. If you need to receive money, set up direct debits, or generate invoices, you'll pay a one-time £50 setup fee to unlock the Advanced features.

With Wise Business, you can:

  • 🌍 Send money to 70+ countries and pay overseas invoices at the mid-market exchange rate with low, transparent fees and no hidden exchange rate markups (product availability varies by region)
  • 📥 Receive payments in 24 currencies and counting
  • 💵 Get local account details for 8+ currencies, including USD and EUR, to let your customers pay in a currency they know and trust - convenience for them and peace of mind for you
  • 💰 Hold money in 40+ currencies
  • 🔁 Convert currencies anytime at the mid-market exchange rate with low, transparent fees
  • ⚡ Use the batch payments tool to create and send up to 1,000 payments in a single transfer
  • 👥 Run payroll and make international payments for up to 1,000 employees all over the world - including paying suppliers using local payment methods like ACH, SEPA, and Faster Payments
  • 💳 Get business debit cards with 0.5% cashback for you and your team to keep track of team expenses and spend all over the world, with real-time visibility and categorisation. See full cashback terms and conditions
  • 🏢 Manage cash in 55+ currencies across international offices from a single business account and move money between business accounts in seconds (exact speeds can vary depending on individual circumstances and may not be the same for all transactions)
  • 🧾 Connect and sync every business transaction to your favourite accounting software, including Xero, Quickbooks, and more
  • 🔐 Create your own payment approvals process to manage your team better with customised access for different team members, roles and permissions
  • 📑 Create custom professional invoices and schedule invoice payments for future dates
  • 📈 Earn variable returns on GBP, USD and EUR with Wise Interest (Growth not guaranteed. Your balance will go down in the event of a government default or interest rates going negative.)
  • 🔗 Accept credit and debit card payments in 18+ currencies, or create payment links and QR codes to get paid easily
  • ⚙️ Automate payouts with the Wise API (comes with 24/7 customer support, a sandbox account to test integrations, API tokens, and clear documents on how to implement and make the most of our API)

Make the wise choice when selecting a business account for your domestic and global needs.

Be Smart, Get Wise.

Register for Wise Business ✍️

Wise Interest disclaimer: Growth not guaranteed. Your balance will go down in the event of a government default or interest rates going negative. Taxes may apply. 3.32% variable rate on GBP is based on 7 day performance as of 05 Aug 2026. For full 5-year past performance and fund information, visit https://wise.com/interest. Investments are offered by Wise Assets UK Ltd. (FRN 839689)

Wise services and features are not available in all regions, country and product restrictions apply. Visit wise.com to check availability, and for fee details and terms for your region, visit our pricing page for Wise Business.

FAQs

What is the simplest format for a cash flow statement?

A simple format starts with opening cash, shows net cash from operating, investing and financing activities, then adds those amounts to reach closing cash. Keep the transactions and calculations behind each section so the final balance can be checked.

How do I create a cash flow statement in Excel?

Set up columns for transaction date, account, description, amount and cash-flow category. Group the movements into operating, investing and financing sections, then use formulas to total each section and reconcile opening cash to closing cash. If you use the indirect method, include a separate schedule for profit and its adjustments. Check the spreadsheet totals against your reconciled accounting records.

Can I use a cash flow statement template?

Yes, if it has space for the reporting period, opening balance, three cash-flow sections and closing-balance check. Adapt the line items to your business and accounting framework. A template does not decide the correct classification of unusual transactions for you.

Does every UK small company have to file a cash flow statement?

No. FRS 102 says a small entity is not required to comply with its cash-flow-statement section.2 Other reporting requirements depend on the entity and the framework it uses. A small business can still prepare a management statement to understand its cash movements; ask your accountant what its statutory accounts must contain.

Sources:

  1. IFRS Foundation: IAS 7 Statement of Cash Flows
  2. Financial Reporting Council: FRS 102, September 2024 edition, Section 7
  3. GOV.UK: Preparing and filing Companies House accounts

Sources last checked on 29 October 2026


*Please see terms of use and product availability for your region or visit Wise fees and pricing for the most up to date pricing and fee information.

This publication is provided for general information purposes and does not constitute legal, tax or other professional advice from Wise Payments Limited or its subsidiaries and its affiliates, and it is not intended as a substitute for obtaining advice from a financial advisor or any other professional.

We make no representations, warranties or guarantees, whether expressed or implied, that the content in the publication is accurate, complete or up to date.

Money without borders

Find out more

Tips, news and updates for your location