Question

QBs Online re-importing deleted transactions

Forum|Forum|4 years ago
November 9, 2021
1 reply
0 views

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?

M

MirriamM

I appreciate you reaching out and providing detailed information about your concern, sewellman78.

There may be hidden transactions from your CSV file, that's why it is importing deleted transactions. Thus, I recommend double-checking the file before importing it into your QuickBooks Online (QBO) account. And if you upload the transactions again without deleting the old ones, that will cause duplicates within that account. To avoid this, you'll need to delete the transactions, then upload them again.

Once the file is verified, you are now ready to upload your transactions. If you encounter some errors when uploading bank and credit card transactions, here's a guide on what to do: Fix bank upload errors in QuickBooks Online.

Once bank transactions are downloaded, you can now start categorizing or matching them to straighten out your books. After that, you have the option to do your regular bank reconciliation.

I'd appreciate it if you'd update me on how the steps work. If you have any follow-up questions, do let me know. I'm here to help.

J

JRag2021

Here is the notice I get when I delete the duplicate transactions. Additionally, my bank register calls these "Automatically added with rule", however all rules have been removed. Also, all of these transactions have been excluded and deleted from the excluded list.

AlexV

Hello JRag2021!

Nobody wants to duplicate their transactions since it can cause issues and discrepancies. I'm here to help you in fixing these transactions.

The transactions will always have an indicator that they were added with a rule even if the rule itself was deleted already. This is the reason why you can see an Automatically added with a rule on it.

With regard to the duplicate transactions, it'd be best if you can comment below the bank's name. That way, we can check if there's an investigation about it. In the meantime, I suggest you exclude them.

In addition, if you linked the bank account to QuickBooks Online, check with your bank if they are having system issues or maintenance. This can cause connection errors and duplicate entries.

I added these links to know what to do with the downloaded transactions and how to balance your books:

Leave a comment again here if you need more assistance with banking. Take care!

Sign up

Login with SSO

Login to the community

Login with SSO