Post Reply 
 
Thread Rating:
  • 1 Votes - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
ofx/csv ledger import?
05-02-2012, 05:16 AM
Post: #1
ofx/csv ledger import?
What would be very nice for new users and old is the ability to download bank statements and import them. Import of .ofx or csv in a predetermined format would be very useful.
How do other people import (other than manually) financial data for un-invoiced transactions such as travel expenses charged to a credit card and the like? Any way to automate reconcile electronic bank statements against the general ledger? Anyone got any useful SQL queries for doing such?
Quote this message in a reply
05-04-2012, 06:31 PM (This post was last modified: 05-05-2012 05:09 PM by phil.)
Post: #2
RE: ofx/csv ledger import?
I have done this for MT940 bank statements - I need to work with some other formats to get something more generic and get some file examples. I was thinking of charging for this as an add on though - see my web-site.

Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Visit this user's website Find all posts by this user
Quote this message in a reply
12-17-2014, 01:22 AM
Post: #3
RE: ofx/csv ledger import?
(05-04-2012 06:31 PM)phil Wrote:  I have done this for MT940 bank statements - I need to work with some other formats to get something more generic and get some file examples. I was thinking of charging for this as an add on though - see my web-site.
Hello,

Have you done anything about this ?
Are you still willing to keep it out of the open source version of weberp ?
Find all posts by this user
Quote this message in a reply
12-17-2014, 02:51 PM
Post: #4
RE: ofx/csv ledger import?
i did add the GIFTS format too not ofx or csv

Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Visit this user's website Find all posts by this user
Quote this message in a reply
12-18-2014, 01:55 AM
Post: #5
RE: ofx/csv ledger import?
I have done the format for Quickbooks .qbo files which looks to actually be an OFX file (Header data plus XML).
I am attaching that script (Which replaces the MT940 in my system).
We are not using it. I tested on 3-4 files downloaded from a bank with success however it hasn't seen "production level testing".


Attached File(s)
.php  ImportBankTrans.php (Size: 26.26 KB / Downloads: 10)
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)