Work / Independent build

ExpenseOps: expense claims, automated from bill to submission

A personal tool that turns a folder of cab bills into a submitted expense claim, including logging in to Happay and uploading every bill one by one.

Type
Personal project
Role
Builder
Focus
Independent build

Where it came from

While working at a client site, I found submitting cab bills and expenses tedious and repetitive. The same steps, every time, by hand. So I automated the whole thing.

What it does

  1. Parses cab bills.
  2. Extracts the relevant details from each bill.
  3. Renames files into understandable formats.
  4. Aggregates daily expense amounts.
  5. Generates a consolidated Excel report.
  6. Logs in to Happay automatically.
  7. Uploads individual bills sequentially.
  8. Runs the upload workflow without manual intervention.

The interesting part

Parsing and reporting are the easy half. The part I'm proudest of is the end of the workflow: the tool handles the submission itself, including each individual bill upload, which is exactly where the tedium lived.

Bills in, claim submittedCab billsParse and renameDaily totalsExcel reportHappaylogin and upload,one bill at a time
Next case studyMoving 110 legacy SAS jobs onto a Databricks lakehouse