SAP Record to Report (FI) – Realistic Month‑End Closing & Financial Statements Hands‑On Tutorial | Part 08 | FreeLearning365

 

SAP Record to Report (FI) – Realistic Month‑End Closing & Financial Statements Hands‑On Tutorial

You’ve sold, you’ve bought. Now let’s find out if your company is actually making money. This is the Record to Report (R2R) – the process that transforms thousands of individual SAP transactions into a clear, auditable set of financial statements. It’s where the chaos of daily postings becomes the order of the Profit & Loss and the Balance Sheet. And if you can master this, you don’t just “know FI” – you can sit across from a CFO and explain how every line on the P&L was generated.

In this part of the Business Process First series, we will take every single transaction we executed in the Order to Cash and Procure to Pay cycles and walk them through a full month‑end close. We’ll start from a raw trial balance, post adjustments, clear open items, run the financial statements, and then analyze the results. All numbers are real. All accounts are the same ones we’ve already hit. This is the moment where SD, MM, and FI finally unite, and you’ll see exactly why integration matters.

We are still inside GlobalTech Innovations (Company Code 1000). Our chart of accounts has been carefully designed so that every sales order, every goods receipt, and every vendor invoice has a pre‑defined home. By the time you finish this article, you’ll be able to close May 2026 for GlobalTech – and you’ll never look at a trial balance the same way again.

1. The Record to Report Mindset – It’s Not About T‑codes, It’s About Control

Record to Report (R2R) is the financial backbone of any organisation. It takes data from all operational modules (SD, MM, PP, HR) and turns it into management reports, statutory accounts, and tax filings. An SAP FI consultant doesn’t just “post journal entries”; they understand the flow of value, ensure the books are complete and accurate, and give decision‑makers the confidence to act on the numbers.

Before you even open transaction FB50, you must be able to answer:

• Are all the sub‑ledgers (AR, AP, Asset) reconciled with the general ledger?
• Have we accounted for goods delivered but not yet invoiced, or services received but not yet billed?
• What is the GR/IR balance telling us? Is there a mismatch that needs clearing?
• Which period‑end adjustments are mandatory (accruals, depreciation, foreign currency valuation) and which are policy‑dependent?
• How do I trace a single sales invoice all the way to the revenue line on the P&L?

We will answer all of that by doing a complete month‑end for GlobalTech. You will not just “run” F.01 – you will build the trial balance from scratch, adjust it, and then derive the financial statements manually so that every number in the report has a story you can tell.

2. The Chart of Accounts – The Map of Every Transaction

Before we close, we must know exactly which GL accounts our transactions landed in. In our earlier parts, we used the following account numbers. I’m standardising them here to avoid confusion; if you used different accounts, just adapt.

Here is GlobalTech’s simplified chart of accounts (all INR):

• Asset & Liability Accounts
  • 110000 – Bank (Asset)
  • 140000 – Trade Receivables (Domestic)
  • 141000 – Finished Goods Inventory
  • 142000 – Raw Materials Inventory
  • 150000 – Input Tax (GST Receivable)
  • 160000 – Trade Payables (Domestic)
  • 170000 – Output Tax Payable
  • 210000 – GR/IR Clearing
  • 220000 – Accrued Expenses
• P&L Accounts (Expenses)
  • 620000 – Cost of Goods Sold
  • 630000 – Salary Expense (for accruals)
  • 640000 – Rent Expense
  • 650000 – Depreciation Expense
  • 670000 – Price Difference (Purchase Variance)
• P&L Accounts (Revenue)
  • 800000 – Domestic Sales Revenue
  • 810000 – Freight Revenue
  • 900000 – Other Income

We’ll also use a retained earnings account (910000) for closing, but we’ll handle that via the balance carry‑forward.

3. What Transactions Have Already Hit the Books?

Let’s recall the exact financial impact of the transactions we created in Part 6 (O2C) and Part 7 (P2P). I’ll list the FI documents that should exist after May 2026 operations. Assume all dates are within May 2026.

3.1 From Order to Cash (SD)

