Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
This page is still under Construction.

Image Removed

...

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. Image Added 



  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
      Image Added
  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.

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

       

Image AddedImage Added