Why do debit transactions show up twice in register?

SChappell · ‎February 28, 2021

I have QuickBooks desktop pro 2019. I downloaded transactions from my bank. Thought I was working with 1 transaction and did not realize there were 267 items checked. I added info clicked the add/approval and it added all 266 items that I was NOT trying to add. Now there are duplicate debits in my register of 266 items and shows my register as overdrawn by over $31,000.00 I tried to do the UNDO but nothing changed. I don't know why this happened or how to fix it except by going in and deleting each item individually, one item has a check mark, the duplicate has a lightning bolt.

Please help, this is the second time this has happened and I had to open a previously backed up file and reconcile 10 moinths of statements. I don't want to have to do this again if I don't have to. I feel really stupid and stressed.

Thank you for any help with this!!

ReyJohn_D · ‎February 28, 2021

I can help get rid of those duplicate transactions in the register, @SChappell.

You'll need to delete those duplicates one at a time to correct the register balance. After that, you can manually import the said entries. This way, you can match them later on and eliminate the duplicates.

To delete your entries:

Go to the Lists menu, and then choose Chart of Accounts.
Select the bank account associated with the duplicates.
Look for the duplicates, and then right-click on them.
Click the Delete option, and then OK.

To import your transactions:

From the Banking menu, select Bank Feeds.
Choose Import Web Connect Files.
Select the .QBO file you saved, then click Open.
When prompted to Select Bank Account, choose Use an existing QuickBooks account.
Click Continue, and then OK.

Afterward, you're now ready to match your entries to prevent duplicates. Also, make sure to back up your company files every after reconciliation. This way, you can restore them in case of any accidental data loss or corruption.

To ensure your books are well accounted for, you'll want to reconcile them in QuickBooks.

I'm still willing to assist you with other banking concerns you might encounter in the future. Assistance is a comment away.

View solution in original post

ReyJohn_D · ‎February 28, 2021

I can help get rid of those duplicate transactions in the register, @SChappell.

You'll need to delete those duplicates one at a time to correct the register balance. After that, you can manually import the said entries. This way, you can match them later on and eliminate the duplicates.

To delete your entries:

Go to the Lists menu, and then choose Chart of Accounts.
Select the bank account associated with the duplicates.
Look for the duplicates, and then right-click on them.
Click the Delete option, and then OK.

To import your transactions:

From the Banking menu, select Bank Feeds.
Choose Import Web Connect Files.
Select the .QBO file you saved, then click Open.
When prompted to Select Bank Account, choose Use an existing QuickBooks account.
Click Continue, and then OK.

Afterward, you're now ready to match your entries to prevent duplicates. Also, make sure to back up your company files every after reconciliation. This way, you can restore them in case of any accidental data loss or corruption.

To ensure your books are well accounted for, you'll want to reconcile them in QuickBooks.

I'm still willing to assist you with other banking concerns you might encounter in the future. Assistance is a comment away.

SChappell · ‎February 28, 2021

ReyJohn_D

Thank you, I figured I would have to do them one by one. I appreciate your help, will try this and may have more questions.

Thank you again

Steph

Topics

Training

Community

Resources

Why do debit transactions show up twice in register?