Excel workbook previewSanctions Screening Log
3 free downloads per account. Just your email and a 6-digit code.
About this template
A sanctions screening log is the record of every screening alert: who or what was screened, which list it hit, how the match was judged and who signed it off. When a bank, auditor or regulator tests screening, this log is where they start, and gaps in it are hard to explain afterwards.
This workbook holds one row per alert with the identifiers compared, the disposition and two reviewers. Formulas count days open, flag missed service levels and, for blocked or rejected items, set the OFAC report due date 10 business days later, the deadline in 31 CFR 501.603 and 501.604. Records are kept for 10 years under 31 CFR 501.601.
Who it is for
The analyst or controller who must show an auditor or bank a complete record of screening alerts and how each one was resolved.
What is inside
- Alert log with 10 worked alerts and 20 blank formatted rows
- Days open and service level status calculated live with TODAY()
- OFAC report due date set 10 business days after a block or reject decision, using WORKDAY and a holiday list
- Dropdowns for trigger, party type, list hit and disposition
- Red and amber highlighting for overdue alerts, true matches and escalations
- Settings sheet with the review service level and 11 sample 2026 federal holidays as yellow input cells
- Summary sheet with counts by disposition, trigger and list, false positive rate and next report due
- Freeze panes, filters, print fit and a How to use sheet
How to use it
Set your review service level and holiday list on the Settings sheet, then log every alert the day it is raised.
Files
- XLSXsanctions-screening-log.xlsx15 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 should a sanctions screening log record?
At least the party screened, the date and reason for screening, the list hit, the identifiers compared, the decision, the reviewer and the date closed. OFAC FAQ 5 recommends keeping records of the investigation and the information relied on. This log adds a second reviewer, days open and the OFAC report due date for true matches.
How is the OFAC report due date calculated?
The log uses the WORKDAY function to add 10 business days to the date of the block or reject decision, skipping weekends and the holidays listed on the Settings sheet. The 10 business day deadline comes from 31 CFR 501.603 for blocked property and 501.604 for rejected transactions. Check the holiday list each year.
How long should screening records be kept?
31 CFR 501.601 requires a full and accurate record of each transaction subject to OFAC rules to be available for at least 10 years after the transaction. Records of blocked property are kept while it is blocked and for at least 10 years after it is unblocked. Keep the log with the evidence for each alert.




