Was this page helpful?
Thank you!

Comments or suggestions?



Enter Email Address (optional)
email

Handle duplicates in your import file

When you import a data file, QuickBooks detects whether a record already exists that matches a record you're trying to import. When a duplicate record is detected, QuickBooks offers you three options.

Keep existing data and discard import data

Imported data will be ignored and the existing QuickBooks record will be kept.

Replace existing data with import data, ignoring blank fields.

Replace existing QuickBooks data with new import data. If there are blank fields in the import data, they won't overwrite existing QuickBooks data.

Replace existing data with import data, including blank fields.

Replace existing QuickBooks data with new import data. If there are blank fields in the import data, they will overwrite existing QuickBooks data.
  • Click Apply to apply the preference to the current record.

    or

  • Click Apply to All to apply the preference to all records.

KB ID# H_EXCEL_HANDLE_DUPLICATES
12/7/2016 2:11:56 PM
PPRDQSSWS406 9138 Pro 2017 0397ea