cancel
Showing results for 
Search instead for 
Did you mean: 
Capricious
Level 1

double entries in my register

I have been using 2017 and have online payroll. When going to reconcile the checks that I write appear twice in the register and are there month to month making it more difficult to reconcile.

Thanks

Solved
Best answer April 21, 2020

Best Answers
Rubielyn_J
QuickBooks Team

double entries in my register

Hi there, @Capricious.

 

I'd be glad to help you correct duplicate transactions when reconciling. You need to remove double entries in your register.

 

Here's how: 

  1. Go to the Banking menu.
  2. Choose Bank Feeds and then Bank Feeds Center.
  3. In the Items Reviewed section, select the account with the transactions you want to remove.
  4. Select Items to Delete.
  5. Choose the transactions you want to delete.

Once done, you can refer to this article on how to match your real-life bank and credit card statements: Reconcile an account in QuickBooks Desktop.

 

Please let me know if there's anything else I can do to help you succeed today. I'm here to help. Have a great day. 

 

 

 

 

View solution in original post

23 Comments 23
Rubielyn_J
QuickBooks Team

double entries in my register

Hi there, @Capricious.

 

I'd be glad to help you correct duplicate transactions when reconciling. You need to remove double entries in your register.

 

Here's how: 

  1. Go to the Banking menu.
  2. Choose Bank Feeds and then Bank Feeds Center.
  3. In the Items Reviewed section, select the account with the transactions you want to remove.
  4. Select Items to Delete.
  5. Choose the transactions you want to delete.

Once done, you can refer to this article on how to match your real-life bank and credit card statements: Reconcile an account in QuickBooks Desktop.

 

Please let me know if there's anything else I can do to help you succeed today. I'm here to help. Have a great day. 

 

 

 

 

Capricious
Level 1

double entries in my register

I dont see an items reviewed section,items recieved ,?

JonpriL
Moderator

double entries in my register

Hello @Capricious,

 

Items Reviewed is a tab you can locate when your bank account is connected to the banking feeds. Since it is not, you'll want to run a quick report of your register and compare each detail of your check. Doing so, you can decide whether you delete them or not.

  1. Go to Banking.
  2. Click Use Register.
  3. Select your bank account.
  4. Click QuickReport.

From here, you can simply open each check in case you needed to delete them.

 

Lastly, here's a few articles you can read for ideas in managing your bank account and transactions: Banking and Bank Feeds for QuickBooks Desktop.

 

Keep me posted in the comments down below if you have any other questions. I'll be happy to help.

Capricious
Level 1

double entries in my register

when going to quick report,I get an error saying need a name.

Also I'm not allowed to delete a lot of entries because of payroll. 

IamjuViel
QuickBooks Team

double entries in my register

Hello, @Capricious.

 

Let's run the Verify and Rebuild Data Utility tool to isolate this error for possible data damage.

 

Rebuild Data:

  1. Go to the File menu.
  2. Choose Utilities, then select Rebuild Data.
  3. Select OK on the QuickBooks Information window.
  4. Follow the prompt to save a backup.
  5. When you see Rebuild has completed, click OK.

Verify Data:

  1. Go to the File menu.
  2. Choose Utilities, then select Verify Data.
  3. If you see QuickBooks detected no problem with your data, click OK. You can continue using the company file.
  4. If Verify finds an issue with your data, you’ll be prompted to Rebuild Now or View Errors.
  5. Select Close.

Once completed, let's restart your computer to ensure that al QuickBooks components are fixed. You can browse these articles for more insights in resolving duplicates in your account:

Don't hesitate to get back to us if you have other questions about managing your downloaded transactions. I'm just a few clicks away.

KateD
Level 1

double entries in my register

This same thing is happening to me.  I'd rather not go in and delete these entries every month when I reconcile.  Why are they happening in the first place? Is there something I can do so they don't happen in the first place?

AileneA
QuickBooks Team

double entries in my register

Hello, KateD. 

 

Let me share some insight about verify rebuild data utility in QuickBooks Desktop. Verify Data self-identifies the most commonly known data issues within a company file while Rebuild Data self-resolves most data integrity issues that the Verify Data finds. 

  

Below are the common reasons to use the Verify and Rebuild features: 

  • Fatal errors when you use QuickBooks Desktop
  • Discrepancies on reports, such as invoices or bills that post with a negative values
  • Deposited payments show up in the Payments to Deposit window
  • Balance sheet reports do not show all accounts
  • Names are missing from lists
  • Transactions are missing
  • Run a well-data checkup to make sure your company file is error free 

