Internal Order settlement : how to post WIP to FI; how to transfer Cost-of-Sales and Revenue to COPA
The purpose of this blog is to describe the Settlement of an Internal Order to CO-PA, FI and EC-PCA.
Major focus will be on the settlement of the amounts calculated by Results Analysis (RA), i.e., Cost-of-Sales, Revenue to CO-PA; WIP posting to FI.
This blog will try to answer the below questions:
- What kind of G/L Accounts are posted to when WIP is posted to FI?
- What is the configuration required for posting WIP, and reporting Cost of Sales & Revenue to CO-PA?
- What kind of documents are posted after an Order settlement is executed?
For background on Results Analysis, you may refer to my previous blog, “Calculating Results Analysis for Internal Orders“, where we took a deep dive into the business requirement & the configuration required for performing Results Analysis and calculating the WIP amount.
In order to have an idea of the whole life of an Internal Order which is used for managing the costs & revenues posted over a couple of months, please take a look at the flow below:
What kind of G/L Accounts are posted to when WIP is posted to FI?
Ans. : Two types of G/L Accounts, a P&L Account, and a Balance Sheet Account.
Well, let us first try to understand what the WIP amount is and why it is posted to FI.
WIP amount can be considered as an expense which is yet to generate a Revenue.
Since an expense posting is done but the corresponding Revenues are not recorded yet, the Income Statement (or P&L statement) would give an impression that expenses are more as compared to the Revenue.
So, in order to display a more correct picture of a company’s financial situation, the burden on P&L statement is knocked-off by posting the WIP to a BS Account.
Hence, when WIP is posted, the accounting document will have 2 line items,
Debit: A BS Account
Credit: A P&L Account
‘Settlement’ is nothing but a transfer of costs from one object to another.
In the scenario in this blog, Internal order will transfer its costs to Profitability Segment (PSG).
What is the configuration required for posting WIP, and reporting Cost of Sales & Revenue to CO-PA?
Please note that no matter which method you use for results analysis, the configuration required for the settlement of the calculated amounts to COPA, FI & EC-PCA remains the same.
A) Configuration steps required for posting WIP Amounts to FI & EC-PCA:
Step A1. Create two G/L Accounts, a P&L Account, and a Balance Sheet Account.
(The purpose of having these two G/L Accounts has already been explained earlier.)
‘License Costs Transfer (P&L Acc.)’ – 40000900
(This G/L Acc. must not be created as a Cost Element)
‘License Costs WIP (BS Acc.)’ – 22000900
Step A2. Assign these two G/L Accounts to RA Category ‘WIPR’.
B) Configuration steps required for the settlement of Cost of Sales & Revenue to CO-PA:
Step B1. Create an Allocation structure.
The settlement of data to Profitability Analysis is controlled by an Allocation structure.
It is a set-up, which links Sender Cost elements to Receiver Cost Elements.
The below illustration tries to visualize the purpose & constituents of an Allocation structure.
Create an Allocation structure N1. (T-code OKOA)
Next, create two ‘Assignments’,
N11 – For the settlement of Revenue Affecting Net Income
N12 – For the settlement of Cost of Sales (or Costs Affecting Net Income)
Here, the ‘Source’ of Assignment N11 is the Cost Element in CE Group ZCEGRP01.
We have only one Cost element in this group.
‘COGS Revenue for License’ – 93120007 (Sec. CE of CE Category 31) – (After Results Analysis, ‘Revenue Affecting Net Income’ is stored in this CE.)
Next, we need to define the Cost element to which the costs will be settled.
We use a Cost Element of Category 21 (Internal Settlement) for this purpose.
License Revenue Settlement Acc. (92100202)
For a settlement to CO-PA, the settlement category must be ‘PSG’ (Profitability Segment).
This completes the setup of Assignment N11.
Next, we set up Assignment N12 with the same underlying concept.
Here, the ‘Source’ of Assignment N12 is the Cost Element in CE Group ZCEGRP02.
We have only one Cost element in this group.
Step B2. Create a PA Transfer structure.
A PA Transfer structure is a rule or a set-up, which will link Cost elements to CO-PA Value fields.
The below illustration tries to visualize the purpose & constituents of a PA Transfer structure.
Create a PA Transfer structure ‘N1’. (T-code OKOA)
Create two Assignment lines each for License Revenues & License costs.
The ‘Source’ of Assignment Line N11 contains the below Cost Element in CE Group ZCEGRP01.
‘COGS Revenue for License’ – 93120007 (Sec. CE of CE Category 31)
(After Results Analysis, Revenue Affecting Net Income is stored in this CE.)
We assign the above Cost element to a Value field called ‘License Revenues’ (VVA04).
The ‘Source’ of Assignment Line N12 contains the below Cost Element in CE Group ZCEGRP02.
‘COGS Revenue for License’ – 93120003 (Sec. CE of CE Category 31)
(After Results Analysis, Cost of Sales is stored in this CE.)
Step B3. Create a settlement profile.
Default the above created Allocation Structure and PA Transfer Structure to this settlement profile.
IMG path –> Controlling> Product Cost Controlling> Cost Object Controlling> Product Cost by Sales Order> Period End Closing> Settlement> Create Settlement Profile
Step B4. Assign the above settlement profile to your Order type.
This defaults the settlement profile when you create an Internal Order master data.
However, please note that unlike the settlement profile, the ‘Results Analysis key’ cannot be set as default through Order type.
You need to create a Model order for that purpose.
With this last step, the configuration required for settlement is over, and we are ready to execute an order settlement.
Let us take the same business scenario as in my previous blog, say for a certain Internal order which captures the costs and revenues of License, below was the Results Analysis at a certain period end.
(RA Method Used in this example = (01) Revenue-Based Method with Profit Realization)
Perform RA for the Order and save it. (T-code KKA1)
Let us do a little bit of calculation here.
For the Internal Order in this example,
Total Costs planned = 80,000
Total Revenue planned = 100,000
Actual costs = 60,000
Actual Revenue = 50,000
So, Cost of Sales is calculated as
C(PA) = PoC * C(p)
= R(a)/R(p) * C(p)
Revenue Affecting Net Income = PoC * R(p) = R(a) = 50,000
WIP = Actual costs – Cost of Sales
= 60,000 – 40,000 = 20,000
Once the RA Analysis is saved, the below entries are created in Table COSB.
Category for Variance/Results Analysis
Work in Process with Requirement to Capitalize
Cost of Sales with Requirement to Capitalize
Valuated Actual Revenue/Revenue Affecting Net Income
Finally, perform settlement of the Internal Order. (T-code KO88)
Observe that the Sender is Internal Order (ORD LTEST01) & Receiver is a Profitability Segment (PSG).
However, please note that the PSG is only posted statistically.
As a result of this settlement, the below types of documents are posted:
- Accounting (FI) Document. (2 No. of Docs.)
- Profit Center Account (PCA) Document.
- Controlling (CO) Document.
- Profitability Analysis (PA) Document.
Accounting Document generated for WIP posting to FI:
As we can observe from the below document, the WIP Amount is Credited from P&L Account and Debited to the BS Account.
Profit Center Document generated as a result of posting to EC-PCA:
CO-PA Document line item showing that Value fields are updated with Revenue and Cost of Sales.
Controlling Document generated on account of statistical posting from Internal Order to Profitability Segment:
Accounting Document generated with reference to CO document posted for transferring Cost of Sales & Revenue to CO-PA.
A few important observations:
- Since the settlement to CO-PA is a statistical transfer of costs, the Internal Order is not credited during this settlement. (PSG here is a statistical cost object)
- No Special Configuration is required for posting WIP to EC-PCA.
If EC-PCA is active in the system, and the WIP BS Account and P&L Account is maintained in 3KEH (or FAGL3KEH), then a Profit Center Document will be posted automatically.
I hope this blog was able to explain not only the configuration required for an order settlement; but also the concepts behind WIP posting to FI; as well as Cost of Sales & Revenue posting to CO-PA.
Copying my content and publishing it on other sites will be subject to legal action.
Hi Gary, thanks for your detailed step by step share. it is very useful.
Excellent explanation with detailed steps, thanks for sharing.
Hello Lucy Gray,
Thanks a lot for sharing such a wonderful explanation with very detailed steps. I have a question regarding the accounting entry for WIP Settlement to FI. In the accounting document you have the Order number updated in both P&L and B/S line items, even though the P/L is a non cost element. Do you know how is this working? As per latest SAP note 2656171, Co object is not get assigned in the line item of WIP. Any further update or notes from SAP ?
Hi Harekrushna Senapati,
Thank you for your comment, and Sorry for the delay in my reply.
The assignment of internal order no. to B/S and P&L line items is purely statistical.
In other words, the assignment of order no. to P&L account does not mean that 20,000 USD was posted to this order. (As you might have observed, there is no Controlling document generated w.r.t. the FI doc. of WIP.)
Hence, this behavior is in line with SAP note 2656171, since the order was not debited/credit as a result of the WIP posting. The order no. has been assigned to the line items only for information purpose.
I hope this clarifies your doubt. Please feel free to write back if it is unclear.
Thanks & Regards,
Hi Lucy Gray, thanks for spending ur time and effort for this document.