Naar hoofdinhoud springen
Beancount.io LogoBeancount.io
219
Cryptocurrency Sjablonen en Voorbeelden

Cryptocurrency Sjablonen en Voorbeelden

Praktische Beancount sjablonen en real-world voorbeelden voor veelvoorkomende crypto scenario's, waaronder trading, mining, staking, airdrops en DeFi activiteiten.

Deze gids biedt praktische Beancount sjablonen en real-world voorbeelden voor veelvoorkomende cryptocurrency scenario's. Kopieer en pas deze sjablonen aan voor uw eigen crypto accounting behoeften.

Verken een live voorbeeld van een cryptocurrency-grootboek:

Basis Setup Sjabloon​

Accountstructuur Sjabloon​

; =============================================================================
; CRYPTOCURRENCY ACCOUNT SETUP TEMPLATE
; =============================================================================
 
; Exchange Accounts
1970-01-01 open Assets:Crypto:Coinbase:USD
1970-01-01 open Assets:Crypto:Coinbase:BTC
1970-01-01 open Assets:Crypto:Coinbase:ETH
1970-01-01 open Assets:Crypto:Binance:USD
1970-01-01 open Assets:Crypto:Binance:BTC
1970-01-01 open Assets:Crypto:Binance:ETH
1970-01-01 open Assets:Crypto:Binance:BNB
 
; Wallet Accounts
1970-01-01 open Assets:Crypto:Wallet:Ledger:BTC
1970-01-01 open Assets:Crypto:Wallet:Ledger:ETH
1970-01-01 open Assets:Crypto:Wallet:MetaMask:ETH
1970-01-01 open Assets:Crypto:Wallet:MetaMask:USDC
 
; DeFi Protocol Accounts
1970-01-01 open Assets:DeFi:Uniswap:ETH-USDC-LP
1970-01-01 open Assets:DeFi:Compound:cUSDC
1970-01-01 open Assets:Staking:Ethereum:ETH
 
; Income Accounts
1970-01-01 open Income:Crypto:Staking:ETH
1970-01-01 open Income:Crypto:Mining:BTC
1970-01-01 open Income:Crypto:Airdrops
1970-01-01 open Income:Crypto:DeFi:Yield
1970-01-01 open Income:CapitalGains:Crypto
 
; Expense Accounts
1970-01-01 open Expenses:Crypto:Fees:Trading
1970-01-01 open Expenses:Crypto:Fees:Network
1970-01-01 open Expenses:Crypto:Fees:Withdrawal
 
; Commodity Definitions
1970-01-01 commodity BTC
  name: "Bitcoin"
  asset-class: "cryptocurrency"
 
1970-01-01 commodity ETH
  name: "Ethereum"
  asset-class: "cryptocurrency"
 
1970-01-01 commodity USDC
  name: "USD Coin"
  asset-class: "stablecoin"

Trading Sjablonen​

Basis Cryptocurrency Aankoop​

; Template: Koop cryptocurrency op exchange
YYYY-MM-DD * "Koop [AMOUNT] [CRYPTO] op [EXCHANGE]"
  Assets:Crypto:[EXCHANGE]:[CRYPTO]     [AMOUNT] [CRYPTO] {[PRICE] USD}
  Assets:Crypto:[EXCHANGE]:USD         -[TOTAL_COST] USD
  Expenses:Crypto:Fees:Trading          [FEE] USD
  Assets:Crypto:[EXCHANGE]:USD         -[FEE] USD
 
; Example: Koop 1 BTC op Coinbase
2024-01-15 * "Koop 1 BTC op Coinbase"
  Assets:Crypto:Coinbase:BTC      1.0 BTC {45000.00 USD}
  Assets:Crypto:Coinbase:USD  -45000.00 USD
  Expenses:Crypto:Fees:Trading    50.00 USD
  Assets:Crypto:Coinbase:USD     -50.00 USD

Cryptocurrency Verkoop​

; Template: Verkoop cryptocurrency op exchange
YYYY-MM-DD * "Verkoop [AMOUNT] [CRYPTO] op [EXCHANGE]"
  Assets:Crypto:[EXCHANGE]:[CRYPTO]    -[AMOUNT] [CRYPTO] {[COST_BASIS] USD}
  Assets:Crypto:[EXCHANGE]:USD          [PROCEEDS] USD
  Expenses:Crypto:Fees:Trading          [FEE] USD
  Assets:Crypto:[EXCHANGE]:USD         -[FEE] USD
  Income:CapitalGains:Crypto            [GAIN] USD  ; of Expenses:CapitalLoss:Crypto
 
