Table of contents

1. Creating a period

Input Periods

Transactions are stored per period. Setting up periods is quite straightforward.
The following fields need to be filled in to create a period:

Title

Can be anything meaningful to you. (e.g. JAN-2018 - DEC-2018)

Start Date

The start date of the period.

End Date

The end date of the period.

The following actions can be done:

Add period

Creates an extra form to fill in a new period.

Update periods

Sends all the period forms to the database.

Remove/Keep

(Un)marks a period form to be deleted. Only effective after clicking 'Update periods'.

2. Importing transactions

Import Transactions

If you own the Δ Delta app, you can export transactions from it and import them
into Crypto-FIFO. The following fields/checkbox are available:

Period

Select a period in which the transactions should be imported.
For creating periods, see '1. Creating a period'

File

With 'Browse' you should select the *.csv file, exported by Δ Delta.

Fiat Assets

Here you define all fiat assets that are used in the csv.
Crypto-FIFO uses this to switch base and quote assets when dealing with Sells.

Delete before

If you check this, all existing transactions in this period will be deleted
before importing the new transactions.

The following action can be done:

Import

Imports the transactions into the database.

3. Manually handle transactions

Input Transactions

Next to importing transactions, transactions can also be handled manually.
As a prerequisite, the following fields need to be filled in:

Period

Select a period for which the transactions should be handled.
For creating periods, see '1. Creating a period'

Fiat Asset

This will set the fiat asset for all the period related transactions.

Hereunder you can find all possible transaction types with their required fields.

3.1. Buy

Use-case

Book bought crypto with fiat.

Trading Pair

The left asset (base) is the asset you bought.

The right asset (quote) is the asset you paid with.

Note: The quote asset should be equal to the configured fiat asset

Base Amount

The quantity/amount you bought.

Quote Amount

The amount you paid.

Fee Asset

The asset that was used to pay the transaction Fee.

Fee Amount

The fee amount that was paid.

Fee Fiat Rate

The fee asset to fiat ratio.

Note: If necessary you can get the average rate for the given "Date & Time" with the "Get Rate" button.

This rate is provided by cryptocompare.com .

Date & Time

The date & time of the transaction.

Sequence

Guarantees the order in which transactions are processed.
This is needed when the date and time of multiple transactions are equal.

Notes

Free text to describe your transaction.

3.2. Decrease investment

Use-case

Book reduced investment capital for a certain fiat amount.

Asset

The investment asset you have reduced from your investment capital.

Note: The investment asset should be equal to the configured fiat asset

Amount

The amount you have reduced.

Fee Amount

The amount of fee that was charged for this transaction.

Note: It's assumed this fee is also in fiat.

Date & Time

The date & time of the transaction.

Sequence

Guarantees the order in which transactions are processed.
This is needed when the date and time of multiple transactions are equal.

Notes

Free text to describe your transaction.

3.3. Increase asset

Use-case

Book increase of a certain fiat amount to your investment capital.

Asset

The investment asset you have added to your investment capital.

Note: The investment asset should be equal to the configured fiat asset

Amount

The amount you have added.

Date & Time

The date & time of the transaction.

Sequence

Guarantees the order in which transactions are processed.
This is needed when the date and time of multiple transactions are equal.

Notes

Free text to describe your transaction.

3.4. Increase investment

Use-case

Book increase of a certain fiat amount to your investment capital.

Asset

The investment asset you have added to your investment capital.

Note: The investment asset should be equal to the configured fiat asset

Amount

The amount you have added.

Date & Time

The date & time of the transaction.

Sequence

Guarantees the order in which transactions are processed.
This is needed when the date and time of multiple transactions are equal.

Notes

Free text to describe your transaction.

3.5. Opening Balance

Use-case

Set the start balance for a certain asset.

Asset

The asset for which you want to set the start balance.

Amount

The start balance amount.

Fiat Value

The start balance amount converted to fiat.

Date & Time

The date & time of the transaction.

Sequence

Guarantees the order in which transactions are processed.
This is needed when the date and time of multiple transactions are equal.

Notes

Free text to describe your transaction.

3.6. Sell

Use-case

Book the sell of a sold crypto asset.

Trading Pair

The left asset (base) is the asset you sold.

The right asset (quote) is the asset you got in return.

Note: The quote asset should be equal to the configured fiat asset

Base Amount

The quantity/amount you sold.

