Something that has always brought me back to a spreadsheet is the lack of “trust” in the integrity/validation of the Emma data.
An idea I have to overcome this would be to have a choice when integrating an account that you can chose if it is balance only or balance and transactions.
For those where balance and transactions is chosen, there should be some internal verification behind the scenes to ensure the net of the drs and crs comes to the balance.
Equally – this would overcome another issue me, and other users have where they use some credit cards as longer term lending – balance only pull would be perfect. This way the balance reduces over time, the payment side from your current account can be categorised as a bill and there is no faffing with what to do with the “income” on the credit card.
Real life example of this balance/transaction disparity that’s been a headache for months for me now. I have an ongoing dispute with amex, large sum. They’ve credited, debited, re-credited many times over the life of the dispute - for some reason it takes an age to come in to Emma - there is no reconciling between Emma Balance and Emma Transactions - so I am never fully able to trust analytics.
Being able to display assets/liabilities vs. income/expense would be very useful. It would allow users to create a better version of a personal balance sheet.
The data comes straight from the bank and it’s accurate for 99% of the time; there might be the occasional bug that we are happy to fix right away. I think data reconciliation goes more into Xero/Intuit space, not a friendly consumer app for everyone? I am not sure how you’d implement it.
I feel it just needs a simple notification to say “Check Barclaycard - transacation/balance mismatch”
I have identified inconsistencies at least 4-5 times this year and it just gives no reliance on the analytics etc. I’m having to periodically check the data export, pivot the data and cross check to balances.