Bank balance mismatch

Hello.
Quickfile thinks I have nearly £540 more in my Starling account than I really do. I have no idea how this mismatch developed and I’ve tried the ‘reconcile’ process with a couple of date ranges and it seems to suggest there’s no real issues.
What’s the easiest way to identify why the mismatch exists please. Or do I just create some manual entry to correct it??
TIA

You really need to go back month by month and find where the mismatch first appeared. You then tick off each transaction in QuickFile to your bank statement so you can work out which one(s) needs correcting. It’s best not to just create a manual entry as you could potentially make things worse initially!

Thanks for that. I was really hoping for ‘reconciliation’ to spit out details of discrepancies but that is not to be! I’ve waded through the last 4 years of transactions and managed to identify where things went awry. Very time consuming but it’s done. Thanks again.
If only I had a computer and some kind of software that would do that kind of task automatically… oh, wait…

Hi @Andythornton

I had a similar experience when new to Quickfile.

Being able to amend / delete information is really useful but does include the danger that you end up changing some important data by mistake.

So now - on the final banking transaction for each month I manually add to the description line the actal bank statement balance at that point. This means I can easily check that my banking records on QF are OK by seeing that the monthly balance calculated by QF agrees to the manually typed total.

In case it is of interest these are my suggestions for managing QF banking records.
I download my recent banking transactions to a csv file and then import into Quickfile by going to the bank account screen, choosing upload bank statements and choosing other rather than my actual bank. Then I can upload the data without manually typing everything out.

I am very used to using excel so I use a function called concatenate to put all the description data from different columns from my bank download into one description field and also add in a consequetive line number in brackets to make each entry easy to trace back to my original bank download data. On the final banking transaction for each month I also add in to the description line the actal bank statement balance at that point. This means I can easily check that my banking records on QF are OK by seeing that the monthly balance calculated by QF agrees to the typed in total.

If you have a lot of banking transations I would suggest downloading your banking records to excel and use this data to create a very simple cashbook record of your banking in excel. Then copy the data you want to import to QF from this record to an individual csv file. This system really lends its self to including a line item reference number and (if you have excel skills) using lookup lists to also let you easily add the QF category to the description before you import the data. This then allows you to use the QF search feature to search for untagged banking records with the same category and tag as a batch rather than individually.

Again, at the end of each month (or each week if you have lots of transactions) manually add the bank balance to the last tranaction for the week to give a very easy way to spot errors if they sneak in later.

1 Like

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.