Updated for the NRS virtual asset guidelines of 31 July 2026. Live naira rates

Help centre

Uploading a CSV

The calculator reads your transactions from CSV files. Your file is read in your own browser. It is never uploaded to our servers.

Which files work

Each file must be 25 MB or smaller. You can add more than one file, for example one per exchange.

Filling in the template

The template has these columns:

date, type, asset, quantity, fiat_currency, fiat_amount, to_asset, to_quantity, usd_value, fee_fiat, exchange, tx_id, wht_withheld, category, note

The example rows in the template explain a few of them. For instance, on a buy, quantity is the net units credited after stamp duty, and fiat_amount is the total naira paid. On a staking reward, usd_value is the total US dollar value on the day you received it.

The transaction types the calculator understands are: buy, sell, swap, staking_reward, mining_reward, defi_reward, airdrop, hard_fork, airdrop_no_fmv, other_income, gift_received, transfer and ignore.

For a plain-English guide to every column and transaction type, see CSV columns and transaction types.

If your file layout is not recognised

You will see a message saying the layout is unrecognised, and a column mapping screen. On that screen:

  1. Tell NairaTally which column holds the date, the asset, the amount, and so on.
  2. Choose the date format: dd/mm or mm/dd. Please check this carefully. A wrong date format will give wrong results.
  3. Say what the values in the type or side column mean (for example, which value means a buy and which means a sell).

After loading, the calculator tells you how many transactions it read, how many rows it skipped and how many errors it found. Read these numbers before you go further.

Adding your NGN/USD exchange rates

The Guidelines say the dollar gain is converted to naira at the CBN/NAFEM rate on the transaction date. NairaTally does not fetch these rates for the calculator. You supply them.

  1. Upload a rate CSV with two columns: date and ngn_per_usd. A template is available in the calculator. You can also add or edit rows by hand.
  2. Type where the rates came from in the Rate source box. This is required, and it is printed on every report. NairaTally cannot verify your rates.
  3. If some swaps or rewards have no US dollar value, you can also upload a price table with three columns: date, asset, usd. Stablecoins are valued at their peg (1.00) unless you supply prices.

If some rows could not be priced

After you calculate, any rows that could not be priced or read are listed. The usual cause is a missing rate for a date. The calculator lists the missing dates. Add those rates, then recalculate. Until you fix them, the totals are not reliable.

Leaving the page to pay

The calculator may keep your parsed data, settings and rate table in your browser's session storage. This is so you do not lose your work if you leave to pay. If your data is too large to keep in the tab, the calculator will tell you, and you will need to upload it again when you come back.

Keep your own files

We never receive or store your transaction files. To run a report again later, you will need your CSVs and rate tables. Please keep them safe. The Guidelines also expect you to keep records: the report reminds you to keep your transaction records, rate and price sources and valuation notes for at least six years.

Please remember

The calculator works out estimates from the data you give it. If the data is wrong, the estimate will be wrong. It is not tax or investment advice. For questions about your own situation, please ask a qualified tax professional. Never send your transaction files to NairaTally support. We do not need them, and we will never ask for them.

Information only - not tax or legal advice. NairaTally is an independent software tool. It is NOT affiliated with, endorsed by or connected to the Nigeria Revenue Service or any government body. Results are estimates produced from the data you supply and from our reading of the published "Guidelines on the Taxation of Virtual Assets" (Information Circular No. 2026/21, 31 July 2026). They are information only and are not tax, legal or accounting advice. Some provisions are ambiguous and some inputs (rates, prices, withholding status) are supplied by you. You remain responsible for your own return.