Error: Incorrect amounts are imported

Occurs: When importing transactions into QuickBooks the amounts that are imported are incorrect and do not match the amounts that are in the import data file.

Cause:  If you have mapped the rate/cost, quantity and the amount columns then QuickBooks will only consider the rate and the quantity and make its only calculation to the amount this is to avoid potential data corruptions.  Equally if you have mapped the rate column and in your data import file the field is empty then QuickBooks will use the default rate that is set up on the item in QuickBooks to make the calculated amount.  This may lead to discrepancies between what appear in QuickBooks and your import data.

Resolution:  Unmap the amount field or the rate field and allow QuickBooks to retro calculate the corresponding rate or amount. 

Add Feedback