The Book-keepers Forum (BKF)

Post Info TOPIC: Cash Accounting, VAT and DDs


Guru

Status: Offline
Posts: 1329
Date:
Cash Accounting, VAT and DDs
Permalink Closed


One client on cash accounting - using Sage, has just commenced paying electricity by monthly fixed direct debit (easier on the cash flow), however, what is the best way to account for the VAT?

The DD is for 595 per month, when the first month's invoice was received it was for around 395.

Say the 595 payment on account was posted using 5% VAT (co is charity so has the 5% rate) but the actual VAT for the period should only have been on 395.  Will putting a credit note through for 200 adjust the VAT correctly?  Do I do a journal (but would this put the tax control account out?)

Can't get my head around it!!!!!



__________________

Advice from beyond the grave!!!

E&OE



Guru

Status: Offline
Posts: 595
Date:
Permalink Closed

Hi Sheila,

You can ask the electricity company for a VAT invoice for the payment you made- they must give you one,especially as you are on cash accounting, that should simplify things. Or you have to use magic to make it work on Sage.

__________________

Attila



Veteran Member

Status: Offline
Posts: 66
Date:
Permalink Closed

I don't think the invoice makes any difference to Sage cash accounting as it calulates the vat on the payments made. So if you have more payments than the invoice, then after allocating (if you want to) you would just be left with a payment on account. You effectively have an overpayment so I would have thought it should stay on the account as such.  As I understand cash accounting when you receive a receipt in advance you have to pay the vat up to HMRC so surely the same applies to payments you make in advance of supplies.

Sage only appears to use receipts and payments to calculate vat in cash accounting, so you have to ensure that invoices are cleared in this way. If a transaction is cleared with a credit note then it wont show at all on the vat return - after all if an invoice is cancelled by a credit then there is no vat in cash accounting.

Hope I haven't misunderstood, and that this helps

Anne



__________________
Anne P


Guru

Status: Offline
Posts: 1329
Date:
Permalink Closed

Thanks Anne

I think you've clarified my mind a bit. Yes Sage does allocate VAT on receipts and payments, so I suppose in this case we'll be gaining for a while, it's strange when you're in a situation sometimes you can't see the wood for the trees.

Hi Atilla

We do get VAT invoices but, obviously, they don't tie up with the direct debits. Sometimes with Sage it's difficult/impossible to get it to do what you want it to do. Cash Accounting on it is not the easiest!!!!

__________________

Advice from beyond the grave!!!

E&OE



Senior Member

Status: Offline
Posts: 345
Date:
Permalink Closed

No it isn't!! You have to give payments on account a tax code - and it doesn't seem right giving it a T1 tax code to claim back the VAT without an invoice. Could you give it a T2 tax code and then do a journal to correct the VAT when the invoice is received??? dunno?!?!

__________________
Sue
Assist Office Services - Bradford Bookkeeper


Guru

Status: Offline
Posts: 595
Date:
Permalink Closed

hi,
i meant get an invoice for your actual dd payment, they should give you one.or maybe you can create a new nominal code for the amount over paid. i thought even with cash accounting you have to have an invoice/receipt as a proof matching the amount paid/received .

__________________

Attila



Guru

Status: Offline
Posts: 595
Date:
Permalink Closed

Just a thought... You make a payment for electricity, later they issue an invoice on what you have a tax point (the date of invoice). HMRC clearly states in case of continuous supplies ( electricity, etc too) the tax point is either the payment or the invoice, whichever was first. And it is the payment. Electricity company takes the money ( you haven't really got a choice how much you pay) so as they don't actually get the tax point right - should be payment date not invoice date, at least they should automatically issue invoice for the money they've taken and just once a year issue an extra invoice or a credit note for the corrections after meter readings. I read somewhere on HMRC website they do know about the various issues with utility companies but as they are billing millions of people they can get away with it as it would cost too much money to change their billing system. So is it only little people who has to get everything right???



-- Edited by attilabenko on Thursday 14th of April 2011 10:33:00 AM

__________________

Attila



Guru

Status: Offline
Posts: 1329
Date:
Permalink Closed

I don't know either Sue.

I think the problem with doing a journal is the difficulty with reconciling the tax control accounts with the debtors/creditors ?????

 

Atilla - are you saying that as we have paid for the electricity in advance the payment date can be taken as the tax point??

Aaaarrrggghhhh



__________________

Advice from beyond the grave!!!

E&OE



Guru

Status: Offline
Posts: 595
Date:
Permalink Closed

Yes, I will try to find the link on HMRC website, their example was for electricity. But than comes the question if you still have to have an invoice as a proof of your payment and the invoice is for different amount how does this work??? Also I think electricity is not just the basic rule for advanced payment but it is payment in advance for continuous supplies...

__________________

Attila



Guru

Status: Offline
Posts: 827
Date:
Permalink Closed

semsley wrote:

Sometimes with Sage it's difficult/impossible to get it to do what you want it to do. Cash Accounting on it is not the easiest!!!!


 

Sounds familiar..

If you come up with any tips on a convenient way to reconcile Debtors / Creditors and Cash A/c'g - please share them..



__________________
Tony

Responses are intended as outline only. Formal advice should be sort from your Institutes Technical Department or a suitably qualified Accountant.
.
Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.

Tweet this page Post to Digg Post to Del.icio.us
Members Login
Username 
 
Password 
    Remember Me  
©2007-2024 The Book-keepers Forum (BKF). All Rights Reserved. The Book-keepers Forum (BKF) is a trading division of Bookcert Ltd. Registered in England Company Number 05782923. 2 Laurel House, 1 Station Rd, Worle, Weston-super-Mare, North Somerset, BS22 6AR, United Kingdom. The Book-keepers Forum and BKF are trademarks of Bookcert Ltd. This forum is a discussion forum only. There will usually be more than one opinion to any question and any posting should not be viewed as a definitive solution. No responsibility for loss occasioned to any person acting or refraining from action as a result of any posting on this site is accepted by the contributors or The Book-keepers Forum. In all cases, appropriate professional advice should be sought before making a decision. We reserve the right to remove any postings which are offensive, libellous, self-promoting or engaged in covert marketing. We will not notify users of removals. The views expressed in the forum posts are those of the individual and do not necessary reflect or agree with those of The Book-keepers Forum. Any offensive or unsuitable posts will be removed by the moderators. Any reader of this forum can request for a post to be looked into by sending an email to: bookcertltd@gmail.com.

Privacy & Cookie Policy  About