First page of the Segregation of Duties Matrix Template (Excel)Excel workbook preview

GAO Green Book

Segregation of Duties Matrix Template (Excel)

Segregation of duties matrix template in Excel: user access grid, 15 conflict rules, live conflict flags per user, mitigating controls and a summary.

Excel workbook · 32 KB Built on free official texts

3 free downloads per account. Just your email and a 6-digit code.

Need more than 3? Every template for $249, once. Lifetime access, including the templates we add later. See pricing

About this template

A segregation of duties matrix shows who holds which financial duties and where one person holds two duties that together would let them commit and hide an error or fraud. Auditors ask for it in every controls review, and small finance teams need it most, because they cannot separate everything and must show what compensates. It is also the starting point for any review of system access rights.

The workbook follows the GAO Green Book (GAO-25-107721, paragraphs 10.21 to 10.23), which asks management to separate authority, custody and accounting duties and to design alternative controls where separation is not practical. Conflict rules are pairs of duties. A formula grid checks every user against every rule, and an approved mitigation turns a red conflict into an amber one, so the summary always shows what is still open.

Who it is for

The controller or finance director who must show the auditor which staff hold conflicting duties and what compensates where the team is too small to separate them.

What is inside

  • Access matrix with 10 worked users and 16 blank rows against 16 duties
  • 16 duties tagged as authorization, custody, recording or review, with a held-by count
  • 15 conflict rules with severity and risk, plus 5 free rows for your own pairs
  • Conflict Check grid of every user against every rule, showing X or M by formula
  • 4 live columns per user: unmitigated, High unmitigated, mitigated and a conflict flag
  • Mitigations register with 7 worked rows, next due dates and overdue flags
  • Summary sheet with 10 measures, including duties held by nobody

How to use it

List your people and system accounts on the Access Matrix and mark an X under every duty each one holds.

Files

  • XLSXsegregation-of-duties-matrix-template.xlsx32 KB

Opens in Microsoft Word or Excel, Google Docs or Sheets, and LibreOffice. Built on free, official texts that anyone can read: laws, regulations, standards and guidance published by public bodies. A template to adapt, not legal, tax or accounting advice.

Questions about this template

What are the incompatible duties in segregation of duties?

The classic split is authorization, custody of assets and recording of transactions, with review as a fourth function. Holding two of them over the same transaction stream is a conflict, for example approving and releasing payments, or receiving cash and posting receipts. The template lists 15 common pairs.

What if a small team cannot separate duties?

The Green Book says that where segregation is not practical because of limited personnel, management designs alternative control activities. Typical examples are an independent review of a transaction report, dual approval in the bank portal, or a board member reviewing the payment register. Record each one on the Mitigations sheet.

Does segregation of duties stop all fraud?

No. The Green Book notes that it helps mitigate the risk of management override but cannot absolutely prevent it, because of the risk of collusion between two or more people. That is why the matrix should be reviewed by the oversight body, with attention to senior managers and system administrators.