Import your crypto transactions into any accounting software through ledger entries report.

Ledger entries represent the record-keeping system for a company’s financial data, with debit and credit account records validated by a trial balance. The ledger entries report is an accounting report that you can directly export and import back into the accounting system - it's a universal way of sharing accounting data.

What is a ledger entry?

A ledger entry is a record made of business transactions. These entries are usually made using the double-entry format (where the debit and credit sides of each entry always balance).

The ledger entries report is used if:

• Your accounting software does not integrate directly with Cryptio; or
• You want to batch ledger entries to avoid an entry per transaction for high-volume activity.

Check you have completed the following steps before generating your Ledger Entries report:

1. Ensure you have imported your Chart of Accounts.
2. You will need to have Mapped the Accounts with the different transactions.
3. Once completed, you will be able to generate Ledger Entries reports.

Generate a ledger entries report in 8 steps:

1. Go to the Reports page.

2. Click on the + Report button, and a drawer will open. 

3. Find Accounting & Tax reports module.

4. Select Ledger entries.

5. Choose the correct CSV format

   • • Cryptio’s format includes all information. If you are using a system with which we don’t have direct integration, the Cryptio format might be the most helpful as you can extract what you need from there.

6. Choose the date range or include a complete history.

7. Identify the Transaction type: choose between All transactions type, Synchronizable transactions only, or Un-synchronizable complex transactions only.

   ⚠️ Understanding transaction types

   Cryptio can directly sync transactions that are recognized as complete to Xero and Quickbooks. When a transaction is not complete, it will appear under ‘Need Review’ in the Transactions tab. Below we have listed the different transaction types:

   • Synchronizable transactions only - Ledger entries that are complete and ready to be pushed to existing accounting software.
   • Un-synchronizable complex transactions only - Transactions that can’t sync to an accounting system directly, this includes complex transactions. Solution:
     • Step 1: Generate this type of ledger entries report.
     • Step 2: Insert a line in your accounting software with a miscellaneous account.
     • Step 3: Then book these transactions to the miscellaneous account. [Note that complex transactions are consolidated based on contracts. We will increase our contracts support but not all transactions will be bookable directly.]
   • All transactions type - Both synced and un-synchronizable transactions are listed. 

8. Finally, click Create.

9. The report will appear on the page and click the download icon under the Action column.

How to read the report

The Cryptio format Ledger Entry report includes the following data:

1. ID: transaction identifier (hash or trade ID)
2. Labels: label(s) that have been attached to the transaction
3. Date of transaction
4. The account number to which the transaction is mapped
5. Account name
6. Debit
7. Credit
8. And more transaction details as shown in the example below

⚠️ Error column This is an important control column. When you can’t see any transaction information in your table, this column identifies why the transaction hasn’t been imported.

Common messages:

• Invalid journal - incorrect labeling of the taxable event.

  Solution: Change the labeling to taxable or non-taxable event accordingly.

• Missing credited account - incomplete chart of account mapping for the transaction.

  Solution: Revisit the‘ Need review’ page under the Transaction tab and complete mapping for the transactions listed under ‘Incomplete CoA’.

• Missing debited account - incomplete chart of account mapping for the transaction.

  Solution: Revisit the‘ Need review’ page under the Transaction tab and complete mapping for the transactions listed under ‘Incomplete CoA’.

  

• Missing asset rate - no price is available for the token or coin.

  Solution: Manually price the asset (if you have the valuation with you) within the Transaction tab.

  Step 1: Choose the line item and select the ‘Missing price’ box.

  Step 2: Click on the icon underneath Actions at the left.

  Step 3: The ‘Movement details’ tab will open, where you can input the ‘Volume USD dollar rate’ in the first line. [The value should be the price of 1 unit of the asset, e.g. if 1 BTC is $17,000 then you should enter $17,000 under the ‘Volume US Dollar rate’.]

  ⚠️ Important: Once you price this asset, it will apply that value as the purchase price to the asset throughout the workspace. If you are unsure about anything, please reach out to the Customer Success team.

  

  Step 4: Click Save. Navigate back to the Transaction tab view and click on ‘Update cost basis’.

  Step 5: Once this completes, you will see your assets that had ‘Missing pricing’ have a price. The ‘Need Review’ should be under ‘Ready to be synced’ if it was correctly mapped to CoA.

  Step 6: Bulk selects the transactions and clicks on ‘Reconcile with ledger entries’, next to the ‘Ready to be synced’ box. Now you should be able to see the transactions in your Ledger Entries report.

  

• Blank - No issue with the transaction.