Reporting and reconciliation

Layer1 reporting tools help you track wallet activity, monitor balances, and export data to match against your internal financial records. Use this guide to create exports and understand reconciliation best practices.

Exporting reports

Layer1 supports exporting two main types of reports:

1. Transaction report: A detailed list of transactions for a specific time period, filtered by asset pool, asset, transaction type etc.
2. Balance report: A current snapshot of your balances per asset

Export a transaction report

To export a transaction report:

1. Go to Digital Assets > Exports.
2. Select Export.
3. Apply filters to create an export that meets your needs:
   1. Asset pool (for example, Revenue Wallet, Treasury Wallet)
   2. Date range (for example, "1st-30th June", or choose a custom range)
   3. Date type filter (for example, Created at or Updated at date)
   4. Network (for example, Bitcoin, Ethereum)
   5. Asset (for example, USDT, Ethereum)
   6. Status (for example, Success, Failed)
   7. Type (for example, Deposit, Withdrawal)
4. Click Generate Export.
5. Wait for the report to finish generating. Once ready, it will appear on the Exports page. You may need to refresh the page to see the latest status or download link.

Export a balance report

To export a balance report:

1. Go to Digital Assets > Exports.
2. Select Export.
3. Apply filters to create an export that meets your needs:
   1. Asset pool (for example, Revenue Wallet, Treasury Wallet)
   2. Network (for example, Bitcoin, Ethereum)
   3. Asset (for example, USDT, Ethereum)
4. Click Generate Export.
5. Wait for the report to finish generating. Once ready, it will appear on the Exports page. You may need to refresh the page to see the latest status or download link.

Reconciliation notes

When reconciling your platform exports with internal records, keep the following in mind:

Timestamp alignment

• All timestamps are in UTC.
• Ensure your internal ledger timestamps match for accurate reconciliation.

Transaction amount and network fee logic

The 'amount' shown in the transaction report reflects the value debited or credited during a transaction. However, the inclusion of network fees in this amount depends on the type of transaction and whether the transaction currency is the same as the network fee (gas) currency.

warning

The "amount" field does not consistently include network fees across all transaction types. For now, the platform does not support a unified "total spent" or "net received" column, as this calculation varies by context. The logic below outlines how to interpret the amount shown in exports.

Transaction Type	Tx & Gas Currency Relationship	Example	Logic Note
Withdrawal	Same currency	ETH on Ethereum	Amount includes network fee (tx amount + network fee)
Withdrawal	Different currency	USDT on Ethereum	Amount does not include network fee (tx amount only)
Deposit	Same currency	ETH on Ethereum	Amount does not include network fee (tx amount only)
Deposit	Different currency	USDT on Ethereum	Amount does not include network fee (tx amount only)
Consolidation	Same currency	ETH on Ethereum	Amount includes network fee (tx amount + network fee)
Consolidation	Different currency	USDT on Ethereum	Amount does not include network fee (tx amount only)