Period End Close

Once you have reconciled and synced transactions to your ERP, you are ready for the period end close process. Navigate to the Period End Close on the left menu. Follow the steps noted on this screen. Note, the blue text indicates links to the corresponding report.

First download the Period End Reconciliation Template.

Next, run the Gain/Loss scenario for the period period and locate the Cumulative Cost basis of digital assets and input that value in D7 for the beginning cost basis in the Period End Reconciliation Template.

Scroll down to locate the Gain Loss summary. Note the “Unrealized” figure. If the figure is green, this is a positive value. If the figure is negative and colored in red, this indicates a negative value.Scroll down to locate the Gain Loss summary. Note the “Unrealized” figure. If the figure is green, this is a positive value. If the figure is negative and colored in red, this indicates a negative value.

Transfer the Unrealized Gain or Loss from the Scenario Runner to the Period End Close Template in row 9 for the corresponding period. For example, if you are closing for the period 1/1/2024-1/31/2024, you will transfer the values to the 1/31/2024 column in cell E9.

Transfer the Realized Short Term and Realized Long Term Gain or Loss to the Period End Close Template in row 5.

Next, run the Balance Report by navigating on the left menu to reports.

a. Select the Balance Report which allows you to query the fair market value of each digital asset at the end of the day selected at 11:59 PM (based on the entity’s timezone).

For example, if you wish to know what your end of day balance of BTC was on 9/22/2021, you would run the balance report for this date.

Select the Balance as of the end of day either grouped by wallet or without grouping. All other fields are optional.

Transfer the total fiat value to the Period End Close Template in row 14.

Next run the Rolled Up Journal Entry Report

Select the corresponding time period as the Gain/Loss report, grouping is optional, and choose the appropriate Accounting Connection (your ERP system).

Transfer the Report Total values to the Period End Close Template in rows 2 and 3.

The Bitwave Variance column in row 16 is expected to have a $0 variance or based on materiality thresholds. Material differences should be investigated and resolved.

Record manual entries to your ERP to recognize the realized gain/loss amount from row 5 and true up unrealized gain/loss amount from row 9 to the FMV noted on row 14 based on the accounting method that your entity has adopted.

Period End Close

https://www.loom.com/share/9f871709cc5a4142bf9c11e54f9bb1bf