Excel workbook previewBank Account Register and Signatory Matrix
3 free downloads per account. Just your email and a 6-digit code.
About this template
A bank account register is the single list of every account the organization holds: which entity owns it, at which bank, in which currency, for what purpose and who is responsible for it. The signatory matrix beside it shows who can approve or release payments on each account. Auditors, new CFOs and banks ask for both, and they are the first place a former employee who still holds signing rights shows up.
This workbook holds a register of ten accounts for an invented group, a signatory list with panels A and B, a matrix that rebuilds itself from that list, a change log and a summary. Formulas calculate review dates, overdue reviews, the number of active signatories per account and the people who must be removed now. It follows general treasury practice.
Who it is for
The controller or treasurer whose auditor asked for a complete list of bank accounts and who can sign on each one.
What is inside
- Bank Accounts register with 10 worked accounts across 3 entities and 20 blank formatted rows
- Next review date, days to review and review status (Overdue, Due soon, Current) calculated from the last mandate review
- Active signatory count per account with a Below two flag
- Signatories sheet with 21 worked entries, panels A and B, and an Action required formula that catches leavers
- Matrix sheet that shows each person's panel on each account, live from the Signatories sheet
- Change Log sheet for openings, closures and signatory changes with days open
- Summary sheet with 10 live counts and accounts by entity
- Dropdowns, colour bands, freeze panes, filters and print fit on every sheet
How to use it
Replace the sample accounts with your own on the Bank Accounts sheet, then list every signatory per account on the Signatories sheet.
Files
- XLSXbank-account-register-and-signatory-matrix.xlsx24 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets, and LibreOffice. Based on general finance practice, not on one published standard. A template to adapt, not legal, tax or accounting advice.
Questions about this template
How often should bank mandates be reviewed?
Many organizations review every mandate at least once a year and after any change in senior finance staff. The template calculates the next review from the last review date and an interval you choose on the Summary sheet, and marks reviews as Overdue or Due soon so they are not forgotten.
What is a signatory panel?
A panel groups signatories by seniority. A common rule is that every payment above a threshold needs two signatures and at least one must come from panel A. The matrix shows each person's panel on each account so you can check that every account has enough panel A signatories.
What should happen when a signatory leaves?
The person should be removed from every mandate and every online banking profile without delay, and the bank's confirmation filed. In the template, setting Still employed to No turns the Action required column to Remove now until the status is Removed.



