Did you know that you can easily import bank transfers from an Excel, CSV or text file into QuickBooks using Transaction Pro Importer? You can view this transaction type in QuickBooks by selecting the Banking Menu and then the Transfer Funds selection. Below you will find a screen shot of the Transfer Funds form from QuickBooks and in red text you will find the corresponding field from the Transaction Pro Importer mapping screen.
Below is a screenshot of the Transaction Pro Importer mapping screen. Any field that is highlighted in red is required.
Some helpful tips on formatting of your import file:
- The RefNumber is for Transaction Pro Importer internal grouping purposes only. If you do not have a transaction id in your import file you could map the column that contains the date of the transfer to the QuickBooks field, RefNumber.
- For the Accounts either include the lowest sub account number OR the full account name (eg account:subaccount) in your import file.
If you do not already have a copy of the Transaction Pro Importer you can request a free trial of the software here.