Connect with and learn from others in the QuickBooks Community.
Join nowjust started new position with company. in doing so i have ran into a big problem. I have over due invoices and over due payment that are not matched up. therefore showing open invoices in 91 and over that should not be there .
example
invoice dated 2-29-20 with and outstanding balance of 20.00 showing over due
3-31-20 683.72 showing over due
deposits dated 10-15-20 -10000.44 showing overdue
10-16-20 - 52047.03 showing overdue
i need to clean up the a/r but how do i do that.
Hello there, @pam27295.
Let's first record payments made to the invoice. This way, you'd be able to clear the open invoice balance. I can guide you on how to do it.
Once completed, let's make a deposit to clear the deposits that are showing overdue. Here's how:
Now that your AR and deposits are cleared, you can start matching your recorded invoice payments and downloaded bank transactions. By doing this, you'd avoid getting duplicates.
I've added these articles as additional reference in tracking your sales transactions in QuickBooks:
Know that the Community and I are always here to help you manage your income-related transactions. Visit us here again if you have other questions. I'm always here to help.
I want to make sure you're taken care of, @pam27295.
Have you tried following the steps I shared on how to record your client's invoice payments? Were you able to clear your over due invoices and deposits?
Know the Community has your back. I’m also here to lend a helping hand. Have a great day ahead.
I need to unapply and repost the entries. As i said in my original post - these entries have already been made. They are hanging out there in the vendor file. I want it cleaned up.
Hello there, @pam27295.
To unapply those entries, we can remove invoice payments and deposits by deleting them in QuickBooks Online (QBO). You can then recreate them after.
Here's how:
You can also delete the invoices if you wish to, then recreate them. I'll guide you how:
Check this article for reference to create those invoices: Create Invoices in QuickBooks Online.
I've also added this link about categorizing transactions in QBO: Categorize and match bank transactions in QBO. It gives you better options on how to manage your bank transactions moving forward.
Don't hesitate to drop a comment below if you have other questions. I'm more than happy to help. Take care!