; Example: Verkoop 0.5 BTC met winst
2024-03-20 * "Verkoop 0.5 BTC op Coinbase"
  Assets:Crypto:Coinbase:BTC    -0.5 BTC {45000.00 USD}
  Assets:Crypto:Coinbase:USD   24000.00 USD
  Expenses:Crypto:Fees:Trading    30.00 USD
  Assets:Crypto:Coinbase:USD     -30.00 USD
  Income:CapitalGains:Crypto    1470.00 USD  ; 24000 - 22500 - 30

Crypto-naar-Crypto Trade​

; Template: Ruil de ene crypto voor de andere
YYYY-MM-DD * "Ruil [AMOUNT1] [CRYPTO1] voor [AMOUNT2] [CRYPTO2]"
  Assets:Crypto:[EXCHANGE]:[CRYPTO1]   -[AMOUNT1] [CRYPTO1] {[COST_BASIS] USD}
  Assets:Crypto:[EXCHANGE]:[CRYPTO2]    [AMOUNT2] [CRYPTO2] {[NEW_PRICE] USD}
  Income:CapitalGains:Crypto            [GAIN] USD  ; Belastbare gebeurtenis
  Expenses:Crypto:Fees:Trading          [FEE] USD
  Assets:Crypto:[EXCHANGE]:USD         -[FEE] USD
 
; Example: Ruil BTC voor ETH
2024-02-10 * "Ruil 1 BTC voor 20 ETH op Binance"
  Assets:Crypto:Binance:BTC     -1.0 BTC {46000.00 USD}
  Assets:Crypto:Binance:ETH      20 ETH {2400.00 USD}
  Income:CapitalGains:Crypto   2000.00 USD  ; 48000 - 46000
  Expenses:Crypto:Fees:Trading    40.00 USD
  Assets:Crypto:Binance:USD      -40.00 USD

Transfer Sjablonen​

Exchange naar Wallet Transfer​

; Template: Transfer crypto van exchange naar wallet
YYYY-MM-DD * "Transfer [AMOUNT] [CRYPTO] van [EXCHANGE] naar [WALLET]"
  Assets:Crypto:[EXCHANGE]:[CRYPTO]      -[AMOUNT] [CRYPTO] {[COST_BASIS] USD}
  Assets:Crypto:Wallet:[WALLET]:[CRYPTO]  [AMOUNT] [CRYPTO] {[COST_BASIS] USD}
  Expenses:Crypto:Fees:Withdrawal         [FEE] [CRYPTO] {[COST_BASIS] USD}
  Assets:Crypto:[EXCHANGE]:[CRYPTO]      -[FEE] [CRYPTO] {[COST_BASIS] USD}
 
; Example: Transfer BTC naar Ledger
2024-01-20 * "Transfer 1 BTC van Coinbase naar Ledger"
  Assets:Crypto:Coinbase:BTC      -1.0 BTC {45000.00 USD}
  Assets:Crypto:Wallet:Ledger:BTC  1.0 BTC {45000.00 USD}
  Expenses:Crypto:Fees:Withdrawal  0.0005 BTC {45000.00 USD}
  Assets:Crypto:Coinbase:BTC      -0.0005 BTC {45000.00 USD}

Cross-Exchange Transfer​

; Template: Transfer tussen exchanges
YYYY-MM-DD * "Transfer [AMOUNT] [CRYPTO] van [EXCHANGE1] naar [EXCHANGE2]"
  Assets:Crypto:[EXCHANGE1]:[CRYPTO]  -[AMOUNT] [CRYPTO] {[COST_BASIS] USD}
  Assets:Crypto:[EXCHANGE2]:[CRYPTO]   [AMOUNT] [CRYPTO] {[COST_BASIS] USD}
  Expenses:Crypto:Fees:Network         [FEE] [CRYPTO] {[COST_BASIS] USD}
  Assets:Crypto:[EXCHANGE1]:[CRYPTO]  -[FEE] [CRYPTO] {[COST_BASIS] USD}
 
; Example: Transfer ETH van Coinbase naar Binance
2024-02-05 * "Transfer 10 ETH van Coinbase naar Binance"
  Assets:Crypto:Coinbase:ETH   -10 ETH {2500.00 USD}
  Assets:Crypto:Binance:ETH     10 ETH {2500.00 USD}
  Expenses:Crypto:Fees:Network  0.01 ETH {2500.00 USD}
  Assets:Crypto:Coinbase:ETH   -0.01 ETH {2500.00 USD}

