Record to Report RTR

📒 F&A Process Guide

Record-to-Report (RTR) — Complete Guide

Record-to-Report is the backbone of Finance & Accounting. It covers everything from capturing a financial transaction to producing audited financial statements. Master each step — and you control the financial narrative of your organisation.

▶ Start: Understanding the RTR Cycle

The RTR cycle is a 6-step end-to-end process that converts raw business transactions into meaningful financial statements for decision-making, regulatory compliance, and investor reporting.

🔷 Journal Entries & Double-Entry Bookkeeping

Every financial transaction is recorded using the double-entry system — every debit has an equal and opposite credit. This ensures the accounting equation always balances: Assets = Liabilities + Equity.

• Source Documents: Invoices, receipts, bank statements, contracts — the evidence behind every entry
• Journal Entry: Dr. Expense A/c | Cr. Accounts Payable — always balanced
• Types: Regular (daily transactions), Accruals (income/expense earned but not yet received/paid), Deferrals, Reversals
• Golden Rules: Real A/c → Debit what comes in; Personal A/c → Debit the receiver; Nominal A/c → Debit all expenses & losses
• ERP Impact: In SAP, journal entries are called FI Documents; in Oracle, they are General Ledger Journals

🔷 Month-End Close Process

The month-end close is a structured checklist of activities that must be completed before financial statements are produced. Leading companies complete it in 3–5 business days; best-in-class in 1–2 days.

• 📥 Sub-ledger Close: Close AR, AP, Fixed Assets, Inventory — ensure all transactions posted
• 🔷 Accruals & Prepayments: Post accruals for expenses incurred but not invoiced (payroll, utilities, rent)
• 🔷 Depreciation Run: Calculate and post monthly depreciation for all fixed assets
• 🔷 Bank Reconciliation: Match bank statement to GL cash account — resolve differences
• 🔷 Intercompany Reconciliation: Agree IC balances with counterpart entities
• 📤 Close GL Period: Lock the period so no further postings can be made

🔷 Trial Balance & Reconciliation

The Trial Balance lists all GL accounts and their closing balances — total debits must equal total credits. Reconciliation ensures every GL balance is supported by evidence.

• Account Reconciliation: Compare GL balance to sub-ledger, bank statement, or third-party confirmation
• Reconciling Items: Timing differences (outstanding cheques, deposits in transit), errors, and omissions
• Black-Line Reconciliation: Industry-standard format — Opening Balance + Additions − Deductions = Closing Balance
• Tools: Excel (VLOOKUP/Power Query), SAP Open Item Management, Oracle Account Reconciliation Cloud
• Frequency: Bank — daily/weekly; Balance Sheet accounts — monthly; P&L accounts — quarterly

🔷 Financial Statement Preparation

The three core financial statements are prepared from the trial balance after all adjustments:

• 📋 Income Statement (P&L): Revenue − Expenses = Net Profit/Loss for the period
• 📋 Balance Sheet: Assets = Liabilities + Equity at a point in time
• 📋 Cash Flow Statement: Operating + Investing + Financing cash flows — the real liquidity picture
• 📋 Statement of Changes in Equity: Opening equity ± Profit ± Other Comprehensive Income − Dividends = Closing equity
• Standards: Ind AS (India), IFRS (international), US GAAP (USA) — know which applies to your entity

✅ End: Consolidation & Group Reporting

Group consolidation combines the financial statements of a parent company and all its subsidiaries into a single set of consolidated financial statements.

• Step 1 — Align Accounting Policies: All entities must report under the same policies before consolidation
• Step 2 — Currency Translation: Convert subsidiary financials from local currency to reporting currency (IAS 21)
• Step 3 — Eliminate Intercompany: Remove IC sales, purchases, loans, and unrealised profits
• Step 4 — Aggregate: Add line by line — Revenue, Expenses, Assets, Liabilities
• Step 5 — Minority Interest: Show non-controlling interest (NCI) separately in equity and P&L
• Tools: SAP BPC, Oracle HFM, OneStream, Excel-based consolidation templates