While trying to reconcile my HSBC (UK, personal) bank account I run into an issue. Despite I have the correct opening balance, and all the transactions match exactly my paper statement, the difference does not become "£0". This happens for most of the months in the last tax year (from April 2018) and that difference varies each month (so it is not a forgotten transaction). Then suddenly November and December 2019 reconciled beautifully.
I don't understand this, because there seems to be no transaction(s) that constitute that difference, and even if there were, why would they suddenly disappear in November and December?
Also, I triple checked my opening balance, un-reconciled and reconciled transactions again and even tried to do what QB suggests: add adjustment. Nothing helps, when I move to the next month the difference appears again.
The value of that difference is usually equal to that month's Deposits minus Payments.
Also, I have noticed that the statement's Beginning Balance is random (despite the balance in the History of Account is correct), and the Cleared Balance usually shows the figure that should be the statement's Beginning Balance.
Is this a bug? Why then November and December suddenly work well? I think it was around that time that QB interface was redesigned and some things updated...
I spent over an hour in a chat with a QB agent but she insisted I had a wrong transaction somewhere that resulted in the difference so we did not find a solution. I double (or triple) checked my transactions, and unless something is so well hidden that it does not show in the history of the account then my transactions are all matched to the paper trail. Also the amounts of Deposits and Payments each month are the same as on paper, but the difference in QB persists. As the value varies from month to month so it seems like a calculation error.
Any help would be appreciated.
