[Ledger Glue]
Finance Integrations
Corporate-card transactions into accounting, a multi-provider bank ETL with central-bank FX, and projection spreadsheets generated by code.
The finance team reconciled cards, bank accounts and projections by hand across tools that didn't talk to each other.
Solo: I designed and built the three integrations for the finance team, from the API clients to deployment and scheduling.
Copy-paste between card portals, banks and the accounting system, with FX conversion done by hand.
01 · Card → accounting
A serverless function runs every hour, fetches corporate-card transactions and posts them to the accounting software per card; credentials come from a parameter store.
02 · Bank ETL
One client per provider (two digital banks, a payments platform, a corporate card) behind a common interface, plus central-bank FX rates, loaded into Postgres.
03 · Projections as code
OAuth scripts create and format a long-horizon projection model (an 18-year forestry cycle) directly in Google Sheets — formulas, currency formats, frozen panes.