Skip to main content
March 1, 2023
Question

Incorrect Prior Amt on Progress Bills

  • March 1, 2023
  • 1 reply
  • 0 views

I was spot checking a project's invoice when I noticed that it was invoiced at 150%!!!

When I asked the AR staff how this was possible, they said it was the only way they could get the invoice out for the correct amount.

When I looked at the project's billing profile it showed a prior billed amount of $1852.50 invoiced on a total estimated amount of $1,235.00.

When I looked at the project's transaction history, I only see the estimate for $1,235.00, an invoice for 50% of the estimate of $617.50, and a payment for that invoice for $617.50.

Somewhere the system is counting a third invoice that is not present.

When I asked the AR staff if they had created another invoice and then deleted they said that they might have done that. 

When an progress invoice is simply deleted instead of voided, is that what creates the prior billing tracking overstatement?

I need to confirm this is what is likely causing this error. 

If it is I need to make sure the AR staff doesn't delete progress invoices when they find an error and instead void them.  Then I need to figure out how to fix the ones that have this error.

Can anyone shed some light on this?

Thank you.

1 reply

March 1, 2023

Thanks for letting us know about this, @DEW2022. Let's get you going to have you back on track and determine the root cause of the error you encountered inside QuickBooks Desktop (QBDT).

 

To get started, you'll want to run a report to ensure and verify if there are transactions deleted. This way, you can determine what causes your records to be inaccurate inside QBDT. Here's how:

 

  1. Access your QuickBooks Desktop application.
  2. Go to the Reports tab.
  3. In the search bar, type Projects and then open or click it.
  4. Click the Customize button to add more details to your Project report.
  5. Check if all the transactions are correct and intact.

For more information about customizing a report inside QBDT, feel free to visit this page: Customize reports in QuickBooks Desktop.

 

Additionally, here's an article to help you keep your current report settings: Create, access and modify memorized reports.

 

If you need assistance getting this sorted out, feel free to post here in the Community space. I'm determined to help you get through this. Stay safe!

DEW2022Author
March 3, 2023

I am going to follow these steps this weekend when I can focus on the solution and will report back.  Thank you for the recommendations and support.

March 3, 2023

Thanks for getting back with the Community, DEW2022.

I'm happy to hear KurtKyle_M was able to help with identifying how you can verify if transactions were deleted with project reports.
 

You'll also be able to find many detailed resources about using QuickBooks in our help article archives.
 

Please don't hesitate to send a reply if there's any questions. Have a wonderful Friday!