cancel
Showing results for 
Search instead for 
Did you mean: 
CAROLYNSHHI
Level 1

accounts receivable aging report

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 

5 Comments 5
BigRedConsulting
Community Champion

accounts receivable aging 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.

CAROLYNSHHI
Level 1

accounts receivable aging report

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
Community Champion

accounts receivable aging report

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.

CAROLYNSHHI
Level 1

accounts receivable aging report

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?  

 

 

ShiellaGraceA
QuickBooks Team

accounts receivable aging report

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.

 

  1. Go to Accountant at the top.
  2. Choose Make General Journal Entries.
  3. On the first line under Account, pick the Accounts Receivable account. Then, enter the amount as Credit
  4. On the second line select the corresponding income/bank account and amount as Debit. Make sure to select the customer's name from the Name drop-down.
  5. Click Save & Close. See the attached screenshot below.

 

 

 

After that, go to the Customer Payment window so you can apply for the journal entry. Here's how:

 

  1. From your Home Page, tap the Receive Payments icon.
  2. From the Receive From drop-down, choose the customer that you need to apply for the entry.
  3. Put a check on the invoice and then scroll down and select the Apply Credits link.
  4. Mark the journal entry from the Credits tab.
  5. Click Done and then Save & Close. See the image below.

 

 

 

 

 

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.

Need to get in touch?

Contact us