Skip to main content
All CollectionsTroubleshootingImporting
How to Ensure Data Completeness
How to Ensure Data Completeness

A checklist to identify and resolve missing data in your CTC account.

Layla Huang avatar
Written by Layla Huang
Updated over 2 weeks ago

The accuracy of your crypto tax report relies on the completeness of your data. If balances or calculations seem incorrect, ensuring there’s no missing data can resolve most issues. This guide provides a checklist to help you identify and address missing data.

Note: The "account" mentioned in this guide refers to your exchange account, hot wallet, or hardware wallet.

1. Import All Your Accounts

These include but are not limited to:

Accounts that need to be imported

Note

✅ Old accounts that you no longer use

Even if an account is not used during the current financial year, its transaction history—including asset movements, acquisitions, and disposals—can affect calculations.

✅ Accounts you have lost access to or that have been stolen/hacked

Even if you no longer own the account, its transaction history is essential for accurate calculations.

These do not include:

Accounts that should not be imported

Note

❌ Exchange address

Avoid importing the exchange's wallet address unless you're filing taxes for the exchange itself. Exchange wallet addresses typically do not belong to a single customer. Instead, import your exchange transactions using the CSV or API file available through your exchange account.

❌ Protocol contract address

Avoid importing the protocol address unless you are specifically filing taxes for the protocol itself.

❌ Your friend's or family's account

Do not import accounts you do not own or do not intend to include in your tax reporting. For interactions between your accounts and these, you can use the 'Gift' or 'Personal Use' category.

2. Make Sure Your Data Is Synced and Up-to-Date (via API)

CTC does not auto-sync your account, giving you full control over the data you choose to import. To ensure your account is synced and up-to-date, click the button in the 'Synced' column or use the three dots menu for the account on the Intergrations page.

3. Make Sure There Is No Gap If Uploading Files

If uploading CSV files, you can click 'View transactions' under the three dots menu to check the imported data start and end dates to determine whether all transaction history has been imported.

Note: Import all years, not only the current financial year.

4. Follow the Integration Page Instructions

Crypto Tax Calculator (CTC) provides comprehensive import instructions for all available integrations on the Integration page. Follow these instructions carefully to ensure complete data import.

Field

Note

Connect exchange account

  • Connect to your exchange account via OAuth with read-only access.

  • The completeness of the imported data depends on the exchange.

  • Refer to the Additional Notes section for any restrictions.

Sync via API

Exchange:

  • Import your data via API keys with read-only and specified permissions.

  • Data completeness depends on the exchange.

  • Refer to the Additional Notes section for any restrictions.

Wallet:

  • Import your data via a wallet address.

  • Ensure the wallet address is in the correct format by following the provided instructions.

  • Data completeness depends on the data provider.

  • Refer to the Additional Notes section for any restrictions.

Upload file

Exchange:

  • Follow the instructions to upload the correct files. Some exchanges provide multiple file types, which may not always be compatible with CTC.

  • Data completeness depends on the exchange.

  • Refer to the Additional Notes section for any restrictions.

Wallet:

  • We recommend using the 'Sync via API' method to import your wallet.

  • If the integration is not available, use Advanced Custom CSV Import.

Instructions

Providing clear steps and specifying the exact files needed to import your data.

Additional notes

Always review the Additional Notes for data restrictions and any extra steps required to ensure your data is complete.

Note: Always check the Additional Notes section for any restrictions.

5. Review Ignored or Spam Transactions

Double-check the Transactions page under the View tab to ensure no transactions are accidentally categorized as Ignored or Spam. These transaction types are excluded from calculations.

6. Ensure Full Transaction History When Importing from a Custom Date

If you used the 'Start Import From' feature, ensure the starting balances and cost basis for transactions before that date have been imported.

7. Hard Sync the Account if Needed

Occasionally, you may need to use the 'Hard Sync' feature to retrieve missing data. This may happen if the data provider or exchange updates or improves its endpoint. For more details, refer to the 'Hard Sync' guide.

Adding Missing Data

If you've checked all the items above but still can't retrieve the missing data, there are two ways to add it manually. Refer to these guides for details:


Need More Help?
If you have any questions or need assistance, we're here to help! Feel free to reach out to us via the in-app chat in the bottom-right corner or send your inquiries to [email protected].

Did this answer your question?