GL - Cash Flow Statement

Overview

The ‘GL Cash Flow Statement' program is used to produce either:

A report of cash inflows and outflows sorted into 'Groups' and 'Line Items'. The 'Groups' are school-definable but are most often:
- Operating Activities.
- Investing Activities.
- Financing Activities.
A transactional report of cash flows sorted by 'Group' and then 'Line Items'.
A mapping report to assist you with the setup and maintenance of your Cash Flow Statement.

This program can be accessed by navigating to TASS.web Finance > General Ledger > Reports & Listings.

Important!

Refer to the 'How to Set Up a Cash Flow Statement' guide before using this program. Complete Step 7 of the guide before setting the 'Report Parameters' in this program.

The program depends on Reporting Codes 7, 8 and 9. These are set up using TASS.web Finance > General Ledger > Setup Information > General Ledger Setup on the 'Reporting Code' tab.

The convention used needs to be:

Reporting Code 7: Cash Flow Statement – Grouping Codes.
Reporting Code 8: Cash Flow Statement – Cash Inflow Codes.
Reporting Code 9: Cash Flow Statement – Cash Outflow Codes.

Refer to the example below of a Cash Flow Statement and the related use of Reporting Codes.

Example

This is an example of a Cash Flow Statement:

Click here for an Administrator Note.

User Security Permissions

For users to access this program, they need permissions applied to the ‘Cash Flow Statement’ security point in TASS.web System Admin > Users > User Maintenance or TASS.web System Admin > Users > Security Role Permissions.

Report Parameters

Before you can generate the Cash Flow Statement, you must first define the Report Parameters.

Important!

Complete Step 7 of the 'How to Set Up a Cash Flow Statement' guide before setting these Report Parameters.

Click on the 'Report Parameters' icon to display the 'Cash Flow Statement Parameters' screen.

Fields that require further explanation
* Reporting Code Number for Grouping	Use the drop-down list to select the Reporting Code used for the 'Groups' in your Cash Flow Statement. If you have adopted the standard recommendations, this will be Reporting Code 7. Refer to the example of the Cash Flow Statement above to see how and where 'Groups' are used on the report. Reporting Codes are set up using TASS.web Finance > General Ledger > Setup Information > General Ledger Setup on the 'Reporting Code' tab.
* Reporting Code Number for Cash Inflows	Use the drop-down list to select the Reporting Code used for the 'Inflows' in your Cash Flow Statement. If you have adopted the standard recommendations, this will be Reporting Code 8. Refer to the example of the Cash Flow Statement above to see how and where 'Inflows' are used on the report. The transactions that are included as cash 'Inflows' on the Cash Flow Statement originate as either Cash Receipt Journals or Credit Cash Book Journals. Reporting Codes are set up using TASS.web Finance > General Ledger > Setup Information > General Ledger Setup on the 'Reporting Code' tab.
* Reporting Code Number for Cash Outflows	Use the drop-down list to select the Reporting Code used to describe the 'Outflows' in your Cash Flow Statement. If you have adopted the standard recommendations, this will be Reporting Code 9. Refer to the example of the Cash Flow Statement above to see how and where 'Outflows' are used on the report. The transactions that are included as cash 'Outflows' on the Cash Flow Statement originate as Cheques, Electronic Payments or Debit CashBook Journals. Reporting Codes are set up using TASS.web Finance > General Ledger > Setup Information > General Ledger Setup on the 'Reporting Code' tab.
* Balancing item for Cash Outflows	This is used to nominate the 'Line Item' that the Cash Flow Statement will use to allocate Cancelled Cheques or Cancelled Electronic Payments against. The 'Line Items' that will be available in the drop-down list are those set up against the Reporting Code for 'Cash Outflows'. If you have adopted the standard recommendations, this will be the 'Line Items' against Reporting Code 9.
* Bank Accounts for Cash Flow Statement	Use this field to nominate the active bank accounts to use in the Cash Flow Statement. This is a multi-select field. To pick more than one bank account from the drop-down list, hold down the 'Ctrl' key while clicking on the bank codes.

Click the 'Save' button to commit your changes to the TASS.web database.

Running the Report

Important!

This report can only be run for a period in which all postings have been completed (both subsidiary and general ledgers).

The report will not run if it detects unposted journals.

General Tab

Click the ‘General’ tab, then select the ‘Year’ and ‘Period’ to include in your Cash Flow Statement report.

Print Tab

Select the ‘Print’ tab. This tab is split into several sections.

Layout Options
Cash Flow Statement	Select the ‘Cash Flow Statement’ radio button to run the report using the 'Cash Flow Statement' format. An example of this format is available above.
Cash Flow Transactions	Select the ‘Cash Flow Transactions’ radio button to run a report showing all of the cash flow transactions for each 'Line Item'. This format sorts transactions by 'Group', then 'Line Items' within each 'Group'.
Report Mappings	Select the ‘Report Mappings’ radio button to run the report as a useful review tool when setting up or maintaining your Cash Flow Statement. The report lists the General Ledger Accounts that will be used (in the accounting period that you chose on the 'General Tab') in the Cash Flow Statement. These are also sorted in the same order as the actual Cash Flow Statement (by 'Group' then 'Line Items within each 'Group'). The journal codes for 'Cash Book Journals' and 'Cash Receipt Journals' will also be printed. These should be checked.
Portrait Landscape	Choose the orientation of your report.
Include YTD Column	Select the ‘Include YTD Column’ checkbox to include an additional column with Year To Date Balances for comparison.
Formatting Options
Export to PDF Export to Excel Export to Word	Choose the destination of the report. You can export to PDF, Microsoft Excel®, or Microsoft Word®.
Show Table Borders	The 'Table Borders' option can enhance the readability of the report, but it is not available if the listing destination is Excel®.
Alternate Row Colours	The 'Alternate Row Colours' option improves report readability but is unavailable when exporting to Excel®.
Report Title
Enter a preferred title for the report or use the default titles based on the selected report type: ‘CASH FLOW STATEMENT,’ ‘CASH FLOW TRANSACTIONS,’ or ‘REPORT MAPPINGS.’

Click ‘GO’ to generate the Cash Flow Statement.

General Journal entries, including those posted to a bank account, do not appear in the 'Cash Inflows (Outflows)' sections of the Cash Flow Statement. Instead, the statement displays them as Journal Exceptions.