RP2 generates output files by running the report plugins, which vary country by country.
After running RP2, the output files can be found in the output directory or in the directory specified with the -o command line option. A description of the various report generators follows below.
The following reports are valid for any country.
The rp2_full_report.ods output file is a comprehensive, ODS-format report containing full details about the computed taxes (which can be useful in case of audit): complete transaction history with hyperlinks, long/short capital gains, cost bases, balances, average price, in/out lot relationships and fractioning. See crypto_example_fifo_rp2_full_report.ods (an example of this output for input file crypto_example.ods) and screenshots further down in this document.
This report makes it possible to follow step-by-step the process RP2 uses to produce results and verify them. It contains:
- a Legend sheet containing accounting method information and the meaning of each column and keyword
- a Summary sheet containing total short/long term capital gains per year, per cryptocurrency. Here follows an example of this sheet:
- two sheets per cryptocurrency:
- cryptocurrency In-Out: full transaction history for the given cryptocurrency, organized by direction (In, Out, Intra). Taxable events are shown in blue, with taxable amount in yellow. The In table has a Sent/Sold column showing which lots have been fully or partially sold (in purple). Timestamps are homogenized (in the user input spreadsheet they may have different formats), transactions are sorted by time and some running sums are computed. Here follows an example of this sheet:
- cryptocurrency Tax: full tax computation details for the given cryptocurrency: long/short capital gains, cost bases, balances, average price, in/out lot relationships and fractions. In this sheet, blue refers to taxable events and outgoing (sold, donated, etc.) transactions, purple refers to cost basis and incoming (purchased, received) transactions and yellow refers to taxable amount. The Intra-Flow Detail table shows the mapping between taxable event fractions and in-transaction fractions. Here follows an example of this sheet:
- cryptocurrency In-Out: full transaction history for the given cryptocurrency, organized by direction (In, Out, Intra). Taxable events are shown in blue, with taxable amount in yellow. The In table has a Sent/Sold column showing which lots have been fully or partially sold (in purple). Timestamps are homogenized (in the user input spreadsheet they may have different formats), transactions are sorted by time and some running sums are computed. Here follows an example of this sheet:
The RP2 Full Report contains hyperlinks to facilitate navigation: in LibreOffice, CTRL-click (on Mac, Command-click) on a cell to jump to the target. The following content is hyperlinked:
- taxable events and acquired lots in cryptocurrency Tax sheet are hyperlinked to their definition line in the cryptocurrency* In-Out sheet;
- summary lines in the Summary sheet are now hyperlinked to the first line of the given year in the cryptocurrency Tax sheet.
The open_positions_*.ods output file is an ODS-format spreadsheet designed to provide information on assets with non-zero crypto balances including gains and losses.
The report contains:
- a Legend sheet containing the accounting method and the meaning of each column and keyword
- the Input sheet for entering current asset values (or asset values on a given date to be used for the calculations per user requirements).
- the Asset sheet which among other things shows the crypto balance, cost basis information (by unit and in whole) and portfolio weighting of each asset as well as the unrealized / market value and the gains / loss data in fiat and percentage terms in addition to further breakdowns. This tab summarizes the information by asset and holder.
- The Asset - Exchange sheet provides the same information as the asset tab, but further breaks the information down by exchange.
The following reports are country-specific.
This is a US-specific tax-advisor-friendly report that can be understood by tax professionals (not necessarily specializing in crypto). It can be used to fill form 8949, etc: see crypto_example_fifo_tax_report_us.ods (an example of this output for input file crypto_example.ods) and screenshots further down.
The tax_report_us.ods output file contains a legend sheet and a sheet per taxable event type (if there are no taxable events for a given event type, its respective sheet is not generated):
- Airdrops;
- Capital Gains (triggered by cryptocurrency sales);
- Donations (cryptocurrency given to a qualified charity);
- Gifts (cryptocurrency gifted to a friends or family);
- Hard Forks;
- Income;
- Interest;
- Investment Expenses (cryptocurrency fee paid when moving funds between two accounts owned by the same person);
- Mining;
- Staking;
- Wages.
These sheets are in the format of form 8949 and are meant for tax preparers, who can use it to fill the appropriate forms. Every line corresponds to a taxable event and describes it. The left part (with white header) mimics form 8949: cost basis, capital gains, proceeds, etc. The right part (with gray header) contains additional information that can be used to identify the transactions in the user's records or in the rp2_full_report output: full timestamp of date sold, capital gains type (long or short), lot fraction information, transaction type, unique_id, etc. In this sheet blue refers to taxable events and purple to in-transactions (purchased, earned, etc.).
Each sheet has a specific tax treatment.
Here follows an example of the Capital Gains sheet:
And an example of the Interest sheet:
This is a Ireland-specific tax-advisor-friendly report that can be understood by tax professionals (not necessarily specializing in crypto). It follows the same format as the US variant.
This is a Japan-specific report: tax_report_jp.ods output file contains a legend sheet, a summary sheet for every year, and a calculation sheet per asset and year.
The NTA (National Tax Agency) provides an excel spreadsheet for calculating the total average of each crypto asset per year. This report generates a similar report and can be optionally submitted with an individual's taxes or provided to the NTA if requested.
The summary sheet contains the total for the tax year. This is what is normally reported as "miscellaneous income" (雑所得). However, it may be reported as business income in certain circumstances. Please do your own research.