Of Duties Matrix Template Excel Portable - Segregation

| Role | Task | Allowed (Y/N) | |---------------|------------------|---------------| | AP Clerk | Create Vendor | Y | | AP Clerk | Process Payment | Y | | Controller | Process Payment | N (conflict with reconcile) |

Example for AP Clerk (tasks B2:G2):

=COUNTIF(B2:G2,"C") Then use conditional formatting to highlight roles with >2 conflicts. | Task / Role | Create Vendor | Approve Invoice | Process Payment | Reconcile | Access Bank File | |-------------|---------------|------------------|------------------|-------------|--------------------| | AP Clerk | C | R | C | R | R | | AP Mgr | R | C | R | R | R | | Controller | R | R | R | C | C | | CFO | R | R | R | R | C | segregation of duties matrix template excel