# bank-csv
Handle CSV files from a few German banks and PayPal.
## Supported CSV files
| [N26](https://n26.com/) | [Downloads](https://app.n26.com/downloads) |
| [PayPal](https://www.paypal.com/) | [Activity report](https://www.paypal.com/reports/dlog) |
| [DKB](https://www.dkb.de/) | [DKB Konto Umsätze](https://www.ib.dkb.de/banking/finanzstatus/kontoumsaetze?$event=init) |
PayPal has (as I found so far) 2 different CSV file formats.
This project uses [polars](https://github.com/pola-rs/polars) to read CSV files directly by column names.
It's a heavier dependency, but it's easier to support different CSV formats without being super strict about column order and presence.
## Installation
Install directly from GitHub:
```bash
cargo install --git https://github.com/andreoliwa/bank-csv-rs
```
This package is not yet published on [crates.io](https://crates.io/).
## Usage
Merge CSV files from a few German banks and PayPal into a single CSV file.
```bash
bank-csv merge /path/to/import-*.csv
```
`EUR` transactions are filtered by default. You can choose a different currency with the `--currency` option.
```bash
bank-csv merge -c USD /path/to/import-*.csv
```
This will generate `bank-csv-transactions*.csv` files in the download directory of the computer, with transactions sorted by date and grouped by month.
Type `bank-csv --help` for more details.
```bash
❯ bank-csv --help
Handle CSV files from a few German banks and PayPal
Usage: bank-csv <COMMAND>
Commands:
merge Merge one or more bank CSV files and split them into multiple files, one for each month
help Print this message or the help of the given subcommand(s)
Options:
-h, --help Print help
-V, --version Print version
```
## Roadmap (TODO)
- [ ] Generate OFX (or QIF) files to be imported into [GnuCash](https://www.gnucash.org/)