Using bank exports (CSV, QIF,...) to avoid the overhead that comes from processing bills

trythis grahamlane at gmail.com
Mon Mar 8 08:26:42 EST 2010


I am not sure this would help.
I used csv files from mint.com or other bank exports to get gnucash loaded.
I had more than a years worth of bank statements from 4 bank accounts to
load. 
With CSV files I imported them into Excel or Calc and used the qif converter
from this site:

http://xl2qif.chez-alice.fr/xl2qif_en.php or
http://xl2qif.chez-alice.fr/calc2qif_en.php
to make useful QIF files to import to Gnucash.

AS far as automating the business transactions that come from these I am
unsure if that would help you.


Tom Van Braeckel wrote:
> 
> Dear list,
> 
> I searched (the mailing-list archives, Google and the wiki) but could not
> find a way to use the exports from my bank to spare me from manually
> having
> to create, post and pay every bill that I get.
> 
> One solution I can think of is by *not* using the MKB-features (= business
> features) and just using regular transactions for bills. I would then use
> a
> script that adds the opposing account (which can often be deduced from the
> transaction description) to the QIF file, and then import this QIF file. I
> would then use a "transaction report" to extract and sum up the numbers
> for
> when I'm filing my tax report.
> 
> Such an approach would save me from:
> 
>    - manually having to create and input bills, because they would
>    automatically be created when I import the (enriched) QIF file
>    - posting bills, because a "bill" would just be a (possibly split)
>    transaction which is implicitly posted when it's created
>    - marking the bills as paid, because I would know they were paid since
>    they appeared in my bank export
> 
> But then I would miss out on the MKB features such as the "expired bills"
> report...
> 
> So my question is: How can I use bank exports to automate (part of) the
> whole bill processing workflow ?
> What do you think about my idea, or what other approaches would you
> recommend ?
> 
> Thanks for the help !
> 
> Tom.
> 
> PS: There's someone willing to pay for a related feature
> here<http://n4.nabble.com/Hiring-a-GnuCash-developer-for-a-few-days-work-td1457805.html>
> .
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> 
> 

-- 
View this message in context: http://n4.nabble.com/Using-bank-exports-CSV-QIF-to-avoid-the-overhead-that-comes-from-processing-bills-tp1584325p1584473.html
Sent from the GnuCash - User mailing list archive at Nabble.com.


More information about the gnucash-user mailing list