Most close delays come from tasks that everyone assumed someone else owned.
A close RACI matrix lists each month-end task against each role and marks who is Responsible for doing it, who is Accountable for it being right (exactly one person), who must be Consulted and who is Informed. Build it in Excel, check that every task has one A and at least one R, keep preparer and reviewer separate, and update it when people or processes change.
One person can be both R and A for a simple task, but for anything that needs review, keep the reviewer separate from the preparer.
Tasks down the rows, roles across the columns:
Enter R, A, C, I or a combination such as "R/A" in each cell. Use data validation with a list so entries stay consistent.
Exactly one Accountable per task. Count cells containing an A:
=COUNTIF(B2:G2,"*A*")
At least one Responsible:
=COUNTIF(B2:G2,"*R*")
Combine them in the check column:
=IF(COUNTIF(B2:G2,"*A*")<>1,"FIX A",IF(COUNTIF(B2:G2,"*R*")=0,"NO R","OK"))
The wildcards catch combined entries like "R/A". Avoid any other codes containing the letters A or R, or the counts will be wrong.
Workload by role. Count how many tasks each role is responsible for, in a row under the matrix:
=COUNTIF(B2:B80,"*R*")
A role with far more R entries than the others is your bottleneck, and probably your key-person risk too.
Your close checklist should name a person as owner and reviewer for each task. The RACI names roles. Keep a small lookup table of role to person, and pull names into the checklist with XLOOKUP so a change of person updates everywhere:
=XLOOKUP(D2,Roles!A:A,Roles!B:B,"UNASSIGNED")
Name a cover person for each role as well, so holidays and absence don't stop the close.
The RACI is a good place to spot conflicts. The same person shouldn't be R for posting a journal and A for approving it, or R for setting up suppliers and R for payment runs. See segregation of duties in AP and manual journal controls.
RACI is used the same way in the UK and US. Job titles differ (Finance Director in the UK, often VP Finance or Controller in the US), so name the roles your organisation actually uses.
Reviews every balance sheet reconciliation with an on-device AI and 20 review tests, flags vague and wrong-account reconciling items, and builds a risk-ranked review queue. Runs in your browser on your own computer: nothing is uploaded.
12 questions on how strong your close controls are. Free to use online.
The Month-End Close & Controls System tests the trial balance against the sum of reconciled balances, keeps every open item on one exception dashboard and blocks sign-off while exceptions remain open. Excel, no macros, one-time price.
No. Exactly one person should be accountable for each task. Shared accountability usually means nobody follows up.
Responsible does the work; Accountable answers for whether it's complete and correct, usually by reviewing and signing off.
Roles. Keep a separate role-to-person table so changes in staff don't mean rewriting the matrix.
Last updated 28 October 2026. General guidance for finance teams; check it against your own policies, systems and local rules.