Yes @Recchan, at Emma everyone knows basic SQL concepts and obviously we already assign own unique ids to everything.
This is a complex problem because itās about automated transaction āreconciliationā, not merely keeping track of edits.
Plaid, the leading banking API provider we use in US and Canada, with an engineering team of hundreds of people in silicon valley, has only recently developed a feature that may solve this problem.
I recommend you check out the article below to learn more about the kind of work it takes to make something that looks stupidly simple, yet behind the curtains it took months of trial and error of Machine Learning algorithms to make it work.
We are checking with the real data we have if the Plaid solution is actually reliable for every single bank or just marketing BS, because we really care about not losing your transaction edits and attachments.
If this proves to be good we can roll out editing of pending transactions at least for Plaid and try to bring it to every other bank. We agree itās a really good feature.
If youāre an engineer reading this and thinking you have what it takes to solve these kind of problems, Iād love to chat: antonio @ emma-app