EU AMLR client review and deletion date sheet for accountants and tax advisers: customer information updates at least every 1 year for higher-risk clients and every 5 years for others (Article 26), trigger events, and 5-year record retention then deletion (Article 77), from 10 July 2027
What you get: a finished, tested client review and deletion date sheet for accountants, bookkeepers, auditors and tax advisers. One row per client. Formulas give each active client's next customer information update date (at least every year for higher-risk clients, at most every 5 years for everyone else), flag clients where a trigger event means you must update now, and give each former, refused or one-off client the date their personal data must be deleted. A to-do column cites the Article for each step.
Partner programme opening soon: join the free waitlist. Planned terms are 50% of each referred sale (75% once you have 5+ paying customers), single level, paid through Gumroad only from revenue received.
Short answer: from 10 July 2027 (Article 90), you must keep client documents, data and information up to date, and the gap between updates "shall not in any case exceed" 1 year for higher-risk clients under enhanced due diligence and 5 years for all other clients (Article 26(2)). You must also update when circumstances change, when you learn a relevant fact, or when you must contact the client that year about beneficial owners or under Directive 2011/16/EU (Article 26(3)). Records are kept for 5 years after the relationship ends, the one-off transaction, or your refusal, and then personal data is deleted (Article 77(3)).
What to tell a client in one minute
- We will ask you to confirm your details regularly. The law sets a maximum gap: 1 year if you are a higher-risk client, 5 years otherwise (Article 26(2)).
- Tell us when something changes. A new director, a new owner or a new line of business means we update your file straight away (Article 26(3)(a), (c)).
- Low risk does not mean never. We may check less often for low-risk clients (Article 33(1)(b)), but never more than 5 years apart.
- We keep your file for 5 years after you leave and then delete the personal data, unless another law or the authority needs it longer (Article 77(3)).
Why AI tools matter here
AI onboarding and identity-check tools often store client documents and scores without a review date or a deletion date. The AMLR needs both: a dated update cycle per client, and deletion after 5 years under GDPR rules. If your firm uses AI tools for client checks, list them in the free edition of the EURO AI Register so you can answer client and supervisor questionnaires about which AI tools touch client data. For the first onboarding steps see our AMLR client due diligence sheet; for alerts see the Article 69 suspicious activity alert log and the Article 76 screening hit sheet.
The rules the sheet uses
| Rule | What the AMLR says | Article |
|---|---|---|
| Who | Auditors, external accountants and tax advisers are obliged entities | 3(3)(a) |
| Higher-risk clients | Update at least every 1 year (clients under enhanced due diligence, Section 4) | 26(2)(a), 34 |
| All other clients | Update at least every 5 years | 26(2)(b) |
| Lower-risk clients | May reduce update frequency; check the lower-risk conditions still hold | 33(1)(b), 33(4) |
| Update now | Change in relevant circumstances; relevant fact; legal duty that calendar year to contact the client about beneficial owners or under Directive 2011/16/EU | 26(3) |
| What to keep | CDD copies, Article 69(2) assessments and any report, transaction records, unredacted | 77(1) |
| How long | 5 years from end of relationship, occasional transaction or refusal; then delete personal data | 77(3) |
| Longer on request | Authority may require up to another 5 years, case by case | 77(3) |
| From when | 10 July 2027 | 90 |
The sheet, one row per client (columns A to Q)
Make two tabs. Clients: headers in row 1, inputs from row 2, formulas J2 to Q2 filled down. Settings: B1 =TODAY(), B2 2027-07-10, B3 1 (higher-risk years), B4 5 (your house rule for other clients; the sheet never uses more than 5), B5 60 (warning days).
| Col | What goes in it | Based on |
|---|---|---|
| A | Client code | You |
| B | ACTIVE, ENDED, REFUSED or OCCASIONAL | Art 77(3) |
| C | Risk: HIGHER, STANDARD or LOWER (active clients) | Art 26(2), 33, 34 |
| D | Date customer information was last updated | Art 26(2) |
| E | Trigger event since then: Y or N | Art 26(3) |
| F | End of relationship, refusal or occasional transaction date | Art 77(3) |
| G | Further retention date set by the authority (optional) | Art 77(3) |
| H | Who updated / notes | You |
| J | Input check: OK or FIX with the reason | Helper |
| K–M | Maximum years between updates, next update date, update status (OK UNTIL, DUE IN n DAYS, OVERDUE BY n DAYS, UPDATE NOW) | Art 26(2)-(3) |
| N–O | Delete personal data on, and retention status (KEEP UNTIL or DELETE NOW) | Art 77(3) |
| P | To-do list with Article cites | As cited |
| Q | Result: OK, DUE SOON, OVERDUE, UPDATE NOW, KEEP, DELETE NOW or FIX | Summary |
Formulas (row 2; fill down). In Excel files saved by some tools TEXTJOIN shows as _xlfn.TEXTJOIN; that is the same function.
J2: =IF(A2="","",IF(NOT(OR(B2="ACTIVE",B2="ENDED",B2="REFUSED",B2="OCCASIONAL")),"FIX: STATUS MUST BE ACTIVE, ENDED, REFUSED OR OCCASIONAL",IF(AND(B2="ACTIVE",NOT(OR(C2="HIGHER",C2="STANDARD",C2="LOWER"))),"FIX: RISK MUST BE HIGHER, STANDARD OR LOWER",IF(AND(B2="ACTIVE",D2=""),"FIX: ENTER THE DATE CUSTOMER INFORMATION WAS LAST UPDATED",IF(AND(B2<>"ACTIVE",F2=""),"FIX: ENTER THE END, REFUSAL OR TRANSACTION DATE",IF(AND(G2<>"",G2<F2),"FIX: AUTHORITY RETENTION DATE IS BEFORE THE END DATE",IF(AND(G2<>"",F2<>"",G2>EDATE(F2,120)),"FIX: FURTHER RETENTION CANNOT GO PAST 10 YEARS FROM THE END DATE (ART 77(3))",IF(AND(E2<>"",E2<>"Y",E2<>"N"),"FIX: TRIGGER EVENT MUST BE Y OR N","OK"))))))))
K2: =IF(OR(NOT(J2="OK"),B2<>"ACTIVE"),"",IF(C2="HIGHER",Settings!$B$3,MIN(Settings!$B$4,5)))
L2: =IF(K2="","",EDATE(D2,12*K2))
M2: =IF(L2="","",IF(E2="Y","UPDATE NOW: TRIGGER EVENT (ART 26(3))",IF(L2<Settings!$B$1,"OVERDUE BY "&(Settings!$B$1-L2)&" DAYS",IF(L2-Settings!$B$1<=Settings!$B$5,"DUE IN "&(L2-Settings!$B$1)&" DAYS","OK UNTIL "&TEXT(L2,"YYYY-MM-DD")))))
N2: =IF(OR(NOT(J2="OK"),B2="ACTIVE"),"",IF(G2<>"",G2,EDATE(F2,60)))
O2: =IF(N2="","",IF(N2<=Settings!$B$1,"DELETE PERSONAL DATA NOW (ART 77(3)), UNLESS ANOTHER LAW NEEDS IT","KEEP UNTIL "&TEXT(N2,"YYYY-MM-DD")&IF(G2<>""," (AUTHORITY EXTENSION)","")))
P2: =IF(A2="","",TEXTJOIN("; ",TRUE,IF(J2="OK","","Fix the input shown in column J"),IF(AND(J2="OK",Settings!$B$1<Settings!$B$2),"AMLR applies from 10 July 2027 (Art 90); until then follow your national AML law",""),IF(AND(J2="OK",B2="ACTIVE",C2="HIGHER"),"Higher risk: enhanced due diligence (Art 34) and update at least every "&K2&" year(s)",""),IF(AND(J2="OK",B2="ACTIVE",C2="LOWER"),"Lower risk: you may update less often (Art 33(1)(b)) but never more than 5 years apart (Art 26(2)(b)); check the lower-risk conditions still hold (Art 33(4))",""),IF(AND(J2="OK",LEFT(M2,2)="UP"),"Review and update customer and beneficial owner information now, then enter the new date in column D",""),IF(AND(J2="OK",LEFT(M2,2)="OV"),"Update customer information now and record why it was late",""),IF(AND(J2="OK",LEFT(M2,2)="DU"),"Book the update with the client before "&TEXT(L2,"YYYY-MM-DD"),""),IF(AND(J2="OK",LEFT(O2,2)="DE"),"Delete personal data, keep a note of the deletion date",""),IF(AND(J2="OK",LEFT(O2,2)="KE"),"Keep CDD copies, Art 69(2) assessments and transaction records unredacted (Art 77(1))","")))
Q2: =IF(A2="","",IF(NOT(J2="OK"),"FIX",IF(B2="ACTIVE",IF(LEFT(M2,2)="UP","UPDATE NOW",IF(LEFT(M2,2)="OV","OVERDUE",IF(LEFT(M2,2)="DU","DUE SOON","OK"))),IF(LEFT(O2,2)="DE","DELETE NOW","KEEP"))))
What we tested
Fifteen made-up clients in LibreOffice (xlsx → ods → csv), in two runs. Run 1 with today as 10 Nov 2026 and a 5-year house rule: a standard client last updated 1 Mar 2023 (OK until 2028-03-01); two higher-risk clients updated 1 and 20 Dec 2025 (DUE SOON, 21 and 40 days); a lower-risk client last updated 30 Jun 2021 (OVERDUE by 133 days, because 5 years is the cap even for lower risk); a client with a new director (UPDATE NOW); a client that left on 1 Oct 2021 (DELETE NOW); a client that left on 15 Feb 2024 (KEEP until 2029-02-15); a refused client (KEEP until 2031-09-01); a one-off client with an authority extension to 31 Dec 2027 (KEEP); and five bad inputs (unknown risk, missing date, missing end date, extension past 10 years, unknown status), each FIX with the reason. Run 2 with today as 1 Dec 2027 and a 3-year house rule: the standard clients become OVERDUE, the extended one-off client stays KEEP until its extension date. All 15 + 15 results as intended, the empty row stays blank, 0 errors.
Checklist before 10 July 2027
- Give every active client a risk level and a last-update date.
- Book higher-risk client reviews at least yearly.
- Pick a house rule of 5 years or less for everyone else.
- Write down what counts as a trigger event in your procedures, and make staff log it.
- List former and refused clients with their end dates, and diarise deletion 5 years later.
- Check that your AI onboarding or ID-check tools can delete records on that date.
Limits and our reading
- Not read, flagged: AMLA guidelines on ongoing monitoring under Article 26(5); your national AML law, which applies until 10 July 2027; national rules that need records kept longer; GDPR itself.
- Our reading: the sheet treats every client marked HIGHER as under enhanced due diligence (Article 26(2)(a)); the 5-year retention runs from the date in column F; an authority extension is capped at 10 years from that date.
Questions
How often must an accountant update client due diligence information under the AMLR?
Based on the risk, and never less often than every 1 year for higher-risk clients under enhanced due diligence and every 5 years for all other clients (Article 26(2) of Regulation (EU) 2024/1624).
Can a lower-risk client go longer than 5 years between updates?
No. Simplified due diligence lets you reduce the frequency of updates (Article 33(1)(b)), but Article 26(2) says the period between updates shall not in any case exceed 5 years.
When must I update earlier than the schedule?
When the client's relevant circumstances change, when you become aware of a relevant fact about the client, or when you have a legal duty that calendar year to contact the client to review beneficial owner information or under Directive 2011/16/EU (Article 26(3)).
How long do I keep CDD records after a client leaves?
5 years from the end of the business relationship, the date of an occasional transaction, or the date you refused the client. Then personal data is deleted, unless other EU or national law needs it longer (Article 77(3)).
Can the authority make me keep records longer?
Yes. A competent authority may require further retention case by case for money laundering or terrorist financing cases, for up to another 5 years (Article 77(3), second subparagraph).
When does this apply?
From 10 July 2027 (Article 90). Until then, your national law implementing the earlier AML directives applies. Accountants, auditors and tax advisers are obliged entities (Article 3(3)(a)).
Unadhi Guides are free, independent explainers. We correct errors as soon as we find them: write to mininglife7@gmail.com.