bitsofwinter / cryptotaxsweden Goto Github PK

I haven't got there yet but I'm guessing we need a new K4 template for 2018 and a code change to select that file? Thanks by the way for an awesome help tool.

Been using Bitstamp with EUR account and was wondering if you could add support for EUR to SEK and SEK to EUR.

Thanks for a great job.

Hej, jag förstår inte hur jag öppnar programmet efter att ha laddat ner det.
När jag dubbelklickar på "Report" filen så öppnas terminalen med detta meddelande:
/Users/stationarmac/Documents/Crypto/Historik/CoinTracking/cryptotaxsweden\ mac\ /report ; exit;
usage: report [-h] [--trades TRADES] [--out OUT] [--format {pdf,sru}]
[--decimal-sru]
[--exclude-groups [EXCLUDE_GROUPS [EXCLUDE_GROUPS ...]]]
[--coin-report] [--simplified-k4] [--rounding-report]
[--rounding-report-threshold ROUNDING_REPORT_THRESHOLD]
[--cointracking-usd]
year
report: error: the following arguments are required: year
logout
Saving session...
...copying shared history...
...saving history...truncating history files...
...completed.

[Process completed]

Men jag kan inte skriva något eller ändra på något. Hur ska jag göra för att kunna köra commandona som ni skriver i guiden?

jag försökte även i windows via Parallels Desktop men när jag dubbelklickade på exe filen så öppnas bara cmd snabbt och stängs igen.

Tack för hjälpen

Executing this using python3, exposing trades.csv in the data directory, I get this:

pi@raspberrypi:~/cryptotaxsweden $ python3 report.py 2017
Traceback (most recent call last):
  File "report.py", line 7, in <module>
    import tax
  File "/home/pi/cryptotaxsweden/tax.py", line 25
    raise Exception(f"Not enough coins available for {self.symbol}, {self.amount} < {amount}.")

SyntaxError: invalid syntax

It's a bit hard to determine what's going wrong here;

• Is there something wrong in my trades.csv file?

I would assume that the script wanted to echo the symbol and amounts with their actual values, but I seem to only get it in their code authored form.

Any chance you could add conversion rates (USD/SEK) for all of 2018? The current file only covers Q1 2018.

Other than that I guess the current version should work just fine for 2018 as well (after adding the K4 template for 2018 to the data folder), right?

How are fees handled btw? Are they included in the purchase price?

I keep getting the error "Not enough coins avaliable for BTC 0.00XXX < 0.00XXXX" when trying to run the script. All transactions are imported and deposit/withdraw from Exchange as well.

The most generated income is mining deposits beside a few cash deposits. Can the script identify mining income?

Hello there, I am a tad puzzled,
Command : report 2018 --simplified-k4
Exception encountered at line 442 in trades csv-file: Selling currency ETH which has not been bought yet Aborting tax computation.

It is the data from Binance > Cointracking > CSV, Any idea what am I missing here?.

Thank you.

Hi, thanks for the script!

I'm trying to upload the generated .sru file(s) to my Deklaration, but I'm not sure where I'm supposed to do it. When I add a K4-bilaga, and try the "importera" button I get an error saying: " Filen info/blanketter.sru innehåller inga K4-försäljningar. ".

What am I doing wrong?

Very minor issue, but I was generating a correction for 2016 and noticed that 2017 is preprinted in the K4 pdf.

Windows v0.5 fungerar inte alls. Verkar som pyinstaller missade att ta med dateutil:

report.exe

Traceback (most recent call last):
  File "report.py", line 6, in <module>
  File "c:\temp\build_cts\repo\venv\lib\site-packages\PyInstaller\loader\pyimod03_importers.py", line 631, in exec_module
  File "taxdata.py", line 2, in <module>
ModuleNotFoundError: No module named 'dateutil'
[11148] Failed to execute script report

Please correct me if I am wrong but as I understand from glancing at the code:

Let's say you bought BTC with SEK then bought LTC with that BTC then sold that LTC for SEK.
The cost basis calculation always adds the column "value in SEK" price to the average. In the above scenerio The cost for buying that LTC is taken from the cointracking database in SEK on the trade day. But the actual cost is the SEK value of BTC you bought. Similar example is given on the https://www.skatteverket.se/privat/skatter/vardepapper/andratillgangar/kryptovalutor.4.15532c7b1442f256bae11b60.html third example down on the page.

Hi, while running this I get an error. what could i possibly look into to fix this?
Downloads\cryptotaxsweden_win\cryptotaxsweden>report.exe 2017 --simplified-k4 Traceback (most recent call last): File "report.py", line 39, in File "taxdata.py", line 98, in read_from IndexError: list index out of range [8116] Failed to execute script report

