Customizing Cash Flow Statement Account Sections

The standard Cash Flow Statement's Cash at Beginning of Period row references the Total Cash row in the standard Cash Statement. Consequently, if you create a custom Cash Flow Statement that includes changes to standard account sections, it is likely to have an incorrect value for Cash at Beginning of Period because the Total Cash value referenced from the Cash Statement does not include the added/changed sections.

To avoid this issue you must create a custom Cash Statement that shares the Cash Flow Statement's added/changed sections, and define this custom Cash Statement as the reference report for your custom Cash Flow Statement's Cash at Beginning Period row.

See the following example to get a better understanding of how to match up Cash Flow Statement and Cash Statement section customizations, to maintain an accurate value for the Cash at Beginning of Period row.

For information about the permissions required to view and customize financial statements, see Permissions and Roles.

Example Cash Flow Statement Customization

This example provides steps for customizing the Cash Flow Statement to reflect non-cash additions and deductions to Net Income, such as depreciation and amortization.

1. Customize the Cash Flow Statement to add an Expense section.

   1. Go to Reports > Financial > Cash Flow Statement and click Customize after the report loads.

   2. On the Financial Report Builder Edit Layout page, set the Name to Custom Cash Flow Statement.

   3. In the Layout section, expand the Adjustments to Net Income item, and select the row directly below it.

   4. From the Add Row/Section list, select Add Financial Section.

   5. In the popup, choose Create New Section, and click OK.

   6. Set Header Label to be Expense, Child Of to be Adjustments to Net Income, and Display to be Can not Expand.

   7. On the Section subtab, click Share Section.

   8. For the Section Name/ID, enter Expense Section.

   9. Set section criteria. Check the Use Expressions box. Select Account Name from the Filter list, choose Depreciation Expense, select Or from the And/Or list, and click Add. Select Account Name from the Filter list, choose Amortization Expense, select a blank from the And/Or list, and click Add.

   10. Click Save.

2. Customize the Cash Statement to add an Expense section.

   1. Go to Reports > Banking/Budgeting > Cash Statement > Customize Summary.

   2. On the Financial Report Builder Edit Layout page, set the Name to Custom Cash Statement.

   3. In the Layout section, select the row directly below the Cash Accounts.

   4. From the Add Row/Section list, select Add Financial Section.

   5. In the popup, choose Use Existing Shared Section, for Section Name/ID enter Expense Section, and click OK.

   6. For Header Label enter Expense, and for Child Of enter Cash Accounts.

   7. Click Save.

3. Set the Custom Cash Flow Statement's Cash at Beginning of Period Row to reference the new Custom Cash Statement.

   1. Go to Reports > Saved Reports > Custom Cash Flow Statement > Customize.

   2. On the Financial Report Builder Edit Layout page, select the Cash at Beginning of Period row.

   3. Select the Custom Cash Statement from the Report list, select Total Cash from the Row list, and click Save.

Cash at Beginning of Period now includes expense accounts added to the Expense Section.

Related Topics

Financial Statement Sections

Editing a Financial Statement Section

Adding a Section to a Custom Financial Statement

Cash Flow Statement Report

Cash Statement Report

General Notices