Record to Report

Record to report is a management process classification used by SAP.

Record to report or R2R is the management process for providing strategic, financial and operational feedback to understand how a business is performing. [1] It covers the steps involved in preparing and reporting the overall accounts which are typically stored in a general or nominal ledger and managed by a Controller. The detailed steps involved are:[2]

  • data extraction
  • data collection
  • data validation
  • data transformation (generation of voucher)
  • voucher posting (to general ledger)
  • storing vouchers in de-normalized and compressed format
  • generating analysis account trial balance or consolidated analysis account trial balance
  • generating user-defined financial and management reports

In general the Record to Report function is not engaged in processing transactions, but rather the aggregation of existing data in computer systems to enable meaningful performance reporting to be prepared for management. However, the R2R function may be a part of a broader accounting department.

In accounting terms an ideal IT platform (or ERM system) would be one which presents the data management need at the press of a button, however, various factors such as legacy systems, complexity, changing information needs and so on usually mean a team is needed on an ongoing basis to ensure the correct format reports are prepared.

What to expect in such a report:

– financial performance and position – key performance indicators/metrics – business commentary on the performance – reconciliation of actual results to budget, forecast and prior year results

The other divisions of accounting in this structure are:[3]

  • invoice to payment (I2P), or P2P (Procure to Pay)
  • collect to cash (C2C), or O2C (Order to Cash)
  • manage fixed assets
  • manage internal financial controls