DIY accounting software, tax accounting, payroll software, limited company formation UK

 

Accounting Software

Payroll Software

Self Employed Accounts

Self Employed Accts + Payroll

Sole Trader Basic Accounts

Taxi Driver Accounts

Company Accounts

Company Accounts + Payroll

Company Formation

Bookkeeping

Financial Services

Financial & Accounting Articles

Affiliate Program

What's New At DIY Accounting

Questions & Answers

About Us

 

Order FormEmployee DetailsPayroll filePayslipsPaye formsIncome taxNational Insurance

UK Paye Administration made easy with automated Payroll Software solution

completing excel copies of inland revenue paye forms P11, P14, P35, P45 and P60

UK paye administration is the management of income tax and national insurance contributions deducted from wages and salaries paid to employees

No entries are required to complete the inland revenue paye income tax and national insurance deductions records. Administration of the company paye system is automated with excel copies of the inland revenue forms P11, P14, P35, P45, P60 completed to provide the complete payroll return solution. The examples shown on this page are the actual excel spreadsheets the payroll software automatically completes as an essential part of the company paye administration.

All entries to these inland revenue and customs forms are fully automated by the company paye payroll system by recreating excel copies of the actual revenue forms, using the same format and colour coding. Benefits are enormous time savings and the benefit of all records being both accurate and available for inspection should they be required. Plus by having the paye P35 Annual return ready in April savings of up to £250 are available from the Inland revenue by submitting the P35 online.

P11 Employer Tax & National Insurance Deductions Working Sheet

UK Paye Excel Form

The UK paye inland revenue P11 working deduction sheet is fully automated and updated from the payroll system, to record each employees income tax, statutory payments and national insurance contributions deducted from employee wages and salaries each week and month providing the complete paye payroll return solution. National insurance number and the employee national insurance contributions are collected from the payroll file with other items to complete the working sheet such as the employers paye inland revenue reference and income tax code..

No calculations or adding required, UK paye tax and national insurance contributions all fully completed and calculated.

Pay Pay and Tax totals Tax deducted
0.00   <<         In previous employments         >> 0.00
0.00   <<              In this employment              >> 0.00
0.00   <<                  Total for year                   >> 0.00

P14 Employer End Of Year Summary Income Tax & National Insurance

UK Paye Excel Form

The UK paye inland revenue P14 summary is fully automated and updated from the paye tax and payroll system, to record each employees income tax, statutory sick pay payments and national insurance contributions each week and month, recording the deductions against the national insurance table letter which the system calculates from the employees date of birth providing a complete company paye administration payroll solution including the full back up details on the salary slips template.

For help to fill in this form see Employer's Help Book, E10   Please use black ink and write firmly to ensure your entries are clear on all three copies. £ spaces filled from thre right side   P14 End of Year PAYE Summary                  2008 - 09  
                                           
  Your name and address as employer   Inland revenue office name         Employer's PAYE reference        
                       
      For employer's use                            
                      Tax year to  05 April 2007      
    Post code                           Expenses payments and benefits paid to directors and employees:  Complete form P11D or P9D if appropriate and provide a copy of the information to your employee by 6 July.  See Employer's Further Guide to PAYE and NICs, CWG2 for more details  
   Employee's details         Date of Birth   Sex          
  National Insurance number                M or F        
  Surname           Employee's private address (if known)        
  First two forenames                  
                         
  Employee payroll number 01                
                  Post code          
  National Insurance contributions in this employment     (Note LEL = Lower Earnings Limit, ET = Earnings Threshold,  UEL = Upper Earnings Limit)      
  NIC Table letter   Earnings at the LEL        where earnings equal or exceed LEL Earnings above LEL up to and including the ET   Earnings above the ET up to and including the UEL     Total of employee's and employer's contributions   If column 1d is minus enter "R"   Employee's contributions due on all earnings above the ET   Scheme conbtracted out number  
                 
                 
                 
      1a   1b   1c     1d                  1e        
                                    S  
                                    S  
                                           
  Statutory                                        
       Statutory Sick Pay   Statutory Maternity Pay   Statutory Paternity Pay   Statutory Adoption Pay             Student Loan deductions   Tax Credits  
                        This employment only   In this employment
      1f   1g   1h   1i                    1j     Col 9  
                                       
  Date started if during tax year to 5 April 2007       Pay and Income Tax details                        
                                       
            Pay     Tax deducted   Enter "R" if net refund       Payment in week 53: if in pay & tax totals enter 53  
    In previous employment(s)                  
                         
  Date left if during tax year to 5 April 2007                                    
        In this employment                    
                   
                                   
    Total for year                        
                             
