Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowDoes anyone else have an issue of inactive and/or zero balance customers showing up on the accounts receivable aging list? I can't figure out why they are showing on the report and I cannot filter them out unless I drop into spreadsheet. this just seem ridiculous to have these show up on the report with no current activity. I've got some inactive customers 5 yrs back that are now showing up on the report
Yes, this happens when within the detail of the customer's transactions some of them are unpaid. Typically this is a payment that is not applied or not fully applied to the intended invoice(s), for some reason.
To see the unpaid transactions, double click on the customer's total due amount. Then use Receive Payments to apply unpaid payments and credit memos (possibly other types of transactions as well) to the sales they should be applied to.
Interesting. I now see some of the accounts were cleared via journal entry, some refunds. can you suggest the best way to clean this up so I can get them off my report?
Thank you
Yes, apply the unapplied amounts using the Receive Payments window:
- Journals and Credit Memos will appear as outstanding credits you can apply to unpaid invoices.
- Un-applied refund checks will appear as invoices in Receive Payments, waiting to be paid off by something like a Credit Memo.
credit were easy to apply, the ones i don't seem to be able to apply is journal entries created to zero out account, not quite sure how to apply the journal entry to specific invoice. any suggestions?
Thanks for getting back to us, @CAROLYNSHHI.
I'll share some information about applying the journal entry to a specific invoice. When you create the journal entry make sure to credit the A/R account. This way, it'll be posted as credit to the customer. Let me guide you how.
After that, go to the Customer Payment window so you can apply for the journal entry. Here's how:
On the other hand, you can record the uncollected invoices as bad debt and write them off. More details are found in this article: Write off bad debt in QuickBooks Desktop.
That'll do it. I'm attaching this link here in case you need help in managing your company's income and customers: Sales and customer.
Drop a reply anytime if you have follow-up questions or concerns with accounts receivables. I'm here to help. Have a good one.
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.