Simplify your month-end reporting process by generating the asset roll forward report. This report contains critical data for CFOs looking for insight into the performance of all assets in any given period and can serve as revenue reporting per business function if labeled accordingly. The information included in the report:
- opening and closing balances
- whether the assets are included in the revenue and expense (per label mapping)
- the unit and balance of the asset
- ingoing and outgoing internal transfers (per label mapping)
- ingoing and outgoing swaps (per label mapping)
What is an asset roll forward report?
An asset roll forward report (or fixed asset roll forward report in traditional businesses) contains all the detailed data on assets that you require for period closing, financial statements, and tax reporting. The report includes:
- start and end balances for assets;
- together with valuation movements for the period; and
- any new asset deposits and withdrawals that occurred during the period.
Data is reported for individual assets, and values are also summarized for asset groups and the legal entity.
Generate an asset roll forward report by following these steps:
💡 Tip: To make sure the report reflects the most recent transactions, update all sources before generating it. You can do this by going into the Imports tab and clicking ‘Update all.
Basic Asset Roll Forward
-
Go to the Reports page.
-
Click on the + Report button, and a drawer will open.
-
Find Accounting & Tax reports module.
-
Select Asset Roll Forward.
-
Generating All Assets is the default mode. Choose the asset you want or leave default mode on to see all assets.
-
Selecting All Wallet is the default mode. Choose the wallet relevant to your report or leave default mode on.
-
New: Decide if you want to see the NFT tokens in your report.
💡 Tip: The platform now offers support for tracking non-fungible tokens (NFTs) in your reports. This means you can choose to include NFTs in your reports. However, please note that valuation of NFTs is not currently available. The NFT module, which will introduce this functionality, is expected to be released later in 2023.
-
Pick the date range or include a complete history.
-
Customize your report by selecting the columns you need.
-
Click Create.
- The report will appear on the page and click the download icon under the Actions column.
Detailed Asset Roll Forward
-
Go to the Reports page.
-
Click on the + Report button, and a drawer will open.
-
Find the Financial reports module.
-
Select Detailed Asset Roll Forward.
- - 11. same steps as above.
How to read the report
Basic Asset Roll Forward
The Asset Roll Forward report presents the net change in asset balances after deposits, withdrawals, and transfers in a given period.
Basically, users read the report from left to right with the logic: Beginning unit + Deposit unit - Withdrawal unit = Ending unit.
Same for the balance calculation, Beginning balance + Deposit balance - Withdrawal unit = Ending balance.
❗Note that the pricing of data is based on the valuation that Cryptio receives from Kaiko.
The following information is available in the basic report:
- Wallet
- Asset
- Beginning units
- Beginning balance
- Unit deposits
- Unit Withdrawals
- Ending units
- Ending balance
Detailed Asset Roll Forward
The detailed version includes everything mentioned in the Basic Asset Roll Forward report plus breakdowns of the activity within Deposits and Withdrawals by labels. This should reflect the same changes for the period and reconcile to the ending balance. The key function of this is to provide greater insight into activity for customers' accounting teams.
💡 Tip: It is useful to track the performance of different revenue streams and expenses over time.
Label examples:
- Internal transfer (in/out)
- Swap Revenue (in only)
- Staking Revenue (in only)
- Swap (in/out)
- Fee (out only)
- Expense (out only)