Plantilles i exemples de criptomoneda
Aquesta guia proporciona plantilles pràctiques de Beancount i exemples del món real per a escenaris comuns de criptomoneda. Copieu i adapteu aquestes plantilles per a les vostres pròpies necessitats de comptabilitat de criptomonedes.
Plantilla de configuració bàsica
Plantilla d'estructura de compte
; =============================================================================
; PLANTILLA DE CONFIGURACIÓ DEL COMPTE DE CRIPTOMONEDA
; =============================================================================
; Comptes de borsa
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
; Comptes de moneder
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
; Comptes de protocol DeFi
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
; Comptes d'ingressos
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
; Comptes de despeses
1970-01-01 open Expenses:Crypto:Fees:Trading
1970-01-01 open Expenses:Crypto:Fees:Network
1970-01-01 open Expenses:Crypto:Fees:Withdrawal
; Definicions de productes bàsics
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"
Plantilles de comerç
Compra bàsica de criptomoneda
; Plantilla: Comprar criptomoneda a la borsa
YYYY-MM-DD * "Comprar [AMOUNT] [CRYPTO] a [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
; Exemple: Comprar 1 BTC a Coinbase
2024-01-15 * "Comprar 1 BTC a 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
Venda de criptomoneda
; Plantilla: Vendre criptomoneda a la borsa
YYYY-MM-DD * "Vendre [AMOUNT] [CRYPTO] a [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 ; o Expenses:CapitalLoss:Crypto
; Exemple: Vendre 0.5 BTC amb guany
2024-03-20 * "Vendre 0.5 BTC a 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
Comerç de cripto a cripto
; Plantilla: Canviar una cripto per una altra
YYYY-MM-DD * "Canviar [AMOUNT1] [CRYPTO1] per [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 ; Esdeveniment taxable
Expenses:Crypto:Fees:Trading [FEE] USD
Assets:Crypto:[EXCHANGE]:USD -[FEE] USD
; Exemple: Canviar BTC per ETH
2024-02-10 * "Canviar 1 BTC per 20 ETH a 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
Plantilles de transferència
Transferència de la borsa al moneder
; Plantilla: Transferir cripto de la borsa al moneder
YYYY-MM-DD * "Transferir [AMOUNT] [CRYPTO] de [EXCHANGE] a [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}
; Exemple: Transferir BTC a Ledger
2024-01-20 * "Transferir 1 BTC de Coinbase a 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}
Transferència entre borses
; Plantilla: Transferir entre borses
YYYY-MM-DD * "Transferir [AMOUNT] [CRYPTO] de [EXCHANGE1] a [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}
; Exemple: Transferir ETH de Coinbase a Binance
2024-02-05 * "Transferir 10 ETH de Coinbase a 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}
Plantilles d'staking
Staking d'Ethereum
; Plantilla: Fer staking d'ETH
YYYY-MM-DD * "Fer staking de [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}
; Exemple: Fer staking de 32 ETH
2024-01-10 * "Fer staking de 32 ETH a 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}
Recompenses d'staking
; Plantilla: Rebre recompenses d'staking
YYYY-MM-DD * "[CRYPTO] Recompenses d'staking - [PERIOD]"
Assets:Staking:[PROTOCOL]:[CRYPTO] [AMOUNT] [CRYPTO] {[PRICE] USD}
Income:Crypto:Staking:[CRYPTO] [VALUE] USD
; Exemple: Recompenses d'staking d'ETH
2024-02-01 * "Recompenses d'staking d'ETH - Gener"
Assets:Staking:Ethereum:ETH 0.08 ETH {2600.00 USD}
Income:Crypto:Staking:ETH 208.00 USD
Plantilles de DeFi
Provisió de liquiditat Uniswap
; Plantilla: Afegir liquiditat al pool d'Uniswap
YYYY-MM-DD * "Afegir liquiditat al pool de [TOKEN1]-[TOKEN2]"
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}
; Exemple: Afegir liquiditat ETH-USDC
2024-01-15 * "Afegir liquiditat al pool ETH-USDC"
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}
Préstec Compound
; Plantilla: Subministrar actius a Compound
YYYY-MM-DD * "Subministrar [AMOUNT] [TOKEN] a 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}
; Exemple: Subministrar USDC a Compound
2024-01-20 * "Subministrar 10000 USDC a 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}
Plantilles de mineria
Recompenses de mineria
; Plantilla: Rebre recompenses de mineria
YYYY-MM-DD * "[CRYPTO] Recompensa de mineria - [POOL/SOLO]"
Assets:Crypto:Mining:[CRYPTO] [AMOUNT] [CRYPTO] {[PRICE] USD}
Income:Crypto:Mining:[CRYPTO] [VALUE] USD
; Exemple: Recompensa de mineria de Bitcoin
2024-01-15 * "Recompensa de mineria de BTC - Slush Pool"
Assets:Crypto:Mining:BTC 0.01 BTC {45000.00 USD}
Income:Crypto:Mining:BTC 450.00 USD
Despeses de mineria
; Plantilla: Despeses operatives de mineria
YYYY-MM-DD * "Mineria [EXPENSE_TYPE] - [PERIOD]"
Expenses:Crypto:Mining:[EXPENSE_TYPE] [AMOUNT] USD
Assets:Checking -[AMOUNT] USD
; Exemple: Costos d'electricitat de la mineria
2024-01-31 * "Electricitat de mineria - Gener"
Expenses:Crypto:Mining:Electricity 800.00 USD
Assets:Checking -800.00 USD
Plantilles d'Airdrop
Airdrops de tokens
; Plantilla: Rebre airdrop de tokens
YYYY-MM-DD * "[TOKEN] Airdrop de [PROJECT]"
Assets:Crypto:Wallet:[WALLET]:[TOKEN] [AMOUNT] [TOKEN] {[PRICE] USD}
Income:Crypto:Airdrops [VALUE] USD
; Exemple: Airdrop de token UNI
2024-03-01 * "Airdrop d'UNI d'Uniswap"
Assets:Crypto:Wallet:MetaMask:UNI 400 UNI {8.00 USD}
Income:Crypto:Airdrops 3200.00 USD
Plantilles avançades
Arbitratge de préstec llampec
; Plantilla: Arbitratge de préstec llampec
YYYY-MM-DD * "Arbitratge de préstec llampec - [STRATEGY]"
; Préstec llampec
Assets:Crypto:Temp:FlashLoan [LOAN_AMOUNT] [TOKEN]
Liabilities:DeFi:[PROTOCOL]:Flash -[LOAN_AMOUNT] [TOKEN]
; Execució de l'arbitratge
Assets:Crypto:Temp:FlashLoan -[LOAN_AMOUNT] [TOKEN]
Assets:Crypto:Temp:Arbitrage [RETURN_AMOUNT] [TOKEN]
; Reemborsar el préstec llampec
Liabilities:DeFi:[PROTOCOL]:Flash [LOAN_AMOUNT] [TOKEN]
Assets:Crypto:Temp:Arbitrage -[LOAN_PLUS_FEE] [TOKEN]
; Benefici
Assets:Crypto:Wallet:[WALLET]:[TOKEN] [PROFIT] [TOKEN]
Income:Crypto:Arbitrage [PROFIT_USD] USD
Pont entre cadenes
; Plantilla: Actius de pont entre cadenes
YYYY-MM-DD * "Pont [AMOUNT] [TOKEN] de [CHAIN1] a [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}
; Exemple: Pont d'ETH a Polygon
2024-02-05 * "Pont de 5 ETH d'Ethereum a 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}
Plantilles optimitzades per a impostos
Cosecha de pèrdues fiscals
; Plantilla: Cosecha de pèrdues fiscals - Vendre [CRYPTO] amb pèrdues
YYYY-MM-DD * "Cosecha de pèrdues fiscals - Vendre [CRYPTO] amb pèrdues"
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
; Exemple: Cosecha de pèrdues d'ADA
2024-12-15 * "Cosecha de pèrdues fiscals - Vendre ADA amb pèrdues"
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
Guanys de capital a llarg termini
; Plantilla: Venda de guanys de capital a llarg termini
YYYY-MM-DD * "Venda a llarg termini - [CRYPTO] mantingut > 1 any"
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
; Exemple: Venda de BTC a llarg termini
2025-02-01 * "Venda a llarg termini - BTC mantingut 382 dies"
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
Plantilles de reconciliació
Verificació mensual del saldo
; Plantilla: Asseveracions mensuals del saldo
YYYY-MM-DD balance Assets:Crypto:[EXCHANGE]:[CRYPTO] [EXPECTED_BALANCE] [CRYPTO]
YYYY-MM-DD balance Assets:Crypto:Wallet:[WALLET]:[CRYPTO] [EXPECTED_BALANCE] [CRYPTO]
; Exemple: Verificació del saldo de gener
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
Actualitzacions de preus
; Plantilla: Actualitzacions diàries de preus
YYYY-MM-DD price [CRYPTO] [PRICE] USD
; Exemple: Preus diaris
2024-01-15 price BTC 45000.00 USD
2024-01-15 price ETH 2500.00 USD
2024-01-15 price ADA 0.50 USD
Instruccions d'ús
- Copieu la plantilla rellevant per al vostre tipus de transacció
- Substituïu els marcadors de posició (que es mostren entre [CORXHETS]) pels valors reals
- Ajusteu els noms dels comptes perquè coincideixin amb la vostra estructura de comptes
- Afegiu metadades segons sigui necessari per a la declaració d'impostos o el seguiment
- Verifiqueu els càlculs abans de finalitzar les entrades
Bones pràctiques
- Utilitzeu convencions de nomenclatura coherents
- Incloeu els identificadors de transacció a les metadades
- Documenteu les transaccions complexes a fons
- Verifiqueu els tipus de canvi i els preus
- Feu còpies de seguretat periòdiques dels vostres fitxers
Aquestes plantilles proporcionen una base sòlida per a la comptabilitat de criptomonedes a Beancount.io. Personalitzeu-les segons les vostres necessitats específiques i els vostres patrons de comerç.
