• From: Australia
  • Registered: 01/25/2015
  • Posts: 32

Topic: Quickbooks to FrontAccounting conversion

Hi,

I'm in the process of converting from Quickbooks to FrontAccouting and I was wondering if anyone else has any experience or thoughts on this?

Quickbooks does not make it easy to export your data. The lists come as an IIF file which is text (but nothing understands the format) and the transactions can be exported as CSV. Of course none of the code values match FrontAccounting. I am working on a process of parsing the QB exports (with a perl script) to generate CSV files, which can then be amended in a spreadsheet (if required - I'm hoping in most cases the defaults will be sufficient). Then to import these files into FA using a module that I'm developing. So far I have SalesPersons, ShippingCompany and Suppliers working. Currently I'm working on Customers, with PaymentTerms, Items and transactions to do.

Would this be of interest to anyone else? Thoughts? Comments?

Thanks.

Paul Shipley
Melbourne, Australia

PaulShipley's Website

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Quickbooks to FrontAccounting conversion

Check out some of the extensions already in FA. The pkg files are individually available (and updated in many cases) in my GitHub repo.

apmuthu's Website