Sync Crypto Holdings to Your Spreadsheet

Connect Coinbase, Kraken, Gemini or Binance. Holdings, trades and balances land in Google Sheets, Notion, Airtable or Excel.

Read-only API keys. We never request withdrawal access.

Coinbase, Kraken and Gemini in one Airtable base, beside the checking account that funds them.

Read-only, from key to cell.

  1. 01

    Connect with OAuth or a read-only key

    Trading and withdrawal stay switched off, at the exchange.

    Kraken API key
    View balancesOn
    View tradesOn
    TradeOff
    WithdrawOff
  2. 02

    Pick what to sync

    Holdings, trades and balances, with staking and conversions as their own rows.

    HoldingsTradesBalances
    ETH staking rewardIncome
    USDC → BTCPaired trades
  3. 03

    Pick a destination

    One schema across every exchange, hourly on eligible plans.

    Google Sheets
    Notion
    AirtableHoldings table
    Excel

Crypto, start to finish.

Sync balances and holdings from every exchange.

Tax season, without the CSV downloads.

Timestamps, prices, units and exchange fees for every trade and conversion, backfilled and kept current. Hand the tab to your accountant or your tax tool; BankSync does not file.

Trades 2026 · Coinbase, Kraken, Gemini

DateAssetSideUnits
2026-01-04BTCBuy0.05
2026-01-12ETHBuy1.20
2026-02-03USDCConvert250.00
2026-02-21BTCSell0.02

Built for crypto, not bolted on.

Holdings
Asset, units, average cost, price and market value per exchange.
Trades
Buys, sells, conversions and staking, with exchange-side fees.
Tax fields
Cost basis, proceeds and acquisition dates.
Stablecoins
USDC, USDT and DAI use the same fields as any position.
With stocks
Crypto and brokerage holdings share one schema, so totals just work. Track your whole portfolio
Access
OAuth or read-only API keys. No withdrawal or trading permission, ever; a static IP range for exchanges that allow-list.

Questions, answered.

Which crypto exchanges does BankSync support?

Coinbase, Coinbase Advanced, Kraken, Gemini, Binance, Binance.US, Crypto.com, KuCoin, Bitstamp and Bitfinex. Contact us if you need another exchange.

How do I sync Coinbase to Google Sheets?

Connect Coinbase through OAuth or a read-only API key, choose Google Sheets as the destination, and pick a schedule. Holdings, trades and balances sync on every run.

Can I track crypto and stocks in the same spreadsheet?

Yes. Crypto and brokerage holdings share one schema, so one sheet shows BTC, ETH and USDC beside stocks and ETFs, and portfolio totals need no custom mapping.

Does BankSync handle staking, conversions and stablecoins?

Yes. Staking rewards land as income events, conversions appear as paired trade rows, and stablecoins use the same fields as any other asset.

What about crypto tax reporting?

BankSync syncs the trade timestamps, prices, fees and units tax tools need. Drop the history into your accountant’s template, CoinTracker or Koinly; BankSync does not file taxes.

Is connecting an exchange API key safe?

BankSync requests read-only scopes only, never withdrawal or trading permissions. Where the exchange supports IP allow-listing, a static IP range is provided.

Sync every exchange you use.