[GNC] Regularly importing transactions from CSV files
Mateja Maric
mail at matejamaric.com
Sun Jul 24 17:26:51 EDT 2022
Hello everybody,
I found out about GnuCash (and double-entry accounting) three days ago
and I want to use it to track my spending...
My bank allows me to export my transaction history to a CSV file.
I plan to use that feature regularly and import transactions into GnuCash.
Here's how my bank's CSV file looks like:
```
Date made; Date finished; Withdrawn; Deposited; Balance; Description
2.2.2022.; 4.2.2022.; 200; 0; 12800;
Pizza paid by a debit card
15.1.2022.; 16.1.2022.; 2000; 0; 13000; ATM Cash
Withdrawn
2.1.2022.; 2.1.2022.; 0; 15000; 15000; Salary
received
```
Of course this is just an example and I actually have hundreds of
transactions that I have to import from a single file.
I'm using a "A Simple Checkbook" account hierarchy and I'm having
trouble putting transactions into appropriate accounts. What should be
my base account when importing transactions? Also can I move
transactions from one account to another and can I switch debit and
credit fields of multiple transactions (because I already managed to
mess up their order)?
Thanks in advance,
Mateja
More information about the gnucash-user
mailing list