Main menu

ERPCorp SAP FICO Blog

Tips on how to reconcile costing based CO-PA and GL

Why should we worry about reconciling costing based Profitability Analysis (CO-PA) to the GL? After all, GL is the book of record from an external reporting stand point. However, CO-PA has several advantages that the GL does not provide. For example, CO-PA can give us details on revenue and cost of sales (COS) split by sales order, product line, customer, etc. as opposed to the GL, which gives us only total revenue and total COS. CO-PA allows us to drill down to the details of a company’s profitability – customer, product line, which can be especially useful when forecasting future sales/COS. Therefore, CO-PA is an important financial tool; however for it to be accurate, we need procedures to reconcile or explain differences between CO-PA and the GL. 

save 400 button

 For my company SPX Genfare it is important to reconcile CO-PA to the GL since we use the CO-PA line item report KE24 to provide monthly actuals data by customer, product type, and contract size that is loaded in our Hyperion Planning forecasting system. In order to have an accurate base for forecasting, we need to have accurate (with non-material difference) historical data. 

So, how do we reconcile the CO-PA line item report KE24 to the GL?

1. Include manual journal entries (record type “B”) when running KE24

2. All manual journal entries that include revenue and COS must include profitability fields (sales order, customer) in order to post to CO-PA. More details of the requirements are:

A. Profitability fields for all revenue accounts  and manual COS accounts are mandatory

B. Profitability fields for the general COS account are not mandatory since, sometimes, journal entries are recorded to COS but are not related to a specific sales order. These journal entries will be reconciling items between CO-PA and the GL.

3. The above steps minimize the reconciling differences between CO-PA and the GL however they do not eliminate them. There can be timing differences since:

A. CO-PA posts both revenue and COS when an item is invoiced

B. GL posts COS during goods issue, and revenue when an item is invoiced

Run transaction KEAT to display postings to the GL in previous periods, and not yet billed.

4. Remaining reconciling differences between CO-PA and GL result from revenue and COS related to repairs sales orders. Most repair order revenue and COS are not recorded in CO-PA due to the order billing types. We are working on finding ways where they are not a reconciling item. 

During the “Case Study: How SPX Genfare leverages SAP Profitability Analysis (CO-PA) data to feed Hyperion planning” session at Controlling 2014 you will learn more details about the topics discussed above and walk away from the session with an understanding of why SPX selected Oracle’s Hyperion Planning tool to streamline and standardize forecasting across businesses.

 

Exclusive Sneak Peek of New SAP Smart Accounting F...
How Johnson & Johnson Leverages SAP CO-PA Configur...

Related Posts

 

Comments 1

Guest - tereza on Saturday, 27 July 2019 15:02

Hello all my viewers, This is my testimony on how i won $310.5 Million in Power ball I want to use this opportunity to thank dr clement for casting winning spell for me to win the lottery of $310.5 million lottery ticket. I have been playing lotteries for the past 4 years now and i have never won any. Ever since then i have not been able to win any lotto and i was so upset and i needed help to win this mega million lottery. so i decided to go online and search for help, there i saw so many good testimony about this man called Dr clement of how he has cast lucky spell lotto for people to win the lottery. I contacted him also and tell him i want to win the power-ball l, he cast a spell for me which i use to play and won $310.5 million dollars in power-ball lottery. I am so grateful to this man, just in-case you also need him to help you win, you can contact him through his email: allmightbazulartemple@gmail.comm and he will surely help you just the way he has helped me. i will forever be grateful to him and always testify the good work of him to the hole world. contact him via and he will surely help you to win any kind of lottery?he can also help people who have a relationship problem .email: allmightbazulartemple@gmail.com or Whats App him on +2347051758952 or check out his website http:// thanks for reading friend post by Teresa
Dr.clement can also cure all kind of disease with herbal medicine like
1. HIV / AIDS
2. HERPES simplex
3. CANCER
4. warts disease)
5. Hepatitis
6. chronic pancreatic
7. high blood
8. COPD (chronic obstructive pulmonary disease)
9 getting your ex back

Hello all my viewers, This is my testimony on how i won $310.5 Million in Power ball I want to use this opportunity to thank dr clement for casting winning spell for me to win the lottery of $310.5 million lottery ticket. I have been playing lotteries for the past 4 years now and i have never won any. Ever since then i have not been able to win any lotto and i was so upset and i needed help to win this mega million lottery. so i decided to go online and search for help, there i saw so many good testimony about this man called Dr clement of how he has cast lucky spell lotto for people to win the lottery. I contacted him also and tell him i want to win the power-ball l, he cast a spell for me which i use to play and won $310.5 million dollars in power-ball lottery. I am so grateful to this man, just in-case you also need him to help you win, you can contact him through his email: allmightbazulartemple@gmail.comm and he will surely help you just the way he has helped me. i will forever be grateful to him and always testify the good work of him to the hole world. contact him via and he will surely help you to win any kind of lottery?he can also help people who have a relationship problem .email: allmightbazulartemple@gmail.com or Whats App him on +2347051758952 or check out his website http:// thanks for reading friend post by Teresa Dr.clement can also cure all kind of disease with herbal medicine like 1. HIV / AIDS 2. HERPES simplex 3. CANCER 4. warts disease) 5. Hepatitis 6. chronic pancreatic 7. high blood 8. COPD (chronic obstructive pulmonary disease) 9 getting your ex back
Already Registered? Login Here
Guest
Tuesday, 20 August 2019