Memorial Day Sale 90% OFF QuickBooks for 3 months.* Limited time only

Buy now & save
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
JK7338
Level 1

Remove item with zero balance from collections report

Hello,

How can I remove line items from our collections report that already have a zero balance due to a previous general journal entry clearing the amount? This is for QuickBooks Desktop. Please see attached image for reference. 

3 Comments 3
LouiseG
QuickBooks Team

Remove item with zero balance from collections report

You can remove the zero balance due on your collection reports by associating the Journal Entry and Invoice with a Receive Payment, JK7338. Allow me to provide some further insight on this topic.

 

It appears the payment was not initially applied to the invoice. To eliminate the zero balance due in the collections report, you'll need to link the Journal Entry (JE) and the invoice by creating a receive payment entry. By linking these records correctly through the receive payment function, the invoice will be marked as paid, which should then update your financial reports accordingly.

 

Here's how:

1. Navigate the Receive Payments icon on the Home page.

2. Choose the customer's name under Received from dropdown.

3. Click the Apply Credits in the Unused Credits box.
4. Tick the Journal Entry to associate it with the invoice.5. Hit Done, then Save and Close.

 

When customers clear their balances, ensure to document it in QuickBooks with the help of this material: Record an invoice payment.

 

Furthermore, learn how to send detailed statements to your customers that offer a comprehensive overview of their financial transactions with your business. Please refer to the following article for guidance: Create and send customer statements in QuickBooks Desktop.

 

By following the steps provided, you'll be able to keep your financial records accurate and up-to-date in QuickBooks. If you have any questions or need additional help, feel free to reach out. I'm here to support you if you need further assistance.

JK7338
Level 1

Remove item with zero balance from collections report

Thank you, this worked!

FaithA
QuickBooks Team

Remove item with zero balance from collections report

Hello, JK7338. It’s wonderful to hear that my colleague was able to assist you with removing the zero balance due on your collection reports.

 

We appreciate your patience and proactive approach to solving this together. I'll also share this interesting read about how to send detailed statements to your customers: Create and send customer statements in QuickBooks Desktop.

 

If you need further assistance or have any other questions, don’t hesitate to reach out. Our dedicated Community experts are available 24/7 to ensure your experience remains smooth and hassle-free. Take care!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us