Applications

Expand all | Collapse all

Use of GL Subaccounts

  • 1.  Use of GL Subaccounts

    Posted 07-28-2020 22:59
    Hello,
    We are considering enabling subaccounts in our COA structure when we move to the Financials in the Cloud.  Does anyone have any experience with subaccounts either with their on-prem or Cloud version of GL?  If so, would you be willing to share your experience, the Pros and the Cons of this decision.  Thank you.


    ------------------------------
    Mary Zeck
    Director, Financial Systems
    Zebra Technologies Corporation
    Lincolnshire IL
    -
    ------------------------------


  • 2.  RE: Use of GL Subaccounts

    Posted 07-29-2020 08:29
    ​Mary,

    We use them.  Just send me an email and we can arrange a day/time to discuss.  fieldenrick@gmail.com

    ------------------------------
    Rick Fielden

    ------------------------------



  • 3.  RE: Use of GL Subaccounts

    OATUG Star Partner
    Posted 07-30-2020 22:38

    Hello Mary:

     

    Some organizations find a subaccount segment can be a useful method of garnering more detail on transactions. It does provide an additional space for more granular tracking and can help keep the number of natural account values to a minimum. The subaccount segment is often set up as dependent segments, which allows for individual subaccount values to be repurposed depending on the account segment that it's been paired with. However, there are some significant drawbacks to this approach. Oracle enables businesses to add their own internal logic through the use of ranges of values which becomes more complex when multiple segments have to be accommodated when tracking the same type of data. Anytime you are keeping the same type of data in multiple segments additional maintenance will need to occur to ensure everything is kept in line. The use of a dependent subaccount segment will only exacerbates this concern as the segment cannot be used unless paired with independent segment it's been attached to.  Looking forward to connecting.

     

    Cheers,

    Ingrid Houghton

    eprentise

     

     

    Sent from Mail for Windows 10

     






  • 4.  RE: Use of GL Subaccounts

    Posted 07-31-2020 08:23
    Hello,


    We use subaccounts to break down our expanse accounts in manufacturing.  Examples would be Expanse account 3883 with subaccounts such as 3883.0014 Sand paper, 3883.0015 Glue, 3883.0016 Safety glasses.  This helps break down the actual spending on each type of expense.

    ------------------------------
    Tonia Cowan
    Applications Specialist
    OFS Brands, Inc
    Huntingburg IN
    (812) 683-7021
    ------------------------------



  • 5.  RE: Use of GL Subaccounts

    Posted 08-25-2020 11:17
    Hi Rick,
    Thank you for responding to my posting regarding the use of GL Subaccounts.   Myself and a colleague would be interested in speaking with you via a 30 minute Zoom session.  Is there a good time for you in the next couple of weeks?  If you can suggest a couple of dates and time, I'm sure we can make ourselves available.  We will have some prepared questions to make the best use of the time.   Looking forward to hearing from you.

    Kind Regards,

    Mary Zeck
    Zebra Technologies Corp
    Lincolnshire, IL

    ------------------------------
    Mary Zeck
    Director, Financial Systems
    Zebra Technologies Corporation
    Lincolnshire IL
    -
    ------------------------------



  • 6.  RE: Use of GL Subaccounts

    Posted 07-29-2020 17:36
    Hi Mary,

    There is a segment in our chart of accounts that is being as a de facto sub account as it contains values for Product that are used with the P&L accounts as well as the US state codes and Canadian Province codes for the tax liability GL accounts.

    Thanks, Rasik

    ------------------------------
    Rasik Mistry

    rumistry@yahoo.com
    ------------------------------



  • 7.  RE: Use of GL Subaccounts

    SIG Leader
    Posted 07-30-2020 10:25
    Hi Mary,

    There are multiple arguments you will find to both support and not support the use of sub-accounts.

    It all depends on what these constructs will assist in - reporting, data capture, etc..

    My personal opinion the use of sub-accounts are best served when you want to use a Global Chart and not have a desire (for whatever reason) a secondary chart of accounts. On any other business requirement it is a discussion to look art the true requirements - not what you would like because you do that today - but review what the sub-accounts support in your overall design.

    Cross Validation rules can alleviate the need for sub-accounts in some cases but it is a case of understanding the needs.

    One thing you want to be careful about is the use of dependent segments - in Cloud that is best not to use as it is not recommended and there is documentation to support why.

    I would be more than happy to have a discussion - feel free to email me if you have any specific questions .

    Mohan

    ------------------------------
    Mohan Iyer
    Principal Consultant
    FSCP Solutions Inc.
    Fremont CA
    (408) 859-4484
    ------------------------------



  • 8.  RE: Use of GL Subaccounts

    OATUG Star Partner
    Posted 07-31-2020 10:44
    Hello Mary:

    Some organizations find a subaccount segment can be a useful method of garnering more detail on transactions. It does provide an additional space for more granular tracking and can help keep the number of natural account values to a minimum. The subaccount segment is often set up as dependent segments, which allows for individual subaccount values to be repurposed depending on the account segment that it's been paired with. However, there are some significant drawbacks to this approach. Oracle enables businesses to add their own internal logic through the use of ranges of values which becomes more complex when multiple segments have to be accommodated when tracking the same type of data. Anytime you are keeping the same type of data in multiple segments additional maintenance will need to occur to ensure everything is kept in line. The use of a dependent subaccount segment will only exacerbates this concern as the segment cannot be used unless paired with independent segment it's been attached to. Looking forward to connecting.

    Cheers,
    Ingrid Houghton
    eprentise

    ------------------------------
    Ingrid Houghton
    VP of Sales, Channels & Alliances
    eprentise
    Orlando FL
    (315) 3968967
    ------------------------------