Get 50% OFF QuickBooks for 3 months*

Buy now
United States United Kingdom Australia Canada (English) Canada (French) France Singapore South Africa Global Ireland
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
dolsvoid
Level 1
posted
‎March 05, 2024 05:53 AM
last updated ‎March 05, 2024 5:53 AM

Transaction Detail by Account Report with only Charge

I have taken a Transaction Detail by Account Report for all my Amazon purchases, the thing here is that I made a lot of returns to Amazon. This means that besides just Credit Card Charges I also have Credit Card Credits.

 

What I am looking for is to adjust this report so I only saw Credit Card Charges for transactions that have not been returned. Meaning that transactions that have both a Credit Card Charge and a Credit Card Credit that would cancel each other out would not be included.

 

Can I make this report and if so how?

Reply Join the conversation
4 Comments 4
BigRedConsulting
Community Champion
Community Champion
‎March 05, 2024 06:26 AM

Transaction Detail by Account Report with only Charge

There's built-in no way to do that because the charges and credits aren't linked in any way, and there is no concept of a returned status for transactions.

 

 

Reply Join the conversation
dolsvoid
Level 1
‎March 05, 2024 07:42 AM

Transaction Detail by Account Report with only Charge

That's pretty unfortunate, is there anything I can do here?

Reply Join the conversation
BigRedConsulting
Community Champion
Community Champion
‎March 05, 2024 12:02 PM

Transaction Detail by Account Report with only Charge

I'm not sure. I suppose you could manually code the transactions in some way and then group the report or remove them after sending the report to Excel.

 

Why do you want to exclude the activity?

Reply Join the conversation
dolsvoid
Level 1
‎March 05, 2024 01:00 PM

Transaction Detail by Account Report with only Charge

I want to make sure for transactions where I purchased and kept the product not return it I have a copy of an invoice.

Reply Join the conversation
Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Featured
The Answer Room: Banking and Reconciliations in QuickBooks Online
If you're looking to streamline your financial management and take control ...
Read more
Introducing the QuickBooks Online AI Payroll Agent: Streamlining Employee Compensation
(view in My Videos) Payroll management can be a daunting and error-prone ta...
Read more
Introducing your QuickBooks Online AI Finance Agent: Revolutionizing Business Financial Strategy
(view in My Videos) In today's dynamic business landscape, effective financ...
Read more

Need to get in touch?

Contact us