Accurate Cost Basis Tracking Is the Starting Point of Profit and Loss Management
To calculate investment gains and losses accurately, it is essential to properly record and manage the cost basis of each holding. When you purchase the same security in multiple transactions, the calculation method you use for cost basis affects the resulting profit or loss, which in turn impacts your tax liability. Under Japan's tax system, the "method equivalent to the simple average method" (moving average method) is applied by default for calculating capital gains on listed stocks, though you may elect the simple average method by filing a notification. With the moving average method, the average cost basis is recalculated with each purchase, while the simple average method computes the average unit cost across all purchases for the entire year.
If you use a tokutei koza (special tax-withholding account) at your brokerage, cost basis calculations are handled automatically. However, for transactions in a general account or across multiple brokerages, you need to manage records yourself. Additionally, when corporate actions such as stock splits, reverse splits, or share transfers occur, cost basis adjustments are required, making it critical to maintain accurate original purchase records.
Practical Differences Between the Moving Average and Simple Average Methods
With the moving average method, each time you purchase shares, the average cost basis is updated using the formula: (existing shares × existing average cost + new shares × new purchase price) / total shares. For example, if you buy 100 shares of Company A at 1,000 yen and later add 100 shares at 1,200 yen, the average cost basis becomes (100 × 1,000 + 100 × 1,200) / 200 = 1,100 yen. This method has the advantage of letting you track gains and losses in real time with each purchase. Books on stock investment taxation also explain in detail that the method you choose can change your annual capital gains amount, so it is important to select the approach that best fits your trading pattern.
Practical Systems for Maintaining Reliable Records
The most reliable way to maintain cost basis records is to develop the habit of logging the date, security name, number of shares, execution price, and fees in a spreadsheet after every transaction. Save your brokerage trade confirmations as PDFs and retain them for at least five years. Being unable to locate past transaction records when you need them for tax filing can lead to the risk of additional tax assessments.
Particular caution is needed when transferring from a NISA (Nippon Individual Savings Account) to a tokutei koza. The market value at the end of the NISA tax-exempt period becomes the new cost basis, so if the price has fallen below the original purchase price, the actual loss is not reflected in the cost basis. Books on NISA and tax filing can help you build a comprehensive record-keeping system that includes inter-account transfer records.
Next Steps to Start Managing Your Cost Basis
Start by downloading your past transaction history from your brokerage account and compiling a list of cost basis figures for each holding. Create a spreadsheet with columns for security name, purchase date, number of shares, execution price, fees, and moving average cost basis to get an accurate picture of your current holdings. Cross-check against your tokutei koza annual transaction report to confirm there are no discrepancies between the brokerage's calculations and your own records.
As a next step, establish a rule to update your spreadsheet every time you execute a trade. Also review in advance the rules for adjusting cost basis when stock splits or reverse splits occur. Use the compound interest calculator on this site to compute unrealized gain/loss ratios from your cost basis and current prices, and build the habit of regularly monitoring the profit and loss status of your entire portfolio.