cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
HytheMarina
Level 1

Accounts Receivable Aging Report

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.

 

3 REPLIES 3
ChristineJoieR
QuickBooks Team

Accounts Receivable Aging Report

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
Level 1

Accounts Receivable Aging Report

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
Level 1

Accounts Receivable Aging Report

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

Need to get in touch?

Contact us