How acc-tax-reighteen/auto-input-tgl-giro-cair works
This is a local automation for reconciling giro/BG disbursement dates against bank mutation files and updating Google Sheets. The launcher removes stale Excel files, then runs the acquisition script followed by reconciliation. Acquisition selects bank files by dates parsed from their names; reconciliation reads configured sheets and local Excel mutations, matches amounts and dates, and writes matching transaction dates back. The excerpts show these stages and their calls; the README is empty, and configuration contents were not provided.
Main entry points: 2_CekData&Tulis.py Reconciliation runner · Jalankan Program.py Program launcher · 1_TarikData.py File acquisition · config.conf Runtime configuration
Components 11
Program execution
- Program launcher
Jalankan Program.py - Runtime configuration
Dapur/config.conf - Service credentials
Dapur/credentials.json
Mutation acquisition
- File acquisition
Dapur/1_TarikData.py - Local Excel mutations
Sheet reconciliation
- Reconciliation runner
Dapur/2_CekData&Tulis.py - Mutation Excel reader
Dapur/2_CekData&Tulis.py - Amount/date matching
Dapur/2_CekData&Tulis.py
Other components
- Operator
- Bank mutation folder
- Google Sheets
Connections 15
- Operator → Program launcher: starts
Jalankan Program.py - Program launcher → Local Excel mutations: clears stale files
Jalankan Program.py - Program launcher → File acquisition: runs first
Jalankan Program.py - File acquisition → Runtime configuration: reads paths and dates
Dapur/1_TarikData.py - File acquisition → Bank mutation folder: scans files
Dapur/1_TarikData.py - File acquisition → Local Excel mutations: copies date matches
Dapur/1_TarikData.py - Program launcher → Reconciliation runner: runs second
Jalankan Program.py - Reconciliation runner → Runtime configuration: reads sheet settings
Dapur/2_CekData&Tulis.py - Reconciliation runner → Service credentials: authenticates with
Dapur/2_CekData&Tulis.py - Reconciliation runner → Google Sheets: reads worksheets
Dapur/2_CekData&Tulis.py - Reconciliation runner → Local Excel mutations: finds Excel files
Dapur/2_CekData&Tulis.py - Reconciliation runner → Mutation Excel reader: calls reader
Dapur/2_CekData&Tulis.py - Mutation Excel reader → Amount/date matching: provides parsed rows
Dapur/2_CekData&Tulis.py - Reconciliation runner → Amount/date matching: matches amount and date
Dapur/2_CekData&Tulis.py - Reconciliation runner → Google Sheets: writes matched dates
Dapur/2_CekData&Tulis.py