Bring Crypto Transactions into SoftLedger in bulk through our bulk upload excel template.

 




 

 

Note: This article explains the columns and process of upload for uploading crypto transactions into SoftLedger. Be sure to review How to convert a crypto provider export into a SoftLedger upload for an example conversion file from BitGo exports into the SoftLedger Upload Template.


Upload Fields

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

 

type - Deposit, Withdrawal, Transfer (must be between 2 wallets that exist in SoftLedger), or Trade.
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).
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).

CostCenter.id - Cost Center ID created in SoftLedger.

Product.id - Product ID created in SoftLedger.

Job.number - Job number created in SoftLedger.
customer.id - Customer unique ID created from SoftLedger.
vendor.id - Vendor unique ID created from SoftLedger.
reference - Short form text field to add information related to a transaction.
notes - Long form text field to add any information related to a transaction.
currency - Symbol for the fiat currency for rPrice, sPrice, and fPrice.
txHash - Hash ID for on-chain transactions (the Hash ID can be linked out to block explorers from within the UI if available).

 

Important Considerations:

  • Review the Reference file included above, as for different transactions Types, different input fields will be required. For example, rCoin is required for a Deposit, but sCoin is required for a Withdrawal.

 

 

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.
  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:

 

Table Actions:

  • Filters - Filter what appears in the table based on one or more fields available in the table.
  • Saved Views - You can create a set of filters that you would like to save to be able to quickly filter a table.
  • Column Selector - Hide and reveal extra columns and the number of rows visible in the table per page.
  • To review Crypto transactions brought in from an upload, you can copy the ID value in the table, and then paste that into the 'System Job' field within the Crypto>Transactions tab.