Cash Flow Statement report

Summary

How to use the Cash Flow Statement report in Sage Accounting.

Description

The Cash Flow Statement gives you a graphic view and summary of your bank activity for a specific period. Any outstanding VAT or payroll liabilities due will also show.

Resolution

Produce the Cash Flow Statement Report ▼

  1. Go to Reports and select All reports.
  2. Select Cash Flow Statement.
  3. Use the From* and To* fields to enter your date range.
  4. Choose your bank account by selecting Bank account button with three horizontal lines..
  5. Select Calculate.

    TIP:

    Select Detailed to view a transactional breakdown. Cash Flow In and Cash Flow Out are split and show transactions dates, amounts, references and contacts.

  6. Select Export to download the report as a PDF or CSV file.

Understand the graph ▼

The graph displays the bank accounts Balance, Cash Flow In and Cash Flow Out. In the screenshot below, see where you can select and deselect one of these to change the graph view.

EXAMPLE:

To view only cash flow out for the period, select the Balance and Cash Flow In to remove them from the graph.

Screenshot of a cash flow statement graph with the balance, cash flow in and out highlighted.

The graph is designed to show trends throughout the period, so the specific date of a transaction won't always line up with the graph. Use a shorter period to see more accurate transaction dates.

Graph breakdown

Below the graph you'll see the total opening balance, bank activity and closing balance for the period and banks you selected.

Opening Balance

This is the net value of money in and out less any liability from the date you selected above.
Cash Flow In

This includes the total value of your:

  • Customer receipts
  • Supplier refunds
  • Other receipts
  • Bank transfers and deposits
Cash Flow Out

This includes the total value of your:

  • Supplier payments
  • Customer refunds
  • Other payments
  • Bank transfers
Closing Balance The total cash flow in less the total cash flow out for the period you selected.
Liability to offset

The liability includes any outstanding vat or payroll tax due for the current and previous periods whatever date you select.

This calculation will only work for a Standard VAT scheme and doesn't apply to the flat rate scheme.
Net Balance

The Net balance will deduct the VAT liability from the Closing balance for this period.

 

Solution Properties

Solution ID
222001000100856
Last Modified Date
Wed Aug 05 09:04:57 UTC 2026
Views
0