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

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 ? - sequential transaction import

ofbiz.user
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"
<[hidden email]> 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.