Period-End Closing Sales Order - Results Analysis

Objectives

After completing this lesson, you will be able to:
  • Outline results analysis and settlement of sales orders
  • Perform results analysis for partial and final delivered sales orders

Overview of Results Analysis and Settlement

Note

The results analysis will be performed for two accounting rules:
  • International Financial Reporting Standards using results analysis version 0

  • Local accounting rule using results analysis version 1

The settlement to parallel ledgers to Financial Accounting is working. But in release S/4HANA 1909, the settlement of parallel ledgers to CO-PA is under construction. Therefore, the results analysis will be performed for both accounting rules, but only the results analysis for IFRS will be settled to Financial Accounting and CO-PA.

The image depicts a cost object breakdown for SD Order 7000 item 10 FIN-I. It shows the planned and actual revenue, costs, and special costs. It also illustrates the flow of expenses, inventory changes, credits, and price differences impacting customers, with work in process and goods in transit at the bottom.

You can use results analysis to calculate the stock of Work In Process (WIP). You can activate the costs that indicate relevant options by means of settlement to Financial Accounting (FI). Results analysis is recommended when costs do not have any respective revenues or period-based income.

Invoices

The image illustrates the flow of a sales order process, including the SD order, delivery, invoices, cost object with planned and actual revenues/costs, and impacts on expense, inventory, customers, and sales revenue using symbols and text boxes connected by arrows.

During the billing process, the customer is invoiced for the goods and services delivered for a sales order. You create an invoice or a billing document based on the reference document in Sales and Distribution. Invoicing or billing posts the actual revenues to the sales order.

Calculation

The sales price can be calculated in the following ways:

  • Based on conditions, such as material or customer, using pricing
  • Based on the incurred costs if you want to use resource-related billing

Note

When you generate a billing document, the system proposes a billing type depending on the sample document.

Billing Type

The billing type determines the following:

  • The type of pricing procedure used for account determination for FI
  • Whether the invoices are passed immediately to FI

Results Analysis and Settlement (2)

This diagram illustrates the cost object and profit calculation for an SD order 7000, showing planned and actual revenues, costs including FIN-I and special costs, WIP reserves, COGS, and the resulting impact on inventory, credit, reserve, and sales revenue accounts, as well as the final profit object with revenue and cost of sales values.

You can change the status of the sales order item if you do not want to map stock or reserves. The Final Billing status informs the system that no further revenues are expected. The Technically Completed status informs the system that you expect no further costs. In this case, the system does not create further stock or reserves. It cancels existing stock and reserves on the costs and revenues side.

Settlement of Variances to Profitability Analysis

The image illustrates a profit object showing revenue of 500, cost of sales of 200, variance for finished and semi-finished goods. It depicts planned and actual costs for different order types and activities, as well as their variances. The image also shows connections to inventory, customers, price differences, and credit.

The manufacturing orders contain the full actual costs of manufacturing a material. You can calculate variances at production order level and settle them to Profitability Analysis (CO-PA) as well as to Financial Accounting.

Note

To settle the different variance categories to FI, you have to customize a Price Difference Profile in the customizing of FI-General Ledger. In this profile, you assign cost elements plus variance category to G/L accounts.

Settlement of Price Differences to the Sales Order Item

The image depicts a detailed diagram illustrating the cost and revenue flows associated with a sales order (SD Order 7000/10). It shows the planned and actual costs, revenues, profit calculations, as well as the impact on inventory, expenses, and price differences for customers.

In complex MTO scenarios, you have the opportunity to collect all production costs, including price differences on the sales order item level. You can define the price difference account as a cost element and settle the value to the sales order item when settlement to FI takes place. In this case, it is recommended not to settle the variances of the production order to CO-PA, because the sales controlling is performed on the sales order item which is the cost object.

Results Analysis in Detail

The image shows a side-by-side comparison of planned and actual values for various order items like material, internal activities, overhead, and process costs. It also provides a results analysis section displaying categories like revenue, cost of sales, work in process, and reserve.

Results analysis can calculate the following values:

  • Inventory values
  • Reserves for unrealized costs
  • Reserves for imminent loss
  • Reserves for complaints and provisions
  • Cost of sale

Integration of Results Analysis (2)

