How acc-tax-reighteen/auto-input-gunggung-pajak-coretax works
This is a desktop-style tax-data preparation pipeline: an operator supplies an Accurate export and selects a Google Sheets invoice sheet; the scripts normalize, filter, merge, match and calculate tax, validate the result, then populate a Coretax-format workbook. The main controller runs the stages in sequence and handles final output and cleanup. The README documents the pipeline and its capabilities; source excerpts show key implementations and controller dispatch, but not every stage’s internals or configuration wiring.
Main entry points: Jalankan Gunggung.py Pipeline controller · 5_Processing.py Match and calculate tax · 1_FetchFileSS.py Fetch invoice data · 2_Acc_CleanerDel.py Filter tax period
Components 16
Source acquisition
- Google Sheets
- Fetch invoice data
Dapur/1_FetchFileSS.py
Data preparation
- Clean Accurate data
Dapur/2_Acc_Cleaner.py - Filter tax period
Dapur/2_Acc_CleanerDel.py - Normalize invoice dates
Dapur/3_MovDt2MtchFrFetch.py - Combine source sheets
Dapur/4_Merged_all.py - Pipeline settings
Dapur/config.conf
Tax processing
- Match and calculate tax
Dapur/5_Processing.py - Validate tax results
Dapur/7_ValidationDataCtx.py - Validation reports
Dapur/7_ValidationDataCtx.py
Coretax output
- Pipeline controller
Jalankan Gunggung.py - Shape template columns
Dapur/6_Premov2template.py - Coretax workbook template
Dapur/TEMPLATE-GUNG.xlsx
Other components
- Operator
- Accurate export
- GUNGGUNG workbook
Connections 25
- Operator → Pipeline controller: starts
README.md - Accurate export → Clean Accurate data: provides export
README.md - Operator → Fetch invoice data: selects sheet
Dapur/1_FetchFileSS.py - Google Sheets → Fetch invoice data: provides sheets
Dapur/1_FetchFileSS.py - Pipeline controller → Fetch invoice data: runs
Jalankan Gunggung.py - Pipeline controller → Clean Accurate data: runs
Jalankan Gunggung.py - Pipeline controller → Filter tax period: runs
Jalankan Gunggung.py - Pipeline controller → Normalize invoice dates: runs
Jalankan Gunggung.py - Pipeline controller → Combine source sheets: runs
Jalankan Gunggung.py - Pipeline controller → Match and calculate tax: runs
Jalankan Gunggung.py - Pipeline controller → Validate tax results: runs
Jalankan Gunggung.py - Pipeline controller → Shape template columns: runs
Jalankan Gunggung.py - Clean Accurate data → Filter tax period: writes cleaned export
README.md - Filter tax period → Combine source sheets: provides Accurate data
README.md - Fetch invoice data → Normalize invoice dates: writes invoice data
README.md - Normalize invoice dates → Combine source sheets: provides normalized invoices
README.md - Combine source sheets → Match and calculate tax: provides merged sheets
README.md - Match and calculate tax → Validate tax results: writes tax results
README.md - Validate tax results → Validation reports: exports anomalies
Dapur/7_ValidationDataCtx.py - Match and calculate tax → Shape template columns: provides calculated data
README.md - Shape template columns → Pipeline controller: writes template-ready data
README.md - Pipeline controller → Coretax workbook template: copies and fills
Jalankan Gunggung.py - Pipeline controller → GUNGGUNG workbook: moves final workbook
Jalankan Gunggung.py - Pipeline settings → Filter tax period: sets filter mode
- Pipeline settings → Match and calculate tax: sets match mode