How to avoid importing duplicated transactions in Quickbooks

The best way to avoid duplicates is to work in the date ranges. If you are converting the full list of transactions for a specific date range, then delete existing transactions for the date range.

If you are importing IIF files, there is no way to avoid duplicates for existing transactions and transactions that are being imported.

If you are importing QBO files, the format allows using "Unique Transaction ID" (FITID) that QuickBooks keeps track of for a specific account. If your bank provides these transaction IDs, then you can use them. Make sure they are truly unique, not just per file unique.

There is one issue with this: when you are converting your transactions, you may convert the same transactions several times, but Quickbooks keeps track of already imported transactions even if you delete them. 

CSV2QBO or PDF2QBO (or another *2QBO converter) generate unique transaction IDs to make sure when you import a QBO file, QuickBooks does not skip any transactions.

Still need help? Contact Us Contact Us