Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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.
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.
it's Transaction Detail by Account, sorted by Date, Class, and Vendor Name.
Transaction Detail by Account with the filters set for Vendor Name, all income/expense accounts, set up for cash basis.
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.
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:
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!
No errors were found.
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:
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.
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here