Script:
Owner:
Subdir:
Blog ID: 64040601
Group ID: User ID:
 
Narrow by Topic:
Quick Reply
Cancel
Page 2 of 3  •  Prev 1 2 3 Next
Locked: Avoid the pitfalls of calculating asset retirement obligations & liabilities: Q&A on AROs & SAP AROM
1 year ago  ::  Mar 29, 2012 - 12:59PM #11
Nathan Genez
Posts: 19

Mar 29, 2012 -- 12:40PM, Allison wrote:

Nathan, can you provide a quick overview of the challenges of ARO calculations from an accounting perspective?


Well, the challenges of the calculation are that they're currently done offline.  As Keven points out, it's usually done in Excel.  From what I've seen at every customer that has tracked AROs, it's always done in Excel.  That's not a controlled environment.


Probably the second challenge with this is a lack of integration.  Once you calculate the ARO value in excel, you have to load it into SAP ERP.  Then you have to load the periodic accruals each month to record the ARO's accretion expense.  If you have a lot of AROs, that's a lot of spreadsheets to maintain and a lot of uploads to make. 


SAP's solution is (obviously) integrated with FI-GL so that all of these postings are made on a monthly basis.  It's also integrated with fixed assets (FI-AA) so that changes to the ARO (ex. termination) can be reflected in the associated ARO asset.

Quick Reply
Cancel
1 year ago  ::  Mar 29, 2012 - 1:02PM #12
Allison
Posts: 117

Thank you to all who have posted a question for Nathan. Just a quick reminder to refresh your browser to see the latest posts.

Quick Reply
Cancel
1 year ago  ::  Mar 29, 2012 - 1:05PM #13
Nathan Genez
Posts: 19

Mar 29, 2012 -- 12:50PM, Gary Byrne wrote:

Hello, Nathan


Thanks for taking time today to answer our questions. Here is mine:


How is AROM integrated with SAP ERP Financials, including General Ledger, FI-AA, and Lease Accounting (FI-LA)?


Thanks, Gary


 


 


I guess I answered some of that with Allison's question.  To bullet it out...

  • FI-GL -- the AROM solution integrates with the GL for the initial setup of the ARO liability and the periodic postings of accretion expense.  The latter is handled by another utility within FI called the Accrual Engine.  It handles the management of periodic accruals such as this quite well.
  • FI-AA -- For every ARO, an associated ARO asset is also setup.  This is a virtual asset, not a true fixed asset because it's not a tangible piece of equipment / property.  Nonetheless, you are allowed to depreciate the value of the ARO liability amount.  When the ARO is released, the fixed asset record is automatically created and posted to.  From there, normal FI-AA functionality takes over in terms of depreciating the asset along with all other assets in the subledger.
  • FI-LA -- LA is not directly used or requireed, but there is a component of it called the Lease Accounting Engine (LAE) that is leveraged by AROM.  To describe it...  LAE serves as middleware or an integration layer for this SAP solution. For example, when the AROs are valuated and released it is LAE's job to reach out to the GL and make the initial FI posting. It is LAE's job to reach out to FI-AA to create and post to the new fixed asset record.  LAE is delivered pre-configured (mostly) so it's not something that should be seen or interacted with once the AROM solution is operational.

 

Quick Reply
Cancel
1 year ago  ::  Mar 29, 2012 - 1:09PM #14
Keven Purnell
Posts: 3

I have one more question regarding the calculations.  Is it possible to view the technical steps of the calculation to confirm the calculated amounts?


What's the reporting like? 

Quick Reply
Cancel
1 year ago  ::  Mar 29, 2012 - 1:11PM #15
Nathan Genez
Posts: 19

Mar 29, 2012 -- 12:52PM, Scott Wallask wrote:

Hi Nathan, nice to see you on the forum today. Do you how SAP ARO calculates inflation changes? Is that automated at all in ARO or is it just the result of someone monitoring the rates externally?


The initial inflation calculation as part of the ARO's valuation is definitely automated. For US GAAP, inflation rate changes aren't supposed to influence the value of the ARO so they won't trigger a change in the ARO's provision value.


AROM is also supported for IFRS and German HGB and I believe they handle inflation rate changes differently.  In their case, the ARO value will change.

Quick Reply
Cancel
1 year ago  ::  Mar 29, 2012 - 1:16PM #16
Nathan Genez
Posts: 19

Mar 29, 2012 -- 12:52PM, BridgetKotelly wrote:

Does this solution replace manual spreadsheets for managing appraisal and bid estimates for AROs? 


Absolutely. If you get a bid for the retirement, that is what is used for the CEP valuation.  For instance, if a bid for $100,000 is issued to remove a cell phone antenna from a commercial building, that $100k is entered into the ARO's CEP.  From there, it is inflated out to the expected retirement date (in AROM, it's referred to as the settlement date) and then calculated back to today to get the NPV.  You can even view a cash flow report that will show the ARO starting value, interest cost, and ARO ending value per fiscal period.  This is what I've commonly seen in customer's ARO spreadsheets... but now it's all within ERP


 

Quick Reply
Cancel
1 year ago  ::  Mar 29, 2012 - 1:20PM #17
Allison
Posts: 117

Thank you all again for joining us. We have time for 1-2 more questions before the forum ends.

Quick Reply
Cancel
1 year ago  ::  Mar 29, 2012 - 1:24PM #18
Nathan Genez
Posts: 19

Mar 29, 2012 -- 1:09PM, Keven Purnell wrote:

I have one more question regarding the calculations.  Is it possible to view the technical steps of the calculation to confirm the calculated amounts?


What's the reporting like? 


Yes you can view (in great detail) how SAP calculated the ARO values.  This can be done on each individual CEP (transaction).  It's very informative in showing how SAP calculated the ARO, what dates were used in the calculation, what rates were used, etc.  It breaks it down into multiple Calculation Steps... lots of detail.


Reporting is good.  Most people seem to need basic lists of what AROs they have, when do they settle/expire, what are the values today and what are they expected to be xx years from now, etc.  From what I've seen so far, the delivered reports provide this information.  They are also ALV formatted and the selection criteria is quite good.


In addition, SAP has delivered a structure based report that will display the ARO values in a freely definable grid.  You can, via configuration, define your own column/row/cell structure and map which values are shown where.  This is not a report painter/writer report...  it's just a configuration variant within the AROM solution.

Quick Reply
Cancel
1 year ago  ::  Mar 29, 2012 - 1:28PM #19
Nathan Genez
Posts: 19

Currently, AROM is still in RampUp but it will most likely be generally available sometime in Q2 of 2012. 

Quick Reply
Cancel
1 year ago  ::  Mar 29, 2012 - 1:28PM #20
Allison
Posts: 117

Thanks to all who posted questions and followed the discussion!


A full summary of all the questions will be available here in the Financials Forum and in the Financials Group. I encourage you to join these groups for ongoing information and additional resources, and you can post your questions at any time here in the Financials Forum.


And thanks again to Nathan Genez of  Serio Consulting for joining us today! 

Quick Reply
Cancel
Page 2 of 3  •  Prev 1 2 3 Next
Quick Reply
Cancel
    Viewing this thread :: 0 registered and 1 guest
    No registered users viewing

    Become a member of Insider Learning Network:

    - Receive alerts for upcoming Q&As

    - Post your questions and get answers from a trusted network of peers and industry experts

    - Download free Member-only Resources including sample articles, presentations, and book chapters