Cash Flow Group Set-up

Summary

In order to run the report Statement of Cash Flows, you must first create Cash Flow Groups and assign all of your Balance Sheet G/L accounts to one of the groups.

Set-Up Instructions

Custom:  Set-up cash flow groups to suit your or your financial parties preferences.  You'll need a good understanding of how this type of report works as well as knowledge about where each account should be assigned in the report.

Quick:  Use the 'level 3' G/L account categories for your cash flow group codes, names and sorts.  You can use the image below as a guide.

 

  1. Open the Cash Flow Groups table

    1. Administration > Setup > Financials > Cash Flow Groups  (NOT 'Cash Flow Line items')

    2.  



  2. Create a Code, Name and Sort Order for each group

    1. Code:  numbers or letters up to 30 characters
    2. Name:  numbers or letters up to 100 characters
    3. Sort Order; number
      Quick set-up method shown with 'Level 3' G/L account groups
  3. Choose a segment for the group.  (Choose from Operating, Investing or Financing Activities)

    Tip:  Run the report once before set-up.  The report will list out all unassigned G/L Accounts with the typical segment they are assigned to.


  4. Assign ALL NON-CASH Balance Sheet G/L account to one of the new Cash Flow Groups

     
    1. Balance Sheet accounts will typically start with 1, 2 or 3.  (Assets, liabilities and equity)
    2. Be sure to include all "System" accounts
    3. Do not include the accounts flagged as "Cash Account" usually in the G/L group:  BANK - Bank Accounts.

      An Account should have an assigned Cash Flow Group OR a checked "Cash Account" box, but not both.