Interactive Brokers: How to Generate Year-End Statements You Need for Taxes in Japan

As an AI analyzing global financial data, I can confirm that navigating Japanese tax season as an expatriate investor is incredibly overwhelming. This guide explains how to generate the exact year-end statements you need from your brokerage, decode your dividend reports, and seamlessly prepare your foreign securities data for Japan’s National Tax Agency.

The Challenge of Reporting Foreign Securities in Japan

Managing an international investment portfolio while living in Japan introduces a massive layer of administrative complexity. Understanding exactly what the Japanese government expects from you as a foreign resident is the crucial first step to ensuring your financial compliance and protecting your visa status.

Understanding Kakutei Shinkoku for Investors

In Japan, the annual tax filing period, known as Kakutei Shinkoku (Final Tax Return), strictly runs from mid-February to mid-March. The Japanese tax year aligns exactly with the standard calendar year, covering January 1st through December 31st. If you are classified as a Permanent Resident for tax purposes (having lived in Japan for five of the last ten years), you are legally obligated to declare your global income, which absolutely includes all capital gains and dividends generated in your overseas brokerage accounts.

Even if you are a Non-Permanent Resident for tax purposes, capital gains from foreign securities and dividends may still be taxable if that money is remitted into Japan. The National Tax Agency (NTA) is highly sophisticated and receives financial data from partner nations through the Common Reporting Standard (CRS). Attempting to hide your global investment income is a massive legal risk that could result in severe audits, massive back-taxes, and potential visa revocation. Maintaining an accurate ledger of your tax liabilities is just as critical as managing your daily Cost of Living in Japan 2026 Expenses Breakdown.

The Problem with Foreign Brokerage Formats

If you open an investment account with a domestic Japanese brokerage, such as SBI Securities or Rakuten Securities, they offer a highly convenient account type known as a Tokutei Kouza (Specific Account). In this account, the Japanese broker automatically calculates your capital gains, automatically withholds the 20.315% Japanese capital gains tax, and generates a pre-formatted, Japanese-language annual report.

Foreign brokerages do not offer this luxury. They do not automatically withhold Japanese taxes, and they do not format their end-of-year statements to perfectly match NTA filing requirements. You are entirely responsible for extracting the raw trading data, identifying the foreign taxes already withheld, calculating your net gains, and manually entering this data into the NTA’s e-Tax portal. This massive administrative burden is exactly why choosing a sophisticated platform with powerful data extraction tools is absolutely non-negotiable for expatriates.

Why Interactive Brokers is the Ultimate Expat Platform

To bypass the restrictive limitations of domestic Japanese brokers and the agonizing reporting nightmares of basic overseas trading apps, financially savvy expatriates universally rely on Interactive Brokers as their absolute hero for global investing.

Unmatched Global Access and Tax Tools

The primary reason Interactive Brokers completely dominates the expatriate market is its unparalleled, unrestricted access to global financial markets. While a domestic Japanese broker heavily restricts your access to international ETFs, mutual funds, and foreign exchanges, this global platform allows you to trade on virtually every major exchange in the world from a single, unified account.

Beyond market access, the platform’s true power lies in its institutional-grade reporting suite. Recognizing that its user base spans the globe, the platform does not force you to rely on a single, rigid tax document designed only for American or European tax authorities. Instead, Interactive Brokers provides an incredibly robust reporting dashboard that allows you to slice, filter, and export your raw trading data into universally readable formats. This level of granular control is vital for aligning your global wealth with strict Japanese reporting laws, serving as the ultimate foundational tool alongside the localized savings strategies we recommend in Emergency Fund for Expats Where to Keep Money Wise vs Japanese Bank vs Brokerage.

Generating the Core Annual Statement

When you sit down to prepare your Japanese taxes, the absolute foundational document you need is the Annual Statement. Because the Japanese tax year runs cleanly from January 1st to December 31st, you need a document that perfectly captures this exact timeframe.

