Someone asked about this privately, and in order to share, and perhaps learn something myself (eg, improvements), here are the column headings in a couple of spreadsheets I use in my tax reporting. Here's the one for (1) trades, and another for (2) dividends. (There's one more for interest, but it's almost the same as for dividends.)
Tho they have evolved a little, these are what I've used for years, and they are based on some rather important discussions I had with the tax people (was audited).
First, the one for trades. Maybe not really necessary, but in column A, I simply number each item. Column B is ticker symbol (not full name). Column C is what I use to organize the list, and this begins with (eg) January and proceeds down thru the year. Column D is comparatively mixed up, since purchase dates can vary a lot. Columns E and F are the purchase and sale amounts. (Column G, ...I think this one can be eliminated, I don't think I've used it.) Column H is only there for me (with a total at the bottom) so that I can see how that compares to the eventual yen total.
Columns I and J are the TTM rates for the sale and purchase dates. Those, respectively, are used with a formula to produce amounts in yen in columns K and L. Column M is profit/loss in yen.
For the tax return, the important numbers to input, are the totals at the bottom of columns K and L. On the return, this will then generate the number/total at the bottom of column M, a way to confirm if things are unfolding properly on the tax return.
The sheet for dividends is comparatively simple--only one date to deal with. This one is also organized by transaction date (B), and A is simply item numbers, C is ticker symbol. Dividends are listed in dollars (D), converted using the TTM rate for that pay date (F), and a formula in (G) results in a yen amount, again total at the bottom.
I haven't used columns E and H for a year or two. These are there for (in my case) ADRs or foreign stocks where a third country would withhold some percent of a dividend being paid. These amounts (in total, IIRC) are listed/claimed on a tax return here, but there's only a minor bit of detail needed--one or two names/tickers, and then "etc".
So that's it. Suggestions? Questions? Of course, since these sheets are attachments to your tax return, add a header with all identifying bits possible. Name, address, contact phone, tax year that the sheet is for, tax number, MyNumber, and so on.
This isn't too hard, just bookkeeping, and I do like that it makes me aware of what has happened. Eg, for trades, it's useful to see how P/L comes out in dollars and then yen. There are also some other occasional 'insights' ("Boy, why did I buy and then sell that, like that!?!).
Tho they have evolved a little, these are what I've used for years, and they are based on some rather important discussions I had with the tax people (was audited).
First, the one for trades. Maybe not really necessary, but in column A, I simply number each item. Column B is ticker symbol (not full name). Column C is what I use to organize the list, and this begins with (eg) January and proceeds down thru the year. Column D is comparatively mixed up, since purchase dates can vary a lot. Columns E and F are the purchase and sale amounts. (Column G, ...I think this one can be eliminated, I don't think I've used it.) Column H is only there for me (with a total at the bottom) so that I can see how that compares to the eventual yen total.
Columns I and J are the TTM rates for the sale and purchase dates. Those, respectively, are used with a formula to produce amounts in yen in columns K and L. Column M is profit/loss in yen.
For the tax return, the important numbers to input, are the totals at the bottom of columns K and L. On the return, this will then generate the number/total at the bottom of column M, a way to confirm if things are unfolding properly on the tax return.
The sheet for dividends is comparatively simple--only one date to deal with. This one is also organized by transaction date (B), and A is simply item numbers, C is ticker symbol. Dividends are listed in dollars (D), converted using the TTM rate for that pay date (F), and a formula in (G) results in a yen amount, again total at the bottom.
I haven't used columns E and H for a year or two. These are there for (in my case) ADRs or foreign stocks where a third country would withhold some percent of a dividend being paid. These amounts (in total, IIRC) are listed/claimed on a tax return here, but there's only a minor bit of detail needed--one or two names/tickers, and then "etc".
So that's it. Suggestions? Questions? Of course, since these sheets are attachments to your tax return, add a header with all identifying bits possible. Name, address, contact phone, tax year that the sheet is for, tax number, MyNumber, and so on.
This isn't too hard, just bookkeeping, and I do like that it makes me aware of what has happened. Eg, for trades, it's useful to see how P/L comes out in dollars and then yen. There are also some other occasional 'insights' ("Boy, why did I buy and then sell that, like that!?!).