Now accepting guest editorial from SAP, Oracle, Workday and ServiceNow practitioners.Pitch a guide
The Sign-Off Table

Lesson 4 of 5

Reporting by profit center

10 min

Listen to this lesson

0:00 / 6:22

Because profit center values are fields on every Universal Journal line, any report built on the journal can show results by profit center. The skill is not finding a report; it is reading the numbers critically and following a figure back to the documents behind it.

Income statement by profit center

Revenue, cost of goods sold, production variances and overhead all carry a profit center, so a profit and loss statement per profit center is always possible. In the SAP Fiori launchpad, analytical apps such as Profit Centers - Actuals show actual values by profit center and account; the Trial Balance app and financial statement reports can be filtered or drilled down by profit center and segment. App names and versions vary by release, so confirm the catalog your role offers.

LineCMC-FLEETCMC-AFTMKTWhat to ask
RevenueUSD 1,920,000USD 1,140,000Does it match billing by distribution channel?
Cost of goods soldUSD 1,200,000USD 696,000Is the ratio to revenue plausible for each?
Production variancesUSD 18,400USD 4,100Where were the orders produced?
Overhead from cost centersUSD 260,000USD 190,000Are allocations to both complete?
Operating resultUSD 441,600USD 249,900Any postings on CMC-DUMMY that belong here?
A simplified monthly income statement by profit center (illustrative figures).
The Sign-Off Table · thesignofftable.com/academy/sap-co-203

Balance sheet by profit center

A complete balance sheet per profit center needs more than derivation. Receivables, payables, tax and bank lines do not carry a profit center naturally; document splitting by profit center fills them and makes every document balance per profit center. Contoso has splitting active, so Dan gets full balance sheets for CMC-FLEET and CMC-AFTMKT. Without splitting, you would see inventory, assets and work in process by profit center but not a balancing set of liabilities. The course on document splitting covers this in depth.

Document splitting gives the payable line the profit centers of the expense lines, so the invoice balances per profit center.
The Sign-Off Table · thesignofftable.com/academy/sap-co-203
Full balance sheet per profit centerRequires document splitting with profit center as a balancing characteristic
Partial balance sheetInventory, assets, WIP: lines that derive a profit center from objects
Income statement per profit centerRevenue, COGS, variances, overhead: always derivable
Universal Journal linesEach line carries profit center, segment and partner profit center
What you can report by profit center, depending on the design.
The Sign-Off Table · thesignofftable.com/academy/sap-co-203

From a figure to the source document

Every number in a profit center report should be traceable. A practical path: start from the figure in the report, drill to the G/L account, then to the journal entry line items for that account and profit center, then open the journal entry and from there the source document (billing document, goods movement, supplier invoice). The line item views in Fiori and the classic line item report KE5Z serve the same purpose.

  1. Report figureCMC-AFTMKT revenue seems USD 40,000 too high
  2. G/L accountDrill to the revenue account for June
  3. Line itemsFilter by profit center; sort by amount
  4. Journal entryOpen the largest unusual line
  5. Source documentBilling document for a fleet customer in the aftermarket channel
Drill-down from a profit center figure to its source.
The Sign-Off Table · thesignofftable.com/academy/sap-co-203

Profit center reports also show partner profit centers. When stock moves from a Fleet plant to an Aftermarket order, or when one profit center charges another, the partner field records the counterparty. In the Universal Journal these are the fields PRCTR and SEGMENT for the line's own values and PPRCTR and PSEGMENT for the partner, which is what a sweep query or a CDS-based report filters on. Partner information lets Dan see internal flows between CMC-FLEET and CMC-AFTMKT and remove them when he needs a consolidated view of the company. If partner fields are empty on internal flows, the internal positions are still there, but nobody can tell who owes whom.

Filled partner profit centers let Dan identify internal flows between Fleet and Aftermarket and eliminate them for a company view.
The Sign-Off Table · thesignofftable.com/academy/sap-co-203

Questions a controller should ask

  • Is anything on the dummy profit center? If yes, which processes put it there?
  • Do revenues by profit center agree with sales by distribution channel?
  • Did all cost center allocations and settlements run, so overhead is complete for each profit center?
  • Do segment totals equal the sum of their profit centers?
  • For the balance sheet, does each profit center balance to zero across all accounts?

What would you do?

The segment report shows Fleet USD 12,000 lower than the sum of CMC-FLEET in the profit center report for the same period. What is the most likely explanation?

Key points
  • Any Universal Journal report can show results by profit center.
  • A full balance sheet per profit center needs document splitting.
  • Drill from report figure to account, line item, journal entry and source document.
  • Check the dummy profit center and segment consistency every close.

Check your understanding · not graded

Lesson check

  1. 1. What is needed for a complete balance sheet per profit center?

  2. 2. Which lines always carry a profit center without splitting?

  3. 3. What is the last step of a drill-down from a profit center figure?

  4. 4. Which Universal Journal field holds the partner profit center on a line?