Record to report (R2R)

Template

Record to Report (R2R) is a Finance and Accounting (F&A) management process which involves collecting, processing and delivering relevant and accurate information in order to generate meaningful performance reports. Pipefy’s Record to report template is designed to streamline the Record to Report function, by breaking down the R2R process into manageable steps.

Use template now

Template structure

See how this template is structured. As this is just an example, you can customize it.

Start form

  • 1. Responsible staff member

  • 2. Email

  • 3. Fiscal year

Aggregate sub-ledger transactions

  • 1. Phase checklist

    • Record transactions as they are created, approved, and posted.
    • Perform end-to-end intra and inter company accounting.
    • Manage all interfaces.

  • 2. Interfaces checklist

    • General ledger
    • ERP systems
    • Legacy systems
    • Sub-ledgers
    • Other feeder systems

Analyze and adjust

  • 1. Phase checklist

    • Develop a timetable for completing reconciliation.
    • Assign a formal owner to each account.

  • 2. Is the financial balance reliable so far?

    • Yes
    • No - check possible discrepancies

Integrate plans and forecasts

  • 1. Establish a timetable.

  • 2. Issue clear and concise instructions on what the report must be like.

  • 3. Define well-documented procedures and policies.

Consolidate

  • 1. Consolidation process

    • Eliminate entries to remove intercompany transactions.
    • Reflect ownership and equity accounts for the consolidated entity.
    • Record various top-line allocations and adjustments.

  • 2. Consolidation made through:

    • Consolidation tool
    • Withing general ledger

Report

  • 1. Report date

  • 2. Documents generated

    • Balance sheet
    • Income statement
    • Cash flow
    • Other regulatory requirements

  • 3. Copy of the documents

  • 4. Were the documents approved by the board of directors?

    • Yes
    • No - adjust as requested

  • 5. Were the documents approved by the appropriate authority?

    • Yes
    • No - Adjust

  • 6. After approval, send the stakeholders the final report.

    • Internal reporting
    • External reporting
    • Regulatory reporting

  • 7. Final report

Upcoming year's goal

  • 1. Based on the current year's financial report, what is the upcoming year's financial goal?

Done

Welcome aboard

Trusted by 60k users, this could be the beginning of something great.

Use this template

Contact us

Do you have a specific process to manage: