Hello, I have a plus £5658.09 on my bank feed and can’t reconcile it. Can I subtract it using a false expense or should I start again with a new account?
Hello @MTBKona
Has this occurred recently?
Was the balance correct previously?
If you look back to say 01/01/2025 is the balance correct?
Is the opening balance correct on the account? (view the account > Options > Settings)
I think its because I did not update the bank feed for a while (about 3 months) but it still does not help with the discrepancy.
Hello @MTBKona
If there is 3 months of missing transactions on the account you would need to import a bank statement for the missing period.
https://support.quickfile.co.uk/t/importing-your-bank-statement/8823
Can I cancel the bank feed then manually import the bank details?
It’s not an either-or - it’s fine to keep the bank feed running to bring in new transactions as they happen, and also download a CSV from your online banking with the transactions from the missing dates and import that into QuickFile to fill the gap.
The banks only allow third parties like QuickFile to access the last few weeks of transactions through the feed API, so for gaps further back than that you will need to get the data in via a CSV upload, or enter the missing transactions manually if your bank doesn’t provide anything machine-readable like a CSV.
I have uploaded the file and it is closer but still not correct. I am out by 1165.74 - how can I reconcile this?
The only way is to work out when it got out of sync - find a point in time when it was correct, then work forwards from there until you find the first place it diverged from reality.
If there’s only one point of discrepancy then you can find that in fewer than ten steps if you “binary search” - if it’s wrong now but you find a point in the past when it was right, check the date half way in between and repeat for either the left or right half as appropriate until you find the date of divergence.