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.
