Parses Royal Bank of Canada™ bank statements and compiles expenses from them.
Enable the poetry virtual environment:
poetry shellRun the script,
./main.py --helpYou should see output similar to:
Usage: main.py [OPTIONS] COMMAND [ARGS]...
╭─ Options ─────────────────────────────────────────────────────────────────────────────────╮
│ --verbose --no-verbose [default: no-verbose] │
│ --dry-run --no-dry-run [default: no-dry-run] │
│ --help Show this message and exit. │
╰───────────────────────────────────────────────────────────────────────────────────────────╯
╭─ Commands ────────────────────────────────────────────────────────────────────────────────╮
│ export Export a report for the given statement files │
│ list-categories List all configured categories │
│ list-files List the available statements │
│ process Process the statement files │
│ report Generate a report for the given statement files │
╰───────────────────────────────────────────────────────────────────────────────────────────╯
Configuration for the parser categories should be placed in the root folder as categories.json, you can find an example here:
https://gist.github.com/mpurdon/f52ae8216d1ec851873abacea047720f
When an NSF item is found, pop the previous expense off the list. NSF items look similar to this:
"2020-02-12"
Item returned NSF 224.19 - 306.33
Utility Bill Pmt Enbridge Gas 224.19
When several NSF fees are processed at the same time, they stack. Multiple NSF fees look like this:
NSF item fee 2 @ $45.00 90.00 1,089.50
When a purchase goes over the limit, a fee is applied. This expense line is different from the rest in that it has the amount on the same line. Over limit fees look like this:
JAN 28 JAN 28 OVERLIMIT FEE $29.00
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent