Note that you can make minor edits here, and delete records that you don’t want to include. Next you get a display of the records that you are going to import.
The Options button provides you with a number of preferences that will control how the file is processed.
TRANSACTION PRO PRO
Make a backup copy before importing, so that if you find that something didn’t work right you can always go back to the file before you imported.Īfter starting Transaction Pro Importer you select the file to start with, some characteristics of the file, and the type of import. The first step should always be to make a backup copy of your file! Imports cannot be reversed, no matter what tool or method you are using. This is information that you don’t normally find in an import file. At the very least the items must have an item name, an item type, and at least one account. This is a important issue because not only do the other items have to be added to the item list, adding items isn’t a simple task. If we look at the item list we see that one of the items (“Door”) is already on the list, but the other items are not. That means that this import must add three of the customers but not create a duplicate record for the fourth. Looking at my customer list in QuickBooks, only one of these customers is already on file. In this sample file there are 11 invoices for 4 different customers. Note that the Transaction Pro Importer isn’t limited to this kind of file, you can use many kinds of data sources (as I’ll list later). This could be a file exported from an outside order generation system for example. This is a simple flat text file, tab delimited. Here is a view of the file that I’m starting with (I edited out the blank columns to compress this).
What about the accounts that are needed for the item if it is added? What accounts will be used?. If an item is added, what item type will it be added as?. Will the items be added if they aren’t found? You will have one or more items in the detail section of the invoice. What if the Customer already exists in the customer list, will the import add a duplicate?. What if the Customer record isn’t already found in the customer list. There will be a Customer for the invoice. This is a common request – I am getting invoices from some sort of outside order system. I’m going to import several Invoice transactions from a formatted text file. Let’s take a look at how this program works. The tool works, it is highly accurate, and it provides a wealth of features that I haven’t found anywhere else. My absolute favorite import tool is the Transaction Pro Importer, which is based on the QuickBooks SDK. This covers the widest range of QuickBooks data and has the best internal error checking. I’ve worked with all of the methods listed above, and the absolute best method is to use a product that uses the QuickBooks SDK. Wait, what about all the other methods we hear about? The ODBC drivers, the “Method” programming language, other similar products? Well, they all are just layers on top of one of the approaches that I outline above (or, are a read-only method that won’t let you import). This is a newer method that is still being developed, so you won’t see it for imports as often. QuickBooks IPP programming: This is a newer method of programming being pushed by Intuit, but again it requires you to either be a programmer (and this is REALLY complicated!) or to use a third-party tool using this method. See Doug Sleeter’s article on QuickBooks Add-ons for a discussion of the SDK. QuickBooks SDK programming: This requires you to either be a programmer (and it can be complicate to use the SDK) or to use a third-party tool that uses the SDK (much easier!). There also are a few other Excel related imports scattered about in the program where you can copy/paste Excel info into a grid, such as Add/Edit Multiple List Entries and the Lead import found in the Lead Center. See my article on importing inventory records for an example. Excel file import: This is also found in File/Utilities/Import, and it is limited to just importing customer, vendor and item records. This is an older format (see my older article on IIF). Intuit hasn’t been updating this for many years, and it isn’t always reliable. IIF file import: This is an older format, accessed via the File/Utilities/Import/. There are really only four ways to import data: That means that you can only use a limited number of methods to import data, and all are controlled by Intuit. 
Let’s take a look at this important tool.
One of the best tools that I’ve found over the years is the Transaction Pro Importer from Baystate Consulting. Importing information into QuickBooks can be a difficult chore, but it is a task that many people need to perform.
0 kommentar(er)
