I have just come to a client's this morning to do the bank rec and VAT return and the last reconciled balance in Sage is different to the one that is showing in the history as reconciled (the correct one). How can I find out why there is a difference? I would have thought that if the client had accidentally done another reconciliation, then it would show in the history.
Hi, first question will be has the difference gone down? If so could it be a deleted transaction and therefore worth creating a search in audit trail for reconciled items that are deleted. It is always worth checking the audit trail for deleted items.
__________________
Donna Curling - Complete Book-Keeping Ltd (CBKLtd) - 07939 101900
It had gone up. The customer remembers deleting a sales invoice & receipt, but it didn't add up to the difference. Will check the audit trail - thanks. What baffled me is that I didn't think Sage allowed you to delete reconciled transactions.
Unfortunately, you are not alone with that misunderstanding. Sage will let you delete most entries that are made into the day books.
On pressing delete there will be a message "This transaction has been reconciled, if it is deleted this will affect the bank reconciled opening balances or relevant bank account. Are you sure you wish to delete this" Most press yes button not understanding the consequences.
I always ask customers not to use the deletion option if it can be avoided, that way they will not risk the bank reconcile or VAT return (yes it effects the VAT too by creating a double entry) ie if a payment into account is wrong - issue a refund. Makes a much cleaner audit trail and no headache of deleting reconciled items.
It could be worth entering a Search on any items bank reconciled as it may not be last reconcile they have deleted from, just as easy to be historical. The line should be Bright Red.
__________________
Donna Curling - Complete Book-Keeping Ltd (CBKLtd) - 07939 101900
Hi, I am have the very same problem - an item has been deleted which had been previously reconciled. I am now £386.30 out on my latest reconcile. How do I amend this? Can I put a reciept in under the mispostings nominal? Thanks, Caroline
Hi Caroline, long time no question - you will need to enter again as the transaction actually happened. This would have to be brought to companies attention though as they obviously believe it never happened - maybe they have paid twice or cancelled and therefore believed cancelling was correct. worth a little investigation with company - but atleast found it.
__________________
Donna Curling - Complete Book-Keeping Ltd (CBKLtd) - 07939 101900
