Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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?
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.
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