Lesson 2 of 5
Subledgers and reconciliation accounts
6 min
If accounts payable lives by supplier and the balance sheet needs one total for payables, something must keep the two in step. In SAP, that something is the reconciliation account: a G/L account flagged, in its company code data, as the reconciliation account for one account type (customers, suppliers or assets). Every customer, supplier or asset is assigned a reconciliation account in its master data. When you post to the subledger, the system posts the same amount to that G/L account at the same moment.
- Post to the supplierAP clerk enters an invoice from Lakeside Components for 5,000 USD
- Find the reconciliation accountSystem reads the reconciliation account in the supplier's company code data for 1710
- Write one journal entryCredit the payables reconciliation account and the supplier subledger together; debit expense or GR/IR
- Stay in balanceSum of all supplier balances equals the payables account balance, always
Why you cannot post to it directly
A reconciliation account is blocked for direct posting. If you could post 1,000 USD straight to the payables account, the G/L would show 1,000 USD more than the sum of supplier balances, and nobody would know which supplier it belonged to. Blocking direct postings is what guarantees that the subledger and the general ledger agree without a separate reconciliation. If you try to enter a reconciliation account as an ordinary G/L line in a journal entry, the system rejects it. You must post to the customer, supplier or asset instead.
| Subledger | Detail kept by | Reconciliation account type | Example at Contoso (illustrative) |
|---|---|---|---|
| Accounts payable | Supplier (business partner in the supplier role) | Suppliers | Payables, domestic |
| Accounts receivable | Customer (business partner in the customer role) | Customers | Receivables, domestic |
| Asset accounting | Fixed asset | Assets | Machinery acquisition value; accumulated depreciation |
A company can have several reconciliation accounts per account type, for example domestic and foreign payables, or trade and intercompany receivables. The assignment in each business partner or asset class decides which one is used. Choosing the right assignment is a master data decision with direct balance sheet consequences.
Assets are a subledger too
Asset accounting works the same way. Each asset belongs to an asset class, and the class (through account determination) points to reconciliation accounts for acquisition value and accumulated depreciation. When Contoso capitalizes a new test bench for the Detroit plant, the asset is debited, the asset reconciliation account rises by the same amount, and the depreciation run later credits accumulated depreciation asset by asset.
Open items
Subledger accounts are managed by open item: an invoice stays open until a payment or credit memo clears it. The open item list for a customer is what collectors work from and what customers dispute. The reconciliation account in the G/L simply carries the total. This is why, in a migration or conversion, finance checks open items by customer and supplier, not just the G/L balance.
| Event | Subledger effect | General ledger effect |
|---|---|---|
| Supplier invoice posted | Open item on the supplier | Payables reconciliation account credited |
| Supplier paid | Invoice cleared | Payables debited, bank clearing credited |
| Customer invoice (billing) posted | Open item on the customer | Receivables reconciliation account debited |
| Customer payment received | Invoice cleared | Bank clearing debited, receivables credited |
Subledger and general ledger effects move together.
What a key user tests
When Contoso tests procure-to-pay or order-to-cash, finance checks more than "the invoice posted." The question is whether the subledger and the general ledger tell the same story. A good test looks at the supplier or customer line items and at the reconciliation account in the same journal entry, and confirms both moved by the same amount.
- The supplier or customer shows a new open item for the right amount, currency and due date.
- The journal entry contains the reconciliation account line with the same amount.
- The offsetting line hits the expected account (GR/IR, expense, revenue).
- A negative test: try to post directly to the reconciliation account in a journal entry and confirm the system blocks it.
What would you do?
At month end, Contoso's payables account is 2,000 USD higher than an AP manager expected. She asks the G/L accountant to "just post a correction to the payables account." What should the G/L accountant do?
- A reconciliation account links a subledger (customers, suppliers or assets) to the general ledger.
- Every subledger posting updates its reconciliation account in the same journal entry.
- Reconciliation accounts cannot be posted directly, so subledger and G/L always agree.
- Subledgers are managed by open item; the G/L carries the total.
Check your understanding · not graded
Lesson check
1. Where is a G/L account flagged as a reconciliation account?
2. Why are reconciliation accounts blocked for direct posting?
3. Which subledger uses asset classes to find its reconciliation accounts?
4. What clears an open customer invoice?