more-arw search

Q&A Forum

Import to Quickbooks

Ayaz Ahmed's Profile


I am using quick books for my clients. I want to know how i can import data into quickkbooks using MS excel, CVS files or file from any other software. Can any body help?


Bobby Bluford
Title: VP, Finance
Company: Printroom, Inc.
(VP, Finance, Printroom, Inc.) |

What type of data are you looking to import?

beth damis
Title: Owner
Company: Bookkeeping by Beth, LLC
(Owner, Bookkeeping by Beth, LLC) |

You may want to look into a 3rd party application

jt forhan
Title: consultant
Company: in-between
(consultant, in-between) |

it's actually very easy, just make sure you have the data in the same order of the template you want to add the data for, they have a wizard that will walk you through it. excel is the easiest format to import.

Hillari Selby
Title: Internal Recruiter
Company: Gemological Institute of America
LinkedIn Profile
(Internal Recruiter, Gemological Institute of America) |

I have 2010 and it does it, but not sure years before that do? It IS easy, they have a wizard that walks you through it. Go to general company settings and check the box that allows all first time messages to pop up again. Then, when you go to the item list (or customer or vendor list or whichever...), it will bring up a pop-up to walk you through it.

Becky Warburg
Title: Contract Accountant
Company: Premier Business Solutions
(Contract Accountant, Premier Business Solutions) |

Remember, you can only import lists, not transactions and you have to make sure everything is in the correct order before you do it. In 2010, Premier, you can dump columns in at once into the "Edit Multiple Lists" option.

Ayaz Ahmed
Title: Consultant
Company: Azure Global International
(Consultant, Azure Global International) |

Let suppose i have to import bank in the quick books. What is the format i should follow. Can anyone email me at ayaz786amdatgmail [dot] com. I have QB Premier 2009 & QB Pro 2010.

John Kogan
Title: CEO/CFO
Company: Proformative, Inc.
(CEO/CFO, Proformative, Inc.) |

In the "Ask the Experts" area of the site. She is great and you can find her under: Ask the Experts, Technology, Quickbooks.

Bobby Bluford
Title: VP, Finance
Company: Printroom, Inc.
(VP, Finance, Printroom, Inc.) |

Hey Ayaz-

Another idea is something I've been working on and just learning. QODBC and AccessBooks RT( If you are at all familiar with MS Access, it provides direct access (read and/or write, if you're brave enough) to the back-end tables that make up Quickbooks. It's actually fairly easy to do, once you get the hang of it. More importantly, at least for me, is that you can that use that information and do a number of things with it in Access or Excel. This has allowed me to distribute information much more readily to managers and executives who don't have direct access to the accounting information. If you'd like help in getting started, I'd be more than happy to provide some guidance. I'm certainly not an expert, but am moving along and find it extremely helpful.


Phil Drummond
Title: CFO
Company: First Financial Services
(CFO, First Financial Services) |

Quickbooks can be picky about importing files unless they are "lists" as a previous commenter stated. If you want to import transaction data (i.e., journal entries) for your clients, Quickbooks uses an IIF file type for this. You can buy IIF file creators that integrate very well with your QB data and even validate accounts, etc. before importing. I use an IIF file creator published by Big Red Consulting. It's around $100 and well worth it. Good luck.

Danielle DehmlerBuckley
Title: VP Finance
Company: BlogFrog, Inc.
(VP Finance, BlogFrog, Inc.) |

We import hundreds of bills each month into Quickbooks using Transaction Pro Importer (Baystate Consulting). I have been very happy with the product - no bugs yet, easy to use, only $200. You can use it for any transaction or list. Simply set up your Excel file and then map the fields to your QB file.

Topic Expert
Bob Stenz
Title: Controller
Company: Silicon Valley start-up
(Controller, Silicon Valley start-up) |

I've been using a 3rd-party add-on for journal entries named "Dynamic Ventures General Journal Entry" for years with QB Enterprise (we're currently on QB Enterprise, version 11). It has worked flawlessly...even with QB upgrades. I believe it would work with any QB Pro version and above. The tool comes with easy instructions and the company provides good email support. The tool was free (from emailing the company) at the time I got it and I believe it can still be obtained freely by searching the web (just Google the name).


Get Free Membership

By signing up, you will receive emails from Proformative regarding Proformative programs, events, community news and activity. You can withdraw your consent at any time. Contact Us.

Business Exchange

Browse the Business Exchange to find information, resources and peer reviews to help you select the right solution for your business.

Learn more

Contribute to Community

If you’re interested in learning more about contributing to your Proformative community, we have many ways for you to get involved. Please email [email protected] to learn more about becoming a speaker or contributing to the blogs/Q&A Forum.