I created a transaction detail report that gives me a grand total for each vendor however its not totaling items up correctly. See more details below. How can I fix this?

Hi there, @Kaylamariem33.

The reason why your Transaction Detail by Account shows checks as a negative amount is because it displays both sides of the transaction, the debit and credit entries that balance each other.

To simplify:

• The negative amount on your checks represents the credit to your bank account (money going out).
• The positive amount on your checks represents the debit to the expense or asset account (where the money went).

To see more details, you can add Item split account full name to your columns. This will show you exactly which accounts were debited and credited for each check.

Furthermore, the credit card expenses shows as a positive amount in your report since it indicates that the money you owe increases. This is a standard accounting practice since it is a liability account.

As a workaround, you can export your report to Excel and from there, you can manually total the amounts of your expenses and checks.

Feel free to leave a reply if you have further questions about QuickBooks Online.