The image displays various business accounting and financial analysis concepts, including order item details with plan vs actual values, profitability analysis breaking down revenue, cost of sales and profit, financial accounting covering WIP, inventory changes, reserves and expenses.

The results from results analysis are transferred to Financial Accounting (FI), Profitability Analysis (CO-PA), and Profit Center Accounting (PCA).

You can also transfer the following values to FI and CO-PCA:

  • Inventory values
  • Reserves for unrealized costs
  • Reserves for imminent loss
  • Reserves for complaints and provisions
  • The costs of sale (if you are using non-valuated sales order stock and the cost-of-sales accounting method in FI)

You can settle the following with CO-PA:

  • Cost of sales or calculated revenue
  • Reserves for imminent loss and complaints

General Approach (1)

The image illustrates the concept of profitability analysis, showing the calculation of profit as the difference between revenues (R(PA)) and cost of sales (C(PA)). It explains that these values are derived by multiplying the percentage of completion with planned revenue and planned costs, respectively.

Calculating the percentage of completion (POC) for the cost object is the starting point for calculating accrual values.

General Approach (2)

The image contrasts profitability analysis using revenues and cost of sales against financial accounting using actual costs and revenues. It highlights that cost-of-sales profitability does not equal accounting profit or loss, illustrating a key difference between managerial and financial accounting perspectives.

The period-based costs and revenues of a sale are calculated from the POC. If these values are settled to PA, the profit generated in CO-PA differs from the profit generated in FI and PCA.

General Approach (3)

The image depicts a profitability analysis flowchart, showing how costs and revenues are calculated to determine profit or loss. It includes formulas for calculating work in process inventory, reserves, capitalized revenue, and revenue surplus based on comparisons of actual costs and revenues to expected values.

Stock and reserves are calculated in terms of the costs and revenue, depending on the data model.

General Approach (4)

The image depicts a flow chart illustrating profitability analysis, settlement process, and financial accounting for revenue and costs. It shows formulas for calculating work in progress (WIP), reserves, capitalized revenue, and revenue surplus based on actual revenues and costs compared to projected amounts.

Stock and reserves are transferred to FI and PCA so that the profit generated there is the same as the profit in CO-PA.

Method-Based Results Analysis

You can choose any of the following method-based results analysis:

01 – Revenue-based method with profit realization 
02 – Revenue-based method without profit realization 
03 – Cost-based POC method
04 – Quantity-based method
05 – Quantity-based POC method
06 – POC method based on the revenue planned by period
07 – POC method based on the project progress value determination
08 – Derive COS from resource-related billing
09 – Completed contract method
10 – Inventory determination, without planned costs, without partial billing
11 – Inventory determination, without planned costs, with partial billing
12 – Inventory determination, provisions for follow-up costs, with partial billing
13 – Inventory determination work in process (WIP) at actual cost for objects not carrying revenue
14 – Derive COS from resource-related billing of dynamic items
15 – Derive revenue from resource-related billing and simulation of dynamic items
16 – Cost-based POC method without profit realization if planned revenue > planned costs
17 – Cost-based POC method without profit realization and loss realization

The system can carry out results analysis for cost objects automatically. The type of results analysis method you choose depends on your business requirements. Several methods can be used simultaneously in different business areas. The results analysis method contains the rule for calculating results analysis data.

Revenue-Based Method

The image illustrates formulas for calculating the percentage of completion (POC) and profitability analysis (R(PA) and C(PA)) in project management, involving revenue, cost, and profit factors. It provides a visual representation of these key performance metrics used in project evaluation.

To explain the results analysis work method, you can choose different methods for generating accrual values, as well as revenue-based and cost-based methods.

The revenue-based method derives the POC from the relationship between the actual and planned revenue. This means that actual revenue is correctly assessed according to period-based activity. You can calculate profit-relevant costs by multiplying planned costs by the POC: [C (pa) = C (p) xR (a) / R (p)].

The corresponding stock and provisions are mapped in the following ways:

  • The system creates WIP if the actual costs are greater than the costs relevant to profit.
  • The system creates reserves for unrealized costs if the actual costs are less than the costs relevant to profit.

Note

If you are using the revenue-based method with profit realization, the calculated cost of sales is zero as long as your actual revenue for the period is zero. The WIP then equals the actual costs of the period.

