New transaction type added! Transaction Pro Importer 5.0 now has the ability to import credit card statements. First of all make sure that you are on release 5.015 or later by selecting the about and check for updates buttons within Transaction Pro Importer.
This post will walk you through the process of downloading an excel, csv or txt file from your financial institution and then how to import this file using the powerful payee alias feature.
On the first screen of Transaction Pro you will select the browse button to select your import file. In this example we are using file that we downloaded from our American Express Account. We will also select an import type of credit card statement. 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. Please note that the negative amounts are credit card charges and positive amounts are credit card credits. Select the next button.
The next screen in Transaction Pro Importer is the mapping screen. Required QuickBooks Fields are depicted in red in the first column (Credit Card Account, Payee, RefNumber, Account and Amount). Since the import file does not contain the credit card account from the QuickBooks chart of accounts we have typed it in as a static value of American Express. Also we provided a static vale of TBD (to be determined) as we will assign accounts on the payee alias screen.
Select the next button to advance to the next screen of Transaction Pro Importer. You will get the validation error below. We will assign the correct vendor names on the payee alias screen so select ok 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. Then select the payee aliases button. You can read how to use the Aliases here.
Below is a completed Payee Aliases screen. Based on the Alias mapping that is on the top grid the proper accounts and vendors populate the bottom grid. Select Apply and then Next.
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.
You can also download a free demo to try this out here. If you have any questions feel free to post a comment below.
Hi Karen,
The 2nd paragraph: This post will walk you through the process of downloading an excel, csv or txt file from your financial instruction and then how to import this file using the powerful payee alias feature.
Did you mean ‘instruction’ or ‘ institution’?
Regards,
Yes that was my typo (should be institutiion) I have corrected the article. Thanks.
Hi Karen: Excel will not let you type in a numerical string greater than 15 digits. So when you type in a credit card number (16 digits) that last number rounds to 0 (zero). Who knew! So, you need to convert it to a text format. Will TPR import a text string for the credit card number?
Thanks
Barb B
Yes TPI will recognize the credit card column as number even if it is formatted as text.
Thanks Karen. I am continually finding new applications for TPI!
When we uploaded a statement with a credit on it (in TPI the Amount was positive) the Vendor name did not appear in the Quickbooks file, is this common?