Skip to main content

How to view and filter transactions

Learn how to use basic filters to quickly view specific transactions and how to use advanced filters for nuanced, sophisticated filtering using logical operators.

Written by Jack

You can view all the transactions imported to Koinly on the Transactions page.

If you want to view only a specific subset of transactions, you can filter the view using either basic or advanced filters - Koinly has some of the most advanced filtering capabilities in the crypto space.

Basic filters

"Basic" filters are the ready-to-use filters available at the top of the Transactions page:

Using the basic filters, you can filter by:

  • Specific wallet

    • Select more than one wallet to view transactions from those wallets only

  • Specific token

    • Select more than one currency to view transactions involving those tokens

  • Type of transaction

    • Available types: Deposit, Withdrawal, All trades, Fiat-to-crypto trades, Crypto-to-fiat trades, Crypto-to-crypto trades, Transfers, All Deposits (inc. fiat), All withdrawals (inc. fiat)

  • Tag

    • Select more than one tag to filter by transactions with those tags only

    • You can filter by any of the tags that exist in Koinly

    • You can also by "No tag", to only view transactions without any tag assigned

  • Manual

    • View only transactions that were added manually

  • Warnings

    • View only transactions that show one of the warnings: missing purchase history, missing prices, missing price on the acquisition

  • Dates

    • View only transactions that happened in a particular time period selected (from/to a specific date)

Advanced filters

These filters include over 20 different attributes to choose from, and can be chained together with OR and AND operators, allowing extremely precise and versatile filtering.

Advanced filters include:

  • Basic filters

    • You can filter by Wallet, Currency, Type, Tag and Date, just like Basic filters

    • With advanced filters you can apply more sophisticated conditions to those filters, like "is not", "has any value", etc.

  • Amounts

    • Filter by Net Value, Fee Value, Gain or Amount of the asset traded

    • Use number filters like "greater than", "less than", "between" etc.

  • Info

    • Filter by transactions' meta data, including Description, Destination, Source, Transaction hash, Contract, Contract function, Net value source, Net value source type

    • Use text filters like "contains", "does not contain", "starts with", etc.

  • Issues

    • Filter by warnings reported by Koinly on the transaction, including Missing cost basis, Missing purchase, Missing prices, Deleted, Spam

    • Missing cost basis and Missing purchase allow number filtering conditions the same as Amounts filters ("greater than", "less than", etc.)

    • Missing prices, Deleted, Spam are boolean filters (true/false)

  • Import

    • Filter by import source (a particular sync or file import) import type (whether it's a CSV, API, or manually added data) and import date

How to add advanced filters

To filter transactions using an advanced filter, click the "+ Add Filter" button below the Basic filters:

Filter chains

You can add multiple advanced filters at once using OR or AND operators. Add another filter by clicking the + at the end of the existing chain:

There's no limit to how many filters you can add in a chain.

By default, the AND operator is added, but you can switch it to OR by clicking on it:

Changing the operator for one condition within a chain changes it for all of them - so every filter can be only AND or only OR.

Filter groups

You can add another separate filter group for even more nuanced filtering. Add a second filter group by clicking the "+ Add Filter" button when you already have one group added:

You can think of filters as another set of rules in parenthesis.

You can have up to 10 filter groups set at once (and as many filters within each group as you need):

Each filter group can be added with OR or AND operator. Similarly to filter chains, you can click on the operator to switch between them:

Changing the operator for one group changes it for all of them - so every group filter can be only AND or only OR.

šŸ“Œ Examples

Expand to see examples of using filters and filter groups

  • View transactions involving ETH, BNB or MATIC only:

  • View transactions worth over $1000 and a calculated gain over $100

  • View transactions worth over $1000 or with a profit of over $100, but also these transactions need to be in "Binance Smart Chain (BNB)" wallet, and the date of the transaction needs to fall on Jan 1st 2023 until Aug 30th 2023:

Common questions and issues

My fiat deposits are missing when filtering

"Deposits" filter excludes fiat transactions - so if you have this filter on, fiat deposits will not show. If you want to view both crypto and fiat deposits, use the filter "All Deposits (inc. fiat)":

The same confusion may happen for withdrawals - to view fiat withdrawals, use "All Withdrawals (inc. fiat)"

Did this answer your question?