The revenue-based method provides the following functions:

  • Creating reserves for unrealized costs
  • Creating reserves for imminent losses
  • Using milestone billing
  • Reporting intermediate profits

Example – Revenue-Based Results Analysis (1)

The image displays a profitability analysis workflow, showing the planned and actual revenue, costs, and profit calculations. It illustrates settlements being made from the order item results to the profitability analysis and financial accounting sections, tracking work-in-process (WIP) and inventory changes along with profit/loss figures.

You have planned revenue of 3,000 and costs of 2,000 for the sales order. You have actual costs of 1,000 but no revenue.

The system calculates the following data during results analysis:

  • Revenue – 0
  • Cost of sales – 0
  • Costs to be capitalized in stock (WIP) – 1,000

During the settlement process no line items are generated for CO-PA. You settle the capitalized costs to FI and PCA. The actual amounts of 1,000 profit and 1,000 loss are generated on the profit and loss account because the inventory change account is settled to the profit and loss account. As in CO-PA, FI and PCA do not generate any profit.

Example – Revenue-Based Results Analysis (2)

An image depicting the process of profitability analysis and financial accounting, showing the calculation of profit based on revenue, cost of sales, and settlement figures. It illustrates the connection between operational data, profitability metrics, and financial reporting of profit/loss and inventory changes.

You have actual costs of 1,000 and actual revenue of 1,200.

The system calculates the following data during results analysis:

  • Revenue – 1200
  • Cost of sales – 800
  • Costs to be capitalized in stock (WIP) – 200

CO-PA indicates a profit of 400. You settle the capitalized costs to FI and PCA. During settlement, the posting is created as WIP against inventory change account 200. Because the inventory change account is settled to the profit and loss account, an actual revenue of 1,200 plus 200 inventory change in profit and actual costs of 1,000 in losses are generated on the profit and loss account. As in CO-PA, FI and PCA generate a profit of 400.

Example – Revenue-Based Results Analysis (3)

The image displays a flow diagram illustrating the process of profitability analysis and financial accounting. It shows how order item details like planned and actual revenue and costs feed into results analysis, which calculates revenue, cost of sales, and reserves.

You have actual costs of 1,800 and actual revenue of 3,000.

The system calculates the following data during results analysis:

  • Revenue – 3000
  • Cost of sales – 2000
  • Reserves for unrealized costs – 200

Revenue minus cost of sales generates a profit of 1,000. You settle the reserves to FI and PCA. Because the inventory change account is settled to the profit and loss account, an actual revenue of 3,000 is indicated as profit. Actual costs of 1,800 plus the inventory change of 200 are indicated as a loss by the profit and loss account. As in CO-PA, FI and PCA indicate a profit of 1,000.

Valuation Method - Cost-Based POC

The image displays formulas for calculating the percentage of completion and profitability analysis in project management. It shows how the percentage of completion (POC) is derived from actual cost over planned cost. The profitability analysis formulas calculate revenue and cost over the profitability analysis period to determine profit.

The cost-based POC method derives POC from the relationship between actual and planned costs. This means that actual costs are assessed correctly on the basis of period. The POC method differs from revenue-based results analysis, particularly when actual costs have been incurred but no revenue has been received. The system calculates the profit-relevant revenue by multiplying the planned revenue by the percentage of completion (POC): R(pa) = R(p) x C(a) / C(p).

Profit-relevant revenue is processed as follows:

  • The system creates a revenue surplus if the actual revenue is greater than the profit-relevant revenue.
  • The system creates revenue in excess billings if the actual revenue is less than the profit-relevant revenue.

Example – Cost-Based POC Method (1)

The image presents a flow diagram analyzing profitability and financial accounting for an order item. It shows the planned revenue and costs, actual results with revenue of 1500 and cost of sales 1000, a profitability analysis, and a financial accounting section displaying profit/loss, work-in-progress inventory, and inventory change values. Settlement arrows connect the different components.

You have planned revenue of 3,000 and costs of 2,000 for your sales order. You have actual costs of 1,000, but no revenue.

The system calculates the following data during results analysis:

  • Costs affecting net income of the sale (cost of sale) – 1,000
  • Revenue affecting net income – 1,500
  • Revenue in excess of billings – 1,500

