SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends June 27

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
kardele77
Level 1

Bank Checking account reconciliation...$0 difference but I still have white/unchecked lines...what do I do?

First time reconciling.  I see a grayed/checked IRS line and a same $ amount white/unchecked line under it.  Did I manually add something in error that I need to delete?
2 Comments 2
KimAnnVA
Level 5

Bank Checking account reconciliation...$0 difference but I still have white/unchecked lines...what do I do?

If I understand you correctly, during your reconciliation, you reconciled with all the transactions that are highlighted and checked but you have transactions still remaining that are unchecked.  

 

One could be that it is a transaction has not cleared your bank account.

Two could be a mis keyed transaction that needs to be removed.

Three could be a duplicate transaction.

 

If it has not cleared it is ok to leave for next month reconciliation.  

 

For miskeyed or duplicate transactions, go into the transaction itself and take a look at it, if it has no bank feed match, check the bottom bar and under "More" > "Audit History", here you can get more information about the transaction and figure out if it needs to be removed or not.   Use your actual bank statement to review further information on transactions. Duplicate transactions are a little tricky because if you delete the bank feed one it will go back into the bank feed you will need to exclude it or see if it will match to the one in the bank register.  You must go in and out of your reconciliation process to bank feed and get everything matched before finishing reconciliation. 

 

 

 

MarkAngeloG
QuickBooks Team

Bank Checking account reconciliation...$0 difference but I still have white/unchecked lines...what do I do?

Hi there, @kardele77.

 

It sounds like during your first reconciliation, you may have manually added a duplicate transaction, which is why you're seeing a $0 difference but still have uncategorized lines. To ensure your reconciliation is accurate, follow these steps:

 

  1. Navigate to the Accounting menu on the left-hand side and select Reconcile.
  2. Choose the account you're reconciling and the statement period.
  3. Look for the grayed (checked) line, which indicates a cleared item, and compare it with the white (unchecked) line below it.
  4. Verify if both entries have the same amount and details.

 

If you suspect a transaction has been added manually, you can review your recent transactions:

 

  1. Go to the Register for the account in question by selecting Accounting, Chart of Accounts, and then your checking account.
  2. Review recent transactions to see if there are any duplicates or manually entered items that match the amount and details of the checked transaction.
  • Delete the Duplicate Transaction:
    1. If you find a duplicate transaction, click on the white (unchecked) transaction to open it.
    2. Click on the More button at the bottom and select Delete to remove the duplicate entry.

 

By following these steps, you can identify and correct any manually added duplicate transactions, ensuring your reconciliation is accurate. Regular reviews and ensuring transactions are not duplicated will help maintain precise financial records.

 

When you're ready to close out the year, you may need to consider closing your books to prevent unwanted changes.

 

You can always leave a reply if you have additional concerns in dealing with duplicate transactions. You're doing an excellent job managing your accounts, and we're here to support you every step of the way!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us