Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
lisakeith
Level 2

invoices saved incorrectly

I discovered employees showing a partial fee paid as a negative in the total column so a client could see the remaining balance on their invoice, but on numerous invoices, they forgot to remove the negative amount when saving.  Therefore when the client later paid the additional amount, it didn't appear as if the client had a balance due on their account and other employees showed the payment as credit received.  Saving the invoice with a negative actually gave the client credit when there was actually a balance due.  Is there a way I can filter for additional invoices saved this way?  I found the error 3 months later.  We have 15 users and issue 100+ invoices per day.  We also have hundreds of clients with credit on their account.  I don't have time to search individual invoices for the errors.  I'm also worried about refunds issued on credit that wasn't credit!  Help please!    

1 Comment 1
Giovann_G
Moderator

invoices saved incorrectly

Hello, lisakeith.

 

I know how to filter invoices that were saved with a negative amount.

 

To do this, you can run a Custom Transaction Detail report and customize it to display only invoice transactions.

 

Here's how:

 

  1. Go to the Report menu.
  2. Hover your mouse to Custom report, then select Transaction Detail.
  3. Set the correct date.
  4. Click Customize button, then go to the Filter tab.
  5. Select the TransactionType from the Filter section, then choose Invoice from the Transaction Type dropdown.Capture1.PNG
  6. Once done, hit OK.
  7. Double-click the invoice with a negative amount in the Balance column to open the transaction.Capture.PNG
  8. Make necessary changes to the invoice and then click Save & Close.

 

For more information on customizing your reports, see this article: Customize reports in QuickBooks Desktop.

 

Also, you can memorize your report to save the current customization setting if you want to use it in the future. Memorize a report.

 

You're welcome to post again if you need anything else. We're always here to help you.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us