[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