bomyrk/ohada-financial-extractor ? reverse-engineered prompt

Build me a Python tool that can take OHADA compliant Excel financial statements and turn them into clean structured data. I want it to extract the balance sheet, income statement, cash flow statement, company metadata, and notes, then normalize everything into a JSON format that is easy to use in analysis or reporting. It should handle multi year files, validate the data, and separate asset values into gross, amortization, and net when needed. Please also add a way to export the results as pandas DataFrames, both in a tidy long format and a wide format, so I can do time series analysis later. If possible, include a simple visualization view that shows the main financial statements in charts. Make sure it works nicely from a simple Python import, and if you need current library details or examples, look them up online.