@edoardomoreni
This is very desirable. Let me challenge the believed complexity of this:
In my experience pending transactions don’t actually change much when they are posted. The vendor always stays the same. The amount may change. I don’t think it ever changes in my banks. The date will change. But the date does not really matter for budget assignment.
Hypothetical scenario 1: You let me change the budget category on a pending transaction. You save it in a pending table (in addition to your regular tables): Vendor, Amount, Date, New Category. In a few days the transaction is posted… The original transaction is gone (removed from your regular tables). The new transaction comes in as posted with the regular budget category (unrelated to the original transaction, different ID). You match the new transaction first to the pending table. If there is anything for this vendor, this exact amount and date >= pending date + 10 days – that’s a match – you grab the New Category from the Pending table and apply it to the new transaction. Remove record from the pending override table. I would suggest doing second select without amount. Only if the first select was unsuccessful.
Scenario 2: I made two transactions in the same store. Both are pending. I marked one as Shopping. The same story for the tables. If you do select on exact amount – Emma will find the one for shopping.
You can store tags, notes, receipts, exclusion flag, even split info in the pending table. The key is to have the vendor, the amount and the date (within the last 10 days) in a separate table for lookup.
Scenario 3: My wife bought a yoga mat when she was grocery shopping. Single receipt. Say $100. The mat is $35. I do a split of a hundred. It is saved in the pending table. When transaction is posted – Emma will find the pending override record by exact amount.
Scenario 4: I fill up my tank. Pay at the pump prior to filling. Credit card is pre-authorized for $200. I fill up only for $75. This is where the second select will find my override. I think my bank will only show me $75 pending. But I understand everyone’s bank is different.
I am sure if we think hard enough we can find a scenario where it won’t be able to find the override for pending transaction. But I think it will be pretty rare.
This feature seems very intuitive from the user perspective. We users are dumb. We don’t want to understand why we can change this transaction but not that transaction. It just seems odd.
I can buy anything at the grocery store nowadays. By the time my transaction is posted - I will not remember that I have bought new sneakers instead of my regular baguette.
For myself… I can probably estimate I would do overrides on pending transactions for maybe 5% of total transactions. Say it will work 9 times out of 10 (pessimistic). What is 10% of 5%? 0.5%. I think I am fine if Emma will miss my override once for 500 transactions. I probably will forget about it and won’t even notice. But I will be bragging at every corner about an awesome app that let’s me edit even a pending transaction.
Apologies for long post.