Solved

Sage Payroll to Quickbooks Pro

Posted on 2012-03-15
1
891 Views
Last Modified: 2012-03-26
Hi Experts,

I need some guidance to migrate from Sage 50 Payroll to Quick books Pro. What needs to be done? Is there any third party software that should be used. What steps to be undertaken. Alternatively if i could find some on to complete the task remotely it would be great.

I already know that in theory you should export all information from Sage to csv files. They should be converted to iif and then imported to Quick books. Unfortunately it does not work.

Please let me know if you have any questions.

Thank you.
0
Comment
Question by:goliveuk
1 Comment
 
LVL 8

Accepted Solution

by:
KoiGirl earned 500 total points
ID: 37726546
Have you looked into QODBC? If you can export Sage data to csv, you can then import that data into Microsoft Access and export it into QuickBooks using QODBC, an ODBC driver for QuickBooks.

QODBC uses SQL pass through queries to read/write between QuickBooks and Microsoft Access and in my opinion is easy to learn.

I believe Flexquarters still offers a free demo that you could use with some code to see if this method interests you.

You may want to look over some of the codes on VBQuick.com (shame on me - my own blog) to see if it's something you want to attempt. There is a link to a quick start tutorial to give you quick results and see how it works.

If you already know SQL, the hop to QODBC is a short one.

If you are not ready for a new learning curve, there must be someone out there who could do this for you.

The negatives would be the time involved in both the learning and implementation. However, you could then use QODBC in many different ways like I do. You may enjoy the flexibility and ability to write your own QuickBooks add-ons.

Geez, I sound like a commercial! But I use it every day and it really helps us in our business.

I'm sure a utility must exist to automate the entire migration but I am not aware of it. I am a carpenter with only a hammer (QODBC) so that is my solution to almost everything, lol.

Good luck to you and make sure to come back and tell us what your solution was when you find something that works for you. At least I will be interested to see what you find.
0

Featured Post

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Getting data out of MAS90 doesn’t have to be tedious or time consuming.  With any version of Excel using the included Microsoft Query function, you can access just about any data set or combination of data sets stored in your MAS90 MAS200 Software. …
Hi, I've just fixed a problem with Sage 50 Accounts 2011 crashing when creating a new Company.  I've wasted several hours on it so I thought I'd share the solution with others.  Remarkably, the same laptop had what appears to be exactly the same …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question