Step 6: Syncing and reconciling transactions to your accounting software

Once you’ve imported your data, labeled your transactions, uploaded your Chart of Accounts (COA), and completed your mappings, you’re ready to start booking your transactions with your ERP. At Cryptio, we call this synchronizing your transactions.

Step 1: Review the Needs Review Module

On your Transactions page, under NAVIGATE, click Needs review at the top. This opens the Needs Review Module, where each tab shows different reasons a transaction cannot yet be sent to your ERP.

The final tab, Ready to be synced, displays all transactions with complete mappings and no issues. Before syncing these, we recommend working through the other tabs first.

Here’s what each tab means:

Transactions without label

• These transactions don’t have a label, meaning the journal entry is incomplete.

• Look for patterns (e.g., the same wallet involved) and consider setting up a From/To label rule.

• Alternatively, add labels manually. As long as labels have mappings, the COA mapping will be complete.

Missing prices

• These transactions involve assets our system couldn’t price, so we can’t assign a fiat value.

• This often happens with:

  • New assets from chains/exchanges

  • Spam or scam tokens

• Solutions:

  • If the asset is legitimate, contact support with the token name, address, and (if possible) a CoinGecko link so we can add pricing.

  • If no price data exists, manually assign prices. (See: Manual Asset Pricing.)

  • If the token is spam, mark it as spam in the Assets module. Transactions will then be labeled spam and priced at 0.

Missing volumes

• These occur when outgoing asset movements exceed incoming ones, bringing the balance below 0.

• This creates a Cost Basis Error: Missing Volumes. See our guide on resolving these errors.

• If needed, reach out to support for troubleshooting.

Potential internal transfers

The Potential internal transfers tab lets you review transactions that may be movements between your own wallets or accounts.

You can adjust the matching rules that determine what appears here:

• Time difference: By default, this is set to 6 hours, but you can choose anywhere between 0 and 24 hours.

• Maximum volume difference: By default, this is set to 0%, but you can allow up to 5%.

After setting your rules, click Refresh to update the results.

To review:

1. Expand the dropdown toggle on a transaction pair.

2. Review the details, including:

   • Whether the transaction hashes match

   • The time gap between transactions

   • The volume difference

3. When you’ve found the correct match, click Confirm. The pair will then be matched as an internal transfer.

Bulk option: You can mark multiple transactions as internal transfers at once, but proceed with caution—this skips counterparty review.

Hide option: If transactions aren’t internal transfers, you can hide them. Select the checkbox → Edit → Hide transactions from ‘Internal Transfer review tab’. Once hidden, they won’t appear again.

Incomplete COA

• These transactions are missing COA mappings and can’t be directed to debit/credit accounts.

• Fix manually, or automate for efficiency:

  • Go to Chart of Accounts under ACCOUNTING.

  • Click Needs Review to see unmapped Labels or Sources.

  • Assign them to the correct accounts.

Once mappings are complete, click Apply mappings and transactions will leave the Incomplete COA tab.

Step 2: Synchronize Your Transactions

Now that all issues are resolved, you can sync your transactions.

Option 1: From the Needs Review Module

1. Go to Ready to be synced.

2. Select the checkbox at the top (next to Date) to select all transactions.

3. At the bottom, choose Sync with Xero/QuickBooks/NetSuite.

Other options available under Edit → Synchronization:

• Synchronize transactions – Pushes transactions to your ERP.

• Mark transactions as synchronized – Marks them synced without pushing to your ERP.

• Unmark transactions as synchronized – Reverses the sync status.

• Hide transactions – Removes them from the Ready to be Synced tab.

Option 2: From a Ledger Entries Report

If you have large volumes of monthly transactions (10k+), generating a Ledger Entries report may be easier.

• Go to Reports under CONNECT.

• Generate the report in the format needed (e.g., Xero, QuickBooks).

• Upload it directly to your ERP.

You can also generate a Rolled Up Ledger Entries report, which summarizes debits and credits by time period (daily, weekly, etc.).