Originally Posted by something
Yeah, it's still pretty difficult. Too much tweaking needs to be done. I track three prices:
1) Yen, which gets screwy with the constantly shifting prices and any item cancellations (which affect S&H per item)
2) Dollars, initially calculated off #3 but later adjusted as best I can based on what actually charges to my credit card. Of course in multi-item shipments this gets complicated and I need to go calculate what item was what percentage of the yen price, then apply that to the dollar price and... well, meh.
3) Dollars, at today's exchange rate. I have a cell where I can just plop in the current rate and it'll calculate what the items would have cost if it shipped right now. Of course this is based on #1 which is tough to be exact with.
In the end I'm sure I always wind up off a little but probably doesn't add up to much either way so far. But as long as I can get close with #2 based on actual CC charges (made easier if items ship one at a time), the total spent should be pretty accurate.
What I should do is make another column and separate S&H cost in yen from item cost in yen. It'd be easier to modify. But I already have like 20 columns in my spreadsheet...
I have a yen (item price) column, a yen (shipping based on the invoice when it ships) column, and one dollars column that combines them and uses the exchange rate listed on my credit card statement. I just ignore the conversion charge by my bank and I'd just as soon not see how much extra I've spend thanks to that. The yen item price isn't a problem, since I can just update it when it ships and then again when this situation comes up. The shipping one is the that can get tricky, when more than one item ships at a time and I'm trying to decide where fractions of a yen go. Shipping calculation is more of a problem for CDJapan orders, when I have to try to figure out how much of the shipping to apply to each group of items (I haven't yet used CDJapan for DVD/BD imports, but I still track the dollar amount I spend on CDs, manga, artbooks, etc., and I have manga/light novels and CDs/artbooks/other as separate lists, so I have situations like needing to figure out how much of the shipping charge goes to 5 manga and how much goes to 2 CDs and an artbook).
The dollar one only becomes a problem in this situation, when I'm dealing with multiple exchange rates. But in both the shipping situation and the dollar situation, the difference is negligible. For 200-300 yen, the exchange rate difference for the refund is going to throw it off by maybe 10 cents on the high end and the fraction of yen is going to be a difference of a penny, if that much, so its not a big deal. I have an idea of how I could deal with the refund at the different exchange rate [(original price x original exchange rate]-[refund amount x refund exchange rate]) , but for something that throws the entire series cost off by less than 50 cents, its just not worth it.