Accounts Receivable Aging Report

HytheMarina · ‎December 18, 2022

At year end 2021 a JE was made to Dr A/R and Cr Prepaid Income. I believe this invoice should have been reversed in January of 2022. It was not.

I have created a JE to reverse this in December 2022 prior to year end. The books are correct.

However, my A/R aging detail report shows two line items.

In the "Over 90 days section" it shows the 2021 JE. In the "30 days" section it shows the December JE.

When I close the books will these two cancel each other and clean up the report? What do I need to do to clean this up? The rest of the A/R has been resolved and so I will start out clean at the new year.

ChristineJoieR · ‎December 18, 2022

Hello there, @HytheMarina.

I'm here to assist you in removing the unwanted items showing QuickBooks Online's report.

If you want to offset unnecessary items, we will need to ask assistance from your accountant to locate the accounts.

Furthermore, when closing the books, we can't edit or modify the data to prevent changes to the reconciled transactions. Refer to this article for additional insights: Close your books in QuickBooks Online.

Alternatively, since the new year as the year comes to an end, utilise this guide to finish the year-end task: QuickBooks Online year-end guide and checklist.

You are always welcome to ask for help, @HytheMarina. We are available 24/7. Enjoy.

HytheMarina · ‎December 18, 2022

Thank Christine for your quick response. But I'm afraid it isn't the answer I was looking for. I am new to Quickbooks and so I am not sure what the system will do. I just need to know if the system will offset those two Journal Entries that are sitting on my Accts Receivable Aging Detail report or if I am going to have to look at them forever. That isn't what the A/R aging detail is for.

This is what I have on the report. I want this to not show after the end of this year. Is that possible?

DATE TRANSACTION TYPE NO. CUSTOMER DUE DATE AMOUNT OPEN

91 or more days past due

31/12/2021 Journal Entry Closing journals 2021 Leavers 31/12/2021 292.50 292.50

1 - 30 days past due

17/12/2022 Journal Entry JE - 2022 -01 Leavers 17/12/2022 -292.50 -292.50

HytheMarina · ‎December 18, 2022

Christine Thanks for the response. The information is good however not exactly what I was asking. I was asking a very specific question

This is what my A/R aging detail looks like right now. I need these 2 JEs to be offset. Will that happen when I close the books? Or will I see these JEs forever on my A/R detail report?

DATE TRANSACTION TYPE NO. CUSTOMER DUE DATE AMOUNT OPEN BALANCE

91 or more days past due

31/12/2021 Journal Entry Closing journals 2021 Leavers 31/12/2021 292.50 292.50

1 - 30 days past due

17/12/2022 Journal Entry JE - 2022 -01 Leavers 17/12/2022 -292.50 -292.50

Topics

Training

Community

Resources

Accounts Receivable Aging Report