Bank Reconciliation

Dansigwa · ‎August 18, 2020

I'm trying to clean my Bank Register of Duplicate Deposits and Payments and Erroneous Deposits and Payments but I'm stuck. I have tried to figure out exactly how to reach this position but it's been a challenge;

Go to the QuickBooks homepage and click on the record icon to open the "make deposit" screen.
If the payment to deposit screen appears instead, click on cancel to close it and proceed

I DON'T KNOW WHICH IS THE RECORD ICON!

Go to your QuickBooks and click on your company file then select Open.
Once opened, click on the "banking" menu and choose "to deposit" from the options.
Click to choose the line that contains the duplicate payment and click edit.
When you click on edit, proceed to choose the "delete line" from the drop-down options.

THESE DUPLICATE PAYMENTS AREN'T APPEARING IN THIS SECTION OF QBO BUT RATHER THEY ARE IN THE CHECK REGISTER SECTION PROCEEDING FROM THE CHART OF ACCOUNTS. NOW IS IT OKAY TO DELETE DIRECTLY FROM THE CHECK REGISTER RATHER THAN FROM THE BANKING MENU?

ChristieAnn · ‎August 18, 2020

Hi there, Dansigwa.

The steps you provided are for QuickBooks Desktop version and that's the reason you can't see the record icon and those duplicate entries.

Yes, it's OK to delete directly the duplicate transactions from the check register page. I attached a screenshot below for visual reference.

Also, one of the reasons there are duplicate entries in your QuickBooks could be the transactions are added instead of matching or excluding them in the For Review section. If so, you can undo the added or the matched Deposits and Payments. This way, the transactions will be removed from your QuickBooks register and put back to the For Review tab of the Banking page.

Here's how:

Select Banking on the left menu and go to the Banking tab.
Highlight the connected bank account and go to the Reviewed section.
Click Undo on the transactions you to put back to the For Reviewed section.

You can browse this link for more information: Unmatch or move bank transactions after reviewing them.

Please check this article to see information on how you can split transactions and how to troubleshoot bank entries: Categorize and match online bank transactions in QuickBooks Online.

Please know that you're always welcome to post if you have any other concerns. Wishing you and your business continued success.

View solution in original post

ChristieAnn · ‎August 18, 2020

Hi there, Dansigwa.

The steps you provided are for QuickBooks Desktop version and that's the reason you can't see the record icon and those duplicate entries.

Yes, it's OK to delete directly the duplicate transactions from the check register page. I attached a screenshot below for visual reference.

Also, one of the reasons there are duplicate entries in your QuickBooks could be the transactions are added instead of matching or excluding them in the For Review section. If so, you can undo the added or the matched Deposits and Payments. This way, the transactions will be removed from your QuickBooks register and put back to the For Review tab of the Banking page.

Here's how:

Select Banking on the left menu and go to the Banking tab.
Highlight the connected bank account and go to the Reviewed section.
Click Undo on the transactions you to put back to the For Reviewed section.

You can browse this link for more information: Unmatch or move bank transactions after reviewing them.

Please check this article to see information on how you can split transactions and how to troubleshoot bank entries: Categorize and match online bank transactions in QuickBooks Online.

Please know that you're always welcome to post if you have any other concerns. Wishing you and your business continued success.

Dansigwa · ‎August 24, 2020

What if the Transaction appears in the Bank Register as a Check which is Unreconciled, also in the Reconciliation page as Unreconciled yet it is not in the Banking Feed under Reviewed Transactions?

Nick_M · ‎August 24, 2020

Hi Dansigwa.

Thanks for stopping by this afternoon, I'm happy to help. If you have transactions that are still unreconciled, I would first reconcile them, below, I'm attaching a helpful article that shows the reconcile workflow so you can keep your QuickBooks accounts accurate.

Go to Settings ⚙ and select Chart of Accounts.
Select New.
Follow the steps to create a new account. Give the account a name, an account type, and a detail type.
Choose when you want to start tracking the money from the ▼ dropdown. Or learn more about opening balances:
- Select Today if the account you're tracking is brand new as of today. In the Account Balance field, enter the balance in the account as of today.
- - If you started the account on another date, select Other. In the Select a date field, enter the date you want to start tracking money in the account in QuickBooks. In the Account Balance field, enter the balance of the account for the date you choose.
- When you're done, select Save and Close.

5.You can now add new transactions following your opening balance as of date.

If you have any other questions in the meantime, feel free to post down below at anytime. Thank you and have a nice Monday.

Dansigwa · ‎August 25, 2020

Nope, I don't need to create another account! I already have a Checking Account where the Transactions are posted it's only that they are Duplicates and errors which are in the Checking Register but not in the Bank Feed hence I can not Undo to remove them and take them to the For Review Section before finally disallowing them. The Bank Reconciliation has already been previously done by someone else. Only that they left many Erroneous Checks and Deposits in the Register which I need to clear.

MarsStephanieL · ‎August 26, 2020

There's no need for you to create a new account, @Dansigwa.

If those transactions weren't reconciled yet, you can go to your bank register and manually clear the transactions from there. If the transactions are already reconciled, you may need to undo it before you proceed with deleting the duplicate.

Here's how to manually clear bank transactions in QuickBooks:

Navigate to the Gear icon, then select Chart of Accounts.
Locate the account of the transaction.
Click View Register from the Action column.
Identify the transaction to clear.
Under the reconcile Status column, select C for Cleared. You can also manually reconcile by selecting R or you can leave it as blank if they aren't cleared or reconciled.
Select Save.

To completely delete the duplicate transactions, please refer to the steps below:

Go to the Settings or Gear icon, then select Chart of Accounts.
Click View Register from the Action column.
Select the Cleared (C) transaction.
Select Delete and choose Yes to confirm the action.

I'd also recommend asking for professional advice from your accountant about this.

You can also check out this article for more reconciliation reference: Learn the reconcile workflow in QuickBooks.

Let me know in the comment section below if you need further assistance or questions. I'm here to help you. Take care.

Topics

Training

Community

Resources

Bank Reconciliation