In this post we will provide an overview of how to import deposits 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 5.0\sample files We will also select an import type of deposit. Then select the options button if you want to select any options. Select the next button to advance to the next screen.
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:\documents\01 Transaction Pro Importer 5.0\deposit map.dat Required QuickBooks Fields are depicted in red in the first column (RefNumber, Deposit to Account, From Account, Amount).
Below is a table showing all the fields available on a credit card charge import and where these fields reside in QuickBooks. You can also download the data dictionary in an excel format at http://www.baystateconsulting.com/forum/forum_posts.asp?TID=338&title=tpi-field-listing-data-dictionary
|QuickBooks Field from TPI Mapping Screen||QuickBooks Form - Field Description||Notes||Required Field||Type/
|RefNumber||For internal TPI processing only. TPI uses this field to group multiple lines onto the same deposit transaction.||Yes||Char 11|
|Deposit to Account||Deposit - Deposit To||If using account numbers just provide the lowest subaccount number. If using account names include both the account and the subaccount separated by a colon.||Yes||Char 31|
|Transaction Date||Deposit - Date||Date|
|Deposit Memo||Deposit - Memo||Char 4095|
|Received From||Deposit - Received From||If using jobs include both the customer and the job in your import file separated by a colon.||Char 31|
|From Account||Deposit - From Account||If using account numbers just provide the lowest subaccount number. If using account names include both the account and the subaccount separated by a colon.||Yes||Char 31|
|Memo||Deposit - Transaction Line Memo||Char 4095|
|Chk No.||Deposit - Chk No||Char 11|
|Payment Method||Deposit - Pmt Meth||Char 31|
|Class||Deposit - Class||If using subclasses include both the class the subclass separated by a colon.||Char 31|
|Amount||Deposit - Amount||Yes||Numeric|
|Currency||Deposit - Deposit Total||This field is available if the multi currency feature is turned on in QuickBooks.||Char 64|
|Exchange Rate||Deposit - Exchange Rate||This field is available if the multi currency feature is turned on in QuickBooks.||Numeric|
Select the next button to advance to the next screen of Transaction Pro Importer.
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:
There are also many other options that you might want to consider reviewing which are highlighted in yellow below. All of these options are discussed in detail in the help file that comes installed with Transaction Pro Importer. To access the help file select the help file on any of the pages within Transaction Pro Importer or press the F1 function key while Transaction Pro Importer is open.
Basic Options tab:
Advanced Options tab:
You can also download a free demo to try this out here. If you have any questions feel free to post a comment below.