I was going to make this slightly more bulletproof but I threw this together for _freshface and I’ve not really got the time to extend it much futher. It takes your statement and spits out a reformatted one into another .csv file. It should be fairly straightforward to use though.
Yeah, good job Thomas! Thank you very much for taking the time for it
@Joost I just copy paste the outputs into one excel file.
Having all the juicy details locked up in a string makes out of the box excel processing not possible. Dev’s should keep the string representation of the statement item there if they want, but split out the good stuff into new columns like “rate” “sale amount” “sale/widthdraw/etc” “item name” and “item_id”
the date isn’t too hard to parse, excel should be able to recognise it. if not, then a Y-m-d H:i:s would be perfect.
The statement CSV is how it is for no real good reason, other than that’s how it got built originally. And it’s a bit tricky to change (in its current form)
Over the past few months however, we’ve been making a lot backend changes in how our accounting system generates reports internally.
There’s still a bit more work going on behind the scenes, but when it’s all finished it will be much easier to produce more meaningful account statements – and we’ll be pretty open to suggestions (within technical feasibility) on how that data comes out.
If you’ve noticed we’ve been sluggish on API change requests and issues with the statements, it’s largely because the backend code supporting these bits have been in flux.