Some of my transactions contains purchases with cryptoassets. I have marked them all as "spend" on cointracking and guess these need to be added in the script for the calculation to be correct?

How are they handled now and if not handled at all could you please consider adding it to the script?

I noticed that the conversion rates used to calculate the "value in SEK"-column are often off by a lot on cointracking. I think this is because cointracking uses bitcoinaverage which seem to base their BTCSEK exchange rate on a just a few localbitcoin trades, see this, resulting in a very inaccurate value on some days.

A solution might be to set the cointracking currency to USD and then do conversions to SEK using the conversion rate from google finance. It is possible that this solution might break something else though.

Hi,

I have a question on why are all the SEK amounts (försäljningspris, omkostnadsbelopp, vinst, förlust) in the K4 form rounded to whole numbers? Isn't the script calculating always using floating point numbers ? Why not show it with decimals in K4 ?

Thanks,
Marko.

Getting this error.

Traceback (most recent call last):
File "report.py", line 38, in
File "taxdata.py", line 98, in read_from
IndexError: list index out of range
[15240] Failed to execute script report

File: exported trades.csv from cointracking
Edited the personal template.

Hi,

First of all, just want to say - impressive job! Thanks so much for providing this tool - easing the job for all the rest of us panicking when trying to declare crypto gains/losses... I have tried generating K4 for both 2017 & 2018 and it works good. Now I have K4 reports. But i am afraid of uploading them to SKV as I wouldn't be able to explain where the cost basis are coming from, i.e. prove the average cost basis of all trades in the K4 report. Am I missing something - Is there a way to do this? Or are there any plans in the future to add support for Hjälpblankett SKV 2198 - making it possible to easily prove the cost basis in a very clear way? By having that it would enable to double check that all calculations in the k4 report are correct.

Anyhow - many thanks for taking time building this tool... Cred to you!

Hi,

I'm trying to use your script which seems really useful, especially to me who doesn't speak Swedish :-)
If I could just get it to work...

After importing all the data from exchanges to CoinTracking, exporting the data to trades.csv and running the report.py script, it fails immediately with exception:

Exception: Selling currency EUR which has not been bought yet

I've been looking into the code a bit, and from the first glance it seems to me that it could be due to that trade types "Deposit" and "Withdrawal" are not supported by the script... Or am I misunderstanding something ?
Also, adding to the same question, are transfers between the exchanges supported ?

Thanks for all the hard work :-)

Regards,
Marko.

Having done a fair amount of work with CoinTracking I'm surprised to see something I can't really understand.

Adding Deposits as Gift/Tip [In], includes them in the calculation for profit, loss and tax.
However, adding Withdraws as Gift [Out], doesn't include them in the calculation for profit, loss and tax.

I don't really grasp this. If a Gift/Tip [In] is seen as an increase in account value, then surely a Gift [Out] should be seen as a decrease, right?
Should I simply detract my withdraws from my deposits to get the correct total account value as a base for tax calculation?

What gives?

I could make a pull request to expand on the documentation about this, as I believe it's one of the things that pop up frequently.

I believe the message raise Exception(f"Selling currency {trade.sell_coin} which has not been bought yet") usually occur because deposits and withdraws aren't recorded properly?

But, since I'm not overly familiar with all the situations that could raise this issue, I'd like to ask if there are other variants to this?

I think that could be put into the FAQ area of the README, or maybe better yet, inside the Wiki.

Hej, jag hoppas någon kan hjälpa mig med denna fråga:
Jag har Cointracking.info och försöker förstå hur jag ska få mina insättningar och trades att bli inlagda rätt. Jag har använt Api importen och försökt att fixa det som behövs själv men jag vet inte riktigt hur jag ska göra.
Jag har ställt in Cointracking på SEK som min huvud Valuta.
Men när jag fört över pengar från min bank till tex Coinbase så blir ju överföringen i EURO och som jag förstår det så krånglar det till det lite med hur man ska redovisa detta i cointracking.
Är det någon som vet hur man gör en transaktion enligt nedan?

1. Jag gjorde en Banköverföring av : 364.56 EUR Från Min Bank "Swedbank" till "Coinbase".
2. Jag flyttade mina 364.56 EUR Från Coinbase till mitt Coinbase Pro account.
3. Från Coinbase Pro köpte jag 0,11464188 BTC med mina 364,56 EUR
   (4. Min huvudvaluta i cointracking är SEK)

Jag bifogar en printscreen på hur det nu ser ut när jag har importerat från Coinbase API och även lagt till en manuell post där jag för över ("deposit") från swedbank, men jag tror detta är helt fel.
Så hoppas någon kan hjälpa mig då jag börjar bli lite stressad med att bli klar med min deklaration

Tack så jättemycket.
Printscreen:
https://imgur.com/B1mO04z