Hi - I’ve got in a mess and I think deleted transactions in error and now bank wrong.
I imported bank transactions for tagging but also there have been payments for invoices that I either allocated on the Sales screen or were done automatically via Go Cardless. I think I may have seen a duplicate entry and deleted it.
Bank Account listing is wrong but other areas including VAT return (cash accounting) seem correct.
How do I sort this mess out?!
The VAT calculations are done on the invoices entered - so it’s good to hear that’s still correct.
I think the approach you have done (uploading a bank statement) is the best way to sort this out. However, you may find reconciling a small date range at a time will help narrow the window of error down.
You can find this option on your bank statement:
If you reconcile it first, find the error, you may get away with just entering one or two transactions.
I hope that helps!
Whenever your bank becomes out of sync you just need to trace it back to the exact date the issue arose. This would normally involve you going back through your bank statement in QF and finding a date where the balance agrees with your actual bank statement. Then just iterate forward until the balance goes out.
You can use the Reconcile tool to simplify this job, as per @QFMathew’s suggestion.
What I think I may have done though is to delete the bank entries generated by paying the invoice via the system which has left me with an untagged imported bank transaction which I can’t tag as the payment is already allocated. Deleting the untagged imported transaction just makes the bank more wrong?
If you already have a tagged payment (and therefore unable to tag the imported one), it should be a duplicate entry. Deleting the duplicate entry should bring you closer to the actual balance of your account
No - because the correct entry is already missing/deleted so deleting the remaining one albeit untagged makes it worse!
Apologies if I misunderstood.
If you delete a tagged payment, the invoice it was tagged against will become unpaid as there’s no payment to match it against. Tagging another payment against the invoice would correct it.
So if you have imported a payment entry that’s not a duplicate, you can tag it against an unpaid invoice.
If it’s a duplicate, you should be able to safely remove one of the entries, and tag the other.
I’m confused now because the invoices show as paid on the invoice screen but there was/is no matching transaction in the bank other than the one imported which I can’t tag as the invoice is already paid. Maybe I wasn’t going mad?
On the invoice, you should see two things to show it’s been paid.
Clicking the payment link will show you what account it’s been paid from:
I can see quite a few ‘Sent’ invoices on your account, which I suspect are the ones that are missing payment entries in the bank account. Doing the above (reconciling and importing a bank statement for the missing periods) should correct that
I’m only looking at December till now as this is when I became VAT registered and looking at the bank entries for the same period. The numerous sent invoices you refer to are as yet untagged - I’m catching up in reverse as it were. When I say the bank is wrong, clearly if payments made are not showing within the relevant window, I have a problem!
The payments that have been made, is this something you’re seeing on the system somewhere? If so, where are you seeing this and I’ll check it out further for you?
Untagged Bank receipt : FASTER PAYMENTS RECEIPT REF.3RSITLIMITED-DAM FROM GC C1 , 495.16
From Go Cardless
Payment: #SP000180 £414
Payment: #SP000181 £84
I don’t have a bank entry for £495 for these 2 payments
These can be found in your ‘GoCardless Holding Account’:
You can reach it from Banking > All Bank Accounts, and it’s down the bottom of the screen
Oh silly bugger! So, do I transfer that now to the current account?
You should have a deposit date on your bank account (or you can go searching through GoCardless for this, which may be easier!)
On GoCardless, you have ‘Paid Out’ dates:
Create a transfer for that date in your current account, and tag it as a transfer from the GoCardless account:
And job done (hopefully!)
You’ll end up with a small amount left in the GoCardless holding account, which you can tag to ‘Bank Charges’
Hope that helps! 
Ah - I think there’s the problem - the money has been received and the transactions imported from the statement - then I think I may have deleted them as duplicates. I don’t therefore have entries to tag against the holding account.
You can just create them manually to save you importing parts of the statement again
Thanks - Got It! A great help 
This topic was automatically closed after 7 days. New replies are no longer allowed.
