I assume that there’s an existing table (1) in Emma that stores the users’ transaction augmentation data (notes, category, etc.) indexed on their account + transaction ID. It doesn’t hold information about pending transactions because their transaction IDs are unstable - the issue we want to solve.
I imagine a copy of that table (2) for pending transactions with a different key: account + merchant + value + sequence id to which the same data is written when the user augments a pending transaction. This table also stores the unstable transaction id and a last seen batch id. The sequence id is only used when we have rare duplicate pending transactions - it allows us to try to keep them in sequence.
When we receive a batch of records for the users’ account, we start by processing the non-pending ones. We do a partial key look up (excluding sequence id) on each non-pending transaction on table 2 ordered by sequence id. If we match a record, we copy the data from the first matching record to table 1 and delete that record from table 2.
We then process the pending transactions. For each record in turn (in date order if possible) we do a partial key look up (excluding sequence id) on table 2 for records that do not already have this last seen batch number, ordered by sequence id. If we get a match we update the unstable transaction id and the last seen batch id for the first matching record. When we’ve finished loading the whole batch we delete any records from table 2 for this account whose last seen batch id does not match the one we just loaded (the pending transaction has changed or vanished.)
When the user goes to augment a pending transaction they receive a warning: “Pending transactions sometimes change or even vanish. Any information you add BEFORE the transaction is confirmed WILL be lost if that happens.” In the event the user proceeds to update a pending transaction for which there is a duplicate record (same account + merchant + value), when we add the data to table 2 we include a sequence id to distinguish them.
Sorry for not getting back to you sooner about this. I’ve mentioned to the rest of the team about increasing the split transaction feature up to 12 instead of 10, so hopefully we will be able to roll something out soon!
Option to remove subscriptions from “This week you spent XXX”. Otherwise, there are big differences between weeks when you pay your rent for instance and other weeks. Ability to look at historical weekly spend.
Welcome to the Emma Community! We have an introduction page here if you wanted to say hello.
Thanks for this suggestion - at the moment the only way you could remove things like rent from the “This Week You Spent” is to exclude the transaction, but I’ll mention the idea to the rest of the team
So I just realized that there is no feature to save towards a specific goal. Like put away a certain amount every week, month, etc. to make a specific amount by a specific time. Or just have a goal that doesn’t have a specific time limit. And any leftover money from the monthly budget goes towards that goal.
Another thing is that I like to put 10% of my income in a savings account. I don’t know if emma would be able to automatically transfer that 10% (or any chosen amount) from my checking account (rbc) to my savings account with the same bank. Would be great and a lot more convenient for me.
This is something we’re currently thinking about You wouldn’t be able to use Emma to transfer money between accounts, but we do like the idea of motivating people to save with some kind of goal tracker…
One way of doing this with a Pro account (when Smart Rules are working) would be to create a manual Loan account (negative balance is your target), then create a rule to add real transactions. It would be really easy for Emma in fact to add a Goal account that does exactly the same thing, but just tracks the balance as a percentage of your goal.
Of course, the money would have to be going to some real savings account somewhere!
A setting option to choose between displaying merchant icons or category icons (esp for custom categories) would be great please in all transactions view and any other similar view.
Typically the merchant name is in transaction anyway so I’d prefer to see the icons I’ve created for my custom categories. Easier to scan transactions at a glance but realise may not suit everyone. Thanks!
When changing categories, please display current categories of the additional transactions to select!
I’m just starting, and I have a ton of Amazon transactions. Some are business expenses, some are groceries, and some are shopping. But when I go to change categories of multiple transactions at once, I can’t tell if I’ve already changed the category for a transaction or not, so something that I already classified as a business expense might get inadvertently changed to shopping