Setting Up Bookkeeping From a Specific Date

Created by Richard Pasquin, Modified on Fri, 19 Jan at 3:33 PM by William Kinash

In this tutorial, we will guide you on how to set your bookkeeping from a specific starting date. Some business may want to ignore previous year transactions and only start the bookkeeping from a specific starting date. This is done through inputing the starting carryover balances. 


Through this strategy, one of two options must be employed. Option one is to ignore all transactions before the specific start date. Option two is to always have your start date filter on for the date of your starting balances in inventory. 


See the steps below.


Step 1


In a new portfolio, start by clicking the Connect button.



Or in a portfolio with existing connections, head to the Connections tab.


Step 2


In the Connections page, search for manual import and select the connection.



Step 3


In the Manual Import connection menu, add the name, description and click the "Use CSVs for transactions" checkbox. Then click on Connect to establish the manual connection.




Step 4


Head to the Transactions tab.



Step 5


Click on the 3 dotted button and select Import.



Step 6


Click on the source box and select your manual import connection.



Step 7


Click on the linked Cryptoworth Manual Import format to download the CSV.



To learn more about the Cryptoworth manual CSV import format, see our guide (Step 10).


Step 8


On the Cryptoworth Manual CSV format, you will be required to fill out the following fields from left to right: 


  1. Date Time (UTC)
  2. Crypto ID
  3. Type
  4. Tag
  5. Amount One
  6. Amount One Type
  7. Amount Two
  8. Amount Two Type
  9. Fees
  10. Fee Currency
  11. Cost Value
  12. Cost Value Currency Code
  13. Sale Value
  14. Sale Value Currency Code
  15. Transaction_ID
  16. From_Wallet
  17. To_Wallet
  18. Classification ID
  19. Label
  20. Description
  21. Contract_Address
  22. Token_ID
  23. Token_Name


You will need to set the date of when you intend your business transactions to officially start by using the Date Time field.


The Crypto ID is how the platform recognizes and identifies cryptocurrencies, see our Crypto ID guide here on Step 10. For example, Bitcoin's Crypto ID on Cryptoworth is 1.


The type should only be RECEIVE transactions since these transactions will show your carryover balances. 


The tag is the transaction event itself, in this case deposits.


Amount one/type and amount two/type are your credits and debits for Cryptoworth.


Fees and fee currency is needed even if it's zero. 


Input your total cost basis for the consolidated carryover balance of each crypto asset.


If you have them, input the transaction IDs, To and From wallet addresses. 


In the example below, there are 4 carryover balance transaction line items for 4 different crypto assets.



Step 9


Once your CSV fields are properly inputed, import the CSV into Cryptoworth.




Step 10


Head back to your Transactions page and you will see your carryover balances from your starting date (CSV import could take a couple minutes before transactions display).


NOTE: If you have existing transactions before the starting balances date, make sure to classify transactions as ignored for every transaction before the start date of the carryover balances.

 



Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article