RAMP — August reconciliation and automation requirements gathering

Summary

Catch-up reconciliation for (early) August. More monthly expenses have ticked over since the July production bootstrap — time to reconcile the new transactions and push the updated financial picture to the live OpenCollective site. We also want to move the manual bootstrap scripts from July toward a repeatable automation path.

Background

The production OpenCollective bootstrap (ledger!21) got our finances live at opencollective.com/startmeupnz. The scripts used (seed_host_and_allocate.py, get_balance.py) are now in oc-opsdevnz — the direction of travel is toward automated reconciliation, but for August we will do another manual pass to keep the books current while building out the automation.

July work was tracked in #13 (closed).

What needs doing

Reconciliation

• Fetch August transactions via Akahu (Current and Call accounts)
• Import into Beancount, validate with bean-check
• Reconcile against bank statements and Stripe
• Push updated balances to production OC (top up host, adjust project allocations)

Automation progress

• Review and refine the scripts used in the July bootstrap
• Identify which steps can be automated (balance queries? host seeding? project allocation?)
• Start building the reconciliation runbook into something repeatable

Documentation

• Update public startmeup.nz financial data from August Beancount snapshot
• Update operating costs page

Related

• #13 (closed) — July reconciliation and OC bootstrap (prior session)
• ledger!21 — production OC bootstrap
• modules/oc-opsdevnz — the module we are building toward automated reconciliation