Run the cash flow statement report | Centre d’aide Rentsera
Run the cash flow statement report
Track the sources and uses of cash over a range of months, consolidated or by property.
Les articles du centre d’aide sont offerts en anglais seulement.
Run the cash flow statement to see how cash moved through the account over a range of months.
Before you start
Your role needs the Cash Flow Statement permission with Access. Without it, the page returns a 403 page.
Your books must be started. If they are not, the page shows a setup card in place of the report.
Steps
Select Reports in the sidebar. Find the Cash Flow Statement card in the Financial Reports section, or type "Cash Flow" in the search box. Select the card. The cards Cash Flow Statement by Month and Cash Flow Statement by Property are not in any section. Type their titles in the search box to find them.
Cash Flow Statement by Month opens the same report for the current fiscal year, with one column for each month.
Cash Flow Statement by Property opens the same report for the current fiscal year, with one section for each property.
In the filter form, set Owner. The default is All Owners.
Set Property. The default is All Properties.
Optional: choose a Period preset. The preset fills in Month From and Month To. Choose Custom to set the months yourself.
Set Month From and Month To. When you open the report, both are the current month.
Choose the Accounting Method: Accrual or Cash.
Choose the options:
Show GL Account adds the general ledger account number before each account name.
Show 12 Months adds one column for each month in the range.
Consolidate combines the selected properties into one set of rows. Clear it to show one section for each property. All three options are selected when you open the form.
Select Display.
To save the report, select Export, then Excel, PDF or CSV.
What happens next
The report opens with its months and scope in a line under the title. The table has an Account column and a Total column.
With Show 12 Months selected, the table adds a column for each month.
Select an amount to open the General Ledger for that account. An amount in a month column opens that month. An amount in the Total column opens the whole range. The General Ledger keeps the accounting method, owner and properties of the report.
Select Filter to return to the filter form and change the settings.