Changing the Statement of Cash Flows template design
A statement of cash flow shows you the movement of cash through your company. It presents the cash receipts and payments of the company over a period of time. It complements the profit and loss statement by providing information on the company's liquidity and financial flexibility. It also show the change of cash and cash equivalents during the period.
The Statement of Cash Flows template creates a cash-flow statement based
on the default account groups in Ajera. Please work with your CPA to verify that the account groups in the statement
are correct for your firm.
To change the Statement of Cash Flows template, do this:
Step 1: Verify the rows
Each account group you have set up to print on your current cash-flow
statement will need to appear in the statement design in the Financial
Statement Designer.
- From
the Reports menu, click Manage Financial Statements > Designs. A blank
worksheet appears.
- Click Open, and double-click Template - Statement
of Cash Flows. The Statement
of Cash Flows template design appears.
- The design contains the following sections:
Cash Provided by Operating Activities, Cash Provided by Investing Activities,
and Cash Provided by Financing Activities.
- The Amounts row in each
section is based on one or more account groups, except the
Net Income row. This row is based on your profit and loss account
types.
- In
the template design, start with the second Amounts row in the design.
Verify that each Amounts row is correct:
- Click the row
in the worksheet. The account group for that row appears in the properties
area, below the worksheet.
- If this account
group does not exist or is incorrect, click in the Account Group list and select
the correct account group. (For more information, see Setting
up Amounts rows.)
- To
delete an Amounts row, right-click the row and click Delete.
- To
add an Amounts row:
- Right-click
the totals row and click Insert.
A blank row appears above the current row.
- Click the blank
row, and click the Amounts button.
- Click the Account Groups button.
- Click in the Account Group list and select the correct account group.
- Click the Summarized button.
- Based on the
account group, select or clear the Reverse
sign check box.
For example, this check box is cleared for
the Accounts Payable Net and Repurchase of Common Stock and Dividend Payments
account groups in the design, and selected for the other account groups.
- If
you have accounts without account groups, you will need to set up new
Amounts rows for these accounts so that they appear on the statement.
You can set up an Amounts row by account range, ID range, or account type.
(For more information, see Setting
up Amounts rows.)
- Click the totals rows and
verify that the formula in each cell is correct. If a formula is incorrect,
double-click the cell and change the formula. (For more information, see
Setting up totals and Entering
formulas in the worksheet.)
Step 2: Verify the columns
Each column you have set up to print on your current cash-flow statement
will need to appear in the statement design.
The design contains the following defined columns: This Quarter, This
Year, Last Year.
- In
the Column Setup row, verify that the defined columns match the columns
in your current cash-flow statement.
If a column is not the same, do one of the
following:
- To
delete a column, do one of the following:
- Right-click the column letter at the top of the worksheet
and click Delete.
- Right-click a defined cell in the Column Setup
row and click Clear Contents.
- To
add a column:
- If needed, right-click a column letter at the top of
the worksheet and click Insert.
- Click a blank cell in the Column Setup row, and select
the correct option in the properties area or enter a formula.
See also
Changing
the Profit and Loss Statement (account groups) template design
Changing the
Balance Sheet (account groups) template design
Changing a financial statement design
Designing a financial
statement
Designing multilevel
profit and loss statements
Printing a financial statement
Exporting a financial
statement workbook
Exporting a financial
statement to Excel
Copying a financial
statement design
|
|