Skip to main content
H
HytheMarina
December 18, 2022
Question

Accounts Receivable Aging Report

  • December 18, 2022
  • 1 reply
  • 0 views

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.

 

1 reply

C
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.

H
HytheMarinaAuthor
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

 

 

 

Terms & ConditionsAccessibility statement