Reconciliation Accounts and G/L Master Data Creation in SAP S/4HANA – A Complete Beginner’s Guide

If you are learning SAP S/4HANA Finance, understanding Reconciliation Accounts and G/L Master Data is critical.

These concepts form the backbone of FI postings, sub-ledger integration, and real-time financial reporting.

This blog explains everything clearly, practically, and in simple terms.

1. General Ledger in SAP S/4HANA

The General Ledger (GL) is the central repository of financial data in SAP.

A G/L account consists of two segments:

  • Chart of Accounts (CoA) segment – global level

  • Company Code segment – company-specific level

Business transactions are:

  • Recorded using the double-entry accounting principle (Debit = Credit)

  • Classified into Assets, Liabilities, Income, and Expenses

  • Used to generate Balance Sheet and Profit & Loss statements

All transactions with business partners are first posted to sub-ledgers, and their totals are automatically updated in the General Ledger.

1. What Is a Reconciliation Account?

A Reconciliation Account is a special G/L account that stores the summarized balances of sub-ledgers.

  • It does not hold individual transaction details

  • It reflects totals from sub-ledger accounts

  • Postings happen automatically by the system

👉 Users cannot post manually to reconciliation accounts.

Why Are Reconciliation Accounts Important?

Reconciliation accounts ensure:

  • Real-time sync between sub-ledgers and the General Ledger

  • Clean FI reporting

  • Accurate audit and balance sheet control

They provide a snapshot view of detailed sub-ledger activity.

Common Examples

  • Customer Reconciliation Account (Accounts Receivable)

  • Vendor Reconciliation Account (Accounts Payable)

  • Asset Reconciliation Account

  • Bank Reconciliation Account

2. What Are Sub-Ledgers?

Sub-ledgers store detailed transaction-level data.

Examples of Sub-Ledgers

  • Accounts Receivable (Customers)

  • Accounts Payable (Vendors)

  • Asset Accounting

  • Bank Accounting

They contain:

  • Individual invoices

  • Vendor/customer names

  • Payment terms

  • Due dates

  • Discounts

👉 The total balance of these sub-ledgers is automatically posted to the reconciliation account in the G/L.

3. Reconciliation Account Posting Logic (Simple Flow)

  1. Invoice posted to Vendor

  2. Entry recorded in AP sub-ledger

  3. SAP automatically updates Vendor Reconciliation G/L

  4. FI and sub-ledger stay reconciled in real time

✔ No manual intervention
✔ No mismatch between FI and sub-ledgers

4. What Is a Master Record in SAP?

A Master Record stores data that:

  • Is used repeatedly

  • Changes infrequently

  • Is shared across departments

Purpose

  • Avoids duplicate data entry

  • Improves system performance

  • Ensures consistency

Common Master Data in SAP S/4HANA

  • G/L Accounts

  • Business Partners (Customer/Vendor)

  • Bank Master

  • Asset Master

  • Material Master

5. What Is Transaction Data?

Transaction Data is created from day-to-day business activities.

Examples

  • Vendor invoices

  • Customer payments

  • Credit memos

  • Goods receipts

Transaction data:

  • Is time-based

  • Has monetary values

  • References master data

6. What Is a G/L Account Master Record?

A G/L Account Master Record controls:

  • How postings behave

  • Whether the account is Balance Sheet or P&L

  • Field requirements (Cost Center, Tax, etc.)

  • FI–CO integration

👉 It governs how accounting transactions are processed in SAP S/4HANA.

7. Ways to Create G/L Accounts in SAP S/4HANA

1️⃣ Create with Reference

  • Copy existing G/L from another company code

  • Saves time

  • Inherits control settings

2️⃣ Data Transfer / Migration Tools

  • Used for legacy system migration

  • Suitable for large data volumes

  • Tools include LSMW (ECC) and LTMC / Migration Cockpit (S/4HANA)

3️⃣ Copy Existing G/L Account

  • Useful when chart of accounts already exists

  • Faster than manual creation

4️⃣ Manual Creation (FS00)

  • Used for small volumes

  • Best for learning

  • Time-consuming for large datasets

8. Key Changes in SAP S/4HANA (FI–CO Integration)

SAP S/4HANA introduced major changes:

  • G/L and Cost Elements are merged

  • Secondary cost elements are now part of G/L

  • Old transactions like KA01 / KA02 removed

  • Introduction of Universal Journal

  • Fiori apps for managing G/L master data

G/L Account Type Classification

TypeMeaning
XBalance Sheet Account
NNon-operating Expense/Income (FI only)
PPrimary Cost or Revenue (FI + CO)
SSecondary Cost (CO only)

9. Important Note

Every financial transaction in SAP ultimately posts to a G/L account, either directly or through sub-ledgers.

10. Case Study: Office Stationery Expense

Requirement

Create a G/L account for Office Stationery Supplies

