Accounts Receivable - Offsetting Amounts

Let's identify where these amounts are coming from to get this off from your A/R Aging report, @dsky227.

After generating the report, click those +100 and -100 amounts to open the A/R Aging QuickZoom report that will show you transactions that make up that total amount. 

That can be a payment that is not linked to an invoice, a credit memo to a customer not linked to an invoice or a refund check, or a journal entry crediting A/R as the source account. You can check the following article for more information about Accounts Receivable (A/R) or Accounts Payable (A/P) balances and on how to resolve them: Resolve AR and AP balances on the cash basis Balance Sheet.

Here's also more information that can help you with customizing any report that you generate like adding or deleting columns, information on the header/footer: Customize reports in QuickBooks Desktop. 

Let me know in the Reply section if you need further guidance getting off those amounts from your A/R Aging report. I'm always glad to help. Have a wonderful day!

There are 2 JEs

The first JE Debits the A/R account 1115 for 100 and credits the bad debt acct 5510 for 100

The 2nd JE credits the A/R account 1115 for 100 and debits the bad debt acct 5510 for 100.  

Both amounts appear on the A/R aging report.  

Hi there, @dsky227. I've got your back, and I'll ensure you can get through this and get rid of those bad debt adjustments on your aging report in QuickBooks Desktop (QBDT).

A possible reason there are no open invoices in your customer's profile, you've already paid the invoice and created two journal entries for the bad debt. You'll want to check your customer's profile to see if there's an existing paid invoice. If there is, you can delete your journal entries so they won't appear in your Aging reports. But before you make changes to your account, you'll want to ensure you have a backup copy of your company file.

 Refer to this page for further guidelines on how to create a backup company file in QBDT: Back up your QuickBooks Desktop company file.

Based on the details you've provided, It can also be that you've deleted the uncollectible invoice and then created a journal entry for recording the bad debt. If this is the case, you'll need to recreate the invoice and delete your first journal entry. Keep the second journal entry so you can link it to the invoice you recently created. I'll input the steps below so you can proceed. To begin, here's how:

1. Access your QuickBooks Desktop company file.
2. Go to Customers tab, and then locate the customer you used on the invoice.
3. In the Transactions column, click the Invoice you recreated.
4. Receive payment for that invoice.
5. Link the journal entry by checking it.
6. Once done, click Save and close.

You can also visit this article to see other ways of handling bad debt in QBDT: Bad debt in QuickBooks Desktop.

Also, I still suggest consulting your accountant before making changes to your account. This way can give you the best possible advice to get this sorted out.

Feel free to get back to me if you need further assistance dealing with bad debt in QuickBooks. You can also post here again if you have any additional QuickBooks-related concerns. Rest assured, our team of dedicated experts is always around to help you. Take care, and have a nice day!

People - I figured it out!!!!  

  The customer charge and the customer credit were posted to two different A/R accounts!?!  And - to make matters a bit more challenging - both of those A/R accounts were marked inactive.  That just made things a bit more challenging to figure out.  Anyway, once I figured all that out... I just went back to the credit entries, changed them so that they posted to the same A/R account that the invoice were posted to... then went to receive payments... and viola - the credits were now showing as available to be applied to the outstanding invoice.  

  Going through these steps cleared out my customers with a net zero balance on the A/R report.  

  Yeah me!  

It's nice to see you again here in the Community, @dsky227.

I'm glad to know that your issue about the account receivable report is already resolved. Thanks for getting back here to update us regarding the steps you've performed and the outcome. 

Keep me posted if you have any other QuickBooks-related questions or concerns. I'm always around in and ready to lend a hand. Have a good one and take care.