Importing Amounts (instead of per unit prices) using Transaction Pro Importer for QuickBooks

Updated on December 10. 2012 to include revised command line for Transaction Pro Importer 5.0.

If your quantities and/or per unit prices exceed the five decimal place limit on QuickBooks transactions often times the extended amount (quantity times price) might not be round correctly by QuickBooks. So to get around these rounding issues you can enable the -USE_AMOUNT command line parameter. What this parameter will do is to replace the QuickBooks field, price, with the QuickBooks field, amount.

Instructions on how to enable the -USE_AMOUNT command line parameter (for TPI 5.0 the command line is /USE_AMOUNT but all other instructions remain the same)

Make a copy of the Transaction Pro Importer 4.0 shortcut by right mouse clicking on the shortcut and select copy. Then put your cursor on your desktop and right mouse click and select paste shortcut.

On the new shortcut for Transaction Pro Importer 4.0 that you just created right mouse click on the icon and select properties

On the shortcut tab at the end of the target box leave a space after the ending quotation and type in -USE_AMOUNT and then select the OK button.

Then you will use this new shortcut to launch Transaction Pro Importer 4.0

After adding the -USE_AMOUNT command line parameter you will notice that the QuickBooks field, Price, has been replaced by the QuickBooks field, Amount. So what you will need to do is map the two QuickBooks fields, Quantity and Amount. Then the per item price will be a calculated amount.

You can download a free demo of Transaction Pro Importer 4.0 to test this out here.