Setup

  • Account Group: Operating Expense

  • Account Type: P (Primary Cost)

  • P&L Account

  • Cost Center: Mandatory

This ensures:

  • Correct expense tracking

  • Proper CO reporting

  • Clean financial statements

Final Takeaway

Reconciliation accounts ensure automatic and accurate integration between sub-ledgers and the General Ledger, while G/L master data controls how financial transactions behave in SAP S/4HANA. Mastering these concepts is essential for anyone working in SAP FICO.

6. What Is a G/L Account Master Record?

A G/L Account Master Record controls:

  • How postings behave

  • Whether the account is Balance Sheet or P&L

  • Mandatory fields (Cost Center, Tax, etc.)

  • FI–CO integration

👉 It governs how accounting transactions are processed in SAP S/4HANA.

7. G/L Account Master Data Structure

In SAP, G/L master data consists of two segments:

  1. Chart of Accounts segment

    • Stored in table SKA1

  2. Company Code segment

    • Stored in table SKB1

Together, these form the complete G/L Master Record.

Path to configure >>


8. G/L Account Groups

A G/L Account Group is used to classify similar G/L accounts.

Purpose of Account Groups

  • Controls number range

  • Determines mandatory, optional, or hidden fields

  • Improves reporting and account management

Business-Friendly Numbering Convention

  • All Asset Accounts to start with 1 series.

  • All Income Accounts to start with 4 series.

  • All Expenditure Accounts to start with 3 series.

  • All Liabilities Accounts to start with 2 series.

Transaction Code: OBD4


The Field Status of G/L Account Group Controls: Field Status of G/L Account Group Controls fields at the time of Creation of General Ledger Accounts.




Retained Earnings

Retained Earnings Account is used to maintain the G/L in which the system will transfer the P&L amount at the end of the every fiscal year when the balance carry forward activity is executed(with T.Code FAGLGVTR).A General Ledger account is a fundamental element in financial accounting that represents a specific item in an organization's financial statements. It is used to record financial transactions, and each G/L account is assigned to a particular account group within the Chart of Accounts. The General Ledger Master Data in SAP FICO is made up of a chart of accounts area and an area specific to the company code Example: 'Cash A/c', ' Interest A/c', 'Debtor A/c', 'Bank A/c' etc. There are 3 different ways to create G/L Accounts in G/L Master Data : 1. Edit G/L Account Centrally (T.Code FS00) - To create G/L account centrally in both the chart of account area and company code area. 2. Edit Chart of Accounts Data (T.Code FSP0) - To create G/L account only in Chart of Account without specifying Company Code to use. 3. Edit Company Code Data (T.Code FSS0) - To Extend G/L account to one of Company code without specifying the Chart of Account.

GL Account Creation To Define G/L Account Centrally ( T.Code FS00 ) STEP 1: Click on Create icon and Enter Company code and G/L Account Number. STEP 2: In Type/Description Tab > Select "G/L Account Type" and Account Group, Enter Text of G/L Account.

Creating a G/L Account in SAP S/4HANA

Case Study: Office Stationery Supplies

Creating G/L accounts is a core activity in SAP Financial Accounting (FI). Every business transaction in SAP ultimately posts to a G/L account, so understanding how to create and control G/L master data is essential.

In this blog, we will create a G/L account for Office Stationery Supplies and understand each step in detail.

Navigation to Create G/L Account

You can access the Edit G/L Account Centrally screen using either of the following paths:



IMG Path

IMG
 → Financial Accounting
   → General Ledger
     → Master Data
       → G/L Accounts
         → G/L Account Creation and Processing
           → Edit G/L Account Centrally

SAP Easy Access Path

Accounting
 → Financial Accounting
   → General Ledger
     → Master Records
       → G/L Accounts
         → Individual Processing
           → Centrally

This opens the Edit G/L Account Centrally screen.

Step 1: Enter Initial Details

G/L Account

  • Enter the G/L account number

  • The number must fall within the number range assigned to the account group

  • The length of the number depends on the Chart of Accounts configuration

Note: SAP will not allow numbers outside the defined account group range.

Company Code

  • Enter the company code where the G/L account will be used

  • This assigns the G/L account to the selected company code

Step 2: Maintain Chart of Accounts Segment

Click Create to activate the fields.

Control in Chart of Accounts

G/L Account Type

Select the appropriate account type:


If G/L Account type is set as 'P' or 'S' : then "Cost Element Category" is required field. " Cost Element Category " : The cost element category determines which cost elements can be used for which business transactions.


  • For Office Stationery Supplies, select:

    • P – Primary Costs or Revenue

This allows the account to be used in both FI and CO.

Account Group

  • Select the appropriate account group (e.g., Operating Expenses)

  • Account group controls:

    • Number range

    • Field status

    • Account classification

Description Section

Short Text

  • Brief name of the account
    Example: Office Stationery

Long Text

  • Detailed description
    Example: Office Stationery and Consumable Supplies

Consolidation Data (Optional)

