Then something went wrong with one step. Please write us a ticket via our HelpDesk.
Dominik
I have just tried this all again.
Which step?
There are a total of 2 steps
Step 1. Export .csv report to hard drive and save
Step 2. Import .csv report to Cointracking
All completed within 2 minutes.
Same problems as reported to you before so which step is wrong?
??
I exported the report in CSV Extended view to my laptop.
I then re imported the same file into my Practice account via the Enter Coins page CSV and Excel import tools and compared the resultant entries with the original entries still in my Personal account and the bad news is that they are not identical.
The re import transfers all the correct existing data from the Comments column into the Group column, inserts a random date into the Comments column, deletes all the listings of exchanges under the Exchange column and removes all the entries under both the Fee and Currency columns?
You can see this for yourself in my Practice account.
Why is this happening when it is the same file(s) re imported that was exported moments earlier?
Obviously this messes all reports up and is useless to rely on for backup locally.
Please advise on how to fix this here openly on this forum as from experience things seem to get lost in the Help Desk.
Thank you
Hi AussieWayne,
Exporting the trade list is really a great way exporting all of your data including Tx and buy and sell values.
Before importing you have to move the columns around and adjust the headers from the export so they are in the right order. This is the order what I'm using:
Type,Buy Amount,Buy Currency,Sell Amount,Sell Currency,Fee,Fee Currency,Exchange,Trade-Group,Comment,Date,Tx-ID,Buy Value in your Account Currency,Sell Value in your Account Currency
Also pay particular attention to the date column. That's where things usually get messed up for me. I use a lot of Custom Exchange imports and have to adjust the cell format for the date column most of the time before importing. I'm sure that there's an easy way but I haven't had the time to look into it.
Looking at my import template the cell format for the date column should be as follow: yyyy-mm-dd h:mm:ss
But that's just for me. I might use different regional setting on my computer than you. Try it out. If you get the right date and time you're fine. Other than that this method of exporting all your trading data and re-import into another account works beautifully.
If you still can't get it right try using google sheets. Excel messes with a lot of things and if you don't fully understand it you might get frustrated and give up in the end. Or use a text editor like Notepad++. One of the best ways to manupilate but not change the format of a csv. Although not as convenient as excel.
There's also another method of moving data between accounts.
1. Create a backup in your main account
2. Click restore on that new backup
3. You can now select the account, if connected, where your backup should get restored.
Very convenient I find.
Don't give up mate. I also struggle with a view things and there's a steep learning curve but the more I try and play around the more I like it. Also every country has different tax and reporting requirements. It's a lot for them to cover.
If you're not sure what to lodge with your tax return and whether your stuff is correct or not then at least lodge something. You can still amend once you got the hang of it and got it right. --> No tax advise here!!!
I haven't found a better and more complete tool other than CT.
Cheers and good luck