Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
A new client has asked me to help clean up their books (QBO) When she moved to online she or a bookkeeper connected the bank account and also created a new bank account, but they are the same account. Now there are duplicate entries for the past year and to date. What is the easiest and fastest way to clean this up? Intuit really needs to give us a batch option to do this. Clients just don't understand the bank feed section....ugh!
Let me help you clean your client's bank account, SCampbell3.
You'll have to undo or unmatch the transactions. This way, it will no longer create any duplicate entries.
Feel free to follow these steps:
They will be transferred to the For Review tab. We'll have to exclude them again by selecting the transactions, then clicking Exclude.
Once done, they will be transferred to the Excluded tab. From there, you can delete the transactions.
I'll add this article to better guide you: Unmatch downloaded bank transactions or move them to another account.
If you need something else, don't hesitate to leave a comment below. We'll reply as soon as we can. Take care!
I would just do a Journal Entry.
Thanks...but would excluding them remove them for the ledger?
Thanks....that is what I am leaning towards.....I can't believe the "bookkeeper" says she has 20 years experience and would duplicate the same checking account...ugh!!!
I think our account was set up incorrectly, prior to me arriving, is there someone who can assist me getting it straightened out? I spoke to someone in the QB Priority Circle, but I feel like he did his best, but didn't figure out exactly what is going on?! Multiple bank accounts linked together, that don't have anything to do with the accounts in question.
Any advice will be fantastic!!
You've come to the right place for help, @AmyK2775.
I'll ensure your bank accounts are set up correctly in QuickBooks Online.
I recommend undoing the bank transactions to ensure that the accounts are correctly linked. Then, double-check that it's linked to the correct account assigned through Banking. If this is not the case, you can disconnect the bank account.
Here's how:
After that, you can reconnect the appropriate bank account.
You'll also want to make sure that you only add transactions that aren't already in QuickBooks, and that you match any current transactions in QuickBooks. For your guidance, take a look at this article: Categorize and match online bank transactions in QuickBooks Online.
I'm also adding this article setting up subaccounts in your online banking: About bank or credit card subaccount setup.
Keep us updated by replying back to this thread. We are more than happy to help. Take care always!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here