To learn more about verify rebuild feature, you can refer to this article: Verify and Rebuild Data in QuickBooks Desktop

 

I have handy articles to help you fixed duplicates in your account: 

Please don't hesitate to reach out to me here again in Community. I'm just a post away. Have a great day, and stay safe!

laalnyc
Level 1

double entries in my register

This isn't at all helpful. I'm having the same issue: first of all, it's with QB Online, not Desktop. Second, why is this happening and how can we stop it??! My workaround has been to write a journal entry cancelling it out; but this is a ridiculous waste of time. 

laalnyc
Level 1

double entries in my register

This isn't solved. Why does it keep happening to me?

JamesDuanT
Moderator

double entries in my register

We appreciate you for clarifying that you're using QuickBooks Online, laalnyc.

 

When you connect your bank account, QuickBooks Online downloads your bank transactions which can be Added, Matched, or Transferred.

 

Duplicate transactions in your register can happen if you did the any of the following scenarios:

  • You have recorded a transaction in QuickBooks Online manually. Then, you also selected Add on the downloaded transaction, instead of Match.
  • QuickBooks Online downloaded two same bank transactions and you selected Add for the both of them. You could have Excluded the other bank transaction.

To remove the duplicates in your register, we'll need to go back to the Banking page and undo the incorrectly added bank transactions. Here's how:

  1. Select Banking/Transaction on the left menu and go to the Banking tab.
  2. Click on the affected bank account and go to the Categorized section.
  3. Look for the duplicate transactions and click Undo.

These transactions will go back to the For Review section. You can exclude them from there. Here's a link for reference: Exclude a bank transaction from your expenses in QuickBooks Online.

 

If you encounter the same issue, I'd recommend contacting our Customer Care Team. They can review the details and provide you additional steps to correct your register.

 

Keep us posted about this so we can check what else we can do to correct your register.

lwccpm
Level 1

double entries in my register

Hi there I am having this issue too. For 3 months now our tax payments are being posted to both of our bank accounts. The payment only comes out of one of them so we have had to fix it with a journal entry every month. It wont let me delete the items as they are tied to payroll taxes. So frustrating and the 3 calls I have made to Quickbooks have offered zero help!!!!

Rebekah1972
Level 2

double entries in my register

I have the same issue.  QBO automatically adds the fee, and it's downloaded as a transaction from the bank feed.  Why do these not trigger the "match" for the transactions?  If we're able to match it wouldn't create such hassle.  

MichelleBh
Moderator

double entries in my register

Thank you for joining us on this thread, @Rebekah1972.

 

When you say "QuickBooks Online automatically adds the fee, and it's downloaded as a transaction from the bank feed", may I know what specific goal you're trying to achieve? Any additional information will help me make sure that I can provide you with the most suitable resolution.

 

You can also visit our Help Articles for your future guide. This page contains a lot of information on how to handle banking feeds. 

 

Please click the Reply button below to leave a comment. I'm looking forward to hearing from you soon.

Rebekah1972
Level 2

double entries in my register

I do not enter these charges, QuickBooks automatically creates these (due to credit card fees) on a daily basis.  When they show up in the clearing the bank, they are downloaded (our bank feed is pulled with QBO).  Thus, duplicate entries.  I will try to upload a screen capture of those tomorrow.  I've already cleared them through Friday. 

Rebekah1972
Level 2

double entries in my register

This is what I see.  Do you see where Quickbooks Payments Fees of $87.38 has "cleared" as in matched from the bank draft to the expense listed by QBO?  Then a few transactions down, it's doubled?  The original expense that was entered by QBO was on 3/16 and when it cleared the bank and the transactions were pulled from our bank, it's there again.  How do I stop the duplicity?  I have to go back in and delete duplicates. 

MichelleBh
Moderator

double entries in my register

Thanks for coming back and for attaching a screenshot, @Rebekah1972.

 

I'll point you to our QuickBooks Online Support since we're unable to review your account here in the Community. This way, they can check the main cause of your QuickBooks Payments fees duplicates. They can also provide troubleshooting steps to stop the duplicity in your account. 

 

Here's how: 

 

  1. Go to the Help menu, then click Contact Us
  2. Type your concern in the box and tap Let's talk
  3. Choose either Get a call or Start a chat
  4. Complete the required data and submit the request.

Please call them within business hours to ensure we cater to your concern immediately.

 

You can also check this article about the fees works in QBO and other related topics. 

 

 

