Enterprise Resource Planning Blogs by Members
Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
cancel
Showing results for 
Search instead for 
Did you mean: 
ihsen_abroug2
Explorer
Using the parallel ledger, companies can set parallel valuation in different accounting principles

Typically, a local company that belongs to a group needs to follow both local and group accounting principles

In Assets accounting, we can set Parallel ledger  accounting using depreciations areas

We need to define depreciation area per involved accounting principles,

In our scenario company FR01 a local branch of an international group, company FR01 needs to report financial statements in group accounting principles IFRS and in local GAAP accounting principles.

We defined the Leading ledger '0L' for IFRS and non leading ledger '2L' for LG accounting principles.

Let's see the major customizing steps and a process flow to demonstrate the power of the ledger approach in parallel valuation in assets accounting.

1. Define settings for ledgers




We assigned accounting principles to corresponding ledgers for the company 'FR01'.

  • 0L Ledger:




  • 2L Ledger:




 

2. Define Depreciations areas


In our example we created the following 2 depreciation areas:

  • Depreciation area 1 for IFRS accounting principles (0L Ledger group)




 

  • Depreciation area 12 for LG accounting principles (2L Ledger group)




Both areas 1 and 12 posts in real time

Important note:

In New Assts accounting, the delta depreciation area is no longer needed, the system posts in real time to both ledgers.

 

3. Assign GL Accounts


In this step we need to assign GL accounts for both depreciations areas, 1 and 12

We used the same accounts for both areas as we are using separate ledgers for both areas



The following screen shots applies for area 1, area 12 have the same accounts assignments





 

4. Define technical clearing account for integrated assets aquisition:


Below the SAP definition of the integrated aquisition postings available in SAP HELP

You can find this definition also when clicking on the glasses in front of the main customizing neud



"For an integrated asset acquisition posting, the system divides the business transaction into an operational part and a valuating part:

  • For the operational part (vendor invoice), the system posts a document valid for all accounting principles against the technical clearing account for integrated asset acquisitions. From a technical perspective, the system generates a ledger-group-independent document.



  • For each valuating part (asset posting with capitalization of the asset), the system generates a separate document that is valid only for the given accounting principle. This document is also posted against the technical clearing account for integrated asset acquisitions. From a technical perspective, the system generates ledger-group-specific documents for each accounting principle."




 

5. Specify alternative document type for the valuation part of the posting


The derived document type is for the valuation posting created at the same moment of vendor invoice when posting Asset aquisition



 

6. Determine Depreciations Areas in Asset Class


Select Asset class 3000





--> Deactivate all depreaciations areas except 01 and 12 areas

--> Set the usefull life 2 years for depreciation area 01 and 4 years for depreciation area 12

 

7. Business Scenario for Parallel Ledger Valuation


The company FR01 needs to maintain accounting and reporting for Assets in both group and local accounting principles,

In this scénario will process the following flow and track accounting posting and reporting in both acct principles

Create an asset, Post acquisition,  Run depreciation, post retirement

7.1 Create asset


Create asset for Fixture and fitting (class 3000) with straight line depreciation method for depreciation area 1 and depreciations area 12

  • In Class 3000 for Area 1, the useful life is 2 years

  • In Class 3000 for Area 12, the useful life is 4 year


Transaction: AS01





 

7.2 Asset Aquisition


Asset acquisition for 2400 Euros

Transaction: F-90



  • Operational part (vendor invoice)




  • Valuating part (asset posting with capitalization of the asset)




 

7.3 Asset Depreciation Run


Transaction: AFAB

Posting for the first 5 periods of 2020.

Asset explorer for IFRS (0L)



--> Posted depreciation value 500,00 Euos for ledger “0L” for 5 periods (100,00 Euros per period).

Depreciation FI document posted to Ledger 0L:



 

Asset explorer for Local GAAP (2L)



--> Posted depreciation value 250,00 Euros for ledger “2L” for 5 periods (50,00 Euros per period).

Depreciation FI document posted to Ledger 2L:



 

7.4 Asset Retirement


Asset retirement for a sale value of 2000 Euros

Transaction: ABAON



 

Posting to IFRS acct principles (Ledger 0L)

--> 100 Euros gain for 0L ledger









 

Posting to LG acct principles (Ledger 2L)

--> 150 Euros Loss for ledger 2L









 

--> In IFRS Depreciation area we have a gain of 100 Euros and in the LG depreciation area we have 150 Euros loss

Using the parallel ledgers 0L and 2L, we are able to run parallel valuation according to different accounting principles

 

Please feel free to comment

 

Best Regards

Ihsen ABROUG
17 Comments