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 Smiley
Mr Bee
Thank you for taking the time to respond with your thoughtful advice.
I have tried exporting via the Trades List and also via the Trade Table and then re importing the same unedited file back into Cointracking.
Both ways introduce different mistakes and differing results due to the multiple values CT applies.
I am still waiting on a response from CT support after supplying them with all the files and detailed info so will let you know the outcome.
Creating a backup only saves the data into CT and not on my laptop unfortunately. I would like to remove all backups to my local hard drive so that when and if the online security at CT is breached then my records should be safe as they will not be stored on their servers.
I now have a pretty good understanding of the date format problems having spent countless hours on understanding and solving various date problems to be able to import and make sense of my records. It seems to work in various date formats not just the one which is as it should be to cater for different formats used around the world.
The learning curve as you mention is steep beyond belief. I acknowledge that what CT is attempting to do is very complicated and convoluted and has so many parameters to consider in arriving at meaningful results BUT it introduces multiple values for each transaction as outlined in my earlier post on the 2nd March re the hypothetical purchase of 1 BTC example. This where a lot of the incorrect results stem from and CT support still refuses to supply a detailed explanation of why it does this?
I do agree that CT is the potential leader in the field of crypto record keeping and it is such a shame that they do not put a greater effort into providing support to their customers when those customers identify problems that are occurring within the way that CT works. I still do not have a detailed answer to my post of 2nd March despite their protestations that they have answered each of these queries which they certainly have not. Just imagine how much better CT would be if they actually learned from their customers reports of the problems that they experience instead of blindly believing that CT is PERFECT and that customers reports are always customer error. I acknowledge that due to the complexities involved with CT some but not all customer complaints are customer error but...
I do thank you for your positive encouragement and I will not be giving up as I can see the potential of the power of the CT program:)
Hopefully these blemishes can be straightened out and in time CT can assume the mantle of the worlds leading crypto accounting software.
Wayne