This page explains how to get trade history from GMO Coin.
【For those who have completed the file download.】
When uploading the downloaded files to cryptact, please upload them in order from the oldest transaction date. For more details, please refer to the help page below.
Contents
-
Our Support Status for GMO Coin
1-1．Types of transactions that can be retrieved
1-2．Time period that can be retrieved - Upload boxes and files
- How to get the statement CSV (trade history)
-
Deposit / Withdrawal History
4-1．Crypto deposit / send history
4-2．JPY deposit / withdrawal history - Store trade history (legacy format)
- How to paste into Excel
- Upload the GMO Coin file to cryptact
1．Our Support Status for GMO Coin
1-1．Types of transactions that can be retrieved
You can check the types of files supported by cryptact on the "Supported Exchanges & Blockchains" page. Please click on the relevant exchange to view the details.
Please refer to the following help page for the detailed status of supported transaction types.
Our Support Status for GMO Coin
If the uploaded file contains transaction details that can be interpreted by cryptact, the data will be automatically reflected. However, due to the specifications of certain exchanges, some files may lack transaction histories or contain unclear information, making automatic processing impossible. In such cases, if the transaction history is not supported via API or file upload, we kindly ask you to upload the data using a Custom File.
How to Create a Custom File
1-2．Time period that can be retrieved
According to the exchange’s specifications, data export via CSV is limited to the most recent five years. If you need transaction history from earlier periods, please check with the exchange's support desk on how to retrieve it, and then upload the history as a custom file.
2．Upload boxes and files
GMO Coin has five upload boxes. Depending on your transactions, please upload the following files to the corresponding upload boxes.
| Upload box | File to upload | How to get the file |
| GMO/取引履歴 (Trade History) | Statement CSV (yearly files for the most recent 5 years) | Section 3 |
| GMO/2017年度以前 (FY2017 and earlier) | File created by pasting the spot trade details from the 2017 "取引残高報告書" (PDF) | How to get trade history from GMO Coin (Fiscal year 2017 and prior) |
| GMO/現物売買履歴（旧形式） (Legacy Spot Trades) | Excel file created by copying the Store trade history | Section 5 |
| GMO/暗号資産預入・送付履歴 (Crypto deposits/sends) | Excel file created by copying the crypto deposit/send history | Section 4-1 |
| GMO/日本円入出金履歴 (JPY deposits/withdrawals) | Excel file created by copying the JPY deposit/withdrawal history | Section 4-2 |
If you upload files containing the same transactions to more than one upload box, the transactions will be duplicated. For "GMO/現物売買履歴（旧形式）" and "GMO/2017年度以前", please upload only transactions from periods not covered by the statement CSV (GMO/取引履歴).
3．How to get the statement CSV (trade history)
1. After logging in to GMO Coin, click on "CSV" under "明細(Statement)" in the menu bar on the left side of the screen.
2. For each fiscal year, click "CSVを作成する"(Create CSV).
*Files are downloaded in ZIP format for each fiscal year. Upload them in the order of older fiscal years to new.
3. Once the file is created, the button label changes to "CSVダウンロード"(Download CSV). Click the button.
4．Deposit / Withdrawal History
Transfers between your own accounts (deposits and withdrawals) do not affect your profit and loss, so they are not needed for the calculation. For this reason, "Import asset transfers (deposits/withdrawals)" in the ledger settings is turned off by default (for users who migrated from Gtax, it is turned on by default).
However, withdrawal fees (send fees) are reflected in cryptact for both crypto and fiat currencies, regardless of whether the setting is on or off.
Turn this setting on only if you want deposits and withdrawals to be reflected in the transaction list. For more details, please refer to the help page below.
Settings: Import Asset Transfers (Deposits/Withdrawals)
About deposits and withdrawals in the statement CSV
The statement CSV (downloaded in Section 3) also contains "暗号資産預入・送付" (crypto deposits/sends) and "日本円入出金" (JPY deposits/withdrawals) records, but cryptact currently does not import deposit and withdrawal records (including send fees) from the statement CSV. If you want to reflect deposits, withdrawals, or send fees, please upload the history files obtained with the steps below.
▼What each file reflects
| File | Reflected in the P&L calculation (regardless of the setting) |
Additionally shown in the transaction list when the setting is on (no effect on P&L) |
Upload |
| Crypto deposit/send history | Send fees (if recorded in the file) | Deposits / sends | Required if you paid send fees; otherwise optional |
| JPY deposit/withdrawal history | Withdrawal fees (if recorded in the file) * | Deposits / withdrawals | Required if you paid withdrawal fees; otherwise optional |
*JPY withdrawal fees are reflected as "send fees." Whether they affect your profit and loss depends on the "Expense transfer fees" ledger setting. For more details, please refer to the help page below.
How to Handle "Fees in Fiat Currency" during Deposits and Withdrawals
4-1．Crypto deposit / send history
1. Click "入出金" (Deposit/Withdrawal) → "暗号資産" (Crypto) in the left menu bar and select any coin.
2. Click "取引履歴" (Transaction History) at the top of the screen.
3. Select "全て" (All) for "授受区分" (Type), "ステータス" (Status) and "銘柄名" (Coin), specify the period under "期間" (Period), and click "検索" (Search).
*The maximum period you can specify is one year. If you have more than one year of history, repeat the steps for each period.
4. Copy all of the displayed history, including the header row from "受付日時" to "ステータス".
▼Crypto deposit/send history screen
5. Paste the copied history into Excel and save it, following the steps in 6. How to paste into Excel.
4-2．JPY deposit / withdrawal history
1. Click "入出金" (Deposit/Withdrawal) → "日本円" (JPY) in the left menu bar.
2. Click "取引履歴" (Transaction History) at the top of the screen.
3. Select "全て" (All) for "入出金区分" (Type), specify the period under "期間" (Period), and click "検索" (Search).
*The maximum period you can specify is one year. If you have more than one year of history, repeat the steps for each period.
4. Copy all of the displayed history, including the header row from "取消" to "ステータス".
▼JPY deposit/withdrawal history screen
5. Paste the copied history into Excel and save it, following the steps in 6. How to paste into Excel.
5．Store trade history (legacy format)
Use this method only if you have Store transactions in periods for which the statement CSV (Section 3) cannot be downloaded (such as 2017). Uploading history for the same period as the statement CSV will duplicate the transactions.
1. Click "販売所" (Store) in the left menu bar, then click "取引履歴" (Transaction History) at the top of the screen.
2. Select "全て" (All) for "売買区分" (Buy/Sell) and "銘柄名" (Coin), specify the period under "期間" (Period), and click "検索" (Search).
*The maximum period you can specify is one year.
3. Copy all of the displayed history, including the header row from "売買日時" to "約定ID".
▼Store trade history screen
4. Paste the copied history into Excel and save it, following the steps in 6. How to paste into Excel.
6．How to paste into Excel
Paste the history you copied in "4. Deposit / Withdrawal History" or "5. Store trade history (legacy format)" into Excel using the steps below, save it, and then upload it.
1. Open Excel and right-click cell "A1" on a new sheet.
2. From the paste options, select "Paste Values" or "Match Destination Formatting".
▼Pasting into Excel
3. Check that the data is split into cells and that the header is in the first row, then save the file in Excel Workbook (.xlsx) format.
7．Upload the GMO Coin file to cryptact
Select the exchange from this screen and upload each file to the matching upload box, referring to "2. Upload boxes and files."