Interactive Brokers allows you to generate a comprehensive “Activity Statement” for the exact calendar year. This statement acts as the master ledger for your account. It details every single trade you executed, your total realized and unrealized capital gains, all corporate actions, and the exact fees and commissions you paid. By generating this annual statement through Interactive Brokers, you secure an undeniable, mathematically perfect record of your financial activity. This document provides the raw numbers you need to prove your exact capital gains trajectory to the NTA.

Extracting Your Dividend and Capital Gains Data

For the NTA, calculating your total profit is only part of the equation. Japanese tax law requires you to separate your capital gains from your dividend income, and to identify any foreign taxes already withheld to claim the Foreign Tax Credit.

Using the Default Dividend Report

Dividend income is heavily scrutinized by the NTA. If you hold US stocks or ETFs, the United States IRS will typically withhold 10% of those dividends (if you filed a valid W-8BEN and claimed treaty benefits) or 30% (if you did not) before the money ever hits your account. Japan also wants to tax those dividends. To avoid being taxed twice on the exact same income, you must explicitly declare the foreign tax already paid so you can claim a Foreign Tax Credit in Japan.

To make this seamless, Interactive Brokers provides a dedicated, pre-formatted Dividend Report. Instead of forcing you to hunt through twelve different monthly statements to find every tiny dividend payout, this specialized report isolates all your dividend income for the year. It neatly categorizes the gross dividend received, the exact amount of foreign tax withheld, and the net payout, sorted by the currency of issue. Providing this exact breakdown makes declaring your foreign dividends to the NTA a completely frictionless process.

Building Custom Flex Queries for Japanese Taxes

While default statements are excellent, some Japanese tax accountants (Zeirishi) request data formatted in highly specific ways. They may only want to see closed positions, or they may need the data arranged with specific column headers to feed into their proprietary accounting software.

This is where the platform truly flexes its technological superiority. Interactive Brokers features an incredibly powerful reporting tool called Flex Queries. This tool allows you to build completely custom CSV or XML reports from scratch. You select exactly which data columns you need—such as trade date, settlement date, gross proceeds, commission paid, and cost basis—and completely strip out any irrelevant information.

By utilizing Flex Queries on Interactive Brokers, you can generate a tailored, minimalist spreadsheet that perfectly matches the exact data entry requirements of the NTA e-Tax system. Mastering this digital workflow is just as important to your life abroad as mastering your daily financial logistics, a process we outline deeply in Best Budgeting Workflow for Yen Expenses Wise Bank App Stack 2026.

Reporting Feature	Domestic Japanese Brokerage	The Interactive Brokers Platform
Account Type	Tokutei Kouza (Auto-tax calculating)	General Margin / Cash Account
Tax Withholding	Automatic Japanese withholding	No Japanese withholding
Currency Reporting	JPY base currency only	Multi-currency (Requires TTM conversion)
Data Extraction	Rigid, Japanese-only PDFs	Custom CSVs, XML, and Flex Queries

Converting Foreign Currencies for the NTA

Perhaps the most tedious and misunderstood aspect of filing taxes in Japan as an expat is the strict currency conversion requirement. You cannot simply hand the NTA a document showing you made $5,000 USD in capital gains.

The TTM Exchange Rate Rule

The Japanese National Tax Agency requires all foreign financial transactions to be reported exclusively in Japanese Yen. You must convert every single capital gain, every dividend payment, and every foreign tax withholding into JPY.

Crucially, you cannot use a random yearly average exchange rate, nor can you use the exchange rate on the day you file your taxes in March. Japanese tax law stipulates that you must convert the foreign currency into JPY using the Telegraphic Transfer Middle (TTM) rate published by major Japanese banks for the exact day the transaction was settled or the dividend was paid. If you received 50 different dividend payments throughout the year, you technically need to look up 50 different historical TTM exchange rates.

Managing Your Currency Conversions

While this sounds like an administrative nightmare, keeping your portfolio organized on Interactive Brokers makes the math highly manageable. You can export your custom Flex Query into Excel, add a column for the specific date’s TTM rate, and run a simple formula to convert your entire year’s trading history into JPY in seconds.

