{"product_id":"crypto-cost-basis-tracker","title":"Crypto Cost Basis Tracker Spreadsheet","description":"\u003cp\u003eThis crypto cost basis tracker is for people who buy, sell and move coins and want a clear record of what each sell cost them. Log one row per trade or transfer, and every sell gets its cost basis worked out two ways, first in first out and average cost, with the gain beside each.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003ePlease read:\u003c\/strong\u003e This is a tracker tool only, not financial, tax, legal, medical or any other professional advice or advisory service. It records and calculates what you enter; you are solely responsible for checking all figures, rates, dates and results and for every decision you make. By purchasing, downloading or using it, you accept these terms (your statutory consumer rights are not affected).\u003c\/p\u003e\u003ch2\u003eThe dashboard\u003c\/h2\u003e\u003cp\u003eChoose all coins or any single coin, and the whole page follows. It fills itself from your trades.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eWhat your coins are worth at the prices you typed, against their cost\u003c\/li\u003e\n\u003cli\u003eMoney spent buying and received selling, month by month\u003c\/li\u003e\n\u003cli\u003eWhat each coin cost you and what it is worth now, with average buy price against the price now\u003c\/li\u003e\n\u003cli\u003eThe cost of the coins still held, month by month\u003c\/li\u003e\n\u003cli\u003eEvery fee you logged, and its share of what you traded\u003c\/li\u003e\n\u003cli\u003eThe value held on each exchange and in each wallet\u003c\/li\u003e\n\u003cli\u003eRealized gain each year counted both ways, and your latest sells with proceeds and gain\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eCost basis, two ways\u003c\/h2\u003e\u003cp\u003eEach row holds the date, the amount, the price in dollars and the fee. Every sell is costed first in, first out and at average cost, so you can see the crypto gains under each method side by side. Rows out of date order are flagged.\u003c\/p\u003e\u003ch2\u003eEvery coin\u003c\/h2\u003e\u003cp\u003eThe Cost Basis tab shows what you bought and sold of each coin, your average buy price, what you hold, what it is worth at your price and the unrealized gain so far. It works as a bitcoin tracker and covers every other coin in your crypto portfolio too.\u003c\/p\u003e\u003ch2\u003eEvery exchange and wallet\u003c\/h2\u003e\u003cp\u003eTransfers move coins between exchanges and wallets without touching cost, and the Exchanges tab shows how much sits where.\u003c\/p\u003e\u003ch2\u003eNothing connected\u003c\/h2\u003e\u003cp\u003eNo API keys and no logins: the file never connects to an exchange, and you type the price when you look. It is a crypto spreadsheet for your own records and a tidy crypto tax log to work from, not tax or investment advice.\u003c\/p\u003e\u003ch2\u003eSix connected tabs\u003c\/h2\u003e\u003cp\u003eStart Here, Setup, Trades, Cost Basis, Exchanges and Dashboard.\u003c\/p\u003e\u003ch2\u003eLight and dark editions\u003c\/h2\u003e\u003cp\u003eEvery download includes a light edition and a dark edition. Every tab is restyled, not only the dashboard, and both run on the same formulas, so you simply pick the look you prefer. Each edition comes filled with a worked example and as a blank copy, in Excel and in Google Sheets.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook you take a copy of, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo dynamic arrays, no macros, no add-ins and no subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eLight edition: the Excel workbook filled with a worked example (three years of crypto trades across four exchanges and wallets), and a blank one\u003c\/li\u003e\n\u003cli\u003eDark edition: the same two files in the dark design\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, which has one-click links to the Google Sheets versions (light and dark, filled and blank)\u003c\/li\u003e\n\u003cli\u003eThe terms of use as a PDF\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eYour files are ready to download as soon as payment clears. They are for personal and business use on your own devices, so please do not share or resell them. Questions before or after you buy? Use our contact page and we will help.\u003c\/p\u003e\u003ch2\u003eFrequently asked questions\u003c\/h2\u003e\u003ch3\u003eWill it work in Google Sheets?\u003c\/h3\u003e\u003cp\u003eYes. The download includes Excel workbooks for Excel 2016 or later on Windows or Mac, and the instruction guide has one-click links to copy the Google Sheets versions with a free Google account.\u003c\/p\u003e\u003ch3\u003eDoes it connect to my exchange or wallet?\u003c\/h3\u003e\u003cp\u003eNo. There are no API keys and no logins. You enter each trade and type the price when you look.\u003c\/p\u003e\u003ch3\u003eWhich cost basis methods does it use?\u003c\/h3\u003e\u003cp\u003eTwo: first in, first out and average cost. Every sell shows its cost basis and gain under both, side by side.\u003c\/p\u003e\u003ch3\u003eDo transfers between wallets count as sells?\u003c\/h3\u003e\u003cp\u003eNo. Transfers move coins between exchanges and wallets without touching cost, and the Exchanges tab shows how much sits where.\u003c\/p\u003e\u003ch3\u003eWhat is the difference between the light and dark editions?\u003c\/h3\u003e\u003cp\u003eOnly the look. Every tab is restyled with the same formulas, and both editions come with every download.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597876166750,"sku":"OPX-242","price":19.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/crypto-cost-basis-tracker-01.jpg?v=1790833311","url":"https:\/\/opxviashop.com\/products\/crypto-cost-basis-tracker","provider":"OPXVIA","version":"1.0","type":"link"}