cancel
Showing results for 
Search instead for 
Did you mean: 
QuickBooks Team

Re: Flat rate scheme

Hello Jen35,

 

Welcome to the Community. I'm here to lend a hand with your concern about the Flat Rate Scheme in QuickBooks Online.

 

You can review the setup through the VAT Centre to ensure you 'll have accurate information when you need to file them.

 

Here are the steps:

 

  1. On the left panel, click Taxes.
  2. Go to the VAT tab.
  3. Click Edit VAT.
  4. Select Edit settings or Edit rates.

See this screenshot for your visual reference:

 

 

I'm linking an article with additional information on this, such as editing the VAT settings:

 

Set up and edit VAT settings, VAT codes and VAT rates.

 

Please be sure to let me know if there's anything else I can do to help you with the FRS calculation in QuickBooks. The Community will keep an eye on your response.

Not applicable

Re: Flat rate scheme

Thanks very much for the quick reply.  I have checked and all looks correct FRS 8%.  QB should be calculating 8% of sales but it isn't.  Sales £7557.07 VAT should be £604.56, but QB has calculated 8% of £6997.29 which is £559.78, added together is £7557.07, do you know why it has done this rather than 8% of £7557.07?

QuickBooks Team

Re: Flat rate scheme

Hello Jen

 

Could you Private message us with a screen shot of the prepare VAT return screen and the transaction itself so we can look into this further for you?

 

Thank you

 

Emma

Not applicable

Re: Flat rate scheme

Sorry Emma, how do I private message?

 

One other thought, when I set myself up on QB a couple of weeks ago I seem to remember when setting up VAT that there was a question asking about net or gross, I think I may have selected net.  Thinking about it on my manual returns I always took 8% of gross sales, that would make box 6 correct.  There is not an option to change this in EDIT VAT, it was right at the beginning when I set up QB, Is there a way of changing this?

QuickBooks Team

Re: Flat rate scheme

Hello Jen

 

There should be a envelope icon in your Community in the top right.If that is not there you can also message us via a private message on Twitter or Facebook.If you could include a screen shot of the vat liability report as well that would be great.

 

When you set up VAT it just asks for the same information in the edit settings there is not a net or gross box. We have recreated the transaction Are you using a custom code or one of the standard ones?

 

Thanks

 

Emma

 

 

 

Not applicable

Re: Flat rate scheme

Hi Quirkygirlworkshop,

You seem really clued up on this topic, we're in a similar situation to you, ours is 7.5% and we've been happily filling ours with HMRC before MTD decided to ruin everything.

Anyway. You mentioned that you had to file in May, did you manage to resolve this, and if so how?

I am in the process of adding all our cash register takings. I'm now on the third alteration of this process after following different aids from Quickbooks help videos, and I've decided to wait to see if FRS even works properly first.

Many Thanks

Senior Explorer *

Re: Flat rate scheme

Hi there, after getting very frustrated with theQuickBooks team giving different answers and not knowing if they would be ready for the Flat Rate Scheme users, all went very well and was very easy to complete.

The only thing that is still frustrating me is that in QuickBooks the figures given for Profit and Loss can not be used for income tax as they take off 20% Vat then added a figure that is of no help, which I think they call Flat Rate Scheme Saving, to give a gross profit. 

But the figure you need for income tax is the gross figure (including VAT) less the Flat Rate % of Vat, then less your expenses (including VAT), as per HMRC documentation.

I have discussed this with them but got nowhere, if or when we have to submit income tax digitally it might change.

 

Moderator

Re: Flat rate scheme

It's good to see you here, quirkygirlworkshop.

 

Allow me to chime into this conversation and help locate the report, so you can submit your income tax in QuickBooks Online (QBO).

 

The Profit and Loss report will not show you the gross amount less the Flat Rate percentage of Vat. You can pull up the VAT 100 report as this will give you the summary information for each box of your return. 

 

Here's how:

  1. Go to Reports.
  2. Enter VAT 100 Report in the search field.
  3. Set the date range under Report period.
  4. Click on Run report.

The example screenshot below has the Flat rate value of 10%. Multiply the gross amount £26,512.77 with 10% Flat rate and the report results in £2651.28 amount.

 

VAT100.PNG

 

I'm also linking an article that will help: VAT 100 Report.

 

