Recap Getting Started Guide
  • Getting Setup
    • What is Recap?
    • Signing Up
  • ADDING YOUR TRANSACTIONS
    • Accounts Overview
    • Exchange API Account
    • Wallet Account
    • Exchange CSV Account
    • Custom Account
      • Converting Dates to Recap-Supported Formats
  • REVIEWING YOUR DATA
    • The Activity Screen
    • The Tax Screen
    • The Assets Screen
    • The Dashboard Screen (UK Only)
  • FILING YOUR TAX RETURN
    • The Subscription
    • The Tax Reports
  • FIXING ERRORS / DATA INTEGRITY
    • Introduction
    • Unidentified Assets
    • Balance Differences
    • Failed To Value
    • Error
    • Missing Acquisitions
  • RECONCILING GUIDE
    • Introduction
    • Checking that assets are mapped correctly
    • Matching Deposits and Withdrawals
    • Reviewing the Capital Gains Report
    • Reviewing the Income Report
    • Resolving Missing Acquisition Costs
Powered by GitBook
On this page
  • Before you start
  • Data resets on each import
  • Fees
  • CSV File Details
  • Required fields
  • Conditionally required fields
  • Optional / Specialised fields
  • Manually priced assets
  1. ADDING YOUR TRANSACTIONS

Custom Account

PreviousExchange CSV AccountNextConverting Dates to Recap-Supported Formats

Last updated 11 months ago

You can import transactions into Recap using a CSV file. Simply create a correctly formatted CSV containing your transactions and import it to your custom account in Recap.

You can see an example of the correct format for the CSV file in our or you can.

Recap Format CSV:

Before you start

Data resets on each import

To ensure that there are no complications when you upload a CSV to an existing Custom Account, we remove all previous CSV imports assigned to that Custom Account on every import. This is so you don't accidentally upload duplicates or have to manually work out which transactions you do and don't want to be included. You can think of the CSV file as the master record, always overriding data in an account.

Fees

As a general rule, ‘the sender pays the fees’ can be followed. Fees for deposits are inclusive, fees for withdrawals are exclusive. You should therefore add FeeAmount and FeeCurrency for your withdrawals but not deposits.

If you want to see how fees have been applied to a transaction, use the 'changed balances' section in the 'details' tab for any transaction.

CSV File Details

Required fields

  • Type - Airdrop, Deposit, Withdrawal, Trade, Income, Mining, Gift (gifts to or from), Spouse (gifts to or from your spouse or civil partner), Gambling (in or out), Purchase, Stake, Unstake, StakingReward, Donation, Fork, MarginGain, MarginLoss, LendingFee, Fee, FeeRebate, LoanPrincipal (loan acquisition), LoanPrincipalPayment (loan repayment), LoanCollateral (’Locking’ of loan collateral), LoanCollateralUnlocked and LoanInterest

  • Date - Date of the transaction as yyyy-mm-dd hh:mm:ss

    • If using excel you may need to adjust the calendar setting on your PC to format YYYY-MM-DD

Conditionally required fields

Depending on the activity type, there will be a few conditionally-required fields. To give a simple example - if you’re buying an asset or receiving an airdrop, you’ll need the InOrBuy pairs (InOrBuyAmount and InOrBuyCurrency). If you’re selling an asset or withdrawing some bitcoin to another wallet, you’ll need the OutOrSell fields (OurOrSellAmount + OutOrSellCurrency). More details about the specific conditionally-required fields per activity type can be found in the detailed sections for that type.

  • InOrBuyAmount - In or buy amount as a positive number or 0 [Required for Airdrop, Deposit, Trade, Income, Mining, Gift (from someone), Gambling (proceeds), Unstake, StakingReward, Fork (origin currency amount), FeeRebate, MarginGain, LoanPrincipal and LoanCollateral types]

  • InOrBuyCurrency - In or Buy currency, e.g. BTC [Required where InOrBuyAmount is specified]

  • OutOrSellAmount - Out or Sell amount as a positive number or 0 [Required for Withdrawal, Trade, Gift (to someone), Gambling (placement), Purchase, Stake, Fork (new currency amount) types, MarginLoss, LendingFee, LoanCollateralUnlocked and LoanPrincipalPayment]

  • OutOrSellCurrency - Out or sell currency, e.g. GBP [Required where OutOrSellAmount is specified]

Optional / Specialised fields

  • ValueAmount/ValueCurrency - Only used for receiving a Spouse gift, this is the amount and currency of the value of the gift. For example, if your spouse gifts you 1 BTC they bought for 5,000 GBP, you would use 5000 in the ValueAmount column and GBP in the ValueCurrency column

  • FeeAmount - Fee amount as a positive number, where a fee is applicable

  • FeeCurrency - Fee currency, e.g. GBP, BTC

Manually priced assets

Users can choose to override Recap's pricing engine with a manually entered asset price, this is useful when we are unable to price an asset or you'd like to use a manual price instead of ours. Special Note: Imported prices cannot be edited in Recap once imported. Users should re-import their CSV files if they wish to make adjustments to these prices.

  • PriceAmount - A manual price, for one unit of the asset [Required wherever PriceBaseCurrency and PriceQuoteCurrency are specified]

  • PriceBaseCurrency - The asset you wish to manually price (i.e BTC) [Required wherever PriceAmount and PriceQuoteCurrency are specified]

  • PriceQuoteCurrency - The currency you wish to use to price the base asset. This should always be the same as your tax currency - (i.e. GBP for HMRC, USD for IRS and ZAR for SARS). [Required wherever PriceBaseCurrency and PriceQuoteCurrency are specified]

We've got a more detailed A-Z guide for each transaction type . ​

here
Google Sheet
download the CSV template