First page of the AML Training Plan and LogExcel workbook preview

AML and CFT (FATF, BSA)

AML Training Plan and Log

AML training plan and log in Excel: role-based modules, a completion log with pass, overdue and late flags, coverage per role group and the FFIEC basis.

Excel workbook · 16 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

Training for appropriate personnel is one of the required elements of a bank's AML program under 31 CFR 1020.210. Examiners and independent testers ask to see the training plan, the materials, the attendance records and what happened when someone failed or completed late. This workbook keeps the plan and the evidence together in one place.

The plan sets modules by role group, following the FFIEC BSA/AML Examination Manual: an overview for new staff, role-specific examples for tellers, lenders and the wire room, deeper training for the BSA team, a board briefing and training for agents. The log calculates pass or fail, overdue status and days late, and the coverage sheet reports completion per role group.

Who it is for

The BSA Officer who was asked by the examiner or the independent tester for the training program and proof of who completed it, when and with what result.

What is inside

  • Training Plan sheet with 8 modules for 7 role groups, delivery, frequency, hours, owner and month
  • Training Log with 10 invented worked rows plus 20 blank formatted rows
  • Live formulas for result (pass or fail), status (completed, overdue, due soon) and days late
  • Corrective action column for every late or failed completion, as the FFIEC manual expects
  • Coverage sheet: assignments, completed, overdue, failed and completion rate per role group
  • Settings sheet with the pass mark and due-soon window as yellow input cells
  • Basis table linking each element to 31 CFR 1020.210 and the FFIEC training section

How to use it

Set the pass mark on the Settings sheet, adapt the Training Plan, then log each assignment.

Files

  • XLSXaml-training-plan-and-log.xlsx16 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

Who has to receive AML training at a bank?

31 CFR 1020.210 requires training for appropriate personnel. The FFIEC manual explains this as everyone whose duties require knowledge of the BSA or involve some part of AML compliance, plus the board and senior management at a foundational level, the BSA staff on an ongoing basis, and agents who carry out BSA functions for the bank.

How often must AML training be given?

No regulation sets a fixed frequency. The FFIEC manual expects an overview for new staff at or soon after orientation and periodic training that reflects changes in rules, guidance, internal procedures and the bank's products and customers. Many banks choose an annual cycle, which is the example used in this plan.

What training records should we keep?

The FFIEC manual says banks should document the training program and keep training and testing materials, session dates and attendance records, and record failures to complete training on time together with the corrective action taken. These records should be available to auditors and examiners.