That should do it. Tag me if you have further questions about the report. I'll get them answered for you.

Senior Explorer *

Re: Flat rate scheme

Hi there, I have not got a problem with the VAT reports. 

It is the profit figure that is showing as incorrect, as this figure should be the gross figure (including VAT) minus the Flat Rate %.

Not the Gross minus 20% Vat plus Flat Rate Savings.

QuickBooks Team

Re: Flat rate scheme

Hi quirkygirlworkshop,

 

It's best if we can have visuals on your reports and your data, so we can see how the calculations goes. Please reach our to our Chat or Phone support to check this further. They have the tools to see your setup.

  1. Click on Help and choose Contact us.
  2. Enter a short description of your concern and click on Let's talk.
  3. Choose from Chat or Get a callback.

If you have other questions, you can always go back to this thread.

Not applicable

Re: Flat rate scheme

So suppose I buy goods for my business, costing me 100+20(VAT)=120.

So do I enter the purchase as 120 and select 'No VAT' under VAT code section in QBO?

QuickBooks Team

Re: Flat rate scheme

Thanks for contacting us on Community nehachopra.

 

you could record this transaction using the 'Inclusive of VAT' option on the transaction this way you can enter the amount as £120 and select the VAT code and QuickBooks will work out the VAT portion of your transaction.

 

Please let us know if you have any further questions.

Senior Explorer *

Re: Flat rate scheme

Hi there, I am on the Flat Rate Scheme and use the no VAT option, as you do not claim the VAT back on purchases. ( except for large items over £2000).

Doing it this way I find easier when it comes to doing my income tax as you claim the expenses back including the VAT.

It doesn`t effect the amount of VAT you pay HMRC via Quickbooks.

FVA
Not applicable

Re: Flat rate scheme

So would you enter income and expenses as No VAT? Wouldn't that mean the VAT calculation for FRP is wrong?

QuickBooks Team

Re: Flat rate scheme


Hello FVA,

 

We do not recommend to use the No VAT option - QuickBooks will only include purchases with VAT against them on your return if you tick the 'VAT reclaimable' box when creating the transaction. As long as you have your rate entered in your VAT settings, you do not need to change how you enter transactions - continue to use the 20% S code. 

 

Thanks,

 

Talia

FVA
Not applicable

Re: Flat rate scheme

So the issue is how QuickBooks presents the P&L. I want to show the gross income and expense on the P&L, with a line for FRP surplus. But also have the VAT correctly calculated. 

QuickBooks Team

Re: Flat rate scheme

Thanks for reaching back, FVA.

 

The option to show the gross income and expense on the Profit and Loss report, with a line for FRP surplus while having the VAT correctly calculated is currently unavailable in QuickBooks Online (QBO). Please know that we are taking note of your report preference for our product developers to consider this for future product enhancements.

 

For now, you can visit our QuickBooks Blog to be updated of the latest feature available in QBO: QuickBooks Blog.

 

If I can be of help with something else, please don't hesitate to get back to me. I'm always happy to assist.

Senior Explorer *

Re: Flat rate scheme

For me, on the Flat Rate Scheme, it needs to show P&L gross figures (ie including VAT) and not Gross Profit less the 20% VAT plus Flat Rate Scheme savings.

As the FLS savings is a figure that is meaningless (as far as I can see) in calculating my income tax. It gives a figure that is incorrect.

What the tax man wants is my gross profit, minus my flat rate scheme VAT amount, then minus my expenses including VAT.

Or am I missing something

Not applicable

Re: Flat rate scheme

This is the exact same query I have and no one at QB seems to be able to provide an acceptable answer. I wonder if it is possible for the technical team to please take a look at this as currently the figures showing in the Profit and Loss account are inaccurate if using the Flat Rate VAT scheme and any attempt to report the turnover (sales) and expenditure figures to HMRC from the P&L account is inaccurate. It is therefore necessary to manually calculate all figures which defeats the objective of paying for and using this software programme.
QuickBooks Team

Re: Flat rate scheme

Hello Poppylicious,

 

We would advise that the best way to resolve this would be to call our support line - they have access to tools like screen share that we don't, and so can look through your reports (rather than relying on screenshots) and determine how this is being calculated. You can reach them via 0808 234 5337. Make sure to select the VAT option before coming through.

 

Thanks,

Talia