Re: Import of bank transaction/statement data, QIF ? - GnuCash

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Re: Import of bank transaction/statement data, QIF ? - GnuCash

ofbiz.user
Taher,

using GnuCash as a proxy or scavenging it as appropriate is a nice
idea.  I will take that into consideration.

THX



On Fri, 03 Jul 2015 14:05:21 +0200 "Taher Alkhateeb"
<[hidden email]> wrote:

>Hello,
>
>To continue with what Jacques and Sharan stated, OFBiz does not
>support QIF, OFX or QFX out of the box. With that being said, you
>only need to understand a few entities (tables) to map your source
>data to. The main entities coming to mind are AcctgTrans,
>AcctgTransEntry and GlAccount.
>
>Anyway, don't start from scratch as someone almost always did it
>for you. From research I found this Java library for importing /
>exporting QIF -> https://code.google.com/p/jqif/. Are you by the
>way bringing this data from GnuCash?
>
>Cheers,
>
>Taher Alkhateeb
>
>----- Original Message -----
>
>From: "Sharan-F" <[hidden email]>
>To: [hidden email]
>Sent: Friday, 3 July, 2015 2:17:52 PM
>Subject: Re: Import of bank transaction/statement data, QIF ?
>
>Thanks for the recommendation Jacques. The book doesn't cover
>importing bank
>statements.(although there is a small appendix about importing
>data via the
>webtools menu)
>
>I think that if you want to look at importing a bank statement
>then an xml
>import is the way to go (so if you can convert it to xml you can
>import it).
>Effectively all you are doing is importing transactions.
>
>The challenge you may have is going to be the format and linking
>with the GL
>and other areas. I'd suggest you look at importing it as a
>financial account
>bank account to start with. That way you can have a play around
>with the
>different statuses and reconciliations available and posting the
>transactions to the GL account you want.
>
>It's been a while since I looked at it but I remember some
>functionality
>around reconcilation that matches the closing balance of one
>reconciliation
>against the following one, which would help as an ongoing balance
>check for
>ongoing imports.
>
>It's a bit hard to say much more without more information.
>
>Anyway, hope this helps.
>
>Thanks
>Sharan
>
>
>
>--
>View this message in context:
>http://ofbiz.135035.n4.nabble.com/Import-of-bank-transaction-
>statement-data-QIF-tp4670715p4670740.html
>Sent from the OFBiz - User mailing list archive at Nabble.com.