For official use                  
                    Final Tax code          
Employee's widows & Orphans Life Assurance Employee's Widows & Orphans Life Assurance contributions in this employment                
contributions in this employment          
                               
      To Inland Revenue   National Insurance copy  

P45 Inland Revenue form Details of employee leaving

UK Paye Excel Form

An excel copy of the inland revenue paye P45 is fully completed automatically when the employees leaving date is entered on the employees details worksheet section of the payroll file, Paye administration automated with no entries required. The details to complete the P45 collected from the payroll file and include the employer Paye reference number, employee national insurance number, employee details, income tax code at the date of leaving and the gross pay and income tax paid to date. The P45 does not include national insurance contributions as national insurance is calculated on a week to week basis and does not require to be advised to a future employer. Income tax is calculated on a cumulative basis unless the employee is on a week 1 or month 1 basis and has to be advised to the next employer to enable the employee income tax code to be advised and the cumulative income tax deducted to date.

When a new employee joins as a new starter that employee should give the new employer the P45 copies to enable the new employer to maintain the company paye administration as the P45 advises the employee details, income tax code, national insurance number, gross pay to date and tax paid to date. In the DIY Accounting payroll software all these items with the employee starting date are recorded in the employee details section of the payroll file which drives the paye system..

If the new employee does not have a P45 then the employer must give the employee a P46 to record the details, the P46 then being sent by the employer to the inland revenue who will check the employee records and advise the new employer with the employee income tax code and other applicable paye details such as week 1 basis.

      P45
 

 Inland Revenue

  Part 1
          Office number    Reference Number  
  1 PAYE Reference        
  2 Employee's National Insurance number      
                   Mr Mrs Ms  
  3 Surname (CAPITALS)     Ms  
     First name (s)          
                     
  4 Leaving date (figures)     5 Continue Student deductions (Y)  
                     Week 1 or Month 1
  6 Tax Code at leaving date. If Week 1 or Month 1        
               Week    Month  
  7 Last entries on Deductions working sheet P11   Week or Month number          
                 
  Complete only if Tax Code is cumulative. Total pay to date   0.00    
  Make no entry if Week 1 or Month 1 basis Total tax to date   0.00    
  8 This employment pay and tax Total pay this employment        
  No entry is need if Tax Code cumulative & amounts same as item 7 Total tax this employment        
  9 Works Number / Payroll number   10 Department or branch if any 0
                     
  11 Employee's  
       private address    
       and post code  
  12   I certify that the details entered above in items 1 to 10 are correct  
  Employer's Name    
  Address    
  Post Code      
  Date                
                     
   To the employer                              Please complete with care   For IR office use
Complete this form following the "What to do when an employee leaves" instructions in the Employer's Help Book, "Day-to-Day Payroll, E13" Inland Revenue office immediately  
Hand Parts 1A, 2 and 3 (un-separated) to your employee when they leave.
If the employee had died write "D" in this box and send all four parts of this form (un-separated)  to your inland revenue office immediately    
Make sure the details are clear on all four parts of this form. Make sure your name and address is shown on Parts 1 & 1A
Detach Part 1 and send it to your 
P45 BS12/01

P60 Employee End of Year Certificate

The automated paye revenue administration within the payroll software completes from the payroll system an excel copy of the P60 employee end of year certificate with details of employee deductions from wages and salary ready to print and issue to all employees at the year end, completing the employers paye 2008 responsibilities. The P60 is the employees copy of the payments under the UK paye system during the financial tax year. Effectively it is the employees own copy of the employers P14 and contains employee details, gross pay and income tax from the current employment and previous employment, the final income tax code for the tax year, and the national insurance contributions under each of the national insurance tables.

