cancel
Showing results for 
Search instead for 
Did you mean: 
GrantAdmin
Level 1

Original Amount and Amount Paid Are Different

When I run a transaction report by class, various invoices will show a different amount paid than the original amount, except the whole invoice was paid. How do I correct this?

 

Example: Our February health insurance bill was $8,469.62 total. We charged $2,065.64 to Class A.  We paid total the bill on April 11th. When I run my report, it shows the bill twice, with $2,065.64 under Original Amount, but under Paid Amount, it shows $245.81 and $9.77.

 

I don't understand why, because the bill was paid in full with a single check. It wasn't partially paid. This happens typically with our health and life insurance bills, but also other vendors. The report is ran on a cash basis. 

 

 

10 Comments 10
ChristineJoieR
QuickBooks Team

Original Amount and Amount Paid Are Different

I can see you need to view your financial reporting with accurate amounts showing, @Grant. Let me share report information in QuickBooks Desktop.

 

May I know what specific reports you tried to pull up? It will help me identify if this is an issue within your company.

 

Please know that all reports shows different total amount. We recommend running the Customer Balance Detail which will allow you to view all the payment, invoices and all the outstanding balances. 

 

Furthermore, we can also pull up a Transaction List by Customer report that can help you view all the customer transactions and expenses. 

 

If you need to customize your financial data, see this article for your guide: Customize reports in QuickBooks Desktop.

 

I'll here if you need more assistance with managing your data, tap me in anytime. 

GrantAdmin
Level 1

Original Amount and Amount Paid Are Different

it's Transaction Detail by Account, sorted by Date, Class, and Vendor Name. 

GrantAdmin
Level 1

Original Amount and Amount Paid Are Different

Transaction Detail by Account with the filters set for Vendor Name, all income/expense accounts, set up for cash basis. 

FritzF
Moderator

Original Amount and Amount Paid Are Different

Hi there, Grant.

 

I'm here to assist you in resolving the problem you're experiencing with the Transaction Detail by Account report. However, I'll need to inquire further to gather more information.

 

I attempted to replicate this on my test company file, but I am not achieving the same result as you. Could you please let me know what you see when you click on the amounts under the Paid Amount column? If you are able to provide a screenshot of the affected transactions, it would greatly assist me in offering the most effective solution for your concern.

 

In the meantime, you may want to check out this article as your reference in case you need to know how QuickBooks generates reports: Understand reports.

 

I'm looking forward to hearing from you soon.

GrantAdmin
Level 1

Original Amount and Amount Paid Are Different

 

Attached is what it looks like when I click the amounts. As you can see on page 2, there amount for $2,065.64 only appears once. 

 

GrantAdmin
Level 1

Original Amount and Amount Paid Are Different

Here is how the transaction appears in the report. You can see where it shows we paid $245.81 an $9.77 for the same bill and the name is the same (redacted due to company policy, but it is the same name). 

Mark_R
Moderator

Original Amount and Amount Paid Are Different

Thank you for sharing screenshots of your issue and detailed information, @GrantAdmin.

 

What you experience when running a report in QuickBooks Desktop (QBDT) is unusual. Let's perform some troubleshooting steps to get the original amount and the paid amount to match.

 

Once you have already paid a bill, the original and paid amount should match. Since it didn't match, let's run the QuickBooks Tool Hub to help fix data issues in QBDT. Here's how:

 

  1. Download and install the more recent version of the QuickBooks Tool Hub.
  2. In the QuickBooks Tool Hub, select Program Problems.
  3. Select Quick Fix my Program.
  4. Start QuickBooks Desktop and open your data file.

 

I'm adding this article for more guidance: Fix common problems and errors with the QuickBooks Desktop Tool Hub.

 

Just in case you want to save the current customization of the report, you can read this article to learn how to do it: Create, access, and modify memorized reports.

 

Should you need any assistance running reports in QBDT, don't hesitate to leave a comment below. I'm available here to help at any time!

GrantAdmin
Level 1

Original Amount and Amount Paid Are Different

No errors were found.

AbegailS_
QuickBooks Team

Original Amount and Amount Paid Are Different

I understand the impact this situation has had on your business tasks, and I appreciate you following the steps provided by my colleague to resolve the issue that you encountered. I'd like to route you to the best support available.

 

Since the troubleshooting steps didn't work, I recommend contacting our QuickBooks Desktop Support Experts team to ensure that your current situation is addressed and thoroughly investigated securely and reliably. Allow me to guide you through the steps:

 

  1. In your QBDT file, go to Help, then select QuickBooks Desktop Help/Contact Us.
  2. Select Contact Us.
  3. Give a brief description of your issue, then select Continue.
  4. Sign in to your Intuit account select Continue and then Continue with my account.
    • If you don't already have an account, make sure to Create a new account.
  5. We'll email you a single-use code. Enter your code and select Continue.
    • If you have more than one account, select the account you want to use and then Continue.
  6. Select to chat with us or Have us call you.

 

To know our support's availability hours, kindly visit: Contact QuickBooks Desktop support.

 

You may also try personalizing your reports and use this article as your guide: Customize reports in QuickBooks Desktop.

 

If there's anything else I can do to assist you in managing your report, feel free to tap into my expertise.

amgpropowners
Level 1

Original Amount and Amount Paid Are Different

Was any solution found?    I performed the suggested steps, as well as talked to an Intuit QB rep for over an hour, and she couldn't find any reason why or how to fix it.   Not only does mine split payments, it is also splitting an invoice that was entered but not paid yet.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us