First page of the Sanctions Risk Assessment TemplateExcel workbook preview

Sanctions compliance (OFAC)

Sanctions Risk Assessment Template

Sanctions risk assessment template in Excel: risk register by customers, supply chain, products, geography and M&A, with scoring, controls and residual risk.

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

A sanctions risk assessment shows where an organization could come into contact with sanctioned people, companies or places, and how well its controls cover that contact. OFAC calls it a central tenet of a risk-based program, and the result drives screening depth, due diligence and training. Banks and acquirers ask for it before they rely on a compliance program.

This workbook follows the risk areas in OFAC's A Framework for OFAC Compliance Commitments: customers, supply chain, intermediaries, counterparties, products and services, geography and mergers and acquisitions. Each risk gets a likelihood and impact score, a control strength and a residual rating, all calculated by formulas. A geography sheet and a summary sheet update as you type.

Who it is for

The compliance lead who was asked by the bank or the board to show the organization's sanctions risk assessment and has only a list of countries.

What is inside

  • Risk register with 11 worked risks across the risk areas OFAC names, plus 20 blank formatted rows
  • Live inherent score, residual score and High, Medium or Low ratings from formulas
  • Control strength factors and rating thresholds as yellow input cells on a Settings sheet
  • Geography sheet with 9 markets, revenue share formulas and a rating per market
  • Summary sheet with counts, average scores and High residual risks per area, all formulas
  • Dropdowns for risk area, control strength and status, overdue review dates turn red
  • Freeze panes, filters, print fit and a How to use sheet

How to use it

Replace the worked risks with your own, then score likelihood and impact for each and set the control strength honestly.

Files

  • XLSXsanctions-risk-assessment-template.xlsx18 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 risk assessment cover?

OFAC's framework suggests looking at customers, supply chain, intermediaries and counterparties, the products and services offered and how they fit into other systems, and the geographic locations of the organization and its partners. It also stresses sanctions due diligence in mergers and acquisitions. This workbook has a risk area for each, plus transactions and screening systems.

How often should the sanctions risk assessment be updated?

OFAC says the assessment should be routine and, where appropriate, ongoing, and updated for the root causes of any apparent violations or systemic weaknesses found. A common approach is a full review once a year plus an update after a new market, product, acquisition or compliance finding. The register tracks a next review date per risk.

Is there an official OFAC risk matrix?

Yes. The Annex to Appendix A of 31 CFR part 501, OFAC's Enforcement Guidelines, contains an OFAC Risk Matrix with low, moderate and high descriptions, written mainly for financial institutions. This workbook uses a likelihood and impact score instead, which suits companies outside banking, and points banks to that annex.