Generate an Excel/PDF workbook for R2R internal audit: GL master data, close calendar, manual journals, reconciliations, accruals, provisions, intercompany, tax ledgers, reporting mappings and ERP close access.
| Area | Risk | Control | Test | Evidence | Cadence |
|---|---|---|---|---|---|
| GL master mapping | Accounts, cost centres or reporting mappings are created or changed without approval. | GL master ownership, maker-checker approval, mapping review and dormant-account review. | Review GL master additions/changes, trace approvals, check FS mapping and inspect dormant/manual-use accounts. | Chart of accounts, GL change log, mapping file, approval workflow, owner list and dormant account report. | Monthly / Change event |
| Close calendar ownership | Month-end close is delayed, unsupported or dependent on informal follow-ups. | Approved close calendar, account-owner matrix, task tracker and reviewer sign-off. | Compare actual close dates to calendar, inspect sign-offs, review delayed tasks and check carried-forward open items. | Close calendar, task tracker, account-owner matrix, sign-off log, escalation emails and close dashboard. | Monthly |
| Manual journals | Unsupported, late, round-sum, backdated or management-override journals are posted without review. | Journal approval workflow, support checklist, post-close review and risk-based exception scan. | Filter journals by user, timing, round values and keywords; trace entries to support and preparer-reviewer segregation. | Journal register, vouchers, support files, approval trail, user list, timestamp and exception report. | Monthly / Close |
| Accruals provisions estimates | Expenses, provisions or estimates are omitted, reversed incorrectly or unsupported by current evidence. | Accrual checklist, provision computation review, estimate owner sign-off and subsequent-payment review. | Recompute key provisions, trace accruals to support, review reversals/true-ups and scan subsequent payments for missed accruals. | Accrual schedule, provision working, contracts, invoices, subsequent-payment report, estimate note and sign-off. | Monthly / Quarterly |
| Balance sheet reconciliations | Bank, vendor, customer, tax, suspense, clearing or control accounts contain stale or unsupported balances. | Monthly reconciliation checklist, ageing review, reviewer approval and exception closure tracking. | Inspect high-risk reconciliations, age unmatched items, trace clearance and review suspense/clearing movement. | Reconciliation pack, ageing, subledger tie-out, bank/vendor/customer statements, clearance evidence and exception tracker. | Monthly |
| Intercompany related parties | Intercompany balances, allocations, eliminations or related-party disclosures are unmatched or unsupported. | Intercompany confirmation, group reporting calendar, elimination review and related-party identification control. | Match balances both sides, review confirmations/disputes, test elimination entries and tie related-party list to disclosures. | Intercompany matrix, confirmations, dispute tracker, consolidation entries, related-party register and disclosure support. | Monthly / Quarter close |
| Subledger tie-outs | AP, AR, inventory, fixed assets, payroll or tax subledgers do not reconcile to GL control accounts. | Subledger-to-GL reconciliation, ageing review and owner sign-off. | Reconcile subledgers to GL, inspect reconciling items, review stale differences and trace corrective journals. | Subledger extract, GL control account, reconciliation, ageing, corrective journal and reviewer note. | Monthly |
| Tax provision statutory ledgers | GST, TDS, income-tax, deferred-tax or other statutory balances are not reconciled to returns, challans and provision workings. | Tax-ledger reconciliation, return-to-GL tie-out, provision review and demand/refund tracker. | Tie statutory ledgers to returns/challans, review provision working, inspect notices/demands/refunds and age statutory liabilities. | GST/TDS/income-tax ledgers, returns, challans, provision file, notice tracker and management review. | Monthly / Quarter close |
| FS mapping disclosure pack | Trial-balance balances are mapped to wrong line items, omitted from schedules or disclosed inconsistently. | FS mapping review, disclosure checklist, prior-period comparison and schedule owner sign-off. | Trace TB to schedules, review new GL mappings, check variance explanations and inspect disclosure checklist completion. | Trial balance, mapping file, schedules, disclosure checklist, variance analysis and reviewer sign-off. | Quarterly / Annual close |
| ERP close access SoD | Users can create GL masters, post/approve journals, reopen periods, change mappings or run consolidation without segregation. | Role-based access, period-lock control, privileged-user review and close activity monitoring. | Review GL/posting/admin access, test period reopen events, check leavers/shared IDs and inspect SoD conflicts. | ERP user list, role matrix, period-control log, access review, leaver list, privileged activity log and SoD report. | Monthly / Quarterly |
Use this with the R2R internal audit checklist, the RCM builder and the monitoring rules repository.
R2R internal audit is strongest when close evidence, journal evidence, reconciliation evidence and reporting evidence are tested together. The workbook connects GL master data, close ownership, manual journals, provisions, reconciliations, subledger tie-outs, tax ledgers, financial-statement mappings and close access.
The Excel export gives auditors separate sheets for engagement scope, RCM rows, journal testing, reconciliations, accruals/provisions, intercompany and related parties, reporting/tax tie-outs, access/SoD and monitoring exceptions.
A CA firm is reviewing R2R controls for a company with monthly close delays, manual journals, stale balance-sheet reconciling items and statutory ledger differences.