Staking Sjablonen​

Ethereum Staking​

; Template: Stake ETH
YYYY-MM-DD * "Stake [AMOUNT] ETH"
  Assets:Crypto:Wallet:MetaMask:ETH    -[AMOUNT] ETH {[PRICE] USD}
  Assets:Staking:Ethereum:ETH           [AMOUNT] ETH {[PRICE] USD}
  Expenses:Crypto:Fees:Network          [FEE] ETH {[PRICE] USD}
  Assets:Crypto:Wallet:MetaMask:ETH    -[FEE] ETH {[PRICE] USD}
 
; Example: Stake 32 ETH
2024-01-10 * "Stake 32 ETH op Ethereum 2.0"
  Assets:Crypto:Wallet:MetaMask:ETH    -32 ETH {2500.00 USD}
  Assets:Staking:Ethereum:ETH           32 ETH {2500.00 USD}
  Expenses:Crypto:Fees:Network          0.01 ETH {2500.00 USD}
  Assets:Crypto:Wallet:MetaMask:ETH    -0.01 ETH {2500.00 USD}

Staking Rewards​

; Template: Ontvang staking rewards
YYYY-MM-DD * "[CRYPTO] Staking Rewards - [PERIOD]"
  Assets:Staking:[PROTOCOL]:[CRYPTO]    [AMOUNT] [CRYPTO] {[PRICE] USD}
  Income:Crypto:Staking:[CRYPTO]        [VALUE] USD
 
; Example: ETH staking rewards
2024-02-01 * "ETH Staking Rewards - January"
  Assets:Staking:Ethereum:ETH     0.08 ETH {2600.00 USD}
  Income:Crypto:Staking:ETH      208.00 USD

DeFi Sjablonen​

Uniswap Liquidity Provision​

; Template: Voeg liquiditeit toe aan Uniswap pool
YYYY-MM-DD * "Voeg liquiditeit toe aan [TOKEN1]-[TOKEN2] pool"
  Assets:Crypto:Wallet:MetaMask:[TOKEN1]    -[AMOUNT1] [TOKEN1] {[PRICE1] USD}
  Assets:Crypto:Wallet:MetaMask:[TOKEN2]    -[AMOUNT2] [TOKEN2] {[PRICE2] USD}
  Assets:DeFi:Uniswap:[TOKEN1]-[TOKEN2]-LP   [LP_AMOUNT] [LP_TOKEN] {[LP_PRICE] USD}
  Expenses:Crypto:Fees:Network               [FEE] ETH {[ETH_PRICE] USD}
  Assets:Crypto:Wallet:MetaMask:ETH         -[FEE] ETH {[ETH_PRICE] USD}
 
; Example: Voeg ETH-USDC liquiditeit toe
2024-01-15 * "Voeg liquiditeit toe aan ETH-USDC pool"
  Assets:Crypto:Wallet:MetaMask:ETH     -10 ETH {2500.00 USD}
  Assets:Crypto:Wallet:MetaMask:USDC  -25000 USDC
  Assets:DeFi:Uniswap:ETH-USDC-LP        100 UNI-V3-ETH-USDC {500.00 USD}
  Expenses:Crypto:Fees:Network          0.02 ETH {2500.00 USD}
  Assets:Crypto:Wallet:MetaMask:ETH    -0.02 ETH {2500.00 USD}

Compound Lending​

; Template: Lever activa aan Compound
YYYY-MM-DD * "Lever [AMOUNT] [TOKEN] aan Compound"
  Assets:Crypto:Wallet:MetaMask:[TOKEN]  -[AMOUNT] [TOKEN]
  Assets:DeFi:Compound:c[TOKEN]           [C_AMOUNT] c[TOKEN] {[C_PRICE] USD}
  Expenses:Crypto:Fees:Network            [FEE] ETH {[ETH_PRICE] USD}
  Assets:Crypto:Wallet:MetaMask:ETH      -[FEE] ETH {[ETH_PRICE] USD}
 
; Example: Lever USDC aan Compound
2024-01-20 * "Lever 10000 USDC aan Compound"
  Assets:Crypto:Wallet:MetaMask:USDC  -10000 USDC
  Assets:DeFi:Compound:cUSDC             500 cUSDC {20.00 USD}
  Expenses:Crypto:Fees:Network          0.008 ETH {2500.00 USD}
  Assets:Crypto:Wallet:MetaMask:ETH    -0.008 ETH {2500.00 USD}