Please leave a message below if you have additional questions about your payment fees or how the call goes. I'm pleased to help you. Be safe. 

fridaynext
Level 1

double entries in my register

What a really crappy answer. Why is QB making double entries in the first place and how do I stop it.  I don't want to know how to remove it, I want to know why it is happening.

 

ShiellaGraceA
QuickBooks Team

double entries in my register

Thanks for joining us here today, @fridaynext.

 

I'll share some information about double entries. As mentioned by my peer @IamjuViel, duplicate entries might be caused by data damage. Thus, part of the troubleshooting steps is by running the Verify and Rebuild Data Utility tool. Please refer to the above steps.

 

You can also visit this link to get different QuickBooks Desktop tools to help fix problems and errors: Fix common problems and errors with the QuickBooks Desktop Tool Hub.

 

Reach out to me again if you still have questions or concerns with your register. I'll be around for you. Take care and have a great day ahead.

tominrichmondva
Level 1

double entries in my register

I'm having the same problem, we migrated from desktop to online, and now I have double entries which makes it impossible to reconcile. I can see the duplicates in the reconciliation screen but they don't appear in the register screen. 

So what's the solution? I can't seem to delete the obvious duplicates.

 

Please help, reconciling the accounts is holding up my tax return.

 

 

TirzahC
QuickBooks Team

double entries in my register

I'm here to ensure you're able to delete duplicate transactions in QuickBooks, @tominrichmondva.

 

If the duplicate transactions appear on the For Review tab in the Banking page, then you'll have to Exclude the transactions from there.

 

Here's how you can do it:

  1. Click the Banking or Transactions menu.
  2. Choose the Banking tab.
  3. Go to the For Review tab.
  4. Select all duplicate transactions.
  5. Click Batch actions, then select Exclude Selected.
  6. Go to the Excluded tab.
  7. Mark excluded transactions.
  8. Click Batch actions, then click Delete

If they are matched already, we'll have to go to the Categorize section. From there, undo the transaction and exclude them again. Then, delete the excluded transactions in the Excluded section.

 

On the other hand, instead of excluding your previous transactions in the bank register, you can manually delete them to remove the old transactions in the bank register. Here's how:

  1. Go to Accounting on the left panel.
  2. Within the Chart of Account tab, select the account.
  3. Click the Funnel icon and set the date you want.
  4. Click on the transaction you want to delete.
  5. Hit Delete. Then, Yes to confirm.

You can read through these articles to learn more about managing your bank transactions:

I'd like to know how you get on after trying the steps, as I want to ensure this is resolved for you. Just leave a comment below and I'll get back to you. You have a good one.​​​​​​​

Bella44
Level 1

double entries in my register

Hello,

 

I'd like to add that I've tried the steps you recommended and it did not work.  If you delete the duplicated entry, QBO automatically deletes it twice as well throwing off the balance and not allowing you to reconcile the bank transactions.  

 

Please provide another resolution!  I am trying to close-out 2022 and this is holding me up in 2 separate bank accounts.  

 

Thank you

Kurt_M
QuickBooks Team

double entries in my register

Thanks for joining the thread, @Bella44. Let's work this out so you can reconcile your account and close out your books in QuickBooks Online (QBO).

 

Before we dig deeper into this, may I ask what transaction you're trying to take care of or handle? Are you trying to delete or remove a transferred transaction from your reconciliation? If so, please know when transferring a bank transaction to a different bank. You'll only want to reconcile the account where it originated. Doing this ensures QuickBooks will not recognize those transactions as duplicates in your account.

 

Additionally, I recommend checking this helpful article in case you encounter issues after reconciling bank accounts in QBO: Fix issues at the end of a reconciliation in QuickBooks Online.

 

You can also visit this page to learn more closing books: Close your books in QuickBooks Online.

 

Our door is open 24/7 if you need further assistance managing duplicate transactions in QuickBooks, @Bella44. You can also mention me in the comment section below if you have any additional questions related to QuickBooks. I'll be more than happy to help you out again. Stay safe!

Blessed Bookkeeping
Level 1

double entries in my register

You would need to check your payroll settings ! Settings> payroll settings > go to the main bottom to accounting preferences and see where that specific payroll tax is being mapped to in your chart of accounts ! Hit the pen and edit info ! It could be that it was being mapped to that bank at one time and the only way to remove it from the wrong bank to correct is did a Journal Entry but moving forward if that is mapped correctly it will only come out of that specific account and of course your payroll tax chart of account ! Hope this helps !

Need to get in touch?

Contact us