Skip to content
Tutorials Center
My learning

Topics

Lesson 8 of 36 ยท Business Processes

Record to Report (R2R)

Understand record to report: how transactions become journal entries, a trial balance and financial statements, what the month-end close involves and how ERPs automate it.

Every process in this chapter eventually lands in the books. Record to report (R2R) is the process that collects all financial transactions, checks them, closes the accounting period and produces the reports that managers, owners, banks and tax authorities rely on. Where O2C and P2P are operational chains, R2R is the finance chain that sits on top of them.

This lesson follows the data from journal entry to trial balance and statements, explains the period close and shows a working mini-ledger.

From transaction to statement

flowchart LR
  A["Source documents: invoices, receipts, payroll"] --> B["Journal entries"]
  B --> C["General ledger"]
  C --> D["Trial balance"]
  D --> E["Adjustments and close"]
  E --> F["Financial statements"]

Every statement line traces back to source documents.

  • Journal entry: a record with at least two lines whose debits equal credits.
  • General ledger (GL): all journal lines grouped by account from the chart of accounts.
  • Trial balance: the balance of every account at a date. Total debits must equal total credits.
  • Financial statements: the income statement (revenue and expenses over a period), the balance sheet (assets, liabilities and equity at a date) and the cash flow statement.

Account types: assets, liabilities, equity, revenue and expenses. Debits increase assets and expenses; credits increase liabilities, equity and revenue.

A mini ledger

Python Journal entries and a trial balance

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

The sum of all balances is zero: that is the trial balance check. An unbalanced entry is rejected on posting, which is exactly what an ERP does.

Building an income statement

Python Revenue, expenses and profit

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

The period close

At the end of each month (and the year) finance performs a close:

  1. Cut-off: make sure transactions are in the right period; stop postings to the old period.
  2. Sub-ledger reconciliation: receivables, payables and inventory totals must equal their control accounts in the GL.
  3. Bank reconciliation: the bank statement matches the cash accounts.
  4. Accruals and deferrals: record expenses incurred but not invoiced (accruals), and spread prepayments over time (deferrals).
  5. Depreciation: allocate the cost of fixed assets across their useful life.
  6. Foreign currency revaluation: revalue balances in other currencies at the closing rate.
  7. Intercompany and consolidation: eliminate transactions between group companies and combine results.
  8. Review and sign-off: analyse variances against budget and prior periods, then lock the period.

Month-end close

Cut-off Right period
Reconcile Sub-ledgers and bank
Adjust Accruals, depreciation
Lock Review and sign-off

Fast close = fewer manual steps

1 / 2
Python Straight-line depreciation and an accrual

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Why ERPs help

Because sub-ledger postings (sales, purchases, stock) create GL entries automatically, the trial balance is always current. ERPs add automatic recurring entries, allocations, period locks, approval workflows for manual journals and a full audit trail (who posted what and when). The result is a faster close, often reduced from weeks to days.

Controls

  • Manual journals need a second pair of eyes.
  • Posted entries are not deleted; they are reversed.
  • Access to open/close periods is restricted.
  • Reconciliations are reviewed and evidenced.

You will meet the module that does all this in the finance module lesson.

Check your understanding

Quick check ยท 4 questions

of 4 answered You scored / 4 ยท perfect!

  1. 1. What must be true of every journal entry?

    Double-entry bookkeeping requires each entry to balance.
  2. 2. What is a trial balance?

    The trial balance lists balances of every ledger account and checks that the books balance.
  3. 3. An accrual records

    Accruals match expenses to the period they were incurred, even before the invoice arrives.
  4. 4. How are mistakes in posted entries normally corrected?

    Reversal keeps the audit trail intact.

Summary

  • R2R turns transactions into journal entries, ledgers, a trial balance and financial statements.
  • Every entry balances; the trial balance proves it.
  • The period close includes cut-off, reconciliations, accruals, depreciation, revaluation and sign-off.
  • ERPs automate postings, locks and approvals and keep an audit trail.

Next: Plan to Produce