cancel
Showing results for 
Search instead for 
Did you mean: 
AlabamaPamela
Level 3

aging summary is wrong

Just found this and wonder how many others are wrong.  We invoiced a job Sept 8, 2021.  Today's report says this invoice is 60 days old.  Tomorrow it will be 90 days old!!!  Help me find how to fix this.  Thanks.

4 Comments 4
Tori B
QuickBooks Team

aging summary is wrong

Hey there, @AlabamaPamela.

 

Thanks for reaching out to the Community for support. 

 

It sounds like you may have some data integrity issues going on with your company file. Typically when a user has data integrity issues in the company file, it can cause the following:

 

  • Fatal errors when you use QuickBooks Desktop.
  • Discrepancies on reports, such as invoices or bills that post with negative values and incorrect dates.
  • Deposited payments show up in the Payments to Deposit window.
  • Balance sheet reports do not show all accounts.
  • Names are missing from lists.
  • Transactions are missing.

 

Don't sweat. We have tools within QuickBooks that can help resolve these issues. These tools are called Rebuild and Verify. I've included some steps to run them below. 

 

Rebuild data

  1. Choose FileUtilities, then Rebuild Data.
  2. You will receive a warning message to backup your company file, press OK
  3. The Rebuild Data utility starts as soon as the backup is finished.
  4. Click OK when you get the message "Rebuild has completed."

 

Verify data

 

  1. Choose Window, then Close All.
  2. Verify Data. Choose File then Utilities. Click on Verify Data.

 

Once the tools have finished, recheck your Aging Summary. Check out Verify and Rebuild Data in QuickBooks Desktop for additional details about this process. 

 

Please let me know how it goes. I'll be sure to keep an eye out for your reply and look forward to chatting with you soon. Don't hesitate to ask any additional questions if you need to. I'm always here to help. Take care! 

 

AlabamaPamela
Level 3

aging summary is wrong

Thank you     We have our QB on a server.  We have 5 users.  I need to rebuild the Data at end of day after everyone is out of QB, right?  .... and do the rebuild on the server?

DivinaMercy_N
Moderator

aging summary is wrong

Yes, you're right, @AlabamaPamela.

 

When performing the Verify Rebuild data utility in a Multi-user mode, other users will be prevented from doing work. To avoid this, you can perform the process when everyone is out. For more information about the task you can do when in multi-user mode, please visit this article: Features available and tasks you can perform in single or multi-user mode.

 

Also, it's recommended to create a backup copy first before doing any changes to your company file. This is to ensure you have the original details that you can restore at any time in case of accidental loss or damage.

 

You'll want to personalize and filter only the data you need when generating a report, feel free to customize them in QuickBooks Desktop. For the detailed instructions, check out this article: Customize reports in QuickBooks Desktop.

 

In case you have any other questions about performing the verify rebuild tool to fix your report, please leave a reply below. I'd be glad to assist you further. Take care. 

Rainflurry
Level 13

aging summary is wrong

It sounds like these invoices were Net 30 terms?  Aging is the number of days after the due date, not after the invoice date.  So, if the invoices were dated Sept. 8 with Net 30 terms, they should be aged 60 days today. 

Need to get in touch?

Contact us