• Sales Order: No FI impact.
• Delivery / Goods Issue (Movement 601): FI document for COGS and inventory reduction.
  • Dr. 620000 (COGS) 170,000 INR (20 units × 8,500 standard cost)
  • Cr. 141000 (Finished Goods Inventory) 170,000 INR
• Billing (Invoice 90000001):
  • Dr. 140000 (Trade Receivables) 240,720 INR
  • Cr. 800000 (Sales Revenue) 200,000 INR
  • Cr. 810000 (Freight Revenue) 4,000 INR
  • Cr. 170000 (Output Tax Payable) 36,720 INR
• Payment (F-28): Not yet posted? We’ll assume the customer hasn’t paid. So open AR 240,720.

3.2 From Procure to Pay (MM)

• Purchase Order: No FI.
• Goods Receipt (Movement 101, standard price control):
  • Dr. 142000 (Raw Materials Inventory) 160,000 INR (200 PC × 800 standard price)
  • Dr. 670000 (Price Difference) 10,000 INR (200 × (850‑800))
  • Cr. 210000 (GR/IR Clearing) 170,000 INR
• Invoice Verification (Invoice 100000000):
  • Dr. 210000 (GR/IR Clearing) 170,000 INR
  • Dr. 150000 (Input Tax) 30,600 INR
  • Cr. 160000 (Trade Payables) 200,600 INR
• Payment: Not yet made. Open AP 200,600.

Also assume there were no other postings. So the trial balance as of 31‑May‑2026 before adjustments looks like this:

Account	Debit (INR)	Credit (INR)
140000 (Trade Receivables)	240,720
141000 (Finished Goods)	170,000? Actually inventory initially was 30 units × 8,500 = 255,000. After GI of 20 units, balance = 10 units × 8,500 = 85,000. So net Dr 85,000 (we need to reflect the opening stock + movement). We'll handle opening stock. Let's assume initial stock was 30 PC at 8,500 = 255,000 Dr. The goods issue Cr 170,000, so ending Dr 85,000. So in TB, we should have Dr 85,000 for 141000. But the opening stock came from previous period; we'll simplify: opening stock 255,000 Dr, then we Cr 170,000, net 85,000 Dr. We'll show that.
142000 (Raw Materials)	160,000
150000 (Input Tax)	30,600
210000 (GR/IR)		0 (since cleared by invoice)
160000 (Trade Payables)		200,600
170000 (Output Tax)		36,720
620000 (COGS)	170,000
670000 (Price Difference)	10,000
800000 (Sales Revenue)		200,000
810000 (Freight Revenue)		4,000

We also need to account for the opening inventory 255,000 Dr, which probably came from a balance carry‑forward. We’ll include it as a debit to 141000. Then the GI credit reduces it. So our actual 141000 balance is 85,000 Dr. Let’s restructure the TB with proper opening and movement. To keep it simple, I’ll show the net balances after all postings.

We’ll also add the bank balance. We haven’t posted any cash movements except maybe an initial capital? We’ll assume the company started with equity and a bank balance of 500,000 INR. So we’ll have a Bank Dr 500,000, and Equity/Share Capital Cr 500,000. This is necessary for the balance sheet to balance. I’ll incorporate that.

4. The Trial Balance Before Closing – Our Starting Point

Open transaction F.01 or S_ALR_87012284 (Financial Statement) to see the balances. For this exercise, we’ll assume the trial balance as of 31‑May‑2026 (before any period‑end adjustments) is exactly as follows (all amounts in INR):

GL Account	Description	Debit Balance	Credit Balance
110000	Bank	500,000
140000	Trade Receivables	240,720
141000	Finished Goods Inventory	85,000
142000	Raw Materials Inventory	160,000
150000	Input Tax Receivable	30,600
160000	Trade Payables		200,600
170000	Output Tax Payable		36,720
210000	GR/IR Clearing	0	0
620000	COGS	170,000
670000	Price Difference	10,000
800000	Sales Revenue		200,000
810000	Freight Revenue		4,000
910000	Share Capital		500,000
	Total	1,196,320	941,320