Mining Sjablonen​

Mining Rewards​

; Template: Ontvang mining rewards
YYYY-MM-DD * "[CRYPTO] Mining Reward - [POOL/SOLO]"
  Assets:Crypto:Mining:[CRYPTO]     [AMOUNT] [CRYPTO] {[PRICE] USD}
  Income:Crypto:Mining:[CRYPTO]     [VALUE] USD
 
; Example: Bitcoin mining reward
2024-01-15 * "BTC Mining Reward - Slush Pool"
  Assets:Crypto:Mining:BTC    0.01 BTC {45000.00 USD}
  Income:Crypto:Mining:BTC   450.00 USD

Mining Expenses​

; Template: Mining operationele kosten
YYYY-MM-DD * "Mining [EXPENSE_TYPE] - [PERIOD]"
  Expenses:Crypto:Mining:[EXPENSE_TYPE]  [AMOUNT] USD
  Assets:Checking                       -[AMOUNT] USD
 
; Example: Mining elektriciteitskosten
2024-01-31 * "Mining Elektriciteit - Januari"
  Expenses:Crypto:Mining:Electricity  800.00 USD
  Assets:Checking                    -800.00 USD

Airdrop Sjablonen​

Token Airdrops​

; Template: Ontvang token airdrop
YYYY-MM-DD * "[TOKEN] Airdrop van [PROJECT]"
  Assets:Crypto:Wallet:[WALLET]:[TOKEN]  [AMOUNT] [TOKEN] {[PRICE] USD}
  Income:Crypto:Airdrops                 [VALUE] USD
 
; Example: UNI token airdrop
2024-03-01 * "UNI Airdrop van Uniswap"
  Assets:Crypto:Wallet:MetaMask:UNI  400 UNI {8.00 USD}
  Income:Crypto:Airdrops            3200.00 USD

Geavanceerde Sjablonen​

Flash Loan Arbitrage​

; Template: Flash loan arbitrage
YYYY-MM-DD * "Flash loan arbitrage - [STRATEGY]"
  ; Flash loan
  Assets:Crypto:Temp:FlashLoan       [LOAN_AMOUNT] [TOKEN]
  Liabilities:DeFi:[PROTOCOL]:Flash -[LOAN_AMOUNT] [TOKEN]
  
  ; Arbitrage execution
  Assets:Crypto:Temp:FlashLoan      -[LOAN_AMOUNT] [TOKEN]
  Assets:Crypto:Temp:Arbitrage       [RETURN_AMOUNT] [TOKEN]
  
  ; Repay flash loan
  Liabilities:DeFi:[PROTOCOL]:Flash  [LOAN_AMOUNT] [TOKEN]
  Assets:Crypto:Temp:Arbitrage      -[LOAN_PLUS_FEE] [TOKEN]
  
  ; Profit
  Assets:Crypto:Wallet:[WALLET]:[TOKEN]  [PROFIT] [TOKEN]
  Income:Crypto:Arbitrage               [PROFIT_USD] USD

Cross-Chain Bridge​

; Template: Bridge activa over chains
YYYY-MM-DD * "Bridge [AMOUNT] [TOKEN] van [CHAIN1] naar [CHAIN2]"
  Assets:Crypto:[CHAIN1]:[TOKEN]     -[AMOUNT] [TOKEN] {[PRICE] USD}
  Assets:Crypto:[CHAIN2]:[TOKEN]      [AMOUNT] [TOKEN] {[PRICE] USD}
  Expenses:Crypto:Bridge:Fees         [FEE] [TOKEN] {[PRICE] USD}
  Assets:Crypto:[CHAIN1]:[TOKEN]     -[FEE] [TOKEN] {[PRICE] USD}
 
; Example: Bridge ETH naar Polygon
2024-02-05 * "Bridge 5 ETH van Ethereum naar Polygon"
  Assets:Crypto:Ethereum:ETH     -5 ETH {2600.00 USD}
  Assets:Crypto:Polygon:ETH       5 ETH {2600.00 USD}
  Expenses:Crypto:Bridge:Fees    0.01 ETH {2600.00 USD}
  Assets:Crypto:Ethereum:ETH    -0.01 ETH {2600.00 USD}

Belasting-Geoptimaliseerde Sjablonen​

Tax Loss Harvesting​

