accounts receivable aging report

Forum|Forum|4 years ago
August 26, 2021
5 replies
22 views

Does 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

QuickBooks Desktop

BigRedConsulting

Level 15

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.

CAROLYNSHHIAuthor

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

BigRedConsulting

Level 15

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.

Sign up

Login with SSO

Let's get you signed in

Login with SSO