Zum Inhalt springen

cwo

Mitglied
 Profil anzeigen  Aktivitäten des Benutzers anzeigen

  • Gesamte Inhalte

    4

  • Benutzer seit

  • Letzter Besuch

 Inhaltstyp 

Beiträge von cwo

    Trading-Gewinnermittlung für die Steuer - softwaregestützt

    in Recht und Steuern

    Geschrieben · Bearbeitet von cwo

    Hallo YetAnotherBTCGeek,

     

    Ich habe zur besseren Analyse ein csv-export für Dich erstellt:

    "txid","refid","time","type","aclass","asset","amount","fee","balance"
"LI47EH-FMCU2-FWEY4P","T666II-DWKOZ-JKN6PE","2017-03-02 21:10:58","trade","currency","XLTC",99.9301000000,0.0000000000,99.9301000000
"L6BEMW-DFICZ-4IKTA7","T666II-DWKOZ-JKN6PE","2017-03-02 21:10:58","trade","currency","ZEUR",-396.7225,1.0315,102.2460
"L6VG5L-XQ3HE-YVWGZ3","TDXX5H-45ASR-NB4EES","2017-03-02 21:14:36","trade","currency","XLTC",25.7546599400,0.0412065400,125.6435534000
"LJRD2I-ZCTNB-4NXKGW","TDXX5H-45ASR-NB4EES","2017-03-02 21:14:36","trade","currency","ZEUR",-102.2460,0.0000,0.0000
"LZYKC4-BFUZH-AYRRAN","TIIZDG-OYHVK-VXYFNQ","2017-03-10 07:42:33","trade","currency","XLTC",-125.6435500000,0.0000000000,0.0000034000
"LJQD6M-BJOKF-CWN4ZX","TIIZDG-OYHVK-VXYFNQ","2017-03-10 07:42:33","trade","currency","ZEUR",461.1118,1.1989,459.9129
"LV43JD-JKEIC-APQRB5","TH6IOK-L6NBJ-KS27D3","2017-03-13 14:00:14","trade","currency","XLTC",343.7866346400,0.0000000000,343.7866380400
"LNROYQ-HIEXX-YPHKQ7","TH6IOK-L6NBJ-KS27D3","2017-03-13 14:00:14","trade","currency","ZEUR",-1272.0106,3.3072,4317.5719
"LZIAJR-DYHZU-UMGDWZ","TBVOLU-DLFW3-R2ZFCI","2017-03-13 14:00:52","trade","currency","XLTC",2.8357865200,0.0000000000,346.6224245600
"L6SZ7H-CLAEP-5Z2CPE","TBVOLU-DLFW3-R2ZFCI","2017-03-13 14:00:52","trade","currency","ZEUR",-10.4924,0.0168,4307.0627
"LHCZRW-YHQ2V-GAE52G","TIOIK5-GLA4B-TM3MKJ","2017-03-13 14:10:06","trade","currency","XLTC",0.4482000000,0.0000000000,347.0706245600
"LYGLOP-7JIUC-CLUBQG","TIOIK5-GLA4B-TM3MKJ","2017-03-13 14:10:06","trade","currency","ZEUR",-1.6583,0.0027,4305.4017
"LKRKNH-DNHFX-AB4K4A","TDSMWH-PIWNK-MWE7TL","2017-03-13 14:18:41","trade","currency","XLTC",2.0451068700,0.0000000000,349.1157314300
"LVHRGF-IAHPJ-GIJE2L","TDSMWH-PIWNK-MWE7TL","2017-03-13 14:18:41","trade","currency","ZEUR",-7.5669,0.0121,4297.8227
"L5QGQE-Y4IHM-UTFYB3","TTVBVF-NDBBK-QWBRIY","2017-03-13 14:55:05","trade","currency","XLTC",-7.6741394900,0.0122780600,341.4293138800
"LBHHXF-LE7VW-EKJ3M7","TTVBVF-NDBBK-QWBRIY","2017-03-13 14:55:05","trade","currency","ZEUR",30.0826,0.0000,4327.9053
"LQM3B3-YQ6G5-CAQMC2","T3RJ5B-VJBS7-SSTM2R","2017-03-13 14:55:11","trade","currency","XLTC",-34.1884734700,0.0547015300,307.1861388800
"LXEKIK-UEFXB-IVBEKA","T3RJ5B-VJBS7-SSTM2R","2017-03-13 14:55:11","trade","currency","ZEUR",134.0188,0.0000,4461.9241
"LT2HPY-DAYPK-BNR63C","TAFWVP-444BM-H4HUY6","2017-03-13 14:55:17","trade","currency","XLTC",-7.6741394900,0.0122780600,299.4997213300
"LNGRGY-DX3H5-ASWSU6","TAFWVP-444BM-H4HUY6","2017-03-13 14:55:17","trade","currency","ZEUR",30.0826,0.0000,4492.0067
"LMBFIT-QKEAA-QFP7GV","TFLY5N-R5OBW-HXDE5S","2017-03-13 14:55:27","trade","currency","XLTC",-6.6641327800,0.0106632600,292.8249252900
"LJ27J3-ASQFL-VAQCBS","TFLY5N-R5OBW-HXDE5S","2017-03-13 14:55:27","trade","currency","ZEUR",26.1234,0.0000,4518.1301
"LG55CX-UIBGA-YEWSRW","TXRZ5S-VR4GM-3O77KH","2017-03-13 14:55:36","trade","currency","XLTC",-292.8249252900,0.0000000000,0.0000000000
"LHFH54-YPVVB-FOFXQA","TXRZ5S-VR4GM-3O77KH","2017-03-13 14:55:36","trade","currency","ZEUR",1147.8737,1.8366,5664.1672
"LJCK6F-43FGX-INXHUG","THNSZ4-NSHF4-T32T4Z","2017-03-13 15:02:00","trade","currency","XLTC",204.7731215100,0.0000000000,204.7731215100
"LZNSW3-KQJ27-YB7VDU","THNSZ4-NSHF4-T32T4Z","2017-03-13 15:02:00","trade","currency","ZEUR",-812.0360,2.1113,4850.0199
"LPBQ4N-A2SO5-QO7FLX","TVUBTJ-FTM3O-QU2YQL","2017-03-13 15:02:08","trade","currency","XLTC",0.1519000000,0.0000000000,204.9250215100
"LYBZSO-SBHLA-IUQU4G","TVUBTJ-FTM3O-QU2YQL","2017-03-13 15:02:08","trade","currency","ZEUR",-0.6030,0.0010,4849.4159
"LI5RDG-FQAF7-LY22XJ","TW3QM4-F6R5Q-G57JI2","2017-03-13 15:14:06","trade","currency","XLTC",-197.4419419700,0.5159175000,6.9671620400
"LSECNA-WRZJH-DWD76F","TW3QM4-F6R5Q-G57JI2","2017-03-13 15:14:06","trade","currency","ZEUR",810.9809,0.0000,5660.3968
"LR34RS-35WCL-LHH7S7","TWEFZD-UZOXP-JD3ECM","2017-03-13 15:14:12","trade","currency","XLTC",-6.9671620400,0.0000000000,0.0000000000
"LJJZGK-4Q6KF-ISUGXE","TWEFZD-UZOXP-JD3ECM","2017-03-13 15:14:12","trade","currency","ZEUR",28.4957,0.0456,5688.8469
"LWZU4F-NJN6K-BEJSJV","TFTLHL-ONSIH-A6WTWQ","2017-03-13 15:18:36","trade","currency","XLTC",171.4800000000,0.0000000000,171.4800000000
"LHVVF4-KMQ4K-MAHJEL","TFTLHL-ONSIH-A6WTWQ","2017-03-13 15:18:36","trade","currency","ZEUR",-714.6463,1.8581,4972.3425
"L54PAT-CFWJZ-VSE3MG","TPBH3Q-3M5SS-PDZWWK","2017-03-13 15:18:36","trade","currency","XLTC",72.9210060000,0.0000000000,244.4010060000
"LO5GEB-7FZW7-NFSXTG","TPBH3Q-3M5SS-PDZWWK","2017-03-13 15:18:36","trade","currency","ZEUR",-303.9005,0.7901,4667.6519
"LP2L34-V4SP5-K4AKGT","TSQUSK-VFRC4-QZPLXY","2017-03-13 15:18:36","trade","currency","XLTC",24.4686031100,0.0000000000,268.8696091100
"LR3ARK-WZD4V-4KCVBX","TSQUSK-VFRC4-QZPLXY","2017-03-13 15:18:36","trade","currency","ZEUR",-102.0001,0.2652,4565.3866
"LPSJK4-QFOJZ-INA4RR","THFD7G-7YC5B-HARCPG","2017-03-13 15:18:46","trade","currency","XLTC",31.1303908900,0.0000000000,300.0000000000
"LG4GH5-F6QEA-N3FWLB","THFD7G-7YC5B-HARCPG","2017-03-13 15:18:46","trade","currency","ZEUR",-129.8137,0.2077,4435.3652
"LJ2ARR-5VIEK-DCFE5M","TSTQ6G-CJ7FC-2WSNIW","2017-03-13 15:29:22","trade","currency","XLTC",-135.9409000000,0.0000000000,164.0591000000
"LP7F3E-KUVHU-REG2KJ","TSTQ6G-CJ7FC-2WSNIW","2017-03-13 15:29:22","trade","currency","ZEUR",564.1547,1.4668,4998.0531
"L5SGJ7-R54MW-YTQM54","TCDFB6-75WQC-FCN467","2017-03-13 15:29:22","trade","currency","XLTC",-164.0591000000,0.0000000000,0.0000000000
"L7YPWQ-6XIWN-OQ2RPK","TCDFB6-75WQC-FCN467","2017-03-13 15:29:22","trade","currency","ZEUR",675.9235,1.7574,5672.2192

    Nach dem Import sollte die LTC Balance auf 0.00 stehen, es verbleiben aber 0,60583841 im Bestand. Die Gebühren werden mit 0,64704495 berechnet, was korrekt aussieht.

     

    Noch ein paar kleine Anmerkungen:

    Der Kauf incl. Gebühr wird korrekt gebucht:

    "L6VG5L-XQ3HE-YVWGZ3","TDXX5H-45ASR-NB4EES","2017-03-02 21:14:36","trade","currency","XLTC",25.7546599400,0.0412065400,125.6435534000

    Hier wird die kaufende Balance wie folgt erhöht:

     

    99,9301 (vom vorherigen Eintrag) + 25,7546599400 =125,6435534 (balance)

     

     

     

    Die Verkäufte incl. Gebühr hingegen führen zu dem Überschuss an Bestand. z.B. dieser hier:

    "LT2HPY-DAYPK-BNR63C","TAFWVP-444BM-H4HUY6","2017-03-13 14:55:17","trade","currency","XLTC",-7.6741394900,0.0122780600,299.4997213300
     

    Hier wird die verkaufende Balance wie folgt verkleinert:

     

    307,18613888 (vom vorherigen Eintrag) - 7,6741394900 - 0.0122780600 (Gebühren) = 299,4997213300 (balance)

     

    Intern scheint Kraken also die Gebühren beim Kauf (nach dem Kauf zu verbuchen) und beim Verkauf nehmen sie erst die Gebühren und dann den Rest. Könnte zumindest eine Erklärung sein, warum die Einträge nicht symetrisch sind.

     

     
    Viele Grüße
    cwo

    Trading-Gewinnermittlung für die Steuer - softwaregestützt

    in Recht und Steuern

    Geschrieben · Bearbeitet von cwo

    Es gibt ein zweites Problem, das beim Import der Kraken-Daten auftritt: ein Ledger-Eintrag, der nur eine einzige Seite hat.

    Ganz selten scheint Kraken so kleine Summen zu haben, dass auf der Gegenseite 0 verbucht wird. Dann fehlt die Gegenbuchung in den Ledgers. Das führt beim Import zu einem Abbruch.

    Ich musste das XML manuell anpassen, damit es durchläuft. Ein API-Import ist damit nicht möglich.

     

    Hier der Beispielauszug aus dem XML:

     

    "txid"               ,"refid"                ,"time"               ,"type"      ,"aclass"  ,"asset","amount"       ,"fee"
    "L2FVH7-LSCBH-RAYLLK","TMA3QN-KP22B-ZCFEK3"  ,"2017-08-14 09:04:03","trade"     ,"currency","XXBT" ,0.0141752500   ,0.0000000000
    "LQIJ5J-66KA7-GMJ622","TMA3QN-KP22B-ZCFEK3"  ,"2017-08-14 09:04:03","trade"     ,"currency","ZUSD" ,-58.5580       ,0.0351
    "L3MMQV-VX42Z-A32U23","TBFPUW-4726W-DONWFU"  ,"2017-08-14 09:04:13","trade"     ,"currency","XXBT" ,0.0000000100   ,0.0000000000
    "LBJ3IE-TBV6S-GPNZOQ","TCN75L-NOWJA-WV2CBG"  ,"2017-08-14 09:04:13","trade"     ,"currency","XXBT" ,0.2493742900   ,0.0000000000
    "LIF6KI-NH3QC-Y5LZMR","TCN75L-NOWJA-WV2CBG"  ,"2017-08-14 09:04:13","trade"     ,"currency","ZUSD" ,-1030.1652     ,0.6181
     
    Der L3MMQV-VX42Z-A32U23/TBFPUW-4726W-DONWFU ist als Trade markiert, hat im Ledger nur einen Eintrag - und keine Gegenbuchung (im Gegensatz zu "normalen Trades")
    Vermutlich ist die Gegenbuchung im Wert von 0$ erzeugt worden. Das führt aber leider zu einem Abbruch des Imports.
     
    Viele Grüße
    cwo

    Trading-Gewinnermittlung für die Steuer - softwaregestützt

    in Recht und Steuern

    Geschrieben · Bearbeitet von cwo

    Hallo YetAnotherBTCGeek,

     

    ich denke, ich habe einen Fehler in der aktuellen Version (0.9.3) beim Kraken-Import gefunden, denn die Ein/Ausgänge werden nicht korrekt eingebucht. Es bleibt immer eine Differenz offen zu der Berechnung im Kraken-Ledgers-XML.

     

    ich nehme mal folgende Zeile aus dem Ledger XML-export:

     
    "txid","refid","time","type","aclass","asset","amount","fee","balance"
    "L5QGQE-Y4IHM-UTFYB3","TTVBVF-NDBBK-QWBRIY","2017-03-13 14:55:05","trade","currency","XLTC",-7.6741394900,0.0122780600,341.4293138800
     
    Daraus werden zwei Buchungen erzeugt:
    9730;"13.03.2017 15:55:05";"Verkauf";"Kraken.com";"Litecoin";7,67413949;7,66186143;"Kraken.com";"Euro";30,0826;30,0826;30,0826;"L5QGQE-LBHHXF";"trade LTC";False;""
    9731;"13.03.2017 15:55:05";"Gebühr";"Kraken.com";"Litecoin";0,01227806;0,01227806;"Kraken.com";"Gebühr Litecoin";0,01227806;0;0;"L5QGQE-LBHHXF/fee";"Gebühr zu Trade Referenz L5QGQE-LBHHXF";False;""
     
    Das sieht auf den ersten Blick korrekt aus, doch stimmt die "balance" nicht mit der bei Kraken überein. Bei der Anlage der Original-Buchung wird m.E. brutto und netto falsch berechnet.
    In der 9730 ist der
    QuellBetrag: 7,67413949 = "-7.6741394900" aus dem Ledger
    QuellBetragNetto: 7,66186143 = "-7.6741394900" + "0.0122780600" Gebühren
     
    Scheinbar gibt Kraken die Zahlen aber als Netto aus. Die m.E. korrekt Berechnung wäre demnach:
    QuellBetrag: 7.68641755 = "7.6741394900" + "0.0122780600" Gebühren = "7.68641755"
    QuellBetragNetto: 7,6741394900 = "-7.6741394900" aus dem Ledger
     
    Könntest du das Prüfen und das Anlegen der Buchungen anpassen?
     
    Viele Grüße
    cwo
×
×
  • Neu erstellen...

Wichtige Information

Wir haben Cookies auf Deinem Gerät platziert. Das hilft uns diese Webseite zu verbessern. Du kannst die Cookie-Einstellungen anpassen, andernfalls gehen wir davon aus, dass Du damit einverstanden bist, weiterzumachen.