cancel
Showing results for 
Search instead for 
Did you mean: 
DecaturInvestor
Level 4

Reports showing negative numbers because some were paid with credit card and others paid with checking account

I ran a report on Tag Transactions and the line items that were paid with the checking account are showing negative and the credit are showing positive numbers so I can't get an accurate report. How do I get all positive numbers just for the report
5 Comments 5
Ivan_G
QuickBooks Team

Reports showing negative numbers because some were paid with credit card and others paid with checking account

Thanks for providing such detailed information about your concern, DecaturInvestor. I'm here to share why checking and credit card accounts have positive and negative values. Then, lay out the report that meets your needs.

 

Expenses under your checking account were treated as negative entries because it reduces your overall cash balance. Meanwhile, credit card expenses are treated as liabilities, making them appear as positive values on your reports.

 

That said, your transactions on the checking account will show on most of your reports as negative numbers regardless of the account's balance. As an alternative, we can pull up the Profit and Loss by Tag Group report to show the data tracked by tag as positive values:

 

  1. Go to the Reports menu.
  2. Enter and select Profit and Loss by Tag Group on the Find report by name search bar.
  3. Pick the correct tag and then click the amount of the total expense.
  4. Modify the Report period and add filters to the report as needed.
  5. Hit Run report.

 

Finally, you may customize your report according to your preference and save the modifications to smoothen your experience when reviewing them going forward.

 

Tag me on this thread if you have follow-up questions about your accounts and their transactions or whenever you need assistance managing your reports. I'll be sure to help you promptly.

DecaturInvestor
Level 4

Reports showing negative numbers because some were paid with credit card and others paid with checking account

<<Expenses under your checking account were treated as negative entries because it reduces your overall cash balance. Meanwhile, credit card expenses are treated as liabilities, making them appear as positive values on your reports.>>

The problem is it makes the report inaccurate. What I'm asking is there a way to make the negatives appear as positive. One solution would be to download in Excel file and manually change all of the negative, however, that seems cumbersome. Is there a way to do this by changing a filter or something? 

Tori B
QuickBooks Team

Reports showing negative numbers because some were paid with credit card and others paid with checking account

Thanks for checking back in, @DecaturInvestor.

 

At this time, there isn't a way to make changes to the report so it shows positive amounts. I recommend using a different report as my colleague has mentioned above. 

 

In the meantime, I think this would be the perfect opportunity to send this suggestion to our Product Development Team for further review. Our developers review each request and consider them all for future updates. If you're interested in sending this feedback, please feel free to use the link I'm including below. 

 

 

Don't hesitate to let me know if there is anything else I can assist you with. Take care and have a great day ahead! 

DecaturInvestor
Level 4

Reports showing negative numbers because some were paid with credit card and others paid with checking account

What other report than Transaction by Tag would there be? 

SashaMC
Moderator

Reports showing negative numbers because some were paid with credit card and others paid with checking account

Hello DecaturInvestor,

 

Thank you for chiming back on the thread. The only report we have by Tag would be the one you mentioned and the Profit and Loss by Tag Group as the agents mentioned above. If you have any other questions, simply comment below! See you soon. 

 

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

Need to get in touch?

Contact us