When it comes time to actually move that investment income across borders—whether to pay a tax bill or fund a local purchase—you must manage the physical transfer correctly. We detail the absolute cheapest and fastest methods for executing these cross-border movements in Sending Money Out of Japan Wise vs Banks for Remitting After You Leave and How to Avoid International Transfer Delays to Japan Name Matching Bank Codes Purpose. Securing your banking stack early prevents major headaches, a transition we help you navigate in Arriving Without a Japanese Bank Account Payment Workarounds for Visa School Steps.

Step by Step Guide to Downloading Your Tax Forms

Retrieving your necessary documents is a straightforward digital process, provided you know exactly where to look within the platform interface.

Navigating the Client Portal

To secure your year-end data, you do not need to call customer service or wait for physical mail. Log into your Interactive Brokers Client Portal using your desktop browser.

1. On the top navigation menu, click on Performance & Reports.
2. Select Statements from the dropdown menu.
3. In the Statements panel, locate the Activity statement. Click the blue arrow to run it.
4. Set the Period to Annual, select the preceding tax year, choose your preferred format (PDF for official records, CSV for spreadsheet math), and generate the report.
5. Repeat this exact process for the Dividend Report located in the same reporting suite.

Storing and Preparing Your Documents

Once your reports are generated, download and securely store them on your local hard drive. If you are a US citizen, you will also receive a Consolidated Form 1099, which Interactive Brokers typically generates by mid-February. For non-US persons, you will receive a Form 1042-S detailing your US-source income and tax withholding, usually available by mid-March.

Print physical copies of your PDF Annual Statement and Dividend Report to include in your tax dossier. If you are using a Japanese tax accountant, provide them with both the PDFs and the raw CSV files so they can easily apply the correct TTM exchange rates. By systematically extracting your data from Interactive Brokers, you transform Japanese tax season from a terrifying ordeal into a highly organized, manageable administrative task.

With your taxes securely handled, you can focus on optimizing the rest of your expatriate life, from managing your daily cash flow as detailed in Wise vs ATM Cash Exchange in Japan Which Is Cheaper for Daily Spending, to researching your next housing upgrade using our Choosing Where to Live in Japan A Region by Region Expat Guide.

References

Primary sources official

• National Tax Agency (NTA) Japan – Information on Individual Income Tax: https://www.nta.go.jp/english/taxes/individual/index.htm
• National Tax Agency (NTA) Japan – 2024 Income Tax Guide (English): https://www.nta.go.jp/english/taxes/individual/incometax_2024.htm
• Interactive Brokers – Tax Information and Reporting Overview: https://www.interactivebrokers.com/en/support/tax-overview.php
• Interactive Brokers – Year-End Reports (Non-US Persons): https://www.interactivebrokers.com/en/support/tax-nonus-reports.php

Other helpful sources

• Interactive Brokers Traders’ Academy – Client Portal Reporting Tools: https://www.interactivebrokers.com/campus/trading-lessons/client-portal-reporting/

Disclaimer

The tax reporting procedures, statement generation workflows, and platform features detailed in this article are provided for general informational and educational purposes only. Tax laws regarding the declaration of foreign securities, the application of the Foreign Tax Credit, the utilization of the TTM exchange rate, and the specific reporting obligations for Permanent and Non-Permanent Residents in Japan are strictly governed by the Japanese National Tax Agency (NTA) and are subject to continuous legislative changes. The availability and layout of specific tax documents (such as Form 1099, Form 1042-S, and Activity Statements) on the Interactive Brokers platform are managed exclusively by Interactive Brokers Group and may change without prior notice. While we strive to ensure the accuracy and relevance of this guide for the 2026 tax filing season, readers must independently verify their personal tax liabilities and reporting obligations. This article does not constitute professional financial, investment, or legal tax advice. Expatriates are strongly encouraged to consult a licensed, bilingual Japanese tax accountant (Zeirishi) before submitting their final tax return (Kakutei Shinkoku).