• Extract a General Journal
• output a CSV file
• one line per transaction, all debits and credits spread through columns
• one column per account
• The first numeric column, "TRANSACTION AMOUNT", is the absolute value of the "raw" transaction (like in a classic General Ledger)
• account names are preppended with the currencey symbol

The "one column per account, one line per transaction" model captures details of every transaction including all splits and allows for a third party not using GnuCash to have an overview of all transactions and accounts, and work directly in a spreadsheet, for example calculating and account balance by doing a sum of that column.

sudo pip3 install virtualenv
cd gnucash_general_journal
virtualenv .
. ./bin/activate
pip3 install -r ./requirements.txt

• There is now an additional column, "TRANSACTION AMOUNT" which is the absolute value of the transaction. This makes it easier to import as a General Ledger.
• piecash is set at version 0.19.0 in order to work with GnuCash versions 2.x.
• this script works with GnuCash SQLite3 files only. If your data is saved in XML format, you can convert it by opening it GnuCash and "Save as" in SQLITE format (You will need libdbd-sqlite3 to be installed).

./t2csv.py accounting-sqlite3.gnucash general_journal.csv

It prints the message "You need to install requests to use the 'yahoo' import". This comes from importing piecash, you can safely ignore.

• piecash

• add simple sqlite3 file and simple tests
• eliminate the Requests/yahoo warning