Cash Flow Statement Setup Tab of Cash Flow Statement Setup

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 File > Print 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, DPS 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 DPS, 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 File > Print 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.