duplicate deposits

Thank you for your prompt response!

I did want to void them, but the deposits don't have a void option, just delete.

Thanks again!

One more question - Can I clear the voided entries that show in my reconciliation report so they don't show anymore?

thank you!

I appreciate you for getting back to us, Michelle0531.

I'm here to share more information about voiding transactions.

Certain transactions can't be voided. One of them is the Deposit. That said, I'd suggest reaching out to your accountant so they can guide you on the best action to take for the deposit.

As for clearing a voided transactions, yes, it's possible. Keep in mind that even small changes can unbalance your accounts. To minimize the impact, you can only unreconcile one transaction at a time. If you need to completely start over, reach out to your accountant. Only accountants can undo entire reconciliations.

I've added these references for more information:

• Undo or remove transactions from reconciliations
•  Void or delete transactions in QuickBooks Online

Keep me posted whenever help is needed.

Hello!  I'm not looking to undo a reconciliation.  I just want to clear the zero and voided transactions so they don't print on every reconciliation report.  I am so used to Quickbooks Desktop that I seem to have a lot of questions with Quickbooks Online.

Thanks for help!

I understand that you want to remove transactions with zero amounts when printing the reconciliation report, Michelle0531.

Other reports let you customize reports to remove or hide transactions with zero amounts, but not the Reconciliation report. Also, this report is one of the few reports that can't be directly exported to Excel.

To remove transactions with zero amounts, you can manually export the data on your Reconciliation report. I'm adding the following steps below as your guide.

1. Highlight the information on the report.
2. Right-click and copy the information.
3. Open Excel and right-click and paste the information.
4. Adjust the column widths for the format of the Excel report to show all the information.
5. Make some edits by removing columns with zero amounts.
6. Click Save.

There are several things you can do after reconciling bank accounts in QuickBooks. These articles will help ensure transactions from the real-bank match with what's in QuickBooks.

• How to view details for missing reconciliation reports or reconciled transactions
• Enter an adjusting entry for reconciliation in QuickBooks Online

Get back to me whenever you have an additional question. I'll be right here to help you.

Hello @jeniferloras,

It's nice to see that @MaryLandT was able to help you remove transactions with zero amounts when printing the reconciliation report. 

You can always turn to the Community family for support if you have questions concerning reconciliation reports. Enjoy your amazing day!

When I deleted the duplicate deposits, it messed up my beginning balance for my next reconciliation.  Now what do I do?

Thank you!!  

Hello there, @Michelle0531.

I appreciate you for getting back to us. I'd like to provide some clarifications and point you in the right direction to help you resolve this opening balance issue.

Check your bank statement to see if the deleted deposits are verified duplicates. If so, they shouldn't have affected the beginning balance. Make sure all the transactions in your bank statement match the QuickBooks Online records.

Also, if changes are applied to an already reconciled transaction. This changes the ending balance of your last reconciliation, which impacts the beginning balance of the next one.

To fix this, you'll need to undo the reconciliation. After that, go to your bank register and remove the R status of your transactions to zero out the amount.

Here's how:

1. Go to the Accounting menu.
2. Select Chart of Accounts.
3. Find the account holding the transaction. Then select View register. 
4. Select the transaction you want to unreconciled to expand the view.
5. Review the check column. If the transaction is reconciled, you’ll see an “R.” 
6. Select the checkbox. This changes the letter in the box. Keep selecting it until the box is blank. This removes the transaction from the reconciliation.
7. Select Save.
8. Close the account register.

For more details about this process, please see this link: Learn how to unreconciled an individual transaction from a completed reconciliation.

I recommend consulting with your accountant to ensure your records are in ship shape.

You can visit this article which talks about fixing issues for accounts you've reconciled in the past in QuickBooks Online: Learn what to review so you can start reconciling.

The Community always welcomes you for further inquiries about your transactions. Have a great day ahead!

@JamesAndrewM  Some are duplicates and some are errors.  Now it says "not ready to reconcile" The beginning balance is off and the amount is exactly the amount I changed, though they had NOT been reconciled. I was just cleaning up errors from past bookkeepers.  I tried putting them back in and it still says it's off that amount.  Any help would be greatly appreciated!

I have a client I took over from another bookkeeper and they have many duplicate deposits from last year.  Taxes are already done so I do not want to change anything from 2022.  How can I remove the duplicate deposits from last year to not show up on the reconciliation report for this year and correct the QBO balance to the Bank balance?  The client uses Square payments and bank feed so somehow they are duplicating the deposit.  Please HELP!!

I can see that you've done everything to fix these duplicate transactions from Square and Bank feeds, @Jess. I've got the steps to ensure we dissolve them from your records.

You're right about payments recorded within Square are brought over to QuickBooks. Since your client's bank is synced, this creates duplicate transactions. You'll want to consider linking one of them to avoid this from happening again.

One possible reason why there are duplicates is that the imported deposits from Square are added instead of matching them to entries that are already in QuickBooks. To fix this, follow the steps below:

1. Go to the Banking or Transactions menu and select Banking.
2. Locate the tile for Square and proceed to the Categorized tab.
3. Find the Square transactions and click Undo.
4. In the For review tab, locate the Square transactions and tick the Find match button. 
5. On the Match transactions page, search the duplicate and check it, then tap Save.

If you need to remove these transactions, we can Exclude them by ticking the corresponding boxes from the For review tab.

If these duplicates are in the register, we can manually delete them. By doing so, it will avoid doubling the income. I'll show you how:

1. Go to the Accounting menu and select Chart of Accounts. 
2. Find the bank account and then click View Register.
3. Locate the transactions, then hit Delete.

See this article to learn more about managing Square account and handling sales transactions: Connect your Square account to QuickBooks Online.

Once done, check this guide to compare transactions from your bank statement with the ones entered into QuickBooks: Reconcile an account.

Feel free to place a comment below for additional questions about customer payments and bank deposits. It's my pleasure to help. Be well.

Thanks for the info @JamaicaA .  I got the duplicates fixed for this year but my client has already filed taxes for 2022 so I do not want to delete the duplicate deposits from 2022.  This will change the 2022 books.  I need to reverse these transactions using a general journal entry then do a off-cycle reconciliation.  Is it better to create a dummy account or reverse against original category it was for?  The sales are connected to Inventory so I do not want to mess that up either.  Also my client has already reconciled Jan, Feb and March.  Can I still do an Off-cycle bank reconciliation for 1/1/23 if the first 3 months are already complete or do I need to do one for the end of March?  Thanks for the help!!

 @JamaicaA  If the uncleared deposits do not affect the P&L report then I am happy with the steps you gave to me to fix it.  I know the problem just wanted to make sure I did not affect what the tax accountant had already done for last year.