Panels and management control
Tax data automation
Automatic ingestion of tax records from Argentina's ARCA portal, with a queryable history, reconciled totals and an unattended daily run.
Who it's for Small businesses and accounting firms that today log into the portal, filter, export and build the spreadsheet by hand.
The problem
A company's tax information is complete and tidy inside the agency's portal, but locked in there: working with it means logging in with tax credentials, filtering by period, exporting and pasting into a spreadsheet. Every month, for every company.
The official webservice doesn't solve it: it queries one record at a time and doesn't cover received invoices, which are usually exactly the ones needed to control input tax credit.
How I solve it
01I automate the portal, since there's no API
I verified the agency doesn't expose this information as a usable webservice, so ingestion automates the portal itself with tax credentials and reads from the same query the screen uses. It's the path that exists, and it works.
02Issued and received, with history
Both sides of the record, across every available year rather than just the current period. Having the full history is what makes comparing against the same month last year possible.
03Repeatable loads without duplicates
Ingestion is idempotent: you can re-run it over an already loaded period without creating duplicates. That means reprocessing without fear when something was corrected at the source.
04Totals that reconcile
Database totals are checked against the portal's. If they don't match to the cent, it's a bug and it's treated as one: a tax dashboard that "almost" reconciles is worthless.
05It runs itself and speaks up
A scheduled daily run keeps everything current with no intervention, with a retry window if the portal doesn't respond. The system also detects tax regime changes and adjusts its indicators accordingly.
What I've already built
- 1,525 real records ingested, issued and received, covering 2015 through 2026.
- Totals reconciled to the cent against the source portal, with idempotent loading and 207 automated tests.
- Unattended daily run, with tax regime change detection to adjust indicators.
- Note: this system currently runs on my own data; it hasn't been implemented for an external client yet.