Skip to main content
March 3, 2024
Question

bank register

  • March 3, 2024
  • 1 reply
  • 0 views

Can I reconcile the bank account more than once?  I just started with a company and he reconciled, then we had a matching issue and he changed "c" to "R" but i think there was a lot of "junk" and now the books are bad.  I'm identifying duplicate manually added items and deleting them, rematching invoices from customers and trying to get the books in line.  I'm also noticing some payments are duplicated, I'll see same amount and date, type one one is Bill payment the other will say check.  Seems I"d like to see expenses in Payment side of register and some accounts payable offsets?   I know Uncategorized needs correcting. 

 

any suggestions?

Sharon  

 

 

1 reply

March 3, 2024

I understand that you want to keep your reconciliation accurate, Sharon132. No worries, I'm here to help you get this fixed. 

 

Yes, we can reconcile bank accounts for a specific period more than once. If you need to correct your previous reconciliation, we can undo your reconciled transactions and then reconcile them again.

 

However, if you need to change your reconciled transactions status, simply toggle them again in the register. You can check this article in undoing or changing your reconciled transaction status: How to unreconcile an individual transaction from a completed reconciliation.

 

Also, one potential cause for seeing duplicate transactions is that there are manually entered transactions in QuickBooks. Then, those same transactions were later downloaded and added again to the Banking page instead of being correctly matched to the existing entries.

 

To fix this, we can match them to your similar recorded transactions or exclude them if they're duplicates.

 

Here's how to exclude:

 

  1. Go to Transactions, then select Bank transactions
  2. Select the For Review tab.
  3. Select the checkbox of the transactions to exclude.
  4. Select Exclude.

 

If these transactions are already categorized, make sure to undo them first before excluding them. Just select the Categorized tab and check the box for the transaction, then click Undo.

 

Furthermore, you can check this article on what to do if you have issues when you manually upload bank transactions: Fix bank upload errors in QuickBooks Online.

 

Don't hesitate to reply if you need further assistance with reconciliation. I'll be delighted to work with you again.