Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals

reversing a supplier payment once vat reconciled

Bookkeeping and Management Accounting help does not have to be specific to the use of Sage 50
Post Reply
emmac
User
User
Posts: 11
Joined: 27 Aug 2013, 07:26
Sage Version: v2012 18 UK/Europe/Africa

reversing a supplier payment once vat reconciled

Post by emmac » 07 Nov 2013, 14:49

Hello can you give me an idiots step by step guide to reversing a payment sitting on supplier account that has been vat reconciled but shouldn't be there

So appreciated
Thankyou
Anne

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4619
Joined: 28 Feb 2006, 09:56
Sage Version: v28 UK/Europe/Africa

Re: reversing a supplier payment once vat reconciled

Post by brucedenney » 07 Nov 2013, 16:03

Assumptions:-

This is a Payment on Account
It is VAT reconciled so you are running VAT Cash accounting scheme.
You can not reconcile it on your bank rec because it never happened.


Solution:-


Enter a Supplier refund, use the same tax code as the payment and it should have the same net and vat amounts and be on the same bank account probably best to date it the same day etc.
Match the supplier refund against the Supplier payment to cancel both of them off on the supplier account, they should cancel each other out.
Do a dummy bank rec and match of the refund and the payment against each other, they should cancel each other out and not alter the B/F balance.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.

emmac
User
User
Posts: 11
Joined: 27 Aug 2013, 07:26
Sage Version: v2012 18 UK/Europe/Africa

Re: reversing a supplier payment once vat reconciled

Post by emmac » 11 Dec 2013, 15:02

Thank you kindly bruce denny :)

Post Reply

Who is online

Users browsing this forum: No registered users and 8 guests