Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Memorial Day Sale 90% OFF QuickBooks for 3 months.* Limited time only
Buy now & saveHello,
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.
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.
Thank you, this worked!
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!
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