# acc-tax-reighteen/auto-input-tgl-giro-cair architecture

> Architecture diagram of the GitHub repository acc-tax-reighteen/auto-input-tgl-giro-cair, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-08). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/acc-tax-reighteen/auto-input-tgl-giro-cair
- Repository: https://github.com/acc-tax-reighteen/auto-input-tgl-giro-cair

## Overview

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: [`Dapur/2_CekData&Tulis.py`](https://github.com/acc-tax-reighteen/auto-input-tgl-giro-cair/blob/main/Dapur/2_CekData%26Tulis.py) (Reconciliation runner), [`Jalankan Program.py`](https://github.com/acc-tax-reighteen/auto-input-tgl-giro-cair/blob/main/Jalankan%20Program.py) (Program launcher), [`Dapur/1_TarikData.py`](https://github.com/acc-tax-reighteen/auto-input-tgl-giro-cair/blob/main/Dapur/1_TarikData.py) (File acquisition), [`Dapur/config.conf`](https://github.com/acc-tax-reighteen/auto-input-tgl-giro-cair/blob/main/Dapur/config.conf) (Runtime configuration)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_run["Program execution"]
  node_launcher["Program launcher"]
  node_config["Runtime configuration<br/>[config.conf]"]
  node_credentials["Service credentials<br/>[credentials.json]"]
end

subgraph group_acquire["Mutation acquisition"]
  node_acquisition["File acquisition<br/>[1_TarikData.py]"]
  node_local_mutations["Local Excel mutations"]
end

subgraph group_reconcile["Sheet reconciliation"]
  node_reconciliation["Reconciliation runner<br/>[2_CekData&amp;Tulis.py]"]
  node_excel_reader["Mutation Excel reader<br/>[2_CekData&amp;Tulis.py]"]
  node_match_logic["Amount/date matching<br/>[2_CekData&amp;Tulis.py]"]
end

node_operator(("Operator"))
node_shared_mutations["Bank mutation folder"]
node_sheets[("Google Sheets")]

node_operator -->|"starts"| node_launcher
node_launcher -->|"clears stale files"| node_local_mutations
node_launcher -->|"runs first"| node_acquisition
node_acquisition -->|"reads paths and dates"| node_config
node_acquisition -->|"scans files"| node_shared_mutations
node_acquisition -->|"copies date matches"| node_local_mutations
node_launcher -->|"runs second"| node_reconciliation
node_reconciliation -->|"reads sheet settings"| node_config
node_reconciliation -->|"authenticates with"| node_credentials
node_reconciliation -->|"reads worksheets"| node_sheets
node_reconciliation -->|"finds Excel files"| node_local_mutations
node_reconciliation -->|"calls reader"| node_excel_reader
node_excel_reader -->|"provides parsed rows"| node_match_logic
node_reconciliation -->|"matches amount and date"| node_match_logic
node_reconciliation -->|"writes matched dates"| node_sheets

click node_launcher "https://github.com/acc-tax-reighteen/auto-input-tgl-giro-cair/blob/main/Jalankan%20Program.py"
click node_acquisition "https://github.com/acc-tax-reighteen/auto-input-tgl-giro-cair/blob/main/Dapur/1_TarikData.py"
click node_reconciliation "https://github.com/acc-tax-reighteen/auto-input-tgl-giro-cair/blob/main/Dapur/2_CekData%26Tulis.py"
click node_excel_reader "https://github.com/acc-tax-reighteen/auto-input-tgl-giro-cair/blob/main/Dapur/2_CekData%26Tulis.py"
click node_match_logic "https://github.com/acc-tax-reighteen/auto-input-tgl-giro-cair/blob/main/Dapur/2_CekData%26Tulis.py"
click node_config "https://github.com/acc-tax-reighteen/auto-input-tgl-giro-cair/blob/main/Dapur/config.conf"
click node_credentials "https://github.com/acc-tax-reighteen/auto-input-tgl-giro-cair/blob/main/Dapur/credentials.json"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_launcher,node_config,node_credentials toneBlue
class node_acquisition,node_local_mutations,node_sheets toneAmber
class node_reconciliation,node_excel_reader,node_match_logic toneMint
class node_operator,node_shared_mutations toneIndigo
```

## Components

### Program execution

- [Program launcher](https://github.com/acc-tax-reighteen/auto-input-tgl-giro-cair/blob/main/Jalankan%20Program.py): `Jalankan Program.py`
- [Runtime configuration](https://github.com/acc-tax-reighteen/auto-input-tgl-giro-cair/blob/main/Dapur/config.conf): `Dapur/config.conf`
- [Service credentials](https://github.com/acc-tax-reighteen/auto-input-tgl-giro-cair/blob/main/Dapur/credentials.json): `Dapur/credentials.json`

### Mutation acquisition

- [File acquisition](https://github.com/acc-tax-reighteen/auto-input-tgl-giro-cair/blob/main/Dapur/1_TarikData.py): `Dapur/1_TarikData.py`
- **Local Excel mutations**

### Sheet reconciliation

- [Reconciliation runner](https://github.com/acc-tax-reighteen/auto-input-tgl-giro-cair/blob/main/Dapur/2_CekData%26Tulis.py): `Dapur/2_CekData&Tulis.py`
- [Mutation Excel reader](https://github.com/acc-tax-reighteen/auto-input-tgl-giro-cair/blob/main/Dapur/2_CekData%26Tulis.py): `Dapur/2_CekData&Tulis.py`
- [Amount/date matching](https://github.com/acc-tax-reighteen/auto-input-tgl-giro-cair/blob/main/Dapur/2_CekData%26Tulis.py): `Dapur/2_CekData&Tulis.py`

### Other components

- **Operator**
- **Bank mutation folder**
- **Google Sheets**

## Connections

- Operator → Program launcher: starts (evidence: `Jalankan Program.py`)
- Program launcher → Local Excel mutations: clears stale files (evidence: `Jalankan Program.py`)
- Program launcher → File acquisition: runs first (evidence: `Jalankan Program.py`)
- File acquisition → Runtime configuration: reads paths and dates (evidence: `Dapur/1_TarikData.py`)
- File acquisition → Bank mutation folder: scans files (evidence: `Dapur/1_TarikData.py`)
- File acquisition → Local Excel mutations: copies date matches (evidence: `Dapur/1_TarikData.py`)
- Program launcher → Reconciliation runner: runs second (evidence: `Jalankan Program.py`)
- Reconciliation runner → Runtime configuration: reads sheet settings (evidence: `Dapur/2_CekData&Tulis.py`)
- Reconciliation runner → Service credentials: authenticates with (evidence: `Dapur/2_CekData&Tulis.py`)
- Reconciliation runner → Google Sheets: reads worksheets (evidence: `Dapur/2_CekData&Tulis.py`)
- Reconciliation runner → Local Excel mutations: finds Excel files (evidence: `Dapur/2_CekData&Tulis.py`)
- Reconciliation runner → Mutation Excel reader: calls reader (evidence: `Dapur/2_CekData&Tulis.py`)
- Mutation Excel reader → Amount/date matching: provides parsed rows (evidence: `Dapur/2_CekData&Tulis.py`)
- Reconciliation runner → Amount/date matching: matches amount and date (evidence: `Dapur/2_CekData&Tulis.py`)
- Reconciliation runner → Google Sheets: writes matched dates (evidence: `Dapur/2_CekData&Tulis.py`)
