Automating a parking expenses report

For the past year, I was consulting at a place where I could request reimbursement of parking expenses. This had to be claimed using a standard Excel template.

This project automated a significant part of that:

• Fetch parking costs for a certain month from my Paperless-ngx instance
• Calculate costs after taxes and a grand total
• Fill in an Excel sheet with the details
• Convert the Excel sheet to PDF and append photos of parking costs

Note: I don't expect anybody to have the same requirements as me here, but hopefully pieces can be useful to some.

Usage

The project uses Nix for dependency management.

Example usage:

$ cd parking-expenses
$ nix develop
$ PAPERLESS_TOKEN=foo ./main.py -y 2025 -m 1 -p ABC-12-D -u https://paperless.example.com