TABLE OF CONTENTS

 

Description

A how-to guide to convert crypto data from a provider export into transactions within the SoftLedger Upload Template.

 

 

For this guide, we will convert this sample export file from the BitGo wallet to the SoftLedger Upload Template. It is recommended to open this template to follow along the steps below to set up a conversion file that can be used on an ongoing basis with formulas:


              BitGo to SoftLedger Template


 

 

1. Create a Wallet within SoftLedger titled "BitGo", where these transactions will be uploaded and held under (this must be created prior to upload).

2. Convert the data in the columns of the BitGo wallet to the format of the SoftLedger Upload Template:


While some of these columns are straightforward to copy over (e.g. date), some require some more advanced formulas to be sure the correct information is in the right format for the SoftLedger upload template. See a list of columns and formulas from the example conversion file:

 

  1. type:
    =IF('BitGo Example Export'!I2<>"",IF('BitGo Example Export'!I2="Received","deposit",IF('BitGo Example Export'!I2="Fee","withdrawal","")),"")
  2. date:
    =IF('BitGo Example Export'!A2<>"",'BitGo Example Export'!A2,"")
  3. rQty:
    =IF('BitGo Example Export'!I2<>"",IF('BitGo Example Export'!I2="Received",'BitGo Example Export'!F2,""),"")
  4. rPrice - N/A as choosing Automatic pricing on upload
  5. sQty:
    =IF('BitGo Example Export'!I2<>"",IF('BitGo Example Export'!I2="Received","",-('BitGo Example Export'!F2-'BitGo Example Export'!E2)),"")
  6. sPrice - N/A as choosing Automatic pricing on upload
  7. fQty:
    =IF('BitGo Example Export'!I2<>"",IF('BitGo Example Export'!I2="Received","",-'BitGo Example Export'!E2),"")
  8. fPrice - N/A as choosing Automatic pricing on upload
  9. rCoin.symbol
    =IF('BitGo Example Export'!I2<>"",IF('BitGo Example Export'!I2="Received","BTC",""),"")
  10. rWallet.name
    =IF('BitGo Example Export'!I2<>"",IF('BitGo Example Export'!I2="Received",'BitGo Example Export'!$P$2,""),"")
  11. sCoin.symbol
    =IF('BitGo Example Export'!I2<>"",IF('BitGo Example Export'!I2="Received","","BTC"),"")
  12. sWallet.name
    =IF('BitGo Example Export'!I2<>"",IF('BitGo Example Export'!I2="Received","",'BitGo Example Export'!$P$2),"")
  13. fCoin.symbol
    =IF('BitGo Example Export'!I2<>"",IF('BitGo Example Export'!I2="Received","","BTC"),"")
  14. fWallet.name
    =IF('BitGo Example Export'!I2<>"",IF('BitGo Example Export'!I2="Received","",'BitGo Example Export'!$P$2),"")
  15. ledgeraccount.number - Defaults used from setup of the "BitGo" wallet within SoftLedger
  16. notes
    =IF('BitGo Example Export'!K2<>"",IF('BitGo Example Export'!K2<>"0",'BitGo Example Export'!K2,""),"")
  17. reference
    =IF('BitGo Example Export'!J2<>"",IF('BitGo Example Export'!J2<>"0",'BitGo Example Export'!J2,""),"")
  18. customer.id - Assuming no customers to be added to transactions
  19. vendor.id - Assuming no vendors to be added to transactions
  20. currency - If no entry, assumes the Crypto Home Currency from Crypto Settings
  21. txHash
    =IF('BitGo Example Export'!C2<>"",IF('BitGo Example Export'!C2<>"0",'BitGo Example Export'!C2,""),"")

    Assumptions:
  • "BitGo" wallet name has been hard coded into many formulas (this can also be added in the wallet fields where appropriate rather than by formula).
  • "BTC" has been hard coded into many formulas as this file is only for transactions involving Bitcoin.
  • Ledger accounts used for transactions will be the ledger accounts added as defaults in the wallet setup (these can be changed in bulk within SoftLedger through Bulk Edit Actions)

3. Navigate to Crypto > Upload

  • Click "Bulk Upload Crypto Transactions"

 

  • Select the file completed in the previous steps for the 'Input File"
  • Select your Rate Source as "Automatic". This is either "Manual" (you input in the exact rate in your upload file in the Price columns) or automatically pulled from our rate source.
  • Click Upload.
  • If there are errors to be addressed after uploading, they will be displayed in the upload window, or can be accessed through clicking the blue highlight text for that upload:

 

 

  • Fix any errors reported and upload the revised file again until you see a success message to confirm the upload into SoftLedger.

And now you have a file set up to convert future exports from a provider used in your operations frequently! If you have any questions with this process or would like assistance from a member of the SoftLedger team, feel free to reach us with the chat widget in the bottom right of your screen OR at support@softledger.com.