Bank-to-Sheets Sync
A small service that keeps settled BNZ transactions in a Google Sheet, so the budget formulas already in the sheet have current data.
Independent development. Python, Akahu and Google Sheets.
The sheet had places for the numbers, so the job was keeping the rows underneath them current, and stable transaction IDs with saved sync state mean a rerun doesn't duplicate a batch while category rules and transfer detection run before the write.
Reconciliation compares the balance the bank reports against what the sheet expects. It ran on a Raspberry Pi and stayed quiet.
State
A tested sync with state, categorisation and reconciliation, and the thing the later finance projects grew out of.