Migrate Freshbooks to Quickbooks..

Hi guys,

I am trying to move from Freshbooks (www.freshbooks.com) to Quickbooks. I can do an export of my contacts through Freshbooks, but i cannot do anything with all my invoices.

Does anyone know of a way to migrate this?
LVL 4
Cobra25Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

JohnBusiness Consultant (Owner)Commented:
You may not be able to.  This Freshbooks article says Income and Expenses but not Invoices.

https://www.freshbooks.com/support/is-there-a-way-to-import-data-into-my-freshbooks-account

I use QuickBooks extensively. One way to do what you want is to set up a new Company with opening balances and the accounts you need at the beginning of your fiscal year. Import what you can, but keep the old Freshbooks data available for reference and begin QuickBooks new and enter new invoices in QB. Old invoices are either (a) Accounts Receivable or (b) income (revenue history.
Annaliese DellSec-TreasCommented:
Hello. If:

1.  you must have (or really really want to have) your old invoices from Freshbooks in Quickbooks
2. and  you can export the Freshbooks invoices to MS Excel or MS Access
3.  and you are familiar with VBA and MS Access

...you can use a utility called QODBC which is an open database connection driver specifically for QuickBooks. You can import data from QuickBooks into Microsoft Access and export data from Microsoft Access into QuickBooks.

So you don't have to learn the QuickBooks SDK if you know VBA.

Therefore, you could import your Freshbooks invoices into MS Access, either directly or via Excel, and export them back out to QuickBooks.

If you don't know VBA and you really need to do this, you can surely hire somebody to do it for you.

I don't work for QODBC or receive any compensation from them but have been using it for many years and couldn't do my job without it, or at least it would take three times as long.

http://www.qodbc.com is their website.

If you go with it, you'll find QODBC is really handy for doing a lot of things with your QuickBooks data in MS Access that you can't do in QuickBooks. I love it. Best of luck and best wishes!

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
JohnBusiness Consultant (Owner)Commented:
Invoices (and Bills) are a very special type of data in QuickBooks.

You can import Invoices into Quick Books with Zed Systems:

http://support.zed-systems.com/kb/a52/importing-invoices-into-quickbooks.aspx 

But then you need to create Excel files from your Freshbooks data.

Zed Systems is pretty much ready to go. QOBDC may take some work on your part.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
QuickBooks

From novice to tech pro — start learning today.