It wouldn't allow me to reverse the VAT using maintenance!
Did it say why not? I understood that the "Delete" button would be replaced by a "Reverse" button.
Perhaps the reconciled transactions had been deleted from the audit trail after the VAT Return had been reconciled; apparently you can't correct any entry not in the audit trail.
Edit: I am talking the 2012 version here. Don't know if that reversal facility has only just been introduced/fixed for that.
-- Edited by Rob-f58049 on Friday 1st of June 2012 11:37:45 AM
Using the File > Maintenance > Corrections process will not delete VAT-reconciled transactions, but it will allow you to "Reverse" them. This will add an equal and opposite transaction which will be picked up at the next VAT processing stage. You can then add the correct transactions.
You can use the Nominal Ledger > Journals system to post directly to the Nominal Ledger accounts, so yes, you can do an internal transfer - whether you can do it to control accounts I can't tell you.
But in any case, entering journal transactions requires you to understand bookkeeping principles, which I see you do, but some other Sage users reading this might not.
Also, journal entries don't have VAT calculated, so you need to work out whether and how the VAT has to be corrected.
A simpler approach would be to post a "customer refund" to the sales ledger account that the receipt was posted to, and then correctly post it as a supplier refund.
__________________
Vince M Hudd - Soft Rock Software
(I only came here looking for fellow apiarists...)
IMHO, though, doing the customer refund then supplier refund method has one disadvantage - it shows in the audit trail, and perhaps any automatically-generated reports sent to the customer, that the customer paid some money and then got a refund, which is not actually the case.
Using the corrections method to reverse the incorrect transaction at least then shows it as a correction in the audit trail. Don't know how it would appear on reports for the customer - would it just miss the reversed transaction out or show it as having been corrected?
Yes, it shows in the audit trail - both my approach and the reversal approach do (if Sage will do that in this case*), so there's no advantage or disadvantage.
As for showing on reports sent to the customer, that's another kettle of swimmy things.
Note that the OP didn't actually say that the supplier was also a customer, only that the transaction had been posted to the customer ledger - for which the client may have created a customer account for the supplier, in which case this is isn't an issue. If the supplier is a customer as well, then obviously it depends what reports are sent out.
* A [very] quick test by loading its practice data (set to cash basis for VAT) and posting a receipt to a sales ledger account, and then reconciling a VAT return before visiting it in corrections, suggests not. It only offered me the options to delete or amend the transaction - and when hitting delete it simply refused because it was VAT reconciled.
I suspect I know why. I've long suspected the programming teams at Sage working on different parts of the software are not always in sync with one another, which I think is why there is so much inconsistency in the software's UI - and I suspect it's a similar problem here.
A reversal, as you say, is an equal and opposite transaction - so a receipt on the sales ledger would be reversed by posting a payment on the sales ledger, which is exactly what a refund is. The only difference, if Sage had given me the option, would be in the details posted for that transaction. My guess is that the team responsible for posting corrections haven't got refunds in their armoury yet. (A similar test on a VAT reconciled invoice posted a credit as a reversal, as you'd expect).
__________________
Vince M Hudd - Soft Rock Software
(I only came here looking for fellow apiarists...)
Like Vince stated, it only gives the option to delete or edit. When you choose delete it says this cannot be done as it has been reconciled to a VAT return. It causes me so many problems. The Audit Trail hasn't been cleared... his accountant hasn't performed year end for over 4 years! So I'm trying to get this year end done so we can get it all cleared out.
The client has set up all sorts of accounts within the creditors and debtors ledger just so he can post the transaction somewhere and balance the bank! So yes the receipt was a refund from a courier, instead of posting it against the courier supplier account, he created a new customer account and posted it there. Its not actually a customer. I'm trying to sort out the ledgers so that they show correct debtors/creditors.