Repo for importing CSV files to GNUCash with some preprocessing built in.
A transfer is simply half of a transaction in double-entry bookkeeping (which GNUCash uses). So if you move money from Bank Account A to Bank Account B, then you have two transfer records; one from Bank Account A saying XXX money was withdrawn and one from Bank Account B saying XXX money was deposited.
In Mint for example, if you export a CSV of all your transfer data, it will keep each transfer separate from the other, even though they are directly related and should be viewed as a single transaction. This script finds the separate transfers, figures out which ones correspond to each other, and puts their data together
Say your CSV has a category system attached to each transfer and you want that organization to be transferred into Mint without having to go one-by-one through every transfer and label them. This will do that by setting up the translation.json dictionary, which will take a transfer that is under a given category, and place it in the corresponding GNUCash account.
Use the get_uncat_transfers function to view any transactions that haven't been categorized. This can be useful to determine what translations you still need to add to translationS.json.
There is a section in the main.py script called INPUTS. Here you will enter in the path to the CSV of your raw transfer data, the GNUCash book you want to edit, and the translation JSON.
You should already have filled out the translation.json at this point. Use the get_uncat_transfers function to view any transactions that haven't been categorized. This can be useful to determine what translations you still need to add to translationS.json.
I recommend doing this to make sure that all the transactions look ok. I recommend using dfgui as a way to view the DataFrames to make sure everything is looking right.
This function will do all the work and edit your GNUCash book. If you want to, you can go step-by-step by using the individual commands at each step. I recommend using dfgui as a way to view the DataFrames to make sure everything is looking right.
Currently requires the use of a development version of piecash to work with GNUCash 3.X. You can install the new version currently (2018-06-18) through pip:
pip install git+https://github.com/sdementen/piecash.git@feature/py3-gnucash3