ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ofbiz.u...@nym.hush.com
Subject Re: Import of bank transaction/statement data, QIF ? - sequential transaction import
Date Sun, 05 Jul 2015 15:17:48 GMT
Thanks Sharan,

that is something to work with for starters.

I will go on with that when I have the data spec from the bank(s).

THX.


On Fri, 03 Jul 2015 13:41:03 +0200 "Sharan-F" 
<sharan.foga@gmail.com> wrote:
>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.


Mime
View raw message