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,
Deltek 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
Deltek, 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.
|