Alex/VyExpenseConversion
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
Helper scripts using pdftk to parse Vy.no PDFs so I can paste into my Google Sheets
3 Commits 1 Branch 0 Tags 29 KiB
Shell 100%
main
Go to file
Alex Thomassen 63dea6c09d
Put STONKS on newline
2023-12-14 20:39:49 +01:00
.gitignore Initial commit 2023-12-14 20:31:06 +01:00
get_prices.sh Initial commit 2023-12-14 20:31:06 +01:00
README.md Put STONKS on newline 2023-12-14 20:39:49 +01:00
rename_by_date.sh Initial commit 2023-12-14 20:31:06 +01:00

README.md

VyExpenseConversion

Because while Vy's smartprice saves us money, it makes it a little bit of a pain to calculate ticket prices.

Requirements

  • pdftk

Steps

Getting PDFs from Vy

  1. Log into https://www.vy.no/mine-sider/mine-reiser
  2. Filter by "Fullførte" (Completed).
  3. Check off the receipts that are relevant, hit the download button. Will likely download as kvittering-*.pdf
  4. Put downloaded files into a directory, e.g. FolderName

Run scripts to rename PDFs (optional) and get ticket price

  1. Use ./rename_by_date.sh FolderName
    1. This step is technically optional, but for my own sanity I prefer having the PDF files sorted by date & time.
  2. Use ./get_prices.sh FolderName - Will echo out in terminal a CSV you can paste into Google Sheets.
  3. Paste into Google Sheets and use "Split text into columns": Image
    1. Alternatively find this in the "Data" dropdown menu: Image
  4. For B-column, you will have to search and replace . => , for Google Sheets to understand it's NOK.
  5. Then do a simple =SUM(B1:B100)

Upload and submit to Visma Expense.
STONKS