Account balance mismatch problem on new QF account


I started using QuickFile at the start of the new tax/business year on 06/04/21. It is a clean start - i.e. I have not imported any data from my previous accounting system.

I set the opening balance for my business current account to the value reported on my bank statement corresponding to the date[date=2021-04-02 timezone=“Europe/London”] : £1553.44 - this corresponds to the last entry in the statement prior to 06/04. I set the ‘opening balance effective date’ to 05/04 which was the date I actually set the opening balance in QF.

I then set up automatic bank feeds to import transactions from my business current account, starting from 2021-04-05T23:00:00Z.
At the 1st import however, in addition to the 2 income transactions that occurred on 2021-04-05T23:00:00Z (which I duly tagged as income), QF also imported a transaction dated 2021-04-01T23:00:00Z which was a withdrawal of £1000. As this entry corresponds to a transaction that occurred in the previous tax/business year, I deleted the entry from Quickfile rather than tag it.

The problem is, that following the above, in spite of the balance reported on my QF Dashboard matching exactly the balance in my current account, QF is flagging a ‘possible account balance mismatch’ on that account in my dashboard. Clicking on the warning shows that the balance in QF is exactly £1000 less than the balance reported in my bank statement - i.e. matching the erroneous import.

This problem persists even after I have performed a reconciliation of this account over the dates 2021-04-04T23:00:00Z to 06/04 - which, when performed, returns the result ‘PERFECT’.

Additionally, when a subsequent automatic bank import occurred, the same £1000 withdrawal transaction appeared in QF again - and will presumably continue to do so, as long as I continue to delete it?

Does anyone know waht I have done wrong and how can I stop the repeated import of this transaction and get rid of the ‘possible account balance mismatch’ warning that appears?

The following screen shots illustrate the problem:


Hi @Gordon,

It may be because the transaction is still trying to be pulled in that the balance is flagged as a mismatch. If you wait a few days then hopefully this will resolve itself

Thanks @QFBeth, I did wonder if maybe it would, but didn’t want to get several more days down the line only to discover that I had to back-off a whole lot more transactions in order to sort the problem out.

But I guess I’ll try that and see how I get on.

Thanks again for your very quick reply!

1 Like

This topic was automatically closed after 6 days. New replies are no longer allowed.