- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Reports showing negative numbers because some were paid with credit card and others paid with checking account
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Account management
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:
- Go to the Reports menu.
- Enter and select Profit and Loss by Tag Group on the Find report by name search bar.
- Pick the correct tag and then click the amount of the total expense.
- Modify the Report period and add filters to the report as needed.
- 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.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Account management
<<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?
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Account management
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!
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Account management
What other report than Transaction by Tag would there be?
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Account management
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.