Bulk Crypto Upload

Created by Travis Lander, Modified on Wed, 1 May at 3:12 PM by Travis Lander

TABLE OF CONTENTS

Description
Upload Template
Upload Fields
File Upload Process
Bulk Import Table

Description

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

Download 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

Column	Details
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.id	Any 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

Select the saved upload file by clicking Choose File (Note: the file can be csv, .xls, or .xlsx format).
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
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.