Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowOur QBO payroll was linked to the wrong account (on the chart). There is no way to reassign the account number on the transactions to show the payments (employee and taxes) on the correct account. QBO Support advised the only solution was to do journal entries to remove them from the erroneous account and add into the correct one, which I have done as a bulk JE (it is several years of payroll). However, I do not know how to reconcile the bank statement now, as the downloaded transactions do not have anything to match to. If I "add" the transactions the payroll expenses will be overstated as they were already properly recorded by QBO (only the transaction from Direct Deposit payable to the bank is incorrect). Older transactions are not available for matching as "sync" was not enabled (hence why the error wasn't caught sooner) :-(
Solved! Go to Solution.
I appreciate your quick response, @dLearned.
Deleting transactions from the Excluded tab permanently removes it. The Excluded tab serves as the trash bin of your deleted download bank transactions.
Deleted transactions from the For review tab will go to the Excluded tab. There, you can select the transaction you've deleted and select Undo. This will make the transaction appear again in your For review tab and decide what to do with it again.
You can also see this article for more details about excluding bank transactions in QuickBooks Online (QBO): Exclude a bank transaction you downloaded into QuickBooks Online.
When everything is all in place, you can confidently reconcile your accounts. For guidance, feel free to check out this resource: Reconcile an account in QuickBooks Online.
Our door is always open if you need more help matching your accounts. You can also share with me if you have other QuickBooks concerns. I'm always around to back you up. Keep safe!
Hello, dLearned.
I appreciate your time in providing all the details about your situation.
You did the right steps in correcting your payroll payments. Since the journal entry is recorded in bulk, we're unable to match it to the downloaded transactions.
Instead, you can exclude the transactions from the Banking page and manually clear the ones you recorded in the register.
To exclude, here's how:
Here's a sample screenshot for a visual reference:
After excluding these transactions, you can delete them in the Excluded section.
Then, clear the journal entry by following these steps:
Once done, you start reconciling your bank account. You can watch the video tutorial in this article: Reconcile an account in QuickBooks Online.
Please let me know if you have any additional questions or other concerns. Simply click the Reply button below and I'll get back to you as soon as I can. Have a good day ahead.
Thank you for your prompt reply.
That makes sense. One question, when you say to delete them from the excluded tab, does that delete the transaction totally or just from the banking display? I'd hate to lose the actual transaction detail
I appreciate your quick response, @dLearned.
Deleting transactions from the Excluded tab permanently removes it. The Excluded tab serves as the trash bin of your deleted download bank transactions.
Deleted transactions from the For review tab will go to the Excluded tab. There, you can select the transaction you've deleted and select Undo. This will make the transaction appear again in your For review tab and decide what to do with it again.
You can also see this article for more details about excluding bank transactions in QuickBooks Online (QBO): Exclude a bank transaction you downloaded into QuickBooks Online.
When everything is all in place, you can confidently reconcile your accounts. For guidance, feel free to check out this resource: Reconcile an account in QuickBooks Online.
Our door is always open if you need more help matching your accounts. You can also share with me if you have other QuickBooks concerns. I'm always around to back you up. Keep safe!
I have the exact same issue, but have not yet made any corrections. There is about one year worth of paychecks being counted twice. Instead of a one bulk JE, is it preferable to make an individual JE for each paycheck? (There aren't that many.) The bank feed account has been reconciled every month so I'm fearful to exclude those transactions now.
Hey there, @csdouble.
Thanks for joining in on this thread. Allow me to give you some insight into your problem with reconciled accounts and excluding transactions.
If you'd like to exclude these transactions, the best route would be to get a QBOA user to undo your reconciles from each month. From there, you'll be able to exclude the transactions and then re-reconcile the account. Here's a few articles to help you out:
Before doing these actions, I recommend consulting with your accountant to be sure this would be right for your business. I hope this helps answer your question. Have a great day!
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.