P60 End of Year Certificate   Employee's details  
Tax year to 5 April 2009   Surname    
        Forename    
To the employee:   National Insurance number     Payroll number    
Please keep this certificate in a safe place as you may need it to fill in a Tax Return or make a claim for Tax Credits.       01  
                 
    Pay and Income Tax details  
It also helps you check that your employer is using the correct National Insurance number and deducting the right rate of National Insurance contributions.                  
        Pay   Tax deducted    
By law you are required to tell the Inland Revenue about any income that is not fully taxed, even if you are not sent a Tax Return.   In previous employment            
                 
  In this employment *   '*      
                 
INLAND REVENUE   Total for year              
                       
The figures marked * should be used for Employee's Widows & Orphans/ Life Assurance contributions in this employment *      
your Tax Return, if you get one     Final tax code        
National Insurance contributions in this employment  
  NIC Table letter   Earnings up to and including the Earnings Threshold   Earnings above the Earnings Threshold up to and including the Upper earnings Limit   Employee's contributions   .    
           
           
                   
                   
Statutory payments included "in this employment" pay Statutory Maternity Pay   Statutory Paternity Pay     Statutory Adoption Pay        
           
Other Details   Your employer's full name and address (incl. postcode)  
  Student Loan Deductions in this employment        
           
  Tax credits in this employment          
         
To employee                     
          Employers PAYE revenue reference    
          Certificate by Employer/Paying Office:  
          This form shows your total pay for income tax purposes in this employment for the year  
          Any overtime, bonus commission etc., Statutory Sick, Maternity, Paternity, or Adoption Pay is included.  
                       
P60 (2008-09) Do not destroy BS11/04

P35 PAYE Annual Employers tax return of income tax and national insurance deductions

The inland revenue P35 paye employers return is fully completed automatically from the paye system date ready to submit to HM Revenue & Customs at the year end immediately after the final pay period of the Paye year. During the tax year the payroll file collects the records of the total income tax and employee national insurance and employer national insurance contributions on a monthly basis producing the paye 2008 totals. The information in the inland revenue paye payments form provides financial control over the monthly payments of tax paye and NI to the inland revenue. Payments of tax and national insurance being payable to the inland revenue on the 19th of each month following the month when the wages and salary deductions were made.

The P35 Annual return is a summary by employee of all the income tax and national insurance liabilities for each employee. The payroll software collects this information from the payroll spreadsheets and automatically enters in the excel copy of the P35 Annual Return. The P35 Annual return in the DIY Accounting payroll package being arranged in the same colours and layout as the inland revenue form to enable easy copy to a paper copy of the Annual Return or online filing. Submitting this inland revenue paye tax form online save up to £250.

 Completing and submitting the P35 annual return completes the Paye administration with no entries required.

Key Benefits of the Automated UK Paye Administration

  • Enormous time saved in all inland revenue paye UK forms P11, P14, P45, P60 and P35 completed automatically from the payroll software system

  • Accurate information saving time adding and checking paye information providing a complete payroll solution

  • Up to £250 savings by having the Employers P35 Annual Paye Return available on time and ready to submit to inland revenue tax paye return online with the income tax and national insurance entered for each employee and totalled.

Additional notes on Paye UK administration are contained in the payroll articles section

Top Paye Questions Answered

Pay As You Earn Wages And Salaries Tax Scheme Explained

Payroll Software Reduces The Paye Administration

"UK paye calculator for income tax paye administration producing inland revenue paye excel format P11, P14, P60 and P35, employers paye 2008 solved"

 

[ Accounting Software ] [ Sole Trader ] [ Self Employed ] [ Company Accounts ] [ Taxi Driver Accounts ] [ Payroll Software

[ Company Formation ] [ Bookkeeping Register ] [ Questions & Answers ] [ Affiliate Program ] [ Articles ] [ About us ]

Copyright © 2006 2008 DIY Accounting
Last modified: 10/20/08