Skip to Content
author's profile photo Former Member
Former Member

How to assign ACCTYPE for CASH FLOW accounts?

Dear all:

A few questions in regards of managing CASH FLOW accounts in my Account Dim:

1) How do you assign ACCTYPE for CASH FLOW accounts, which use accounts both from Balance Sheet and Income Statement? For Balance Sheet, It is clear what AST (Assets) or LEQ (Liab or Equity) is, as well as for Income Statement that INC (Income) and EXP (Expense) accounts are easy to figure out. Do I assign ACCTYPE for CF accounts by definitions of each ACCTYPE? For instance, if I need positive and non-aggregative, I use AST, and if I want positive and aggregative, I use EXP?

2) What happens to the Parent accounts that don't have any ACCTYPE? Is there a default setting for ACCTYPE?

I am playing around with my ACCTYPE under ACCOUNT Dim, but the complex database is giving me a difficult time in finding relations/patterns for accounts with different combination of ACCTYPEs.Therefore, I am hoping someone else can give me a pointer.

Thank you! Have a great day!

Brian

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 20, 2008 at 04:34 AM

    The key point to consider is, how should each account aggregate across the 12 months to get to quarterly and yearly totals. And for the cash flow, this answer depends on (1.) the data storage method for the application - YTD or Periodic, and (2.) whether you're handling your CF movements as flow vs. last year's closing balance, or flow vs. prior month.

    Since the cash flow statement is where the P&L and B/S meet, normally I find the AccType's are a combination as well. If you consider a YTD cash flow:

    1.) change in working capital (i.e., change since last year's close) must be an AST account, since if you look at your Year.Dec value, it should be the same as your Year.Total value. (It could also be an LEQ account, but that just determines the sign of the data. This is really up to you, based on how you want the numbers to look on the report, and whether you flip the sign when computing the CF account based on the B/S account.)

    2.) Income, and adding back the other P&L items (depreciation,etc.) must be an INC AccType, if these are periodic values. If they are YTD values that are posting each month, I think these need to be AST accounts. Again, the answer depends on what the source period is for the cash flow, as well as whether you set your Measures = YTD or Periodic (considering both the report's CV selection, and the application data storage)

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Tim:

      Thank you very much for your reply.

      We are storing data in the PERIODIC fashion.

      I played around with ACCTYPE, and finally got everything to work out the same way (in terms of right signs) as our manually written Cash Flow Statement. However, my questions are:

      1) Do I have to assign an ACCTYPE for each CF account? I noticed that it wouldn't hurt to leave blanks on ACCTYPE for most of my CF accounts.

      2) Did ACCTYPE affect the way data gets aggregated? It seems to me that only the signs were flipped but aggregation was not adjusted accordingly. For instance, in my Income Statement, I have a monthly depreciation of ($1000), which is always negative. When I bring this value to CF Statement, it should be recorded as a positive Inflow, and should be positively aggregated to the Operating Activities. By assigning AST to depreciation account, I was able to change ($1000) --> $1000, but depreciation account was still calculated as a negative value when combining to the rests of the Operating Activities accounts.

      In this case, do I use unaryoperator to adjust to the right aggregation?

      I guess some of my questions are answered by myself already, but as you know I am new to BPC, so I would like to do it the "best practice" way by confirming with Professionals like you and others on this forum!

      Happy Holiday!

      Sincerely,

      Brian

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.