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
- Our generic template. Download it from the calculator ("Download generic CSV template") and fill it in. This is the most reliable option.
- Binance, Bybit and Luno-style exports. These are recognised on a best-effort basis.
- Anything else can be mapped column by column (see below).
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:
- Tell NairaTally which column holds the date, the asset, the amount, and so on.
- Choose the date format: dd/mm or mm/dd. Please check this carefully. A wrong date format will give wrong results.
- 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.
- Upload a rate CSV with two columns:
dateandngn_per_usd. A template is available in the calculator. You can also add or edit rows by hand. - 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.
- 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.