If your company prepares group financial statements:

  • Enter Trading Partner

  • Enter Group Account Number

This supports group consolidation in SAP S/4HANA.

Step 3: Maintain Control Data (Company Code Segment)

Click the Control Data tab.



Account Currency

  • Defines the currency of the G/L account

  • Recommended:

    • Use company code local currency

  • Advantage:

    • Allows postings in any currency

    • SAP converts foreign currency automatically

Only Balances in Local Currency

  • Select this checkbox when:

    • You want balances maintained only in local currency

  • Commonly used for:

    • Balance sheet accounts without open item management

    • GR/IR clearing accounts

❌ Do not use for AR/AP reconciliation accounts

Tax Category

  • Determines whether the account is tax-relevant

  • For expense accounts:

    • Input tax is usually allowed

  • In this example:

    • Tax category maintained as “-” (input tax allowed)

Posting Without Tax Allowed

  • Allows postings without tax, even if tax category is defined

Reconciliation Account for Account Type

  • Used only when the G/L account is a reconciliation account

  • Options include:

    • Customers

    • Vendors

    • Assets

👉 For Office Stationery Expense, this field is not used

Open Item Management

  • Enables tracking of open and cleared items

  • Commonly used for:

    • Bank accounts

    • GR/IR clearing accounts

    • Salary clearing accounts

Sort Key

Controls how line items are displayed.

Common SAP standard sort keys:

Sort KeyDescription
001Posting Date
002Document No. & Fiscal Year
003Document Date
008Cost Center
009External Document Number

In this example:

  • Sort Key = 001 (Posting Date)

SAP automatically sorts line items based on the selected key.

Step 4: Assign Field Status Group

Go to the Create/Bank/Interest tab.



Field Status Group

  • Controls whether fields are:

    • Suppressed

    • Required

    • Optional during posting

SAP provides standard field status groups.

For Office Stationery Expense:

  • Field Status Group: G004 – Cost Accounts

👉 This ensures the Cost Center field becomes mandatory during posting.

Step 5: Save the G/L Account

  • Click Save

  • The G/L account is now created successfully

Creating a G/L Account with a Template

SAP allows you to copy an existing G/L account using the With Template option.

Benefits

  • Saves time

  • Copies control settings

  • Reduces errors

Case Study: Copy G/L Account Using Template

Requirement
Copy:

  • G/L Account: 474100 – Domestic Travel Expenses

  • Source Company Code: 1000

  • Target Company Code: C100

Steps

  1. Open Edit G/L Account Centrally

  2. Enter:

    • G/L Account: 474100

    • Company Code: C100

  3. Click With Template

  4. In the reference screen:

    • Enter source G/L account

    • Enter source company code (1000)

  5. Copy and adjust details as required

  6. Save

Note: Both company codes must share the same chart of accounts and number range intervals.

Key Takeaways

  • G/L accounts control how transactions behave in SAP

  • Expense accounts must use:

    • Primary cost type

    • Cost-center–relevant field status

  • Using templates significantly speeds up configuration

  • Proper master data design ensures clean FI–CO integration

Comments

New comments are not allowed.

Popular posts from this blog

What is General Ledger Master Data creation and deletion ?

Image
SAP FICO Global Parameters refer to a set of mandatory variants and control parameters that must be maintained for every company code to enable smooth financial accounting and integration with Controlling. These parameters define the basic accounting framework of a company code, such as: Chart of Accounts Fiscal Year Variant Posting Period Variant Field Status Variant All these are maintained based on the Variant Principle. Master Data O Master Data is the information which remains in the system for a long period of time and does not change so often such as G/L Master Data, Customer Master Data, Vendor Master Data, Bank Master Data, Item Master, User Master Data etc. O It represents the business objects that contains agreed upon information which is shared across an organization O It is non-transactional in nature but is used in transactional documents as an information about a G/L account, Customer/Vendor or an item etc. O G/L Master data (Centrally) - Both chart of accounts level/seg...
Read more

What is a Chart of Account and how to assign to company code in SAP FICO ?

Image
Chart of accounts  A Chart of Account is assigned to a company code in SAP Configuration by specifying the chart of accounts key in the company code settings. Each company code can be assigned to only one operational chart of accounts, but one chart of accounts can be assigned to multiple company codes. O Highest level of hierarchy for all the G/L accounts O It is created by following the 3-method variant principle O Create Chart of Accounts: T-code: OB13 O Define the properties to the chart of accounts O Assign company code to the chart of accounts: T-code: OB62 Menu path: Display IMG -> Financial Accounting -> General Ledger Accounting -> Master Data -> G/L Accounts -> Preparations -> Edit Chart of Accounts List O Table: SKAI can be viewed through T-code: SE16N to display the relevant information III. Defining Chart of Accounts in SAP S/4HANA – A Step-by-Step Configuration Guide In every SAP S/4HANA implementation, the Chart of Accounts (COA) is one of the most ...
Read more