Wait, debits don’t equal credits. I missed the opening inventory came from somewhere (maybe share capital contributed inventory?). Actually, if opening finished goods inventory was 255,000 Dr, then the credit side must have a corresponding credit. That would have come from previous revenue or equity. To balance, we must assume that the opening inventory was funded by share capital (i.e., the company started with inventory and cash). The entry for initial capital might be: Dr Bank 500,000, Dr Inventory 255,000, Cr Share Capital 755,000. Then after our transactions, the share capital credit would be 755,000. Let’s adjust. That makes the balance sheet balance perfectly. So the starting position (1‑May‑2026) before any operations: - Bank 500,000 Dr - Finished Goods 255,000 Dr - Share Capital 755,000 Cr Now, during May: - Goods issue reduces finished goods by 170,000 → FG becomes 85,000 Dr. - COGS 170,000 Dr. - Sales increase revenue (credit) and AR (debit). - GR for raw materials increases RM inventory 160,000 Dr, and price diff 10,000 Dr, GR/IR credit 170,000. - Invoice clears GR/IR and creates AP. So after all transactions, the trial balance should be: Debit: Bank 500,000 AR 240,720 FG 85,000 RM 142000 160,000 Input Tax 30,600 COGS 170,000 Price Diff 10,000 Total Debits = 1,196,320 Credit: AP 160000 200,600 Output Tax 170000 36,720 Sales Revenue 800000 200,000 Freight Rev 810000 4,000 Share Capital 910000 755,000 (500,000 cash + 255,000 inventory) Total Credits = 200,600+36,720+200,000+4,000+755,000 = 1,196,320. Perfect! So our trial balance is balanced. Now we proceed to period-end closing.

5. Step‑by‑Step Month‑End Close for GlobalTech

Closing the books is a sequence of checks and adjustments. I will walk you through every step, explaining not just the T‑code but the business reason behind it. After each step, we’ll see the impact on the trial balance.

5.1 Step 1 – Reconcile GR/IR Account (T‑code MB5S, F.13)

The GR/IR account (210000) should have a zero balance after all invoices have been received and matched. However, in reality, there may be timing differences. Use MB5S – Display GR/IR Balances. If there is a balance, it means there are goods delivered but not invoiced (credit balance) or invoiced but not delivered (debit balance). For our scenario, the GR/IR is zero because we matched the invoice perfectly. But let’s assume a common situation: we received an extra 10 units of raw material (consignment or returnable packaging) that created a GR without PO, leading to a lingering GR/IR balance. We’ll cover that later.

In standard practice, you run F.13 (Automatic Clearing) to clear open items in GR/IR that are matched. But since our GR/IR is already zero, this step is complete. However, if there were open items, F.13 would post a journal entry to reclassify the balance to a different account (e.g., a GR/IR regrouping account). This is important because at month‑end, the GR/IR balance must be reported appropriately: a credit balance represents an accrual for goods received not yet invoiced, a debit balance is a receivable. F.19 can be used to regroup.

5.2 Step 2 – Foreign Currency Valuation (T‑code F.05)

GlobalTech has a payable in USD to a foreign vendor? In our scenarios, all transactions were domestic INR, so no FX. But in a real company, open items in foreign currency must be valued at the month‑end exchange rate, and unrealised gains/losses posted. We’ll skip the detailed run, but note that F.05 or FAGL_FC_VAL is the tool. The posting is automatically made to a P&L account for exchange rate differences and a balance sheet adjustment account.

5.3 Step 3 – Run Depreciation (T‑code AFAB)

Fixed assets (like machinery, buildings) need depreciation. GlobalTech has a server room equipment asset? We’ll assume a small asset: a “CNC Machine” with acquisition cost 100,000 INR, useful life 10 years, straight‑line depreciation 10% per year = 10,000 per year, monthly 833.33 INR. We’ll create a simple asset (AS01) and then run AFAB in planned mode. The entry: Dr Depreciation Expense (650000) 833.33, Cr Accumulated Depreciation (asset account). For our closing, we add this manual accrual using FB50 for simplicity. Let’s post: Dr 650000 833.33, Cr Accumulated Depreciation (let’s use account 190000) 833.33. We’ll include it.

