How do I correctly use transaction types in CSV files for ZenLedger?
When importing transaction data into ZenLedger using a CSV file, it is crucial to select the correct transaction type and fill out the appropriate columns. This ensures accurate tax calculations and reporting. Below is a guide to help you understand and correctly use the transaction types in your CSV file.
Overview of CSV Transaction Types
ZenLedger supports various transaction types to categorize your crypto activities. The most common types include:
Purchase: Used when acquiring cryptocurrency in exchange for fiat or another asset.
Send: Used when spending cryptocurrency for goods or services.
Trade: Used for recording profit/loss from trading activities, including crypto options trades.
Detailed Instructions for Common Transactions
1. Purchase Transactions
Use the "Purchase" transaction type when you acquire cryptocurrency in exchange for fiat currency or another asset. Fill out the following columns in your CSV file:
Date: The date of the transaction.
Transaction Type: Select "Purchase."
In Amount: The amount of cryptocurrency received.
In Currency: The type of cryptocurrency received.
Out Amount: The amount of fiat or other asset paid.
Out Currency: The type of fiat or other asset used for payment.
Fee Columns: Include any applicable fees, if charged.
2. Send Transactions
Use the "Send" transaction type when you spend cryptocurrency for goods or services. Fill out the following columns:
Out Amount: The amount of cryptocurrency spent.
Out Currency: The type of cryptocurrency spent.
Leave the "In" columns empty unless you received something in return.
Fee Columns: Include any applicable fees, if charged.
3. Trade Transactions
Use the "Trade" transaction type to record profit or loss from trading activities, including crypto options trades. Ensure the following:
Select "Trade" as the transaction type in the CSV template.
Tips for Avoiding Common Errors in CSV Uploads
Double-check column headers: Ensure they match the required format in ZenLedger's CSV template.
Verify transaction details: Confirm that all amounts, currencies, and dates are accurate.
Leave unnecessary fields blank: Only fill out the columns relevant to the transaction type.
Include fees where applicable: This ensures accurate cost basis calculations.
By following these guidelines, you can ensure a smooth CSV import process and accurate transaction reporting in ZenLedger.