How acc-tax-reighteen/automasi-ar-orderan works
Automasi AR Orderan is a Python pipeline that prepares Accurate accounts-receivable and optional giro exports, enriches customer data with Google Sheets references, then fills empty order-tracker cells with an AR total and structured customer-credit notes. The main user flow starts at the launcher and ends in a recurring Google Sheets sync. The README describes the broader enrichment capabilities; some processing links below are documented there because the excerpts do not show every read/write handoff.
Main entry points: 6_InjectDataToSS.py AR sync and notes · 0_DownloaderData.py Reference downloader · Jalankan Automasi.py Automation launcher · 0_HDownloaderData.py Backup downloader
Components 21
Run control
- Automation launcher
Jalankan Automasi.py - Preparation scripts
Dapur
Data preparation
- Reference downloader
Dapur/0_DownloaderData.py - Backup downloader
Dapur/0_HDownloaderData.py - AR cleaner
Dapur/1_CleanerAccAR.py - DEPO AR cleaner
Dapur/1_CleanerAccARD.py - Giro cleaner
Dapur/2_CleanerAccGiro.py - Expired giro filter
Dapur/2_HCleanerAccGiroDue.py - Date formatting
Dapur/5_AdjDateFormat.py
Reference enrichment
- Giro due-date enrichment
Dapur/3_AddGiroToSheet.py - Cash-customer fallback
Dapur/4_PatchFallbackCash.py - Prepared AR workbook
Order tracker sync
- AR sync and notes
Dapur/6_InjectDataToSS.py - Service account
Dapur/credentials.json
Other components
- Operator
- Accurate AR export
- Accurate giro export
- OWING reference
- AVG reference
- FallbackCash reference
- Order tracker
Connections 24
- Operator → Automation launcher: starts
README.md - Automation launcher → Accurate AR export: requires
Jalankan Automasi.py - Automation launcher → Preparation scripts: runs scripts
Jalankan Automasi.py - Accurate AR export → AR cleaner: reads export
Dapur/1_CleanerAccAR.py - Accurate AR export → DEPO AR cleaner: reads export
Dapur/1_CleanerAccARD.py - Accurate giro export → Giro cleaner: reads export
README.md - Reference downloader → OWING reference: downloads
Dapur/0_DownloaderData.py - Reference downloader → AVG reference: downloads
Dapur/0_DownloaderData.py - Reference downloader → FallbackCash reference: downloads
Dapur/0_DownloaderData.py - Backup downloader → OWING reference: downloads backup
Dapur/0_HDownloaderData.py - Backup downloader → AVG reference: downloads backup
Dapur/0_HDownloaderData.py - AR cleaner → Prepared AR workbook: writes workbook
Dapur/1_CleanerAccAR.py - DEPO AR cleaner → Prepared AR workbook: writes workbook
Dapur/1_CleanerAccARD.py - Giro cleaner → Expired giro filter: provides giro data
README.md - Expired giro filter → Giro due-date enrichment: filters dates
README.md - Giro due-date enrichment → Prepared AR workbook: adds due dates
Dapur/3_AddGiroToSheet.py - FallbackCash reference → Cash-customer fallback: provides customers
Dapur/4_PatchFallbackCash.py - Cash-customer fallback → Prepared AR workbook: adds missing customers
Dapur/4_PatchFallbackCash.py - Prepared AR workbook → Date formatting: formats dates
Dapur/5_AdjDateFormat.py - Date formatting → AR sync and notes: supplies prepared data
README.md - OWING reference → AR sync and notes: informs notes
README.md - AVG reference → AR sync and notes: informs notes
README.md - AR sync and notes → Order tracker: fills cells and notes
README.md - Service account → AR sync and notes: authenticates
README.md