cancel
Showing results for 
Search instead for 
Did you mean: 
VK-EA-IL
Level 1

Aging AR - Bad Debts

Hello - I would like to implement automated payment reminders but I don't want to send them out for unpaid invoices older than previous fiscal year (before I took over). First, I ran an Aging AR report and identified all invoices to write-off.  Next, I recorded a Payment and used the 'Discount' tab to apply the amount to Bad Debt Expense. This carries over to the current-year P&L but the unpaid amount remains on the Aging AR report.  I reversed the Payment and tried the Credit Memo method and, again, it carries over to the P&L but no luck with the Aging AR. 

 

The previously-unpaid invoices now show as paid so I think I would be OK to send the automated payment reminders but I just wanted to make sure before I let it rip. Regardless, Is there any way to clean up Aging AR? 

 

Thank you!

1 Comment 1
JonpriL
Moderator

Aging AR - Bad Debts

I'm here to help share how you're able to clean up your report, @VK-EA-IL.

 

You're on the right track, the bad debt expense and credit memo method is the best way to clean up your Aging Accounts Receivable report. And you'll have to make sure the date of both the invoices to write off and the offsetting entries are the same so it won't carry over on your Profit and Loss this year.

 

Also, I highly recommend contacting your accountant or a bookkeeper who you can work with in handling your reports and for the accuracy of your accounting books. If you haven't yet, you can use this link to find someone near you: Business is better with a ProAdvisor.

 

I'm adding a couple of articles below that'll allow you to dive in deeply and understand your report:

 

 

Don't hesitate to post again here if you have other questions or concerns with QuickBooks reporting and navigations. I'm always around happy to help. Stay safe and have a good one!

Need to get in touch?

Contact us