5.4 Step 4 – Accrue Expenses Not Yet Invoiced

Rent for the factory is 20,000 INR per month, but the landlord hasn’t sent the May invoice. We must accrue. Post via FB50: Dr Rent Expense (640000) 20,000, Cr Accrued Expenses (220000) 20,000.

Similarly, salary for the last week of May hasn’t been paid yet: 50,000 INR. Dr Salary Expense (630000) 50,000, Cr Accrued Expenses (220000) 50,000.

These accruals increase expenses and liabilities, affecting P&L and BS.

5.5 Step 5 – Recurring Entries and Prepayments

GlobalTech paid a one‑year insurance premium of 12,000 INR in April, debiting Prepaid Insurance (asset). Now we must recognise one month’s expense: Dr Insurance Expense (660000) 1,000, Cr Prepaid Insurance (asset) 1,000. Not needed in our TB because we haven’t created that asset, but it’s a classic example. We’ll skip to keep focus.

5.6 Step 6 – Tax Adjustment and Calculation

We need to determine the net GST payable. Output tax credit 36,720 (from sales), less Input tax credit 30,600 = 6,120 payable. This matches the entries: Output Tax 170000 has a credit balance 36,720, Input Tax 150000 has a debit balance 30,600. At month‑end, we may need to post a tax payment (not due yet, but provisioning). Usually, the tax liability is already shown. In some countries, you set off input against output and pay net. We can do a journal to transfer: Dr 170000 (Output Tax) 30,600, Cr 150000 (Input Tax) 30,600, leaving 170000 balance 6,120 Cr. But actual set‑off is done in the tax return. We’ll assume we keep the balances separate for now. For closing, it’s fine.

5.7 Step 7 – Run Financial Statements (F.01)

Now, after all adjustments, our adjusted trial balance is:

Add depreciation 833.33 Dr (650000), Cr Acc. Depr. 190000 833.33
Add rent accrual: Dr 640000 20,000, Cr 220000 20,000
Add salary accrual: Dr 630000 50,000, Cr 220000 50,000
So new balances:

• 650000 Depr: Dr 833.33
• 640000 Rent: Dr 20,000
• 630000 Salary: Dr 50,000
• 220000 Accrued Exp: Cr 70,000
• 190000 Acc. Depr: Cr 833.33

The P&L accounts will now have more expenses, reducing net income. The balance sheet will show higher liabilities.

Now run F.01 for company code 1000, period 5, fiscal year 2026. Select financial statement version (e.g., GLOBAL). The system will generate a report with P&L and BS. You can drill down to line items. This is where the magic happens: you see “Sales Revenue” 200,000, COGS 170,000, gross profit 30,000, plus freight 4,000, less OpEx (Depr 833, Rent 20,000, Salary 50,000, Price Diff 10,000) = net loss of (46,833). Ouch! This reveals that GlobalTech’s O2C margin was eaten by fixed costs. The balance sheet will show total assets = Bank 500,000 + AR 240,720 + FG 85,000 + RM 160,000 + Input Tax 30,600 = 1,016,320; Liabilities: AP 200,600 + Output Tax 36,720 + Accrued Exp 70,000 + Acc. Depr 833 + Share Capital 755,000 = 1,063,153? Doesn’t balance, because net loss must be deducted from equity. We need to run the balance carry‑forward (F.16) to close the P&L accounts to retained earnings. That is step 8.

5.8 Step 8 – Carry Forward Balances (F.16)

Transaction F.16 (or FAGLGVTR) transfers the P&L balances to retained earnings account. After this, all P&L accounts are set to zero, and the net income (loss) is posted to retained earnings. In our case, total revenue 204,000, total expenses (170,000+10,000+833.33+20,000+50,000 = 250,833.33) → net loss 46,833.33. So Dr Retained Earnings (account e.g., 910000) 46,833.33, Cr each expense account, and Dr each revenue account, Cr Retained Earnings? Actually the carry‑forward entry will debit Retained Earnings and credit all expense accounts to close them, and debit all revenue accounts and credit Retained Earnings. Net effect: Retained Earnings credited by revenue 204,000 and debited by expenses 250,833.33, resulting in a net debit (reduction) of 46,833.33. So the retained earnings after closing becomes 755,000 – 46,833.33 = 708,166.67. Then the balance sheet will balance.

