In this tutorial, explain how to import your existing chart of accounts onto Cryptoworth.
Step 1
Head to the Accounting tab and click on Classifications.
Step 2
Click on the Import button. This is where you will be importing your chart of accounts.
Step 3
On the import page, please read the full description and instructions before downloading and using the CSV template for importing your chart of accounts.
If you are migrating your chart of accounts from your own CSV/Excel file, make sure to input into the Cryptoworth CSV template's proper format. Click on the link to download the CSV template.
Step 4
On the CSV template, you have the classification IDs in the first column that will be generated upon import. The Parent ID column should have the classification ID inputted of the Parent classification associated to the child classification indicated in the "Level(parent/child) column.
The "Type" column is where the account needs to be identified. The chart of accounts to choose from is listed in the import page and is the following below.
Accounts Receivable
Bank
Deferred Expense
Fixed Asset
Other Asset
Other Current Asset
Unbilled Receivable
Equity
Costs of Goods Sold
Expense
Other Expense
Income
Other Income
Accounts Payable
Credit Card
Deferred Revenue
Long Term Liability
Other Current Liability
Decide the Non-taxability and Ignored characteristics of the classifications by using 1 to define "yes" and 0 to define "no" for both columns. Afterwards, your template will be ready to be imported. See a filled out example below the template screenshot.
Step 5
Once your chart of accounts and classifications are migrated onto the CSV template, import the CSV.
Head back to the Classifications page by clicking the "Close" button and your chart of accounts have now been synced.
See step 6 for how to rollback your chart of accounts CSV import.
Step 6
Head to your Portfolio History, click the CoA Imports menu and click the Rollback button to undo your chart of accounts CSV import.
