My accountant has told me to put my sales into sage as a customer (cash sales)
So I have to add a new invoice to cashsales each month and then receive payment against it. (banking and credit card totals)
However this month the bank have found an error in the cash I put into the bank so this means my total sales for the month are incorrect and the amount allocated against this cash is incorrect too.
How do I fix this as the corrections function wont allow me to edit the amounts.
thanks
Caroline
Replies (7)
Please login or register to join the discussion.
Ask your accountant
It will be better for you, and your accountant, if you take guidance from him/her.
We all have our different preferences as to how things are recorded/corrected, and your accountant would probably appreciate the error being pointed out to them anyway, as it may save lots of questions further down the line.
You could raise a credit note
If you have banked less than you have recorded on Sage then you could raise a dummy credit note and refund your Cash customer. If you have banked more than you have recorded on Sage then raise a dummy invoice and record the payment of that invoice.
Little confused
I'm a little confused with your reply. Have you banked more than you invoiced for or have you banked less than you invoiced for?
Sage Guidance
Hi Caroline
The reason your accountant has set it up this way is so you can see if want went in to the bank matches your till receipts and what the credit card company pay you. I hope it was just a mistake and you have not been left short by the bank or a member of staff.
I am not sure why you cannot allocated , but I would get a good bookkeeper soon. As a credit note should have solved the problem .
You must be running cash accounting so what you should have done was delete the Sales Receipt as when you were doing your bank rec you would have noticed this was incorrect and your bank account did not reconcile .
If you delete the sales receipt against it . You will now be able to edit the original invoice and enter the correct sales receipt amount. You then renter the sales receipt. I notice you mention about your accountant but you do seem to struggling with this as the reason why sage would not let you change this invoice is because you would be effecting your vat return and not doing the full correction.
You have said you have entered a credit note so if you delete that as well you should be okay to re enter the receipt.
-- Kind Regards Sarah@ Douglas Accountancy & Bookkeeping Services, Glasgow