I have accidently reconciled in the bank a Sage cheque that has not been cashed.
We have paid the supplier twice , once by a manual chq and then again with a sage chq. I have reconciled the Sage chq but it is the manual one that has been cashed and the supplier has returned the Sage one.
The manual one has not been entered into the cash book.
How do I unreconcile that chq and then reconcile the other once it as been entered?
Depending on your version of Sage, you can go into "maintenance" | "Corrections" and edit the cheque that you reconciled in error, and then "untick" the "bank rec" box. Then go and re-reconcile your bank account on Sage, this time reconciling the cheque that was actually cashed.
-- Edited by Figurate on Thursday 6th of October 2011 11:32:19 PM
Hi, I have unticked the reconciled chq and cancelled that chq through the supplier returned chq option. I have then posted the manaul chq to the account.
However I just can not figure out how to reconcile the new chq. In the reconciliation screen the cancelled chq is still showing as a payment. I need to be able to show on the reconciled statement that the original Sage chq has not been cash and the manual one has...... Sorry for sounding clueless but thats what I am :(
I need to somehow contra the cancelled and cashed chq, but the supplier account is now balanced.
On your bank reconciliation screen in Sage, ensure that you reconcile the (manual?) cheque that was actually cashed by your supplier.
(What cheques are actually on the supplier account and in the bank in sage? both the manual/cashed cheque AND the Sage/uncashed cheque or just one of them?? From what you have said, it sounds like you need to have entered the manual/cashed cheque in Sage as a supplier payment and deleted the Sage/uncashed cheque from Sage?)
Hi, I have now entered the manual one. The Sage (uncashed) chq was automatically entered to the bank/ supplier account. So it appeared they had a payment on account. I then cancelled the uncashed chq using the Sage tool for returned supplier chqs, so the supplier account was then balanced.
The Sage chq has not actually been deleted and it appears in the supplier account as both a debit & a credit with the reference CANCEL which as replaced the chq number.
The uncashed chq appears on the reconciliation statement, so I need to somehow show that that chq as not been returned and then reconcile the correct chq.
As far as I can see all I can do is open a new reconciliation with the statement name as the number - correction, and the reconcile both the cashed chq and the returned transaction so the closing balance balances (this will be the last reconciled balance).
My only concern really is that when I hand over these reconciled statements with the quarterly accounts, the accountant will not know what I have done. Am I worrying too much about how it looks?
As you've cancelled the Sage cheque that's equivalent to deleting it, really. So, yes, all you have to do re the bank reconciliation is what you've put...
You could mention it to the accountant at the end of your quarter, but they should be able to see what's happened just by looking at the Sage audit trail, so it shouldn't be a problem.
Aaahhh what a nightmare. I did the above and I have just gone to do the next bank reconciliation as normal and the balance difference is £24.00 which was the amount of these cheques. Because I have unticked the reconciled chq it has change the last reconciled balance (I did not think of that!). Uh I do not know what to do now..... If I reconcile the three transactions (the old chq, the cashed chq & the returned chq transaction) it will bring me to my last rec balance (i think) but it will not balance on the reconciliation screen ?????????
-- Edited by jenand on Monday 10th of October 2011 03:55:28 PM
I think what I should have done is left the original chq reconciled (instead of unticking) and the just done the above to correct... Will try re-ticking it as reconciled in corrections................. how can something so small be causing me so many problems :(
Aarrghh, sorry, I misread your post (at 11.41am) "and the reconcile both the cashed chq and the returned transaction so the closing balance balances (this will be the last reconciled balance)"...
As my brain had not connected that you had also done a supplier refund (even though, I know you said... ) because, in my first post, I originally meant, "untick the reconciled Sage cheque, delete it and reconcile the manual cheque instead" (and so not do a supplier refund)
Therefore, my third comment on this thread should have said reconcile the manual cheque only (NOT the "CANCELLED/REFUND" as well) OR reconcile all three...
(I'm assuming that all these cheques are for £24 (or whatever identical amount), and not for all different amounts and that going through your bank is: the original Sage cheque, the manual cheque (both credits) and a cancellation/refund - the latter being a debit)
Oh dear God (or other deity/secular alternative), sorry, it's been a long day.
Anyway, I hope you have got it all sorted. If not, please give me a ring and I'll go over it over the phone (with the mods' permission)
-- Edited by Figurate on Monday 10th of October 2011 07:31:51 PM
I have now re-ticked the original rec'd chq and it sorted now (thank god). I know I was having one of them days yesterday too! Had loads to sort and this little thing kept popping up and preventing me getting anywhere. Glad it sorted now. Thanks for all your replies :)
, once by a manual chq and then again with a sage chq. I have reconciled the Sage chq but it is the manual one that has been cashed and the supplier has returned the Sage one.
