StraitsChain Edu

Language

English 日本語

Currency

$ USD ¥ JPY HK$ HKD
Create Account
Crypto Gain/Loss Tracker Spreadsheet
Crypto Taxation & Accounting (Japan-Specific)

Crypto Gain/Loss Tracker Spreadsheet

A spreadsheet for recording crypto purchases, sales and swaps and calculating the gain or loss on each transaction in yen. It suits investors who want organised records throughout the year, so that preparing a tax return and reviewing the results of their decisions becomes easier.

Levels
4
Starting from
280 credits
Category
Crypto Taxation & Accounting (Japan-Specific)
Choose a level

About this material

This spreadsheet gives you a structured place to record every cryptocurrency transaction and see the resulting gain or loss. Separate sheets cover purchases, sales, coin-to-coin swaps and transfers between wallets, with columns for dates, quantities, prices in yen and fees. Formulas calculate the acquisition cost and profit for each disposal and roll the figures up into monthly and annual totals, while a short instruction sheet explains how to fill in each column and how to choose a cost calculation method. You can use it alongside the transaction histories from your exchanges to keep records complete and consistent. The tracker helps you understand where gains and losses come from, but it is a record-keeping tool, not tax advice. Check the current National Tax Agency guidance or a qualified professional before filing a return.
Each level is unlocked separately

Choose a level

Compare the levels below and add the one that suits you to your cart

01
Level 1

Beginner

280 credits

What this level includes

  • Covered in this level

    You will learn how to enter a purchase, a sale and a coin-to-coin swap, what date, quantity, price in yen and fee mean in each row, and how the spreadsheet works out a simple gain or loss.

  • Suited to

    This level is for investors who have never tracked their crypto trades in a spreadsheet and want a simple starting point. It explains what each column is for and why recording every trade matters.

  • What you will be able to apply

    You will be able to record your basic trades correctly, read the gain or loss for each transaction and keep the file up to date as you go. You will have a clear, simple record instead of scattered exchange statements.

02
Level 2

Intermediate

480 credits

What this level includes

  • Covered in this level

    You will study how the spreadsheet applies an average cost method, how to include fees properly, how to import or copy data from several exchanges, how to check totals against exchange reports and how to review gains by coin or by month.

  • Suited to

    This level suits investors who record trades regularly and want more accurate, useful results. It shows how to handle the details that make the difference between rough figures and reliable ones.

  • What you will be able to apply

    You will be able to keep accurate records across more than one exchange, check that your totals are consistent and see which assets have produced gains or losses. Preparing figures for a tax return will take far less effort.

03
Level 3

Advanced

780 credits

What this level includes

  • Covered in this level

    You will examine how to record transfers between your own wallets without creating false gains, how to log staking or lending rewards, how to handle missing prices or dates and how to trace errors through the formulas.

  • Suited to

    This level is for active investors whose records now include transfers, rewards and gaps that simple entries cannot handle. It explains how to keep the spreadsheet reliable as activity becomes more complex.

  • What you will be able to apply

    You will be able to maintain a complex record that still produces sensible results, investigate and fix errors on your own and document the decisions you made about unclear entries. Your figures will stand up better to careful review.

04
Level 4

Expert

1,080 credits

What this level includes

  • Covered in this level

    You will bring together cost methods, multi-exchange data, transfers, rewards and reconciliation, and weigh the trade-offs between a spreadsheet and dedicated software. The results are for your own records and are not tax advice, so rules should be checked each year.

  • Suited to

    This level is for experienced investors who want the tracker to become a dependable year-round system rather than a once-a-year task. It focuses on design choices, checks and habits that keep records trustworthy.

  • What you will be able to apply

    You will be able to run a complete, well-checked tracking system, adapt it as your activity changes and explain your figures clearly to a tax professional. You will also use the results to review your own investment decisions honestly.

Levels are unlocked with credits from your balance. You can add more credits at any time.