; Template: Tax loss harvesting
YYYY-MM-DD * "Tax loss harvesting - Verkoop [CRYPTO] met verlies"
  Assets:Crypto:[EXCHANGE]:[CRYPTO]    -[AMOUNT] [CRYPTO] {[HIGH_COST_BASIS] USD}
  Assets:Crypto:[EXCHANGE]:USD          [PROCEEDS] USD
  Expenses:Crypto:Fees:Trading          [FEE] USD
  Assets:Crypto:[EXCHANGE]:USD         -[FEE] USD
  Expenses:CapitalLoss:Crypto           [LOSS] USD
 
; Example: Harvest ADA loss
2024-12-15 * "Tax loss harvesting - Verkoop ADA met verlies"
  Assets:Crypto:Binance:ADA      -1000 ADA {0.60 USD}
  Assets:Crypto:Binance:USD       445.00 USD
  Expenses:Crypto:Fees:Trading      5.00 USD
  Assets:Crypto:Binance:USD        -5.00 USD
  Expenses:CapitalLoss:Crypto     150.00 USD

Lange Termijn Capital Gains​

; Template: Lange termijn capital gains verkoop
YYYY-MM-DD * "Lange termijn verkoop - [CRYPTO] gehouden > 1 jaar"
  date-acquired: "[PURCHASE_DATE]"
  holding-period: "[DAYS] days"
  Assets:Crypto:[EXCHANGE]:[CRYPTO]    -[AMOUNT] [CRYPTO] {[COST_BASIS] USD}
  Assets:Crypto:[EXCHANGE]:USD          [PROCEEDS] USD
  Expenses:Crypto:Fees:Trading          [FEE] USD
  Assets:Crypto:[EXCHANGE]:USD         -[FEE] USD
  Income:CapitalGains:LongTerm          [GAIN] USD
 
; Example: Lange termijn BTC verkoop
2025-02-01 * "Lange termijn verkoop - BTC gehouden 382 dagen"
  date-acquired: "2024-01-15"
  holding-period: "382 days"
  Assets:Crypto:Coinbase:BTC    -1.0 BTC {45000.00 USD}
  Assets:Crypto:Coinbase:USD   55000.00 USD
  Expenses:Crypto:Fees:Trading    50.00 USD
  Assets:Crypto:Coinbase:USD     -50.00 USD
  Income:CapitalGains:LongTerm  9950.00 USD

Reconciliatie Sjablonen​

Maandelijkse Balans Verificatie​

; Template: Maandelijkse balans asserties
YYYY-MM-DD balance Assets:Crypto:[EXCHANGE]:[CRYPTO]  [EXPECTED_BALANCE] [CRYPTO]
YYYY-MM-DD balance Assets:Crypto:Wallet:[WALLET]:[CRYPTO]  [EXPECTED_BALANCE] [CRYPTO]
 
; Example: Januari balans verificatie
2024-01-31 balance Assets:Crypto:Coinbase:BTC    2.5 BTC
2024-01-31 balance Assets:Crypto:Binance:ETH    15.0 ETH
2024-01-31 balance Assets:Crypto:Wallet:Ledger:BTC  1.0 BTC

Prijs Updates​

; Template: Dagelijkse prijs updates
YYYY-MM-DD price [CRYPTO] [PRICE] USD
 
; Example: Dagelijkse prijzen
2024-01-15 price BTC 45000.00 USD
2024-01-15 price ETH 2500.00 USD
2024-01-15 price ADA 0.50 USD

Gebruiksinstructies​

  1. Kopieer de relevante sjabloon voor uw transactietype
  2. Vervang placeholders (weergegeven in [HAAKJES]) met actuele waarden
  3. Pas accountnamen aan zodat ze overeenkomen met uw accountstructuur
  4. Voeg metadata toe indien nodig voor belastingaangifte of tracking
  5. Verifieer berekeningen voordat u de boekingen definitief maakt

Beste Praktijken​

  • Gebruik consistente naamgevingsconventies
  • Neem transactie-ID's op in metadata
  • Documenteer complexe transacties grondig
  • Verifieer wisselkoersen en prijzen
  • Onderhoud regelmatige back-ups van uw bestanden

Deze sjablonen bieden een solide basis voor cryptocurrency accounting in Beancount.io. Pas ze aan op basis van uw specifieke behoeften en trading patronen.

VorigeIndustry Specific SetupsVolgendeCryptocurrency Portfolio Tracking

Gerelateerde artikelen

11 min leestijd

Factuur e-mail sjablonen die sneller betaald krijgen: 5 bewezen voorbeelden

Vijf kant-en-klare e-mailsjablonen voor facturen—eerste factuur, herinnering…

invoicing
accounts-receivable