With SoftLedger, you get a powerful crypto accounting software that automates your cryptocurrency transactions - across multiple wallets and exchanges. Learn how to bring Crypto Transactions into SoftLedger in bulk through our bulk upload excel template.




Upload Template

 


Important Considerations:

  • Review the Reference Guide included in the tabs of the excel to see which fields are required for each different transaction type (deposit, withdrawal, transfer, and trade).
  • Coin Symbols are case sensitive (e.g. "BTC" versus "btc").
  • The Ledger Account number input in this upload is for either the credit side of a deposit transaction or the debit side of the withdrawal transaction, where the other side of deposits/withdrawals impact the coin's associated asset account.
  • There is a Sample Transactions tab included in the template to help see data that is completed
  • Custom dimensions can be added according to below logic

Upload Fields

When completing the attached template, please use the following guide to determine the appropriate inputs for each column for each transaction:


Legend
Required
Optional



ColumnDetails
type deposit, withdrawal, transfer (must be between 2 wallets that exist in SoftLedger), or trade. [must be lowercase]
date  Transaction date and time, in "MM/DD/YYYY HH:MM:SS" with AM or PM at the end. (Note: Crypto transactions will be displayed in UTC time within SoftLedger, so it is recommended to upload transactions in UTC).
currency Currency Code for the rate currency of the price information (e.g. USD, CAD, EUR, etc.)
rQty  Received Quantity, # of Coins received.
rPrice  Received Price, market price per Coin received.
sQty  Sent Quantity, # of Coins sent.
sPrice  Sent Price, the price per Sent Coin.
fQty  Fee Quantity, # of Coins used to pay transaction fees.
fPrice  Fee Price, the price per Fee Coin.
rCoin.symbol  Symbol for received Coin (aka "to" coin), the crypto asset balance that is increased as a result of the transaction (e.g. the rCoin.symbol is BTC for Bitcoin).
rWallet.name  Name of received Wallet (aka "to" Wallet).
sCoin.symbol  Symbol for sent Coin (aka "from" coin), the crypto asset balance being decreased as a result of the transaction.
sWallet.name  Name of sent Wallet (aka "from" Wallet).
fCoin.symbol  Symbol for fee Coin.
fWallet.name  Wallet used to pay transaction fees.
ledgeraccount.number  Ledger account number for the debit side of the Journal Entry in Withdrawals (e.g. 620500  Marketing Expense, for paying these expenses with ETH) and the credit side of the Journal Entry for Deposits (e.g. 110000  Cash, for purchasing BTC with USD).
notes  Long form text field to add any information related to a transaction.
reference  Short form text field to add information related to a transaction.
txHash  Hash ID for on chain transactions (the Hash ID can be linked out to block explorers from within the UI if available).
customer.id  Customer unique ID created from SoftLedger.
vendor.id  Vendor unique ID created from SoftLedger.
CostCenter.id  Cost Center ID created in SoftLedger.
Product.id  Product ID created in SoftLedger.
Job.number  Job number created in SoftLedger.
CustomDimension.idAny created custom dimensions can be added and included in upload with the relevant ID (just as you can with Cost Center), meaning if you have a custom dimension titled "Blockchain", then Blockchain.id can be a created column.

 


 

File Upload Process

  1. Select the saved upload file by clicking Choose File (Note: the file can be csv, .xls, or .xlsx format).
  2. Select the Rate Source as 'Manual' or 'Automatic'. Select 'Manual' if you have entered in exact price rates in the rPrice, sPrice, and fPrice fields, or 'Automatic' if you would like SoftLedger to add these rates from the date and Coin.
    1. SoftLedger sources rates for the UTC Open from CoinMarketCap if you choose to use the "Automatic" pricing option
  3. The file will either upload with a 'completed' status, or return errors in a 'failed' status (Depending on the number of entries, this could take several minutes to upload).

Troubleshooting errors:

If there is one or more errors. A table of errors will appear. The first column will read "CSV Row" to signify the row in the file where the "Error" has occurred:

 



After resolving the errors, re-upload the file to complete the process.

 

Bulk Import Table

On the Bulk Crypto Upload tab, there is a table to review previous completed or failed upload attempts:

 



To find the transactions from a particular upload, copy the ID from the upload table (as in image above) and then head to the Transactions table and search on the "System Job ID" field with the copied ID value. From there, you can bulk edit or delete uploaded transactions.


 

Note: Be sure to check out the  How to convert a crypto provider export into a SoftLedger upload for an example of converting exports into the SoftLedger upload format.