ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBOBPBQBRBSBTBUBVBWBX
1
移動平均法
2
取引時レート (円/1コイン)各通貨の取引直後の1コインあたり
の平均取得価額 (円)		取引時損益
3
計算用計算用メモ
(何を記載してもOK)		日付操作内容金額通貨日本円換算BTCETHETCDAOLSKFCTXMRREPXRPZECXEMLTCDASHBCH12345678910111213141516171819202122232425取引後仮想通貨残高
4
11JPYcoincheck12021-05-14 21:40:29 UTC入金300000JPY
5
22JPYcoincheck22021-05-14 22:44:02 UTC購入-99351JPY
6
11XRPcoincheck32021-05-14 22:44:02 UTC購入3800XRP99351.0000000 26.1453800.00000 26.14500 シート全体の損益合計 (所得内通算) (円)
7
33JPYcoincheck42021-05-14 22:44:47 UTC購入-90577JPY移動平均法
8
11XEMcoincheck52021-05-14 22:44:47 UTC購入6000XEM90577.0000000 15.096166676000.00000 15.09617 ¥5,195,135 ①
9
11BTCcoincheck62021-05-14 22:44:57 UTC購入0.5174BTC110072.0000000 212740.62620.51740 212740.62621
10
44JPYcoincheck72021-05-14 22:44:57 UTC購入-110072JPY2020年以前の損益合計 (所得内通算) (円)
11
55JPYcoincheck82021-05-15 21:20:36 UTC入金100000JPY移動平均法
12
66JPYcoincheck92021-05-15 21:34:19 UTC購入-19959JPY¥0 ②
13
11ZECcoincheck102021-05-15 21:34:19 UTC購入1.74ZEC19959.0000000 11470.689661.74000 11470.68966
14
77JPYcoincheck112021-05-15 21:35:11 UTC購入-20080JPY
15
11XMRcoincheck122021-05-15 21:35:11 UTC購入6XMR20080.0000000 3346.6666676.00000 3346.66667 2021年の損益合計 (所得内通算) (円)
16
11ETHcoincheck132021-05-15 21:35:49 UTC購入1.82ETH19970.0000000 10972.527471.82000 10972.52747 移動平均法
17
88JPYcoincheck142021-05-15 21:35:49 UTC購入-19970JPY¥5,195,135 ①-②
18
99JPYcoincheck152021-05-15 21:36:06 UTC購入-39988JPY
©理系20代の日常レポート (http://www.rikei20.com)
19
22XRPcoincheck162021-05-15 21:36:06 UTC購入1353.9505XRP39988.0000000 29.534314595153.95050 27.03538
20
22BTCcoincheck172021-05-16 02:07:32 UTC売却0.2018BTC1068075.3356000 5,292,7420.71920 1638135.89488
計算手法についての基本ルール (税務署から問い合わせを受けた場合は以下の回答をお願いします)
21
22XEMcoincheck182021-05-16 02:07:32 UTC売却-3000XEM-102414.0000000 34.1383000.00000 15.09617 57126
・日本円と仮想通貨間の売買取引の場合は、日本円の価格を仮想通貨の枚数で除することで取得価額を算出 (円/コイン)
22
33BTCcoincheck192021-05-16 02:08:18 UTC購入-0.31587BTC-1671818.4155400 5,292,7420.40333 1638135.89488 1154380
・コインチェックで取り扱っている通貨同士の売買については、その売買日の終値を用いて売買時のレートをそれぞれ推定 (円/コイン)
23
33XRPcoincheck202021-05-16 02:08:18 UTC購入1900XRP315571.0000000 166.097053.95050 64.49010
・終値はコインチェックHP(https://coincheck.com/ja/exchange/closing_prices)より引用
24
44BTCcoincheck212021-05-16 15:07:01 UTC購入-0.40258BTC-2130752.0743600 5,292,7420.00075 1638135.89488 1471271
・【コインチェックで取り扱っている仮想通貨】と【コインチェックで取り扱っていない仮想通貨】の売買については、
25
44XRPcoincheck222021-05-16 15:07:01 UTC購入2100XRP348789.0000000 166.099153.95050 87.79805
【コインチェックで取り扱っている仮想通貨】の売買日の終値を用いて間接的に【コインチェックで取り扱っていない仮想通貨】の売買時のレートを推定(円/コイン)
26
55BTCcoincheck232021-05-16 15:07:42 UTC売却0.199BTC1053255.6580000 5,292,7420.19975 5279020.07470
※ただしMONAとXLMなどの近年取り扱いが始まった暗号資産は【コインチェックで取り扱っている仮想通貨】として扱わない
27
33XEMcoincheck242021-05-16 15:07:42 UTC売却-3000XEM-102414.0000000 34.1380.00000 15.09617 57126
28
66BTCcoincheck252021-05-16 15:08:40 UTC購入-0.1914BTC-1013030.8188000 5,292,7420.00835 5279020.07470 2626
29
55XRPcoincheck262021-05-16 15:08:40 UTC購入1000XRP166090.0000000 166.0910153.95050 95.50854
30
1010JPYcoincheck272021-05-17 14:33:06 UTC入金200000JPY
31
1111JPYcoincheck282021-05-17 21:13:23 UTC購入-200003JPY
32
66XRPcoincheck292021-05-17 21:13:23 UTC購入3912.91891XRP200003.0000000 51.1135049314066.86941 83.15937
33
1212JPYcoincheck302021-05-18 01:17:23 UTC売却263684JPY
34
77XRPcoincheck312021-05-18 01:17:23 UTC売却-6000XRP-263684.0000000 43.947333338066.86941 83.15937 -235272
35
1313JPYcoincheck322021-05-18 01:17:35 UTC購入-263684JPY
36
44XEMcoincheck332021-05-18 01:17:35 UTC購入14319.27445XEM263684.0000000 18.4146201614319.27445 18.41462
37
1414JPYcoincheck342021-05-21 09:22:11 UTC入金400000JPY
38
1515JPYcoincheck352021-05-21 12:38:06 UTC購入-38310JPY
39
11LTCcoincheck362021-05-21 12:38:06 UTC購入10LTC38310.0000000 383110.00000 3831.00000
40
1616JPYcoincheck372021-05-21 19:57:33 UTC購入-21527JPY
41
11LSKcoincheck382021-05-21 19:57:33 UTC購入200LSK21527.0000000 107.635200.00000 107.63500
42
1717JPYcoincheck392021-05-21 20:14:23 UTC購入-262026JPY
43
88XRPcoincheck402021-05-21 20:14:23 UTC購入6000XRP262026.0000000 43.67114066.86941 66.31623
44
22ETHcoincheck412021-05-22 05:20:42 UTC購入1.8ETH38999.0000000 21666.111113.62000 16289.77901
45
1818JPYcoincheck422021-05-22 05:20:42 UTC購入-38999JPY
46
1919JPYcoincheck432021-05-22 14:06:11 UTC購入-39138JPY
47
22ZECcoincheck442021-05-22 14:06:11 UTC購入0.69102ZEC39138.0000000 56638.013372.43102 24309.54908
48
2020JPYcoincheck452021-05-22 14:06:59 UTC売却422108JPY
49
55XEMcoincheck462021-05-22 14:06:59 UTC売却-14319.27445XEM-422108.0000000 29.478309220.00000 18.41462 158424
50
2121JPYcoincheck472021-05-22 14:07:20 UTC購入-422108JPY
51
33ZECcoincheck482021-05-22 14:07:20 UTC購入7.02ZEC422108.0000000 60129.344739.45102 50915.66836
52
77BTCcoincheck492021-05-22 14:12:51 UTC売却0.79811BTC3289564.4002300 4,121,6930.80646 4133675.83991
53
44ZECcoincheck502021-05-22 14:12:51 UTC売却-9.45102ZEC0.0000000 0.00000 #DIV/0!
54
88BTCcoincheck512021-05-22 14:14:07 UTC購入-0.80646BTC-3323980.5367800 4,121,6930.00000 4133675.83991 -9664
55
66XEMcoincheck522021-05-22 14:14:07 UTC購入6858.23646XEM146992.5820472 21.4336858.23646 21.43300
56
2222JPYcoincheck532021-05-25 23:52:20 UTC入金50000JPY
57
99BTCcoincheck542021-05-26 03:36:07 UTC購入0.16405BTC50000.0000000 304785.12650.16405 304785.12649
58
2323JPYcoincheck552021-05-26 03:36:07 UTC購入-50000JPY
59
2424JPYcoincheck562021-06-04 10:22:11 UTC入金100000JPY
60
33ETHcoincheck572021-06-04 13:47:10 UTC購入0.5ETH14443.0000000 288864.12000 17818.44660
61
2525JPYcoincheck582021-06-04 13:47:10 UTC購入-14443JPY
62
44ETHcoincheck592021-06-05 03:21:18 UTC購入1ETH28481.0000000 284815.12000 19900.97656
63
2626JPYcoincheck602021-06-05 03:21:18 UTC購入-28481JPY
64
2727JPYcoincheck612021-06-05 03:34:56 UTC購入-27491JPY
65
55ZECcoincheck622021-06-05 03:34:56 UTC購入1ZEC27491.0000000 274911.00000 #DIV/0!
66
2828JPYcoincheck632021-06-05 03:36:24 UTC購入-13444JPY
67
11REPcoincheck642021-06-05 03:36:24 UTC購入4REP13444.0000000 33614.00000 3361.00000
68
1010BTCcoincheck652021-06-06 03:36:41 UTC購入0.05047BTC16141.0000000 319813.75070.21452 308320.90248
69
2929JPYcoincheck662021-06-06 03:36:41 UTC購入-16141JPY
70
3030JPYcoincheck672021-06-06 23:32:15 UTC入金100000JPY
71
1111BTCcoincheck682021-06-07 00:09:24 UTC購入0.15BTC47999.0000000 319993.33330.36452 313124.10842
72
3131JPYcoincheck692021-06-07 00:09:24 UTC購入-47999JPY
73
11FCTcoincheck702021-06-07 11:30:09 UTC購入7FCT25896.0000000 3699.4285717.00000 3699.42857
74
3232JPYcoincheck712021-06-07 11:30:09 UTC購入-25896JPY
75
3333JPYcoincheck722021-06-07 12:36:17 UTC購入-15687JPY
76
22LSKcoincheck732021-06-07 12:36:17 UTC購入50LSK15687.0000000 313.74250.00000 148.85600
77
22FCTcoincheck742021-06-07 12:36:27 UTC購入2.93363FCT10418.0000000 3551.231759.93363 3655.66263
78
3434JPYcoincheck752021-06-07 12:36:27 UTC購入-10418JPY
79
3535JPYcoincheck762021-06-13 12:52:26 UTC入金50000JPY
80
3636JPYcoincheck772021-06-27 10:15:05 UTC購入-1428JPY
81
33LSKcoincheck782021-06-27 10:15:05 UTC購入5LSK1428.0000000 285.6255.00000 151.53725
82
33FCTcoincheck792021-06-27 10:15:37 UTC購入0.5FCT1404.0000000 280810.43363 3615.04098
83
3737JPYcoincheck802021-06-27 10:15:37 UTC購入-1404JPY
84
55ETHcoincheck812021-06-27 10:16:01 UTC購入0.05ETH1433.0000000 286605.17000 19985.68665
85
3838JPYcoincheck822021-06-27 10:16:01 UTC購入-1433JPY
86
66ETHcoincheck832021-06-27 14:23:14 UTC購入0.06ETH1547.0000000 25783.333335.23000 20052.19885
87
3939JPYcoincheck842021-06-27 14:23:14 UTC購入-1547JPY
88
4040JPYcoincheck852021-06-27 14:24:14 UTC購入-1233JPY
89
44LSKcoincheck862021-06-27 14:24:14 UTC購入5LSK1233.0000000 246.6260.00000 153.36538
90
44FCTcoincheck872021-06-27 14:24:43 UTC購入0.4FCT1012.0000000 253010.83363 3574.97902
91
4141JPYcoincheck882021-06-27 14:24:43 UTC購入-1012JPY
92
4242JPYcoincheck892021-06-27 14:26:01 UTC購入-1608JPY
93
66ZECcoincheck902021-06-27 14:26:01 UTC購入0.05ZEC1608.0000000 321601.05000 #DIV/0!
94
77ETHcoincheck912021-07-15 23:30:50 UTC購入0.2ETH4043.5000000 20217.55.43000 20058.28729
95
4343JPYcoincheck922021-07-15 23:30:50 UTC購入-4043.5JPY
96
88ETHcoincheck932021-07-16 08:36:13 UTC購入0.15ETH2736.1000000 18240.666675.58000 20009.42652
97
4444JPYcoincheck942021-07-16 08:36:13 UTC購入-2736.1JPY
98
11BCHcoincheck952021-08-01 12:16:09 UTCハードフォークによる入金0.36452BCH21877.0323200 60,0160.36452 60016.00000
99
99ETHcoincheck962021-08-10 11:20:17 UTC購入0.1ETH3431.9000000 343195.68000 20261.35563
100
4545JPYcoincheck972021-08-10 11:20:17 UTC購入-3431.9JPY