Skip to main content
D
dolsvoid
March 5, 2024
Question

Transaction Detail by Account Report with only Charge

  • March 5, 2024
  • 1 reply
  • 0 views

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?

1 reply

BigRedConsulting
BigRedConsulting
March 5, 2024

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.

 

 

D
dolsvoidAuthor
March 5, 2024

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

BigRedConsulting
BigRedConsulting
March 5, 2024

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?

Terms & ConditionsAccessibility statement