Every account and transaction inside of a web connect file has a unique identifier. When transactions are added or matched to the register, QuickBooks stores the ID numbers for these transactions. It will not allow you to import transactions with the same ID more than once to prevent duplicate entries. Transactions with duplicate IDs are ignored and QuickBooks for Mac will display the following error message:
Error: Nothing imported. Account up to date.
Intuit recommends three solutions for this problem. The first solution may solve your problem, or you may need to try all to resolve the issue. For best results, perform the solutions in the order shown.
Solution 1: Restore a backup
You can Restore a backup you created before you imported the web connect file containing the missing transactions. When done, you can import the web connect file again.
Solution 2: Manually enter the transactions
If there are only few transactions for the period, you can just enter them manually in your bank or credit card register.
Solution 3: Edit the QuickBooks Web Connect (.qbo) file
Editing the account ID in the QBO file allows you to import transactions from a web connect file already imported before. The purpose of the account ID is to make sure you don't import duplicate entries. This should only be a one-time event in case a downloaded transaction has been deleted.
Important: To avoid importing duplicate transactions, follow these steps with caution.
- From the Company menu, select Chart of Accounts.
- While holding down the Control key, select the bank or credit card account you want to import the .qbo file into.
- Choose Edit Account then select the Online Settings button.
- From the Download transactions drop-down, choose Not enabled.
- Download a new QuickBooks web connect file from your bank using only the dates you need. Don't go back further to avoid manually matching transactions.
- Open the QBO file in a text editor like TextEdit.
- Scroll down until you see ACCTID and locate your account or credit card number.
- Delete the last digit of your account number then save your changes and close the text editor.
- Import your QuickBooks web connect file and select the correct account.
The next time you try to import a web connect file, you need to repeat steps a through d. You don't have to delete any of the digits from the ACCTID anymore.