If electing to use Accounting Seed’s Cash Flow Statement functionality, there are several setup tasks that must occur prior to the beginning of the fiscal year for which you want to be able to run a Cash Flow Statement.
Accounting Seed's Cash Flow Statement feature cannot generate a Cash Flow Statement until your next fiscal year. This is because all cash related transactions (Cash Disbursements, Cash Receipts and Journal Entries to a cash account) in a customer's fiscal year are required to be tagged with a Cash Flow category in order to generate a Cash Flow Statement. We are releasing this functionality early to allow our existing customers to do the necessary planning, setup and training of staff prior to the beginning of their next fiscal year.
Enable Cash Flow Statement
1. Check the Enable Cash Flow Statement check box in the Cash Flow Statement Settings section of the Accounting Settings tab. (This will auto-create a set of Cash Flow Categories, see table below).
2. Review the out of the box Cash Flow Categories created, delete the ones that do not apply, and create new ones as appropriate.
3. Adjust the Default Cash Flow Categories on the Accounting Settings tab.
4. If you have used Accounting Seed prior to the Daisy release you will need to add the Cash Flow Category fields onto the source object Page Layouts. If you do not have permission to do this, contact your Salesforce system administrator to help you. The following object Page Layouts will need to be adjusted:
- Cash Disbursement
- Cash Receipt
- Journal Entry Line
- Add the cash flow category to the Journal Entry Line Field set.
Create Cash Flow Categories
Please note Cash Flow Categories are implemented in Accounting seed with the GL Account Object.
Create a new Cash Flow Category
- Navigate to the GL Accounts tab and click the New button.
- Enter the name of the new Cash Flow Category.
- Change Type value to Cash Flow.
- Set the appropriate Sub Type 1 value (Operating, Investing, or Financing).
- Click Save.
* Sub Type 2 is not used in the creation of a Statement of Cash Flows.
If you do not see Cash Flow as a Type or the three Sub Type 1 values, then you will need your Salesforce administrator to activate the Type field value Cash Flow, as follows:
- Click into Setup > Create > Objects and select the GL account.
- Click the Type field and scroll down to activate the Type value: Cash Flow.
- Go back to the GL Account object and select the Sub Type 1 field and scroll down and activate the three Sub Type 1 values: Operating, Investing, Financing.
- Go back to the GL Account object and select the Type and scroll down to the Field Dependencies.
- Click Edit next to the Sub Type 1 field.
- In the Cash Flow column, double-click on the Operating, Financing, and Investing fields. This will change the color so that they are active fields under the Cash Flow type.
You can now create your own cash flow categories as described above.
Note: The Cash Flow Categories included with Accounting Seed will display in a specific order on the Cash Flow Statement. New Cash Flow Categories added will list at the bottom of their Sub Type 1 list in alphanumeric order.
Set of Cash Flow Categories installed with Accounting Seed
Note: Accounting Seed's new Cash Flow Statement feature cannot generate a Cash Flow Statement until your next fiscal year. This is because all cash related transactions (Cash Disbursements, Cash Receipts and Journal Entries to a cash account) in a customer's fiscal year are required to be tagged with a Cash Flow category in order to generate a Cash Flow Statement.