AI Tax Auditor

01. The Challenge

With the advent of the Brazilian Tax Reform (Supplementary Law 214/2025), companies operating under Real Profit will face the Split Payment mechanism, where tax is automatically withheld at financial settlement. The challenge was to build a tool to anticipate the impact of this withholding on daily cash flow.

02. The Solution

I developed a data pipeline using Python (Pandas) to extract raw data from XMLs and SPED files. This data is processed and loaded into a SQL Server database.

Power BI connects to this database and applies business rules (DAX) to simulate scenarios: "What if the rate is 26.5%?", "What if there is tax immunity?". The result is the interactive dashboard above, allowing the Controller to make preventive decisions.