Balance by Currency

Dominic Willcock

Modified on: Fri, 23 Jan, 2026 at 3:40 PM

TL;DR: The 'Balance by Currency' section in CoinTracking presents a detailed breakdown of all transactions (purchases and sales) grouped by currency and aggregated over time (e.g., daily, weekly, monthly, or yearly). This is especially useful for analyzing trading activity and value development per currency.

1. Navigation and Filters

At the top of the section, several filters help tailor the displayed data:

Grouped by: Choose to group transactions by day, week, month, or year.
Currency Display: Toggle between viewing balances in EUR or BTC.
Currency Type Filter: Select whether to show all currencies or only digital, commodities, or fiat currencies.
Advanced Filter Options: Control transaction types (incoming/outgoing), exchange accounts, groups, and date ranges. These allow you to isolate specific asset behaviors, like spot vs futures or staking vs margin trades.

2. Chart Overview

Each currency includes a bar chart:

Blue bars represent purchase values (input) in EUR.
Red bars indicate sales (output) in EUR.
Hovering over bars shows specific EUR values for that time segment.

This visual representation helps quickly spot trends, such as spikes in trading or changes in holding strategies.

3. Transaction Table Explained

Below each chart is a detailed table with monthly summaries:

Column	Description
Month	The corresponding period of the grouped data.
Purchases and Inputs	Count of incoming transactions.
Sales and Outputs	Count of outgoing transactions.
Sum Tx	Total number of transactions that month.
Purchase and Input Amount	Total volume of assets acquired (e.g., 0KN2, 1INCH, EUR, USD).
Sales and Output Amount	Volume of assets sold.
Purchase and Input Value	EUR value of purchases.
Sales and Output Value	EUR value of sales.
Difference	Net change in EUR (Sales - Purchases).
Trade Volume	Sum of purchase and sales values.

This granular detail helps users track individual asset movement over time.

4. Export Options

Users can export the displayed data in various formats:

Copy/Print Table: For quick clipboard use or physical copies.
PDF, CSV, Excel: Suitable for backup, sharing, or detailed spreadsheet analysis.

5. Usage Example: ETH

From the visual and tabular data:

In August 2023, ETH purchases totaled 263.02 EUR, while sales totaled 267.10 EUR.
That month included multiple trades with a net difference of -4.08 EUR.
This indicates ETH was sold slightly above its acquisition cost, showing a minor realized gain.

This section helps track asset flow and compute realized gains/losses over time.

6. Final Notes

This tool is particularly helpful for tax reporting and profit/loss analysis.
Negative values in the "Difference" column imply sales exceeded purchases (potential capital gains).
Use the filters to isolate behaviors by coin, exchange, or time period.

For ongoing tracking or historical comparisons, this section provides both a macro and micro-level view of your portfolio's transactional history.

English