skills.rest
diegocamara89
diegocamara89COMMUNITY
Explore all skills by this author →
GitHub

analise-rif

Process COAF RIF CSV files to validate, deduplicate, and generate a .docx RAF report.

3|3|Updated Apr 5, 2026
Search Tags:#deduplication#docx#financial-analysis#aml#rif#coaf#raf
One-click install
npx skills add https://github.com/diegocamara89/ai-skills-hub --skill analise-rif
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: analise-rif
Source: https://github.com/diegocamara89/ai-skills-hub/tree/main/all-skills/analise-rif
Command: npx skills add https://github.com/diegocamara89/ai-skills-hub --skill analise-rif

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill automates the end-to-end validation, relational analysis and reporting of COAF RIF CSVs so investigators and compliance analysts can quickly identify financial intelligence indicators without manual reconciliation errors.

Core Features & Use Cases

  • Robust CSV ingestion with encoding detection and separator fallback for RIF_Envolvidos, RIF_Comunicacoes and RIF_Ocorrencias.
  • Relational cleansing and deduplication: indexer filtering, idComunicacao deduplication, and mandatory cross-joins by Indexador to prevent double-counting.
  • Forensic analysis & typologies: detection of laundering typologies mapped to Carta Circular BACEN 4.001/2020, linkage mapping between involved parties, and generation of executive summaries.
  • Professional report generation: Produces a formatted RAF .docx following the provided modelo_raf_v1 with traceability, Brazilian currency/date formatting, and SIGILOSO classification.
  • Use Case: Law enforcement analysts receive three COAF CSVs and need a defensible, auditable RAF document plus interactive findings for follow-up investigations.

Quick Start

Analyze the attached RIF_Envolvidos.csv, RIF_Comunicacoes.csv, and RIF_Ocorrencias.csv and generate a professional RAF .docx following the modelo_raf_v1 template.

Frequently Asked Questions about analise-rif

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I generate a COAF RAF report from RIF CSV files?▼

To generate a COAF RAF report, ingest RIF_Envolvidos, RIF_Comunicacoes, and RIF_Ocorrencias CSV files. The process validates data, deduplicates idComunicacao entries, cross-references by Indexador, and maps suspicious activity typologies to output a formatted, traceable .docx document.

What is the best way to deduplicate COAF RIF communications and prevent double-counting?▼

The best way to deduplicate COAF RIF communications is by applying idComunicacao deduplication alongside mandatory relational cross-joins by Indexador. This method cleanses the RIF data, ensuring accurate linkage mapping between involved parties without manual reconciliation errors.

How does money laundering typology mapping work with BACEN Carta Circular 4.001/2020?▼

Money laundering typology mapping works by detecting suspicious forensic indicators within RIF data and matching them to the typologies defined in Carta Circular BACEN 4.001/2020. This cross-referencing extracts financial intelligence to identify compliance risks.

Can I process RIF CSV files with different encodings and separators?▼

Yes, you can process RIF CSV files with different encodings and separators. The ingestion performs automatic encoding detection and separator fallback, ensuring robust parsing of RIF_Envolvidos, RIF_Comunicacoes, and RIF_Ocorrencias files before relational analysis begins.

Does the generated RAF report include Brazilian currency formatting and confidentiality classification?▼

Yes, the generated RAF report includes Brazilian currency and date formatting. The final .docx document is professionally formatted following the modelo_raf_v1 template and includes a SIGILOSO confidentiality classification for secure investigative reporting.

What are the limitations of automating financial crime compliance reviews from COAF RIF data?▼

A limitation of automating financial crime compliance reviews is the strict dependency on receiving properly structured RIF_Envolvidos, RIF_Comunicacoes, and RIF_Ocorrencias CSV files. The analysis relies on accurate indexer filtering and cross-joins to generate a defensible, auditable RAF document.

Related Skills

Explore More Legal & Compliance Skills→
didclawapp-aididclawapp-ai
11

office-data-report

Read, process, and render Excel reports from CSV/XLSX files.

Community
Intermediate
SanctifiedOpsSanctifiedOps
3

monitoring-and-alerting

Define monitoring, dashboards, and alerts for Solana applications.

Community
Basic
diegocamara89diegocamara89
3

analise-bancaria

Analyze Brazilian bank statements and transaction logs for suspicious patterns and patrimonial incompatibility.

Community
Advanced
akunikkolaakunikkola
97

rahanpesun-estaminen

Generate AML compliance reports for Finnish customer accounts.

Community
Advanced