I entered a supplier invoice into Sage for £1766 in a previous month.
The invoice had a VAT amount and this was recorded.
This invoice total should have been £1776, I posted it £10 less than it should have been.
I posted it as £1766.
Later, when it was paid, I opened the supplier account, and clicked "pay in full", and I didn't notice the £10.
When I came to bank rec the month, I found a £10 difference and identified it as this transaction.
I opened the corrections and altered the purchase payment of the transaction from £1766 from £1776.
My bank rec now balanced (in excel, not in Sage).
Then I noticed that this suppliers' account was showing a minus -£10.
So I thought I could correct the original invoice through maintenance, but when I tried, I received an message saying
"This transaction has been allocated against a receipt and VAT calculated,therefore this change cannot be allowed."
I can't change the payment to £1766 because that would leave £10 too much in my bank account.
I have thought about using a journal to correct this.
This supplier was a one-off, so I won't be able to offset it against any future invoices, as there won't be any, and I haven't even considered the vat element of this £10.
Can anyone tell me the right way to bring the supplier's balance back to zero in Sage without changing the bank balance?
i agree with steve. invoice for ten pounds.but yes journal entries can help identifying in the future what the error was especially if someone else is looking at the books apart from you-ok it was only ten pounds now.
If your supplier is showing -£10.00 by posting a supplier invoice for £10.00, as already said above, they will cancel each other out and the account will be clear.
The only error is the invoice amount being undercast by £10, the suppliers account is effectively showing a payment on account.
By creating an invoice and using the calc net button you will have created an invoice for £10 incusive of VAT. Allocate it to the payment on account and everything should be back to normal. I think you should be able to use the same invoice reference number for this invoice.