Continuing on the topic of my previous column, 3rd Party Software for Quickbooks, there’s another great utility I came across that allows you to import data from Excel into Quickbooks. Quickbooks 2010 now allows you to add and edit lists in bulk with Excel, such as Customer lists, Vendor Lists and Item lists. However, there is still no easy way to import transactions from Excel into Quickbooks.
. I came across the Transaction Pro Importer program while looking for a solution for a client who used the Concur Solutions website to track Rep expenses across the country. The Reps would submit receipts online. After the client approved them, direct deposit checks were issued from within Concur. The client was downloading an Excel report from Concur and then manually entering each check and related expenses into Quickbooks. They were looking for a way to automate the data entry process from the Excel report into Quickbooks.
. Transaction Pro Importer (TPI) proved to be the answer to their prayers. The program can take a variety of transaction data from an Excel spreadsheet and import it into Quickbooks. It can import all kinds of transactions, everything from bills, checks (except payroll) and credit card charges to Sales Orders, Invoices and Deposits. It also handles most lists in Quickbooks. You have to do some mapping work, telling TPI what fields in the Excel spreadsheet belong to what fields within Quickbooks, to get your first data spreadsheet imported. Once you have the mapping done, you can save that mapping configuration and all future imports are just a matter of a few clicks.
. The TPI program can be found on the Baystate Consulting website (http://quickbooksimporter.com/Default.htm). It is reasonably priced and I found the email tech support very responsive. Please feel free to write me with suggestions for future topics regarding 3rd party software that works with Quickbooks.
Concur Breeze has the ability to directly export to a Quickbooks IIF file. We use that, and it only takes minutes. Have to set up first so the mapping is correct.
Concur Travel & Expense also has a new Connector to import into Quickbooks. However, I spent 8 – 10 hours working for a client with the Concur rep to get the mapping correct for the IIF file. Once it’s set up, the IIF imports do work smoothly.
trik computer…
[...]3rd Party Software for Quickbooks – Transaction Pro Importer « The QuickBooks Pro Blog[...]…