I wonder if someone could point me in the right direction please. I need to complete a VAT return for the period of June-10 - August-10.
I have been given a very large box full of supplier Invoices, Bank Statements, petrol receipts, Cheque books, Paying in books & credit card statements.
From reading different comments on this site i'm going to use VT cash book to produce my VAT return. Please can someone offer advice on where I start.....
I have already put all invoices in date order but what next, do I enter all the invoices, or work from the bank statement and then try to work out what payment matches to what invoice. I have no sales invoices I can only see whats been paid into the bank from the statements, which I've beentold is all subject to VAT. for example if in that period there has been 20k paid in then that is all subject to VAT.
I'm doing this on behalf of my Boss's friend, he had his last VAT return done by a bookkeeper who is no longer around and my boss has put me in the frame to do this as a favour for his friend, never done anything like this before but see it as good expereince, Many Thanks and any type of advise will be welcome.
Personally If all your invoices/reciepts are paid I would work from the statement using excel to list the payments/receipts with a date, amount, description and nominal code to post them to, then match the documents to the payments/receipts then post this information to your accounts package, but only the ones you can match, the un-matched ones will need investigating, so you should then be able to reconcile the bank. For your vat return you should be able to run this through VT put your dates in and it should show exactly what to put where, this of course can be checked manually if you fancy.
-- Edited by Rhianrach on Saturday 14th of August 2010 11:08:09 AM
Hi, Many thanks for the above advice, I'm actually undertaking the VAT return in sage now and just steadily plodding through it, please could someone let me know what nominal ledger i would put a companies House payment to please within sage.
I'm not sure what the payment is for but it's £15 if that helps.
This site has been of great help over the last week helping me to get through this VAT return.
Some further questions regarding my VAT Return, if thats ok:
The Period Im trying to get the Return completed for is June, July & Aug_10, I have about 20 invoices from Dec09 May10 that were paid in June&July, can I still include these invoices for this VAT return?
Some of the Invoices I have are Pro-Forma Invoices should these be entered or not?
When entering the supplier invoices within Sage, Im trying to set up each supplier with a Nominal Ledger, for example I have set BT up as a supplier and used Nominal (7502_Telephone) most of the suppliers happen to be materials, so I have been setting them up using (5000_Materials purchased) I still have a number of suppliers that I dont understand what they supply or the service they provide, its not evident from there name of the business or the description on their invoices. Would I be ok to set these up using (5002 Miscellaneous Purchases)?
One last question for today, Its seems that one of the employees of this company buys a lot of materials on his own Credit card (Invoices still made out in company name) he seems to perhaps get a weeks worth of invs together, than he is reimbursed by way of a single company chq (this chq can sometimes pay off 10 invoices at a time), my question is how do I show this in sage, if I enter all 10 invoices into each supplier then how can I pay this off, when I go Bank Supplier, I can only pay off one supplier at a time. Would I be better not entering them as suppliers and just do a Bank Payments?
I would think the invoices related to previous period should have been included in previous VAT return, depending on what the tax point is on the invoice... And on the last one I would do it as a bank payment as these are basically cash purchases or if you have to track the amounts to suppliers just do the supplier payments with the same refernce/cheque number (either way you do it) so they would add up anyway to the total on the cheque and in the audit they would have the same ref. number.
When paying employees expenses, particularly if they have managed to get the receipts in the name of the company, I set them up with a supplier account and post the stuff to the relevant nominal accounts, clearing the supplier (employee) with either a cheque or direct payment to their account. Without VAT invoices, or VAT invoices not in the company name nor to a company cr card account I zero rate them.
The Period Im trying to get the Return completed for is June, July & Aug_10, I have about 20 invoices from Dec09 May10 that were paid in June&July, can I still include these invoices for this VAT return?
This would depend, if on cash accounting - then yes. If not then they should have been included in previous periods.
Some of the Invoices I have are Pro-Forma Invoices should these be entered or not?
Whilst pro-formas can (and do) include VAT you cannot include them until you receive the actual VAT invoice after you have paid for the goods. The invoice will have a tax point date on it.
Many Thanks for the above, I've just done a little further delving and asked some more questions, this person is on a standard Vat scheme not the 'Cash Accounting Scheme' The invoices I have that are dated before June were apparently just left out by accident and not included in the previous return. I didnt make myself very clear above, these are purchase (Supplier) invoices (not sure if this makes any difference) as they were forgotten about would I be able to include these or is it just the case that I can only include supplier invoices for this current period (June, July & Aug)?
I've also read a lot of info on the site this morning in regards to Fuel (diesel) receipts. I have a lot of these, amounting to a lot of money. From speaking to the person this morning, he keeps no mileage log but he tells me that all the fuel bills have been used for business purposes, On his say so, am I ok to put these into sage and claim the VAT from them?
I have a full afternoon on my attempted VAT return today, so apologies in advance if there are more basic questions posted this afternoon.
Nearing the completion (or so I thought) of the VAT return, I found out yesterday that this VAT return DOES need to be done as per the VAT Cash Accounting scheme, feeling sick this morning about how to approach this......
After reading about this scheme on HMRC, am I right in thinking I only have to worry about what has actually cleared the bank and been paid for by cash within the period? For example if I have an invoice that I can see was paid by a chq and this chq cleared the bank on the 20/05/10, I havent got to worry about it, as this is outside my VAT quarter, is that right?
Also if a chq has been written out on the 17/08/10 (within the qtr) but doesnt clear the bank until the 04/09/10, I again dont have to do anything with it?
My VAT period is June - Aug.
Also with the expenses side, if goods were brought for example by an employee on the 17th but the company issued a chq back to an employee and this cleared on the 26th, what date would i enter this invoice as, originally the good were purchased on the 17th but cleared the company bank on the 26th?
Any addittional info regarding the VAT Cash accounting scheme, or things to look out for would be appreciated.
I would use the date the cheque was issued to the employee.
Think about it, the invoice he has is never going to enter the books of the firm so it doesn't matter when he bought it. The cheque is so thats the date you need to use.
Sorry if I am teaching you how to suck eggs,I just find it easier when I get in a tangle to break it down to absolute basics!
With cheques you must enter them as the date you send/receive the cheque or the date on the cheques whichever is later (not when it clears). With debit/credit card payments it is the date of sales, not when it clears. You must clearly cross-reference payments with invoives. Hope this helps.