Use the Cash Flow Statement Setup tab to define subsection headings and map the accounts associated with each subsection. These accounts determine the amount that displays for each line item on the Cash Flow Statement.
Contents
Field | Description |
Drop-down arrow
|
Click the drop-down arrow on a grid header to complete any of the following actions:
- To print grid data, click
Print. On the Print Preview form, click
to send the grid data to your default printer.
- To export grid data to an Excel spreadsheet, click
Export to Excel. When Microsoft Excel opens, use its features to modify, print, or email the grid data, or to save the spreadsheet file locally.
- To turn on grouping for a grid, click
Enable Grouping. When a field displays with the instruction: "Drag a column header here to group by that column," drag and drop column headers into the field, in the sequence that you want them to display.
Not all options are available on all grids.
|
Test Setup
|
Click this button to test the Cash Flow Statement Setup. When you click the button, Vision displays a message that identifies any accounts missing from the setup and asks you to check them.
The Cash Flow Statement's total cash flow ties to the corresponding balance sheet's current period cash balance only if each general ledger account is associated with a line item in Cash Flow Statement Setup. The account can be a System Account, in a range defined on the Account grid, or an individual row in the Account grid.
|
Insert
|
Click this option to insert a new grid row at the selected location.
|
Copy
|
Click this option to add a copy of the selected grid row at the end of the grid.
|
Delete
|
Click this option to delete the selected grid row.
|
Company
|
From the drop-down list, select the company whose data is defined on this row.
|
Label
|
Enter the text in this field that will be associated with each heading.
|
Report Column
|
Select columns from the drop-down list.
|
Sort Seq
|
Enter a number to indicate the label's order of appearance under its
Report Column on the report.
|
System Account
|
If the label applies to a group of accounts already defined in Vision, you can select an option here rather than specifying an individual account or account range. The available options are:
-
Net Income — This is the sum of amounts in all Income Statement accounts. This amount should equal Total Profit on the corresponding Income Statement, and should also equal the current period's Retained Earnings on the corresponding Balance Sheet.
-
Accounts Payable — This is the sum of amounts in all liability code accounts.
-
Accounts Receivable — This is the sum of amounts in all accounts mapped to accounts receivable.
|
Account Grid
Field | Description |
Drop-down arrow
|
Click the drop-down arrow on a grid header to complete any of the following actions:
- To print grid data, click
Print. On the Print Preview form, click
to send the grid data to your default printer.
- To export grid data to an Excel spreadsheet, click
Export to Excel. When Microsoft Excel opens, use its features to modify, print, or email the grid data, or to save the spreadsheet file locally.
- To turn on grouping for a grid, click
Enable Grouping. When a field displays with the instruction: "Drag a column header here to group by that column," drag and drop column headers into the field, in the sequence that you want them to display.
Not all options are available on all grids.
|
Insert
|
Click this option to add a copy of the selected grid row at the end of the Account grid.
|
Delete
|
Click this option to delete the selected grid row.
|
Start Account
|
Click
and select the starting account in the range of accounts to associate with a subsection and line item label on the report.
|
End Account
|
Click
and select the ending account number in the range of accounts to associate with a subsection and line item label on the report.
|