Record-to-report process map
The period-end close as a swimlane map, from the close calendar through sub-ledger cut-off, adjustments, reconciliations, consolidation and reporting to sign-off, across sub-ledger owners, the GL accountant, the financial controller, group reporting and the CFO. Nine of its twenty-six steps are decisions, and most of them loop back: a close is a sequence of checks that either pass or send work backwards.
Opens a copy in the editor and saves it in this browser. No account, nothing sent anywhere.
What is in this map
26 steps across 5 swimlanes and 6 phases, with 8 decision points.
- Swimlanes (who does the work)
- Sub-ledger owners, General ledger accountant, Financial controller, Group reporting and CFO
- Phases (left to right)
- Cut-off, Adjustments, Reconciliation and review, Consolidation and analysis, Reporting and Sign-off and archive
Why map this process
A close checklist tells you what has to be done; it does not tell you what waits for what. The intercompany match cannot finish until both sides have posted, the trial balance cannot be locked until the reconciliations are approved, and a late sub-ledger delays everything after it. Drawn as a map with those dependencies, the critical path of the close is visible, and so is the step that costs the extra day every month.
The loops are the other reason. Unreconciled items go back for investigation, unexplained variances go back for review, and a material post-close adjustment reopens the period. A checklist records these as ticks; a map shows them as the rework they are, which is where a faster close comes from.
Every step in the map
This is the spreadsheet behind the diagram. The numbers in “Goes to” are row numbers, which is exactly what the editor’s “Line to” column holds — so you can read the flow here and retype any part of it.
| # | Step | Shape | Swimlane | Phase | Goes to |
|---|---|---|---|---|---|
| 1 | Close calendar issued for period end | Start | Financial controller | Cut-off | 2 |
| 2 | Cut off and close the sub-ledgers | Process | Sub-ledger owners | Cut-off | 3 |
| 3 | All sub-ledgers closed **on time**? | Decision | General ledger accountant | Cut-off | 4 (Yes), 2 (No) |
| 4 | Post **accruals, prepayments and provisions** | Process | General ledger accountant | Adjustments | 5 |
| 5 | Match intercompany balances | Process | Group reporting | Adjustments | 6 |
| 6 | **Intercompany balances** agree? | Decision | Group reporting | Adjustments | 8 (Agree), 7 (Out of balance) |
| 7 | Resolve the difference with the counterparty | Process | Sub-ledger owners | Adjustments | 5 |
| 8 | Prepare **balance-sheet reconciliations** | Process | General ledger accountant | Reconciliation and review | 9 |
| 9 | Reconciling items cleared? | Decision | General ledger accountant | Reconciliation and review | 11 (Cleared), 10 (Open items) |
| 10 | Investigate the reconciling item | Process | Sub-ledger owners | Reconciliation and review | 8 |
| 11 | Reconciliations and journals approved? | Decision | Financial controller | Reconciliation and review | 13 (Approved), 12 (Returned) |
| 12 | Correct and resubmit the journal | Process | General ledger accountant | Reconciliation and review | 11 |
| 13 | Lock the **trial balance** | Process | General ledger accountant | Consolidation and analysis | 14 |
| 14 | Consolidate, eliminate and translate | Process | Group reporting | Consolidation and analysis | 15 |
| 15 | Run flux and variance review | Process | Financial controller | Consolidation and analysis | 16 |
| 16 | Variances explained? | Decision | Financial controller | Consolidation and analysis | 18 (Explained), 17 (Unexplained) |
| 17 | Investigate the unexplained movement | Process | General ledger accountant | Consolidation and analysis | 15 |
| 18 | Prepare the **management reporting pack** | Process | Group reporting | Reporting | 19 |
| 19 | Draft the statutory statements | Process | Group reporting | Reporting | 20 |
| 20 | Disclosures complete and accurate? | Decision | Financial controller | Reporting | 21 (Yes), 19 (No) |
| 21 | Post-close **adjustment** required? | Decision | Financial controller | Sign-off and archive | 22 (Material), 23 (None or immaterial) |
| 22 | Reopen the period and post the entry | Compensation | General ledger accountant | Sign-off and archive | 13 |
| 23 | Results approved for release? | Decision | CFO | Sign-off and archive | 24 (Approved), 26 (Withheld) |
| 24 | Archive the **close binder** and evidence | File | General ledger accountant | Sign-off and archive | 25 |
| 25 | Period closed and results reported | Success | CFO | Sign-off and archive | End |
| 26 | Sign-off withheld and filing delayed | Reject | CFO | Sign-off and archive | End |
The decision points
Every branch in the map, with the label on each outgoing line. These are the questions the process has to be able to answer.
-
3. All sub-ledgers closed **on time**?
Owned by General ledger accountant · Cut-off
- Yes → step 4
- No → step 2
-
6. **Intercompany balances** agree?
Owned by Group reporting · Adjustments
- Agree → step 8
- Out of balance → step 7
-
9. Reconciling items cleared?
Owned by General ledger accountant · Reconciliation and review
- Cleared → step 11
- Open items → step 10
-
11. Reconciliations and journals approved?
Owned by Financial controller · Reconciliation and review
- Approved → step 13
- Returned → step 12
-
16. Variances explained?
Owned by Financial controller · Consolidation and analysis
- Explained → step 18
- Unexplained → step 17
-
20. Disclosures complete and accurate?
Owned by Financial controller · Reporting
- Yes → step 21
- No → step 19
-
21. Post-close **adjustment** required?
Owned by Financial controller · Sign-off and archive
- Material → step 22
- None or immaterial → step 23
-
23. Results approved for release?
Owned by CFO · Sign-off and archive
- Approved → step 24
- Withheld → step 26
Notes on specific steps
These notes travel with the map. In the editor they live in the Notes column and appear when you open a box.
- 1. Close calendar issued for period end
- The close calendar is the process. Publish it before the period ends, with a named owner and a time of day against every task, because "day 2, 14:00" is a deadline and "day 2" is a hope. Show the dependencies as well as the dates: nothing accrues until the sub-ledgers are shut and nothing consolidates until the entity trial balances are locked, so a late task is visibly late for everyone downstream rather than only for the person holding it.
- 2. Cut off and close the sub-ledgers
- Cut-off is the boundary between this process and the sub-ledgers that feed it. Payables, receivables, payroll, expenses, fixed assets and inventory each stop accepting postings for the period at an agreed time, and each owner confirms it rather than the general ledger assuming it. The real exposure is invoices still sitting in a payables exception queue and goods received but not invoiced: they are the sub-ledger's backlog and the general ledger's understated liability, which is why the accrual step follows immediately.
- 6. **Intercompany balances** agree?
- Intercompany rarely nets to zero on the first pass, and the usual causes are timing rather than error: goods in transit, cash in transit, invoices raised after the counterparty's cut-off, and each side translating the same balance at a different rate. Agree a tolerance below which the difference is written off centrally instead of argued about, name which entity books the correction, and set a point in the calendar after which unresolved differences go to the group controller rather than holding the consolidation.
- 9. Reconciling items cleared?
- Cleared does not mean the reconciliation balances. It means every difference is identified, explained, supported by something outside the ledger and inside its ageing limit. Set those limits explicitly: an unexplained difference of any size is not acceptable, and an explained one carries a clearing date and an owner. What a reviewer looks for is the same items rolling forward month after month with the same wording, because that is how an unrecorded loss hides inside a balance that ties.
- 11. Reconciliations and journals approved?
- The control here is segregation. Whoever prepares a journal cannot be the person who approves it, and the approver needs the supporting schedule in front of them rather than a debit, a credit and a narrative. Set a value above which a second approver is required, and treat manual journals posted after the sub-ledgers close as a separate population for review. An approval that exists only in an email thread is not evidence anybody can retrieve twelve months later.
- 17. Investigate the unexplained movement
- An unexplained movement is not a journal waiting to be posted. Find the cause first: a missed accrual, a misposting, a wrong elimination, or a real event nobody told finance about. If the entity ledger is still open, push the correction back there. If it is locked, the fix is a top-side journal at group level: the population an external auditor asks for first, because late judgement and management override both surface there. A top-side entry that recurs every quarter is an entity-level error being masked at group.
- 22. Reopen the period and post the entry
- Reopening a closed period is a controlled event, not a convenience. Name who may authorise it, require the reason in writing, and rerun everything the entry invalidates: the trial balance lock, the consolidation and the flux review all happen again, which is why this route loops back rather than dropping an entry into a set of numbers somebody has already signed. Immaterial items go on the summary of unadjusted differences and are carried into the next close instead.
- 24. Archive the **close binder** and evidence
- The close binder is what makes the close auditable a year later: the calendar with completion times, the signed reconciliations, the journal support, the intercompany matching report, the consolidation and translation workings, the flux commentary, the disclosure checklist and the sign-off. Archive it as one dated set with the period stamped on it, keep it read-only, and record which revision of the close procedure was in force, because that is the first thing an auditor asks for.
Making it yours
Put your close calendar into the spreadsheet first: add the working day (D+1, D+3, and so on) to the Notes column of each step, so the map doubles as the timetable. Then look at the three loops (intercompany differences, open reconciling items, unexplained variances) and ask which one runs most often; that is usually the step to fix first. If you run a group close, keep consolidation in its own lane rather than merging it into the controller's.
What to watch out for
- Do not draw sub-ledger close as one box if AP, AR, fixed assets and payroll close on different days. Give the slowest one its own step; it sets the pace for everything else.
- Approval of reconciliations is a separate step from preparing them. When the preparer and approver are the same person, the map should make that visible rather than hide it.
- The post-close adjustment loop needs a materiality threshold on the branch. Without one, every small correction reopens the period.
Frequently asked questions
What is the difference between record-to-report and the month-end close?
Record-to-report is the wider process: recording transactions during the period, closing the books, consolidating and reporting. The month-end close is its most intense part, and it is what this map focuses on. Day-to-day journal recording is usually mapped separately, if at all.
How long should a month-end close take?
Many companies take six to ten working days; a well-run close is often three to five. The map helps because it shows which steps run in parallel and which wait on each other, so you can see whether a shorter close needs faster people or a different sequence.
Does this work for a single-entity company?
Yes. Delete the intercompany steps and the consolidation lane, and the map becomes a single-entity close of about eighteen steps. The reconciliation and review loops stay, because they are where a small finance team spends its time too.
Open the map and start editing
The editor loads this chart with the spreadsheet underneath it. Change a cell and the diagram redraws — no drawing, no signup.