LIst of Partial Refunds Made in 2012?

[Twistmo]

I need a list of all the partial refunds I made in 2012. Does it exist?

[PinchtheMuse]

http://www.etsy.com/teams/11969/direct-checkout/discuss/11607668/page/1/

Spindlecatstudio gives good how to get to the data in the above thread.

The columns you need are toward the end. Order Total and Adjusted Order Total.

[Twistmo]

Thanks PinchtheMuse. I just can't believe you have to subtract the Adjusted Order Total column from the Order Total column to get the Refund Total? That seems a really odd. That would be the same as if there was no column for the shipping. Weird.

[PinchtheMuse]

I know, it seemed odd to me too. I would think--they have the straight number somewhere in the databases.

Let me think...there is a reason too that the straight column totals don't work...my brain is tired.

Oh, if you do a total refund the adjusted amount is zero. Non refunds are a null. The straight auto sum of the columns doesn't work. Because it doesn't pick up the amounts of the full refund.

Making a separate column with a formula for each line to subtract adjusted order total from order total doesn't work because the spreadsheet reads the null entries as a zero entry.

It's incredibly annoying actually. I went through and manually calculated and added up the refund amounts.

I have a guess that the "adjusted amount" is for the third party accounting software they endorse, but that is just a wild guess. The only reason I can think of to have the adjusted amounts the way it is set up and not straight "real" and useful amounts.

[Twistmo]

I created some routines in my database to take care of it now, but just seems like a lot more work than we should need to go to. I feel sorry for those that really don't have a clue how to go about it.

My husband and I have been self employed for over 25 years and we do our own taxes -- even then its so confusing each year.

Thanks for confirming that I actually was seeing the only thing there is. I just thought surely I was missing something. Oh well.

[PinchtheMuse]

Yeah, it looked like a lot of extra steps. I just started on my database and didn't have the patience to set anything up at that exact moment to deal with that when I was doing those numbers. (Self taught so it is a crap shoot whether something will take me a minute or 2 hours to figure out sometimes). I am glad you were able to get it sorted.