TABLE OF CONTENTS
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
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 "YYYY-MM-DD HH:MM:SS" (e.g. "2019-08-24T14:15:22Z", 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.
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.