SAP Production Order Cost Flow: Excel Worksheet | ERPCorp
SAP Controlling Conference attendees participating in a presentation

Search Posts

By Marjorie Wright

Marjorie Wright, SAP Controlling consultant and conference speakerUse this free Excel worksheet to trace how costs post in Financial Accounting (FI) and Controlling (CO) for an SAP make-to-stock production order. Marjorie Wright shared the worksheet in her conference session Filling in the Gaps: FICO Account Posting.

Download the Cost Flow Worksheet

Download CostFlow.xlsx

What the Workbook Covers

  • HowTo explains how to read the debit and credit indicators and use your own account determination in the worksheet.
  • Production Accounting Flow maps component goods issues, labor confirmations, and finished goods receipts to their FI and CO postings. It also covers period-end overhead, work in process (WIP), and variances.

Start with the HowTo tab. Then select a transaction in the posting matrix and compare the expected debits and credits with the documents from a test order. The worksheet illustrates a classic period-end scenario. Use your own SAP release and configuration when validating the postings.

Related Reading