I was wondering if anyone could help / offer some advice?
I am just in the process of filing a VAT return for this quarter. However when I started reconciling the bank statements, I noticed that one sales transaction for £1308.00 which should have been included in the last reconciliation that I did, must have accidentally got unticked and was therefore not included.
I have just done the reconciliation for this month however I think I have made a right pigs ear of it! I included the transaction that was missed and the only way to get it to balance was to amend the statement balance by adding the £1308.00. I realise now that this probably not the right way to do things as I will have to keep adding the £1308.00 on to the statement balance every month now.
Its many years since I last did sage but from memory if you had left a transaction unticked this should have shown up on the next bank reconciliation. Are you able to roll back to the reconciliation prior and redo?
You shouldn't have to keep adding the £1308 if the reconciliation just done matches, but I would investigate the transaction to which this relates to ensure it hasn't been duplicated in the accounts.
__________________
John
Any advice given is for general guidance and professional advice should be sought applicable to your circumstances.