This is my first post so would like to say hello to everyone first of all.
I'm after a little advice on how to post sales commission and vat in sage.
Basically, we send the invoices out to our customers and the payment for them is received in our bank account through a third party that charges 5% sales commission on each invoice + vat.
So the problem is that because we transfer our sale invoices through another system onto sage using the audit trail import function, the balance for each customer shows up as full amount but because we only receive the amount after the commission and vat is taken off, when we post the amount received from the customer in sage, the balance of each invoice remains which is effectively the 5% sales commission and vat charged by the third party.
I'll be thankful if anyone can help me regarding that issue. I hope I have explained everything in detail.
You could post the commission (and VAT) as a dummy sales credit note on Sage. This would clear the customer balance and, if you post the credit note to a commissions nominal code, accurately show the commission.
__________________
Pearce & Co - Chartered Accountant and Chartered Tax Adviser
Thanks for the reply Robert, I have already tried to do that and it works for crediting the customer account as well as sales commission been showed but the problem arises in the vat because then it credits the vat liability instead of adding it to the liability for us to claim it.
Thanks for the reply Robert, I have already tried to do that and it works for crediting the customer account as well as sales commission been showed but the problem arises in the vat because then it credits the vat liability instead of adding it to the liability for us to claim it.
Oh it does let me now !
Right, that's exactly what I tried to do but the problem arises with the vat liability because if I credit the customer account with vat then it credits the vat liability too which is wrong because I need to claim the vat back that has been charged by the third party.
Oh it does let me now !
Right, that's exactly what I tried to do but the problem arises with the vat liability because if I credit the customer account with vat then it credits the vat liability too which is wrong because I need to claim the vat back that has been charged by the third party.
Oh it does let me now. Right, that's exactly what I tried to do but the problem arises with the vat liability because if I credit the customer account with vat then it credits the vat liability too which is wrong because I need to claim the vat back that has been charged by the third party.
Because if I credit the customer account with vat then it credits the vat liability too which is wrong because I need to claim the vat back that has been charged by the third party.
Oh it does let me now !
Right, that's exactly what I tried to do but the problem arises with the vat liability because if I credit the customer account with vat then it credits the vat liability too which is wrong because I need to claim the vat back that has been charged by the third party.
Right, that's exactly what I tried to do but the problem arises with the vat liability because if I credit the customer account with vat then it credits the vat liability too which is wrong because I need to claim the vat back that has been charged by the third party.
For some weird reason, it's not letting me post in the forum.
Right, that's exactly what I tried to do but the problem arises with the vat liability because if I credit the customer account with vat then it credits the vat liability too which is wrong because I need to claim the vat back that has been charged by the third party.
Because if I credit the customer account with vat then it credits the vat liability too which is wrong because I need to claim the vat back that has been charged by the third party.
Right, that's exactly what I tried to do but the problem arises with the vat liability because if I credit the customer account with vat then it credits the vat liability too which is wrong because I need to claim the vat back that has been charged by the third party.
Thanks for the reply Robert, I have already tried to do that and it works for crediting the customer account as well as sales commission been showed but the problem arises in the vat because then it credits the vat liability instead of adding it to the liability for us to claim it.
Posting a dummy sales credit note should reduce your VAT liability (assuming that you're calculating VAT on an invoice basis). There will be an issue with your VAT return in that the dummy sales credit notes will be reducing box 1 and box 6, whereas you want them to be increasing box 4 and box 7. You'll probably need to make a manual adjustment for this.
__________________
Pearce & Co - Chartered Accountant and Chartered Tax Adviser