Chart of Accounts - CSV Import

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.