Good day - I have several clients who have moved from QBs desktop to QBs Online. Several of these clients started using the bank account link feature with their QB bank account to allow them to upload all of their transactions direct from their banks. Additionally, these clients have set Rules so that certain vendors automatically are assigned a specific expense account. All pretty normal stuff.
What I have found is, if I use a CSV file to upload new transactions and/or transactions that are missing in QBs for whatever reason, Quickbooks at the same time, will import several past transactions that had been deleted. Here are the common parameters I'm experiencing with each:
1. I'm uploading new transactions using a CSV file through the Banking Home / upload CSV file feature. "New" as in, not in Quickbooks currently.
2. After I run through the upload CSV file process, I am locating the uploaded transactions and selecting "add" the transactions through the related account in the Banking home.
3. All of these problematic transactions which had been previously deleted AND which are now importing with my new transactions, were NOT included in my CSV file. The deleted transactions that are importing have no relationship with the transactions in my CSV file.
4. I have gone through the process of selecting and "excluding" all transactions which did not belong AND then deleting all of these "excluded" transactions in the Banking home.
5. This problem is not unique to a single QBs file. It is happening with every client file that uses the bank link feature for their cash or credit card accounts for which I try to upload a CSV file.
The only work around I have found, so far, is:
1. Sever the link with the linked bank,
2. Delete all of the excluded transactions (if not done already) and
3. Remove ALL of the rules that the client has setup for their bank imports.
Only after I have done all of this can I upload any new CSV files without having these deleted transactions importing back in again. I've spent a lot of time deleting these old duplicate transactions just to see them added back before figuring out this work around. I do realize I could enter an adjusting entry for every one of these transactions or even a summary adj entry for each week, month, etc; so that Quickbooks recognizes the transaction already exist and doesn't try to re-import them; but with the volume of transactions I have duplicating, it starts to get really messy.
Is there something I'm missing with Quickbooks Online that is causing this reoccurring problem? Is there some kind of glitch in the software I'm not aware of?
