Transaction Log - How do I only save the transactions that did not import to QuickBooks

QuickBooks Desktop (Pro, Premier or Enterprise) > Transaction Pro Importer
Transaction Pro Importer for QuickBooks ("TPI") users have asked us if there is way to save only those transactions that did not successfully import and below are the steps to follow to save only the failed transactions.
  1. On the basic options tab within TPI select the last option to Enable Troubleshooting Log
  2. After the import has completed select the box at the bottom left of the screen, Filter for records that did not import
  3. Select the save button
  4. For the save as file type select either csv or tab as the type.  If you select the excel option the successful transactions will still appear in the excel file but will be a hidden row.

Add Feedback