Skip to main content

Command menu

Jump to a page or search the catalog

Spreadsheets & Calculators

Crypto Portfolio & P2P Cash-out Tracker - Google Sheets / Excel Template (FIFO, Multi-Wallet, GHS/NGN/KES)

Track every coin across every exchange and wallet, log your Binance/Bybit P2P cash-outs, and see FIFO cost basis, P&L and fees in USD and your local currency - in one clean dark-mode spreadsheet for Google Sheets and Excel.

$12.00

What you get: 1 file · 466.4 KB · ZIP

See purchase options

Product description

Spreadsheets for crypto usually stop at "buy" and "sell". Real life has USDT bought with mobile money, swaps on three exchanges, transfers to a hardware wallet, gas fees, staking rewards, and P2P cash-outs back to cedis, naira or shillings.

This template is built for that. You log each event once, and the sheet works out your holdings per coin and per wallet, your FIFO cost basis, realized and unrealized P&L, every fee you paid, and a year-end summary you can hand to your accountant.

WHAT'S INSIDE

  • Dashboard: total value in USD and your local currency, unrealized and realized P&L, fees paid, stablecoin share, P2P cash-outs, staking & airdrop income, plus 4 charts (allocation, P&L by coin, value vs net invested, monthly P2P orders).

  • Transactions log (1,000 rows): Buy, Sell, Swap In/Out, P2P Buy/Sell, Transfer, Fee, Airdrop, Staking Income, Opening Balance. Dropdowns for types, wallets and coins, and a built-in Check column that flags missing dates, unknown types, missing transfer wallets, missing prices and selling more than you hold.

  • Holdings: quantity, value, average buy price, FIFO remaining cost basis, unrealized & realized P&L and allocation per coin, plus a quantity-by-wallet matrix with a balance check.

  • Realized Gains (FIFO) worksheet: every disposal with proceeds, FIFO cost and gain/loss; open lots still held; and a year-end summary (gains, losses, net, income, fees) for the year you choose. Records for your accountant, not tax advice.

  • P2P Cash-out log (500 rows): platform, side, rate, fiat amount, payment method (MTN MoMo, Telecel Cash, AirtelTigo Money, M-Pesa, bank...), counterparty, order ID, status, and the spread vs a reference rate. Yearly and monthly totals, plus a reconciliation table that checks the log against your Transactions.

  • Fees log: fees by wallet and by type (all time and for the report year) and a list of every fee event.

  • Prices tab: type prices manually, or (Google Sheets only) paste the included CoinGecko or GOOGLEFINANCE formulas for live prices, with automatic fallback to your manual price.

  • History tab: monthly snapshots that drive the value-over-time chart.

  • Settings: choose GHS, NGN, KES, ZAR, EUR, GBP or USD as your local currency; edit your coin list (25), wallets/exchanges (12), P2P platforms and payment methods.

  • Start Here guide inside the file + a 2-page PDF quick-start guide.

  • Clearly marked sample data so you can see how everything works, then clear it in under a minute.

WHY THIS ONE

  • Multi-exchange AND multi-wallet: Binance, Bybit, OKX, KuCoin, Trust Wallet, MetaMask, Ledger, Phantom - or any you add.

  • USDT/USDC friendly: stablecoin share on the dashboard, and swaps such as "bought BTC with USDT" are handled properly as two legs.

  • Built for P2P markets: a dedicated cash-out log with local-currency rates and payment methods - something most portfolio templates don't have.

  • FIFO across all wallets, independent of row order (it sorts by date for you).

  • Local-currency view with one setting.

  • Works offline in Excel and LibreOffice; works in Google Sheets with optional live prices.

  • Clean dark design, frozen headers, protected formula tabs (no password - unprotect any time), no macros, no add-ons, no sign-ups.

FORMAT & COMPATIBILITY

  • 1 x .xlsx file (Microsoft Excel 2010+ / Microsoft 365, Google Sheets, LibreOffice Calc 7+)

  • 1 x PDF quick-start guide

  • No macros or scripts. Instant download.

PLEASE NOTE

  • This is a record-keeping template. You enter your own data; it does not connect to your exchange accounts or wallets.

  • Live prices via GOOGLEFINANCE/CoinGecko work in Google Sheets only and depend on those free services (which can be delayed or rate-limited). Manual prices always work.

  • Local-currency figures use one rate that you set. For year-end records your accountant may need the rate on each date.

DISCLAIMER

This product is a spreadsheet template for personal record-keeping only. It is not financial, investment, tax, accounting or legal advice, and it does not recommend buying, selling or holding any asset. The realized-gains and year-end figures are records for your accountant, not tax advice or a tax return, and nothing in this template files or submits anything to any authority. Rules differ by country and change over time - consult a qualified professional. Results depend on the data you enter; prices and exchange rates from live sources may be delayed or wrong. Crypto-assets are volatile and you can lose money. Sample data is fictional. Not affiliated with Binance, Bybit, OKX, KuCoin, CoinGecko or Google; names are used only to describe compatibility. Digital product - no physical item will be shipped.

What you get

1 file · 466.4 KB

  • CryptoSheets-Portfolio-P2P-Tracker.zipZIP · 466.4 KB
LicensePersonal use only
PublishedNov 15, 2026
File size466.4 KB
File formatZIP
Versionv1.0

Tags

crypto portfolio trackercrypto spreadsheetgoogle sheets templateexcel templateP2P trackerFIFO cost basisUSDT trackerBinance P2PGhanaNigeria
C
CryptoSheets Africa

Frequently asked questions

Do I get access instantly?

Yes. This is a digital product - you can download it right after checkout, straight from your library.

Can I use it for commercial projects?

Personal use only. Use it for yourself - not in work you sell or hand to a client - and do not resell or redistribute the file.

What's your refund policy?

You can request a refund within 30 days. If something isn't right, request it from your order and the Getly team reviews it.

What file formats and sizes will I get?

You'll download 1 file - ZIP - 466.4 KB in total.

Do I get free updates?

Yes - when the seller ships a new version, you can re-download the latest files from your library at no extra cost. Check the changelog for recent updates.

Price

$12.00