Quote Amount

The amount you received.

Fee Asset

The asset that was used to pay the transaction Fee.

Fee Amount

The fee amount that was paid.

Fee Fiat Rate

The fee asset to fiat ratio.

Note: If necessary you can get the average rate for the given "Date & Time" with the "Get Rate" button.

This rate is provided by cryptocompare.com .

Date & Time

The date & time of the transaction.

Sequence

Guarantees the order in which transactions are processed.
This is needed when the date and time of multiple transactions are equal.

Notes

Free text to describe your transaction.

3.7. Trade

Use-case

Book a trade of crypto assets.

Trading Pair

The left asset (base) is the asset you bought(traded).

The right asset (quote) is the asset you payed with.

Note: Both assets should be non-fiat assets

Base Amount

The quantity/amount you bought.

Quote Amount

The amount you payed.

Base Fiat Rate

The base asset to fiat ratio.

Note: If necessary you can get the average rate for the given "Date & Time" with the "Get Rate" button.

This rate is provided by cryptocompare.com .

Fee Asset

The asset that was used to pay the transaction Fee.

Fee Amount

The fee amount that was paid.

Fee Fiat Rate

The fee asset to fiat ratio.

Note: If necessary you can get the average rate for the given "Date & Time" with the "Get Rate" button.

This rate is provided by cryptocompare.com .

Date & Time

The date & time of the transaction.

Sequence

Guarantees the order in which transactions are processed.
This is needed when the date and time of multiple transactions are equal.

Notes

Free text to describe your transaction.

Exclude

Exclude transaction from FIFO gain/loss calculation.
E.g.: In some countries crypto-to-crypto trades are tax free.

3.8. Transfer

Use-cases
Book the fee for:
  • Sending assets from exchange to exchange
  • Sending assets from exchange to wallet
  • Sending assets from wallet to exchange
Fee Asset

The asset that was used to pay the transaction Fee.

Fee Amount

The fee amount that was paid.

Fee Fiat Rate

The fee asset to fiat ratio.

Note: If necessary you can get the average rate for the given "Date & Time" with the "Get Rate" button.

This rate is provided by cryptocompare.com .

Date & Time

The date & time of the transaction.

Sequence

Guarantees the order in which transactions are processed.
This is needed when the date and time of multiple transactions are equal.

Notes

Free text to describe your transaction.

The following actions can be done:

Add transaction

Creates an extra form to fill in a new transaction.

Update transactions

Sends all the transaction forms to the database.

Remove/Keep

(Un)marks a transaction form to be deleted. Only effective after clicking 'Update transactions'.

4. Reports
4.1. Balance Report

Reports Balances

After selecting a period you can do the following actions:
For creating periods, see '1. Creating a period'

Get Balances

Calculates reports for the selected period and gets balances.

Print

Prepares the report for print.

The following balances are available:

Balances

Shows the amount per asset.

Closing Balances in <fiat>

The closing balances calculated with the FIFO method, converted to fiat.

Balances in <fiat>

Shows the amount per asset, converted to fiat.

4.2. Transaction Report

Reports Transactions

After selecting a period you can do the following actions:
For creating periods, see '1. Creating a period'

Calculate Reports

Calculates reports for the selected period.

Print

Prepares the report for print.

Next to some of the input fields, the following calculated fields are available:

SHOTD (Sell Half On The Double) Rate

Rate at which the transaction can be sold half on the double.

SHOTD Amount

Amount to sell when selling half on the double.

4.3. FIFO Report

Reports FIFO

After selecting a period you can do the following actions:
For creating periods, see '1. Creating a period'

Calculate Reports

Calculates reports for the selected period.

Print

Prepares the report for print.

Next to some of the input fields, the following calculated fields are available:

Exchange Rate

Base/quote exchange rate.

Asset Total

Base total at the moment of the transaction.

Base Fiat Rate

Base asset to fiat ratio.

Quote Asset Total

Quote total at the moment of the transaction.

Quote Fiat Rate

Quote asset to fiat ratio.

Fee Asset Total

Total fee asset amount at the moment of the transaction.

Total Cost

Total cost of the transaction. (Fiat price + fiat fee)

XXX Remaining from transaction

Remaining XXX amount for passed transaction after FIFO handling.

Gain/Loss

Gain/loss of the transaction.

Gain/Loss Formula

The formula used to calculate the gain/loss amount.