After carry‑forward, you can run the financial statements again for period 5, and the P&L will be zero (since closed) or you can run for period 1‑5 to see cumulative. But typically you run for the period before closing.

6. Full Scenario 1: Scen‑FI‑01 – Complete Month‑End Close with Real Data

I’ll now script the exact sequence you should follow in your sandbox. Use the accounts and amounts we defined.

1. Start with the trial balance as shown in section 4. Verify balances using S_ALR_87012284. Note that the GR/IR is zero, AR and AP are open.
2. Post depreciation: FB50 – Dr 650000 833.33, Cr 190000 833.33 (text: “May Depreciation – CNC Machine”).
3. Accrue Rent: FB50 – Dr 640000 20,000, Cr 220000 20,000 (text: “May Rent Accrual”).
4. Accrue Salaries: FB50 – Dr 630000 50,000, Cr 220000 50,000 (text: “May Salary Accrual”).
5. Review GR/IR with MB5S: Confirms zero. If not, clear with F.13 or post a manual reclass.
6. Review open items: FBL5N for customer 100001 (240,720 open), FBL1N for vendor 200001 (200,600 open). No additional steps unless you want to post payments, which are operational, not closing.
7. Run Financial Statements F.01: Use financial statement version INT (or create a simple one). Check the P&L result. It shows net loss of approx. 46,833.33.
8. Carry forward balances (F.16): Execute for company code 1000, year 2026. The system posts a document that clears all P&L accounts to retained earnings. After this, F.01 for period 6 will show zero P&L; for period 1‑5 (cumulative) still shows the loss.
9. Re‑run balance sheet: Assets = Bank 500,000 + AR 240,720 + FG 85,000 + RM 160,000 + Input Tax 30,600 = 1,016,320. Liabilities = AP 200,600 + Output Tax 36,720 + Accrued Exp 70,000 + Acc. Depr 833.33 + Share Cap 755,000 – Retained Earnings (loss) 46,833.33? Wait, retained earnings after closing is the initial 755,000 credit, then Dr 46,833.33, so net credit 708,166.67. Let’s sum liabilities and equity: AP 200,600 + Output Tax 36,720 + Accrued 70,000 + Acc. Depr 833.33 + Equity (708,166.67) = 1,016,320. Perfect. The balance sheet balances.

7. Full Scenario 2: Scen‑FI‑02 – GR/IR Mismatch and Its Correction

Now let’s stir some real trouble. Suppose that for a PO of 100 PC at 850 INR, we posted GR for 100 PC, but the vendor only invoiced 80 PC. The GR/IR account will have a credit balance for the 20 uninvoiced goods. At month‑end, we must ensure this is not stuck in GR/IR. Use MB5S to see the balance. Then run F.19 (GR/IR Regrouping) to move the balance to a “Goods delivered not invoiced” liability account (provision). Alternatively, you can manually adjust. This is a classic audit point.

Hands‑on: In your system, create a new PO 4500000050 for material MAT‑RM‑001, qty 100, price 850. Post GR 100. Post invoice only for 80 PC. Now GR/IR credit 17,000 (20×850). Run F.19 (Enter company code, key date, etc.). The system will generate a posting: Dr 210000 17,000, Cr 220000 (GNI liability) 17,000. In the next period, when the invoice arrives, you reverse this entry. This ensures the balance sheet is accurate.

8. Full Scenario 3: Scen‑FI‑03 – Management Reporting with Report Painter

GlobalTech’s CFO wants a custom P&L with a breakdown of revenue by sales org and expense by cost element. You can use Report Painter (transaction GRR1) to build a report. We won’t dive deep, but the ability to pull data from FI and CO and present it graphically is a consultant’s superpower. I’ll mention that you can define rows using sets of accounts and columns for periods. Then execute with GRR3. This is how you turn raw data into decision‑making tools.

