In this post we will provide an overview of how to import checks into QuickBooks using Transaction Pro Importer. On the first screen of Transaction Pro you will select the browse button to select your import file. In this example we are using the sample import files that are installed with the program and are located in c:\my documents\01 Transaction Pro Importer 4.0\sample files We will also select an import type of check. Then select the options button if you want to select any options.
On the file contents screen you will see the data in your import file in a grid format. Select the next button.
The next screen in Transaction Pro Importer is the mapping screen. If the map does not load select the load map button and navigate to the following file: c:\my documents\01 Transaction Pro Importer 4.0\check map.dat Required QuickBooks Fields are depicted in red in the first column (Bank Account, Payee, RefNumber). Other fields become required depending on if you are using accounts or items on your check transactions. If you are using accounts you need to map data to the following two Quickbooks fields: Expenses Account and Expenses Amount. If you are using Items at a minimum you need to map data to the QuickBooks field, Items Item. If you do not have a price on your items in QuickBooks you also need to map data to the QuickBooks field, Items Cost. Select the next button to continue.
This next screen shows how the data will be mapped to your QuickBooks fields. The QuickBooks fields are listed at the top of the grid and the data follows in rows immediately below. Review this data to make sure that data is mapped correctly. Select the next button.
On the last screen of Transaction Pro you select how any new items that do not exist in your QuickBooks company file will be set up by making selections from the drop down menus. Please note this last screen needs to be completed even if you are not mapping data to the items item field. Select the finish button to start the import.
Advanced tips and options:
If you would like to print all the checks that are in your import file select the option highlighted below on the basic options tab.
If your import file has multiple expense accounts on one line you may want to consider using the option highlighted below.
You will see that 15 additional expense account are added (see screen shot below).