United States United Kingdom Australia Canada (English) Canada (French) France Singapore South Africa Global Ireland
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Richie O
Level 1
posted
‎September 17, 2023 11:42 PM
last updated ‎September 17, 2023 6:42 AM

Collections and Open Invoice Reports show customers with credits/ paid extra

Hi everyone. I use Quickbooks online for a membership association with over 900 members. At any time, more than 400 of them have paid extra, or have credits to be applied to future invoices. When I run a Collections or Open Invoices Reports, these members with prepaid funds appear there, making the reports obsolete, especially the Collections one where the past due members are drowned by the 400+ prepaid ones. I can't seem to find any way to filter them out. Any idea, please?

Reply
1 Comment 1
AbegailS_
QuickBooks Team
QuickBooks Team
‎September 18, 2023 02:13 AM

Collections and Open Invoice Reports show customers with credits/ paid extra

Hi there, Richie. I'll share insights on how the Collections and Open Invoice report works in QuickBooks Online.

 

Unpaid bills are included in the Collections and Open Invoice Reports regardless of whether a customer has credit or prepaid cash. Thus, even though a member has a credit balance, the report will include them if they have an open invoice. Furthermore, I suggest that you review those unpaid invoices. 

 

To customize the report, refer to this article: Customise reports in QuickBooks Online.

 

You may want to take a look at these articles to know what reports included in your QuickBooks Online subscription as well as memorising them:

 

 Please let me know if you still need help with QuickBooks reports. I'll be happy to help you out.

Reply