|
Post by jmpt on Jul 5, 2016 16:17:22 GMT
Hi,
Have anyone came up with an excel spreadsheet using formulas, to extract the data exported from AC, that you might want to share?
I was trying to get something like that done, so I could get some relevant data (like ID, operation type as in/out/interest/repayment, etc) but or I am doing some weird things here or the exported statements are missing something. I find them quite confusing to start with.
The idea was then to import them into a database and create some custom reports (this is the easy part...).
Thank you, J.
|
|
|
Post by jmpt on Jul 5, 2016 17:33:38 GMT
OK, think I got it... Some operations were marked incorrectly on the exported statement as a transfer to an account when they could only be the other way... (Green Investment to Quick Access Account and not the other way around).
J.
|
|
duck
Member of DD Central
Posts: 2,880
Likes: 6,960
|
Post by duck on Jul 6, 2016 5:34:24 GMT
Just for info, you need to keep an eye on the download statement, terminology changes and if the spreadsheet relies on word searches it will fall over.
For instance at 28/6 you saw Investment into Manual Loan Investments Account (1) at 1/7 you see Investment into qaa swept from
Similar changes happened with the GBBA so I presume the same happened with the Green Account but since I don't have one so can't check.
|
|