9. Integration Checkpoints – The FI‑SD‑MM Triangle

R2R is the summit where all integration is proven. Let’s list the exact touchpoints we used:

• SD Billing → FI: Revenue account (800000, 810000), tax account (170000), AR (140000). Account determination in VKOA.
• MM Goods Movement (601) → FI: COGS (620000) and Inventory (141000). OBYC keys GBB and BSX.
• MM Goods Receipt (101) → FI: Inventory (142000), Price Difference (670000), GR/IR (210000). OBYC keys BSX, PRD, WRX.
• MM Invoice Verification → FI: Clears GR/IR, posts Tax (150000), AP (160000). Tax configuration via OB40.
• Asset Accounting → FI: Depreciation run posts to accumulated depreciation and expense. Integration through depreciation areas.

Now you can trace a single material from procurement to sale, through inventory, COGS, revenue, and tax, and finally see it in the net income. That’s the full circle.

10. Real‑Life Pitfalls and How to Dodge Them

1. Forgetting to clear GR/IR at month‑end: Leads to misstated trade payables and inventory. Always run MB5S and F.19. Make it a mandatory step in your closing checklist.
2. Mismatched tax accounts: If the tax code in MIRO doesn’t match the condition record, the input tax might not post, or post to a wrong account. Cross‑check tax balances with the tax return.
3. Not posting accruals for known expenses: Understated liabilities make the profit look better than it is – until the audit. Create recurring documents (FBD1) for standard accruals.
4. Closing too early before all sub‑ledger postings: If a user posts a goods issue in the previous period after the closing, it messes up the P&L. Enforce strict period locking (OB52) after closing.
5. Ignoring foreign currency revaluation: Can cause large unexplained P&L swings. Automate with F.05 batch job.

11. Consultant Wisdom – Best Practices

• Design the chart of accounts with reporting in mind. Use account groups and number ranges that allow easy financial statement version mapping.
• Create a month‑end closing schedule in SAP (transaction SCMA) to automate task sequences. This reduces human error.
• Use the GR/IR regrouping program (F.19) and never manually adjust GR/IR. Manual adjustments break the audit trail.
• Set up recurring entries for standard accruals. The system can post them automatically each period, saving time and ensuring consistency.
• Always reconcile the asset sub‑ledger with the general ledger before closing. Run ABST2 and compare with GL balances.
• Train the finance team on the importance of the “posting period” field. A single document posted to the wrong period can invalidate the entire closing.

12. Interactive “Try It Now” Checklist

In your SAP sandbox:

1. Define the chart of accounts as described, or use an existing one. Create the necessary GL accounts (FS00).
2. Post the initial equity and bank entries to set up the trial balance.
3. Execute the O2C and P2P transactions from the previous articles (or simulate them) so that the trial balance matches ours.
4. Run F.01 to see the unadjusted financial statements.
5. Post the accruals and depreciation via FB50.
6. Run F.16 to carry forward P&L.
7. Re‑run F.01 and verify the retained earnings impact.
8. Create a GR/IR mismatch scenario and execute F.19.
9. Experiment with Report Painter (GRR1) to create a simple revenue report.
10. Reflect on how every operational transaction affected the final balance sheet and P&L.

13. Closing Thoughts – From Data to Decision

Record to Report is not a technical exercise – it’s the language of business. When you can close the books, explain a P&L, and trace a variance back to its source document, you become invaluable. This article has given you the exact blueprint, the real accounts, and the step‑by‑step closing process. Now it’s your turn to run it, break it, and own it. Because in the end, the most respected SAP consultant is the one who can walk into the boardroom and say, “This is how we’re doing, and here’s exactly why.”

Up next in the series: Plan to Produce (PP) – where we’ll convert that sales demand into production orders, explode BOMs, and see how the shop floor feeds back into costing.

Keep closing, keep learning. A real consultant lives in the numbers.

– FreeLearning365, in tech partnership with @techbook24