I recently took over managing QB for a landscape company. The previous person caused a lot of duplicate payments, I think. I believe they would go into the invoice and mark it paid and would not link it to a specific bank deposit with various checks for multiple invoices. How do I go back and fix these issues if the company already reconciled each month to date. Looks like we are double dipping on the money paid.
Solved! Go to Solution.
Yes, you need to create a bank deposit entry, Chris4242. I'll guide you on how to do this so you can manage your bank transactions accordingly.
When receiving payment for an invoice that goes to your undeposited funds, you'll have to make a bank deposit to match it to the bank feed. Here's how:
Afterward, go to the Bank transactions menu to categorize and match your bank feed deposit to the existing entry.
Additionally, we recommend regularly reconciling your accounts (monthly) to effectively track your business revenue and keep your financial data updated.
If you have other concerns about bank deposits and reconciling accounts in QBO, don't hesitate to ask, as I'm always here to assist you in any way possible.
Welcome to the QuickBooks Community, Chris4242.
To fix those duplicate payments and to manage your sales transactions, you'll need first to unreconcile the entries from the date when the payment was recorded up to the recent one. Let me provide steps to complete this process and ensure you can organize your invoices and payments efficiently.
Beforehand, yes, you're correct that linking to a specific bank deposit with various checks for multiple invoices isn't necessary. This method can usually cause double income, especially if those payments are already added to QuickBooks from your online banking.
To resolve your issue, you can start following the steps below on how to unreconcile the entries.
However, if you're using a QuickBooks Online Accountant version, you can refer to this article on how to undo the entire reconciliation in easy methods: Undo a client’s reconciliation in QuickBooks Online Accountant.
Once done, you can delete the manually entered bank deposit to remove the duplicate data on your end. Then, undo the added payments by going to the Bank transactions section.
Here's how:
After that, you can use the Find Match tool and turn on Suggested Matches to see options that might match. This allows you to match the deposit payment to multiple invoices. Please follow these instructions:
Then, you can now see that your invoices are already mark as paid in your QuickBooks.
In case you need different guidelines that will help you perform or fix any reconciliation issues that you might encounter in QBO, you can refer to this article: Learn the reconcile workflow in QuickBooks.
Keep us posted if you have additional information or clarification about managing your invoice and payments, or reconcilation in QBO. I'm always here to assist you, Chris4242. Have a good day.
Thank you so much. One more question. Do I need to create a bank deposit entry when I have my bank account linked? We go from invoice, to receive payment (invoices go to undeposited funds), then I use the bank feed entry to match the bank feed deposit to the invoices. Is that correct?
Yes, you need to create a bank deposit entry, Chris4242. I'll guide you on how to do this so you can manage your bank transactions accordingly.
When receiving payment for an invoice that goes to your undeposited funds, you'll have to make a bank deposit to match it to the bank feed. Here's how:
Afterward, go to the Bank transactions menu to categorize and match your bank feed deposit to the existing entry.
Additionally, we recommend regularly reconciling your accounts (monthly) to effectively track your business revenue and keep your financial data updated.
If you have other concerns about bank deposits and reconciling accounts in QBO, don't hesitate to ask, as I'm always here to assist you in any way possible.
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