Lesson 3 of 5
Reconciliation in the universal journal world
12 min
Listen to this lesson
In SAP ECC, finance teams spent days of every close reconciling: FI to CO, the general ledger to profit center accounting, asset accounting to the general ledger, inventory to the G/L. SAP S/4HANA's universal journal removed much of this by storing one set of line items for financial accounting, controlling, asset accounting and the material ledger. Testers need to know which reconciliations disappeared, which remain, and how to prove the remaining ones.
What the universal journal changed
| Reconciliation | SAP ECC | SAP S/4HANA | What testers still check |
|---|---|---|---|
| FI to CO | Separate documents; reconciliation ledger | Same line items; no reconciliation ledger | Cost objects on each line are the expected ones |
| Asset accounting to G/L | Periodic reconciliation | Posted together in real time | Depreciation and asset values per asset class are as expected |
| Customer and supplier subledgers to G/L | Reconciliation accounts; consistency checks | Still reconciliation accounts in the same journal | Subledger balances equal reconciliation account balances; explain valuation differences |
| Inventory to G/L | Stock value versus stock accounts | Material ledger in the universal journal | Stock value equals inventory accounts per plant and valuation class |
| GR/IR | Clearing account analysis | Clearing account analysis | Open GR/IR items are explainable timing differences |
| Intercompany, bank, external | Manual or tool-supported | Still needed | Balances agree with counterparties and bank statements |
Reconciling receivables and payables
Customer and supplier line items still post to a reconciliation account in the general ledger, as part of the same journal entry. Direct postings to that account are not allowed. So in principle, the total of open customer items for company code 1710 equals the balance of the receivables reconciliation account. The test is to prove that, and to explain any difference that exists for legitimate reasons.
- Foreign currency valuation. Valuation of open items posts to a balance sheet adjustment account, not to the reconciliation account, and is usually reversed on the next day. The G/L view of receivables (reconciliation plus adjustment) then differs from the customer items valued at historical rates by exactly the valuation amount.
- Special G/L transactions. Down payments, guarantees and similar items post to alternative reconciliation accounts. Include them, or the totals will not match.
- Migration. Open items loaded at go-live must match the migrated G/L balance. Differences here are migration defects.
- Regrouping. Balance sheet regrouping (for example customers with credit balances shown as payables) posts adjustments for reporting. Know them and exclude or include consistently.
Worked example
| Item | Amount (USD) | Source |
|---|---|---|
| Open customer items, company code 1710, at historical rates | 1,284,600.00 | Customer balances or aging report |
| Receivables reconciliation account balance | 1,284,600.00 | Trial balance |
| Difference before valuation | 0.00 | Expected: same journal entries |
| Valuation adjustment on CAD receivables (key date) | -3,150.00 | Foreign currency valuation run, adjustment account |
| G/L receivables after valuation (reconciliation plus adjustment) | 1,281,450.00 | Trial balance |
| Explained difference | 3,150.00 | Equals the valuation amount, so reconciled |
Reconciling Contoso's receivables to the G/L after valuation. Numbers are fictional.
GR/IR and inventory
The GR/IR clearing account holds goods received but not invoiced, and invoices received before goods. At close, testers check that open GR/IR items are explainable: Lakeside Components delivered 500 rotors on the 30th and the invoice arrives on the 3rd. Old or unexplained items point to process or configuration defects such as wrong tolerances. For inventory, compare the stock value per plant and valuation class with the inventory G/L accounts; in SAP GUI, the stock value balance list (MB5L) is a common starting point.
- Is there a goods receipt or invoice with a known counterpart on the way?Yes → e.g. Lakeside's invoice for 500 rotors due on the 3rd: next question · No → investigate as a process or configuration defect
- Is the item within normal lead time?Yes → explainable timing difference: document it · No → old item: check tolerances and price or quantity differences
- Does the explanation have a preparer and reviewer?Yes → reconciled · No → not yet evidence for sign-off
Intercompany and external reconciliations
Where company codes trade with each other, the receivable in one must match the payable in the other, and intercompany revenue and expense must eliminate in consolidation. These reconciliations do not disappear with the universal journal, because they compare two different company codes. SAP offers intercompany reconciliation functions for this; whichever tool you use, the test is the same: post matching and deliberately mismatched intercompany transactions, and confirm the mismatches are found and explained. Bank accounts are reconciled against bank statements, which in a test system come from prepared test files.
- Post matching pairReceivable in one company code, payable in the other, same amount
- Post a deliberate mismatchWrong amount or missing counterpart document
- Run reconciliationIntercompany reconciliation function or agreed tool
- Confirm detectionMismatch is reported; matching pair clears
- Explain and recordDifference explained and documented with preparer and reviewer
What would you do?
During Contoso's mock close, the payables reconciliation shows the supplier open items 12,000.00 USD higher than the payables reconciliation account. No valuation has run yet. What is the most likely explanation to investigate first?
- The universal journal removes FI-CO and asset-to-G/L reconciliation by design.
- Receivables, payables, GR/IR, inventory, intercompany and bank still need reconciliation evidence.
- Valuation adjustments, special G/L items, migration and regrouping are legitimate, explainable differences.
- Every difference must be explained to the cent and documented with preparer and reviewer.
Check your understanding · not graded
Lesson check
1. In SAP S/4HANA, financial and controlling line items are stored together in the:
2. Where does foreign currency valuation of open customer items usually post?
3. Which reconciliation is no longer needed in SAP S/4HANA because of the universal journal?
4. What do old, unexplained GR/IR open items usually indicate?