I don't know about Sage, but the £1000 of sales is essentially £1022.50 worth of turnover, as FRS VAT needs to be accounted for as turnover. So transaction 1 is receiving the £1175 (+bank, +sales), and the tax transaction is £152.75 (-bank, +creditors).
Turnover is sales+VAT less the VAT you have to pay under FRS.
You may want to try the zedAccounts software as it is FRS VAT friendly.
ZED.
- Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
- Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!
Collapse
You are not logged in or you do not have permission to access this page. This could be due to one of several reasons:
- You are not logged in. If you are already registered, fill in the form below to log in, or follow the "Sign Up" link to register a new account.
- You may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
- If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.
Logging in...
Previously on "Accounting opinion needed with dealing with FRS VAT profits in the accounts"
Collapse
-
Just follow the Sage Article Number 11741 on how to do Flat Rate VAT for Instant Accounts. (from http://support.sage.co.uk)
I'm using v14. It's not too bad (two journal entries and a bit of fiddling with the VAT form), but I'll probably upgrade soon if they've added native support for it.
Leave a comment:
-
Originally posted by css_jay99 View Post
Every thing everyone is saying is still more or less pointing to the same thing ....... i.e. apportionment of FRS profits into the year which it relates instead of when VAT is to be reported....
css_jay99
Leave a comment:
-
Originally posted by rmmc View PostJust a bit confused with your post.
when you raise the invoice sales of £1000 will be posted to sales / income and £175 as a vat owing to HMRC.
So at year end your situation would be
Sales £1,000 (Credit balance)
Vat £175.00 (Credit balance)
Bank / debtors £1,175 (debit balance)
So you just need to adjust for the FRS difference.
Debit Vat (vat liability account) £22.50
Credit Sales £22.50
You can ask HMRC to move your vat quarter to coincide with your accounting year end.
I created a nominal code 4906 as Other sales/income to keep track of any extra income comming in via FRS
N/C 2200 is sales tax control Account
N/C 2202 is vat Liability
Credit 4906 others sales with £22.5
Debit 2200 sales control with £22.5
Debit 2200 sales control with £152.75
Credit 2202 VAT liability with £152.75
Every thing everyone is saying is still more or less pointing to the same thing ....... i.e. apportionment of FRS profits into the year which it relates instead of when VAT is to be reported....
Might give the other softwares a try
css_jay99
Leave a comment:
-
Just a bit confused with your post.
when you raise the invoice sales of £1000 will be posted to sales / income and £175 as a vat owing to HMRC.
So at year end your situation would be
Sales £1,000 (Credit balance)
Vat £175.00 (Credit balance)
Bank / debtors £1,175 (debit balance)
So you just need to adjust for the FRS difference.
Debit Vat (vat liability account) £22.50
Credit Sales £22.50
You can ask HMRC to move your vat quarter to coincide with your accounting year end.
Leave a comment:
-
The newer 2011 version of Sage will deal with Flat Rate calculations.
Leave a comment:
-
Or scrap Sage and get a decent system that does the flat rate automatically, i.e. Kashflow or Freeagentcentral!
Leave a comment:
-
Originally posted by css_jay99 View PostHi
I need an accounting opinion on dealing with VAT period straddling company Accounting period.
I guess this is a question for accountants amongst us or people who do their own accounts!
My Company accounting period is Jan - Dec
I have a VAT return period that straddles my Accounting period i.e. a VAT period Dec - Feb.
I am also on the Flat rate scheme
Here is an example of what I currently do... using figures as an example ...
Gross Sales/Invoice for December = £1175 (includes £175 VAT)
Under FRS, VAT to HMRC (due next February) will be £152.75 (i.e. 13%*1175)
Profit/Extra income on FRS will be £22.5 (i.e. 175 - 152.75)
So ...
1) Move £1000 to P&L account as sales
2) Move £22.5 to P&L account as Extra Income
3) Move £152.75 to Balance Sheet as VAT Liability (creditor .. even though not due or realised)
The journal apportionment of steps 2&3 is a complete pain in Sage instant accounts since it can’t handle FRS by default
so My questions are
a) Does everyone do it this way or
b) Leave out steps 2&3 from the current year and deal with it in the next year's account when the VAT is due... if so please explain
Cheers
css_jay99
Leave a comment:
-
Accounting opinion needed with dealing with FRS VAT profits in the accounts
Hi
I need an accounting opinion on dealing with VAT period straddling company Accounting period.
I guess this is a question for accountants amongst us or people who do their own accounts!
My Company accounting period is Jan - Dec
I have a VAT return period that straddles my Accounting period i.e. a VAT period Dec - Feb.
I am also on the Flat rate scheme
Here is an example of what I currently do... using figures as an example ...
Gross Sales/Invoice for December = £1175 (includes £175 VAT)
Under FRS, VAT to HMRC (due next February) will be £152.75 (i.e. 13%*1175)
Profit/Extra income on FRS will be £22.5 (i.e. 175 - 152.75)
So ...
1) Move £1000 to P&L account as sales
2) Move £22.5 to P&L account as Extra Income
3) Move £152.75 to Balance Sheet as VAT Liability (creditor .. even though not due or realised)
The journal apportionment of steps 2&3 is a complete pain in Sage instant accounts since it can’t handle FRS by default
so My questions are
a) Does everyone do it this way or
b) Leave out steps 2&3 from the current year and deal with it in the next year's account when the VAT is due... if so please explain
Cheers
css_jay99Tags: None
- Home
- News & Features
- First Timers
- IR35 / S660 / BN66
- Employee Benefit Trusts
- Agency Workers Regulations
- MSC Legislation
- Limited Companies
- Dividends
- Umbrella Company
- VAT / Flat Rate VAT
- Job News & Guides
- Money News & Guides
- Guide to Contracts
- Successful Contracting
- Contracting Overseas
- Contractor Calculators
- MVL
- Contractor Expenses
Advertisers
Contractor Services
CUK News
- Streamline Your Retirement with iSIPP: A Solution for Contractor Pensions Sep 1 09:13
- Making the most of pension lump sums: overview for contractors Sep 1 08:36
- Umbrella company tribunal cases are opening up; are your wages subject to unlawful deductions, too? Aug 31 08:38
- Contractors, relabelling 'labour' as 'services' to appear 'fully contracted out' won't dupe IR35 inspectors Aug 31 08:30
- How often does HMRC check tax returns? Aug 30 08:27
- Work-life balance as an IT contractor: 5 top tips from a tech recruiter Aug 30 08:20
- Autumn Statement 2023 tipped to prioritise mental health, in a boost for UK workplaces Aug 29 08:33
- Final reminder for contractors to respond to the umbrella consultation (closing today) Aug 29 08:09
- Top 5 most in demand cyber security contract roles Aug 25 08:38
- Changes to the right to request flexible working are incoming, but how will contractors be affected? Aug 24 08:25
Leave a comment: