BBVA reports extractor

Library + script to extract your bank account movements from the pdf reports that BBVA provides each month. Export it to csv or sqlite.

Dependencies

The following libpoppler dependencies are needed for pdftotext:

sudo apt install build-essential libpoppler-cpp-dev pkg-config python3-dev

Downloading the reports

In bbva.es, login and go to Posición global > Cuentas y Tarjetas > Ficha. Then click Operaciones > Extracto mensual cuentas. Ready to go!

Using the libray

Just provide the filepath:

import bbva2pandas
dataframe = bbva2pandas.Report('myfile').to_df()

Running the script

The provided script loads all the PDFs in the provided directory and generates a CSV/sqlite file

usage: bbva2pandas [-h] [--output_filename OUTPUT_FILENAME] directory {csv,sqlite}
bbva2pandas: error: the following arguments are required: directory, output_format

Docker

Build and run with Docker (no local dependencies required):

# Build the image
make build

# Run on PDFs in the current directory
make run

# Run tests
make test

# Or use docker directly:
docker run --rm -v "$PWD:/data" bbva2pandas /data csv

Testing

# Locally
python3 -m unittest discover tests

# With Docker
make test