Accounting Automation Tool (Gmail JSON → Google Sheets → Journal Entries)

Python tool that fetches JSON invoices from Gmail, parses El Salvador DTE-like JSON, writes to Google Sheets, and generates balanced journal entries.

Quick start

1. Put credentials.json in the project folder.
2. Create venv & install deps:

   python -m venv .venv
   .venv\Scripts\activate
   pip install -r requirements.txt
   

3. Dry run using sample JSON:

   python src\main.py --after 2025-07-01 --before 2025-08-01 --spreadsheet-name Accounting_Invoices_2025_07 --dry-run-dir samples
   

4. Real run (Gmail):

   python src\main.py --after 2025-07-01 --before 2025-08-01 --spreadsheet-name Accounting_Invoices_2025_07
   

Vendor matching priority (updated)

1. Exact NIT (normalized: hyphens/spacing ignored)
2. Exact legal name (emisor_nombre, case-insensitive)
3. Substring token (contains_nombreComercial) against legal/commercial names

Recommendation: Fill emisor_nit in the Mappings tab for every recurring vendor.