A customer is on the vat rate scheme @ 11.5% For some reason when I do a vat return for the quarter the sales figure don't match up with the correct figures so I end up reconciling the vat and submitting the return via the HRMC website
The net sales I have for the quarter are £39562.70. Vat on the sales £7912.34. Gross £47475.04 Flat rate vat @ 11.5% 5459.63
However they've bought an asset (£2199 plus vat) so can claim the full vat back on this, but I'm not to sure how to journal this in, plus what figures to put in what box on the HRMC web site vat return.
I'm not sure where you get the figures from for your journal. I would post the total figure (£47,475.04) to sales, then deduct the payment from sales (dr sales, cr bank account).
In relation to your asset, this should follow the normal way of dealing with input VAT. Box 4 on the VAT return.
An accountant I spoke to said that Sage have always had problems with the flat rate scheme, and with the problems I'm having looks as if they still are.
Peter, which version of Sage are you running? The new versions handle flat rate VAT very well indeed in my experience - it made it worth upgrading for me
As Clare said, I'm not aware of any real problems with Flat Rate, do you cross check the Customer Receipt report? I'd change the flag, if you're at the end of the Vat quarter to run on a cash received basis.
__________________
Tony
Responses are intended as outline only. Formal advice should be sort from your Institutes Technical Department or a suitably qualified Accountant.
I'm on the same version as you Peter and haven't had any problems at all with the flat rate setup. I'd review your company preferences and settings to see if anything looks askew there as a next step...
Dr £2199.00 to Asset Nominal Code (eg 0020, 0030 etc) *when entering journal, use the tax code for the current rate of VAT eg T1 (this means it will appear on the VAT return) Dr £439.80 to Purchase Tax Nominal Code 2201 *when entering journal, use the tax code for the current rate of VAT eg T1 (this means it will appear on the VAT return) Cr £2638.80 to Bank/Cash Ac Nominal Code (eg 1200, 1230 etc) * (use T9)
Then it will show on the VAT return in Box 4 as £439.80 and Box 7 as 2199.00