trezor-suite icon indicating copy to clipboard operation
trezor-suite copied to clipboard

Modify export files (PDF, .csv, JSON)

Open Hannsek opened this issue 2 years ago • 2 comments

Current export of past transactions is insufficient. Therefore, changes in the exported files are proposed.

proposed changes

  • [ ] divide current Date & Time column to Date and Time columns
  • [ ] add time zone to Time column (e.g. 9:49:53 CET)
  • time zone should be local (e.g. in Prague - CET, in New York - EDT), watch out for time cahnge
  • [ ] add Symbol column (e.g. BTC, ETH, …)
  • [ ] add Fee column
  • [ ] add Fiat value (currency) colum
  • fiat value at the time of transaction
  • currency set in settings
  • currency symbol only in header of the column
  • [ ] divide Addresses column to Address and Label columns
  • in case of one transaction with multiple outputs, every address will have its own row
  • Date, Time, Type, Symbol, Transaction ID values will be the same
  • OP return will stay right next to the address
  • fee value will be written only next to the first Transaction ID value - other rows with same transaction ID will be without fee value in Fee column
  • [ ] change the name of the exported file to labeloftheaccount_yyyymmddThhmmss (e.g. Account1_20220801T103427)
  • in case of no label is used, use name of the account

Layout of the .csv file (other types should be modified in the same style) Date;Time;Type;Transaction ID;Fee;Address;Label;Amount,Symbol,Fiat value (currency)

old .csv file: export-btc-1659437329948.csv new .csv file Bitcoin#1_20220802T131432.csv

Hannsek avatar Aug 02 '22 08:08 Hannsek

Bug to consider resolving: https://github.com/trezor/trezor-suite/issues/4604

sime avatar Aug 03 '22 12:08 sime

Fiat value and a csv that opens properly in excel (accountants software of choice) would have been nice for tax season.

  • [x] Id add time stamp as well

mwanser1 avatar Aug 07 '22 23:08 mwanser1

New .csv file: Bitcoin.1_20220802T131432.csv

Hannsek avatar Aug 24 '22 06:08 Hannsek