the company I am working with has not reconcile the bank accounts for at least 9 years. They are currently using QuickBooks online and I would like to clean it up. they have been downloading bank info using QuickBooks but things are not matching the bank statements. How can I clean up their files and start clean organized QuickBooks for 2019.
Hey there, @A CCar.
Welcome, and thank you for stopping by the Community for help with reconciling your client's account. Allow me to show you the ropes and get you and your client situated. From what I've read here, you may need to undo some transactions and match others from the banking center. I'll cover that later in my post. First, I'd like to bring your attention to this article here: Reconcile your accounts. This link will take you to one of our support articles that comes with a "how to" video and all of the steps, with pictures, on how to reconcile an account.
Now, because you mentioned things are not matching the bank statements, you may have to match some of the existing bank transactions. When QuickBooks Online downloads transactions from your bank, you can review, categorize, accept, and match transactions to existing ones in your company. Additionally, you can pay existing bills or invoices directly by matching downloaded bank transactions. This may be why QuickBooks isn't matching the bank statements, as you can add transactions without matching to preexisting transactions. For more on how QuickBooks handles bank transactions, see How to add and match downloaded banking transactions.
You may need to undo some of what has been added already through the Online Banking Center. To do this, simply open the banking center and select the In QuickBooks tab. From there, Check off all of the transactions you want to undo. Next, select the Batch Actions drop-down and click Undo. This will put the transactions back into the For Review tab and remove them from the register in the program. This will let you add and match the transactions properly, as well as clear out any duplicates.
Once all of this is said and done, you should be able to reconcile with no issues. Should there be any questions about the information I've provided or anything else QuickBooks, feel free to leave me a comment below and I'll be sure to get back to you.