Removing old transactions in a Customer statement

DES2022 · ‎January 19, 2023

I printed a customer statement that i wanted to list all open transaction but it also list the invoice from previous years that has already been negated by a journal entry to declare it as a bad debt. Both the invoice (dab debt) and the journal entry appears on the statement. how do I make these 2 transactions disappear from the statement

Alex M · ‎January 19, 2023

Hi there DES2022,

If you're looking at removing both from the report, then the journal entry would need to be applied to the invoice. This can be done by going to the Sales tab, then Customers. Click on the name of the customer in question, then find the invoice. Click on Receive Payment, then from within that payment, check the journal entry to select it, and this payment will just take the open balance of the Journal entry and the invoice and apply them together so they're no longer overdue.

If you have any other questions, feel free to reach out here.

View solution in original post

Trish_T · ‎January 19, 2023

Hi DES2022,

Thanks for reaching out here. Welcome! Removing transactions from prior periods in QuickBooks Desktop, can potentially have a negative impact on other areas of your books. For this reason, I encourage you to reach out to an accounting professional for their expertise and best course of action. If you don't have an accountant, we can help you locate a ProAdvisor in your local area.

If you have any other questions, feel free to reach back out. We'd be glad to assist!

DES2022 · ‎January 19, 2023

I guess I have not explained it well. I did not want to remove transactions in the system. I just want them to not appear on the customer statement of open transactions. As the invoice was supposed to be closed already when it was declared as a bad debt.

Alex M · ‎January 19, 2023

Hi there DES2022,

If you're looking at removing both from the report, then the journal entry would need to be applied to the invoice. This can be done by going to the Sales tab, then Customers. Click on the name of the customer in question, then find the invoice. Click on Receive Payment, then from within that payment, check the journal entry to select it, and this payment will just take the open balance of the Journal entry and the invoice and apply them together so they're no longer overdue.

If you have any other questions, feel free to reach out here.

Topics

Training

Community

Resources

Removing old transactions in a Customer statement