Revenue minus cost of sales generates a profit of 500. You then settle the capitalized costs to FI and PCA.

Based on posting rules, which must be maintained in Customizing, settlement generates the following posting: inventory account against inventory change account, that is, 1,500. Because the inventory change account is settled to the profit and loss account, actual amounts of 1,500 (profit) and 1,000 (loss) are generated on the profit and loss account. As in CO-PA, FI and PCA generate a profit of 500.

Example – Cost-Based POC Method (2)

The image illustrates the profitability analysis process, including order item with planned and actual revenue/costs, results analysis showing revenue, cost of sales and capitalized revenue, settlement calculation with R(PA) and C(PA) values leading to profit amount, and finally the financial accounting section showing profit/loss, WIP (work in progress), and inventory change values.

You have actual cost of 1,000 and an actual revenue of 1,500.

The system calculates the following data during results analysis:

  • Costs affecting net income of the sale (cost of sale) – 1,000
  • Revenue affecting net income – 1,500
  • Revenue in excess of billings – 300

Revenue minus cost of sales generates a profit of 500. You then settle the capitalized costs to FI and PCA.

Settlement generates the following posting: inventory account against inventory change account, that is, 300. This is based on posting rules, which must be maintained in Customizing. An actual revenue of 1,200 plus 300 inventory change in profit and actual costs of 1,000 in losses are generated on the profit and loss account. As in CO-PA, FI and PCA generate a profit of 500.

Example – Cost-Based POC Method (3)

The image presents a profitability analysis workflow, showing calculations and accounting entries related to revenue, costs, profit, and settlements. It covers key steps like determining the profit on costs ratio, analyzing revenue surplus based on planned versus actual figures, and recording the profit/loss and revenue surplus in financial accounting statements.

You have actual cost of 1,800 and an actual revenue of 3,000.

The system calculates the following data during results analysis:

  • Costs affecting net income of the sale (cost of sale) – 1,800
  • Revenue affecting net income – 2,700
  • Revenue surplus – 300

Revenue minus cost of sales generates a profit of 900. You then settle the capitalized costs to FI and PCA.

Settlement generates the following posting: inventory change account against inventory account, that is, 300. This is based on the posting rules, which must be maintained in Customizing. An actual revenue of 3,000 in profit and actual costs of 1,800 plus 300 inventory change in losses are generated on the profit and loss account. As in CO-PA, FI and PCA generate a profit of 900.

Valuation Method - Planned Costs and Partial Billing

The image shows accounting methods for handling revenues and expenses based on percentage of completion status. It outlines two methods - capitalizing all expenses when there is no revenue, or treating all expenses as costs of sales when revenues are posted. It also provides formulas for calculating work in progress (WIP) and costs of sales based on percentage of completion status being 0 or greater than 0.

Inventory determination without planned costs and partial billing is an example of a valuation method. If you use the valuation method, the calculated cost of sales is zero as long as your actual revenue is zero. The WIP is equal to the actual costs during this time.

If the actual revenue is not zero, the calculated cost of sales is equal to the actual costs. The WIP is canceled when the actual revenues are received. During billing, it is not possible to activate WIP.

The cost portion in stock is canceled when it achieves the TECO status.

Note

The method without planned costs and partial billing does not allow you to create reserves and is not suitable for milestone billing because this type of billing results in the final cancellation of WIP.

Connection between the cost of sales and revenue

As soon as the revenue has been received, the actual costs are considered as the full cost of sales. This means that the cost of sales is neither proportionate to the actual revenues, as with the revenue-based method, nor to the quantity sold, as with the quantity-based method. One advantage of this method is that you do not require plan values.

Perform Results Analysis for Partial and Final Delivered Sales Orders

Summary

  • Results analysis calculates stock of work in process and activates costs for settlement to Financial Accounting.
  • Billing posts actual revenues to the sales order based on reference documents in Sales and Distribution.
  • Manufacturing orders contain full actual costs; variances can be settled to Profitability Analysis and Financial Accounting.
  • Results analysis calculates inventory values, reserves for unrealized costs, imminent loss, complaints, provisions, and cost of sale.
  • Results analysis values are transferred to Financial Accounting, Profitability Analysis, and Profit Center Accounting.