Hi,
I’ve been using this for over a year and its never faulted but I’ve just come back from a holiday plus the Christmas break and I’m experiencing 2 issues.
My bank statement is now over a few pages long (which I have to manually click through) - it doesn’t appear to be pulling everything through as the balances are different (QF showing more than the bank). i have tried to export per page on the Bank site.
But I have also noticed that because of my multiple attempts to import, QF now has 2 instances of the same transaction even though it only happened once in the bank.
I can only see one duplicate but there could be others based on why the two things aren’t balancing maybe.
I don’t believe the plugin imports multiple pages automatically, but will allow you to import them by clicking through the pages and clicking ‘Export’. Are you noticing any specific transactions not being pulled through, e.g. any specific types or dates?
It may pull duplicate bank transactions in, but when you go to confirm these, it should flag them as duplicates - is this the case in your situation?
The good news is, we are in the final stages of testing with a more automated feed via Yodlee (albeit in HSBC’s case, not fully automated).
I’ve just manually been through it all and have found the answer.
The duplicates are happening because of slight differences on what appears to be automatically generated references.
So the main culprits for me were cheques. The first time I imported the reference said “Cheque paid in at 402012”. The second time I ran the import it got duplicated because it now said “Cheque paid in at Eastwood 402012”. This had happened on 2 instances.
I also had an international purchase which had a slight reference change due to the second one including the exchange rate which the first one did not have.
All the dupes have happened within the last 5 weeks so not sure if something has altered? I also noticed another cheque transaction within that period which hadn’t duplicated even though I run an import most days.
I’m sorted now but thought I would share my findings with you.
Glad you found the issue! Banks have been known for changing their descriptions after they originally show them, which unfortunately does throw up situations such as this.
Unfortunately, there’s no way to detect that as apart from the amount and date, there’s nothing in common with it’s original.
HSBC could well have changed things. Barclays also do something similar.
But thank you for sharing your findings with us and the community - hopefully this will help other users with the same issue
