General Information about Reporting

The system provides a number of substitute HMRC facsimiles. These are annually HMRC approved and are exact reproductions of the HMRC forms:-

  • P11D
  • P11D (b) 
  • P46(car) 


As well as these mandatory HMRC forms, the P11D Organiser also generates employee benefit statements as an alternative to the official HMRC P11D form itself, together with a number of management and Class 1A  reports. 

These reports can be sent to screen, print, file (PDF,XLS,CSV) or emailed as email attachments.


P11D Organiser reports are created, previewed and printed using the system’s inbuilt Reports Wizard which can be accessed from all areas of the system using the reports wizard "Printer" Icon.


All reports can be printed on standard A4 plain paper and no additional stationery is needed. The majority of reports are also available to be saved to file, allowing you to easily export data from the system into spreadsheets or PDF files.


Report Types

The reports are categorised and selected from one of seven reports "types" :-

1. Employee

2. Benefit

3. Periodic

4. Fleet

5. Employer

6. HMRC Amendments

7. Draft




Employee Reports

All employee reports are accessed and controlled from here, including HMRC approved P11D facsimiles, or the alternative P11D Benefit statements.



Available employee reports

Report Name Description 
P11D FacsimileSubstitute HMRC approved form.
P11D Facsimile (part)Substitute HMRC approved form - abbreviated to display only the sections of the P11D that have a benefit record assigned to an employee.
P11D Benefits Statement (both Standard & Modern)The widely used alternative employee P11D report – displays only the sections of the P11D that have a benefit assigned (both taxable & non-taxable) Also displays the employees home address, customizable text/guidance notes and an employer logo. 
P9D Facsimile (Obsolete after 2015/16 Tax year)Substitute HMRC approved form (under £8500 salary & BIK)  
P9D Benefits Statement (Obsolete after 2015/16 Tax year)Recommended employee report – displays only the sections of the P9D that have a benefit assigned (both taxable & non-taxable) Also displays customizable text/guidance notes & an employer logo 
P11D Benefits Statement BlankA report for employees who have NO reportable benefits or expenses.  
P11D Taxable Benefits Statement (both Standard and Modern)A report for employees to report taxable benefits only, as opposed to the standard benefit statement which will display ALL benefits both taxable and non-taxable. 
Employees Part 5 ITEPA2003 expenses claim formIn the absence of a dispensation, a claim form addressed from the employee to the HMRC to state all expenses are “wholly & exclusively” business related and therefore claim tax relief. 
Employees section 336 business mileage claim form Where an employee received less than the HMRC approved mileage rate (AMAP) for using their own car for business (currently £0.45) A claim form format report that is  addressed from the employee to the HMRC to compare the amount that they have received for mileage claims against the approved HMRC rate to then claim the difference in Tax relief. 
P46 (Car)
Substitute HMRC form for mid tax year company car changes (Replaced by on-line FBI filing)
Employees business mileage comparison
A report to compare the mileage values saved with the approved HMRC AMAP rates (currently £0.45 per mile)
Employees Business mileage statement 
Legacy report – (Where car mileage was recorded and used to calculate benefits under previous years legislation)
Employees Business mileage declaration
Legacy report – (Where car mileage was recorded and used to calculate benefits under previous years legislation)
 



Benefit Statements

Benefit Statements are used to communicate what benefits have been provided to an employee for a specific Tax year. The Benefit Statement is as an alternative employee report to the official HMRC looking "P11D Facsimile".

Benefit Statements are available as either standard or modern, employee benefit statements are produced in a window envelope format for ease of posting and can be print ordered. The standard system graphic can be replaced with your own company logo. Additional text can also be added so as to provide your own text/guidance notes to employees.






Attached sheets

Where the number of benefit records assigned extend so as to necessitate the creation of an “attached sheet” (e.g. where an employee had more than 2 company cars available in the tax year) the system will refer to this on the HMRC P11D facsimile and will automatically produce the appropriate attached sheet to display all the relevant data.

 


 



Benefit Reports
A report for each P11D section benefit category that has assigned benefit records saved in the system e.g. Cars and Car fuel, Medical Insurance, Vans etc.



Periodic Reports
Company car VAT Fuel Scale Charge and a number of legacy reports such as mileage and Printed P46(car) reports. Most of which are now able to be reported on-line to the Government Gateway and are no longer "printed" and posted to HMRC.

This section also contains a number of legacy reports such as company car mileage and company car class 1A. 



Fleet Reports
Car movement reports, fuel benefit reports, capital & private use contribution reports plus a number of legacy reports referring to car mileage and car data validation.




Employer Reports 

Primarily the HMRC approved P11D(b) Employers Declaration and a selections of Class 1A NIC reports. 

Global benefit and employee reports are also available, including the ability to export the employee records data using the "List employees with all associated details" report when saved to a "file" (xls, xlsx, csv etc.)




HMRC Amendments

HMRC only allow a single end of year on-line FBI submission to the Government Gateway, therefore any subsequent amendments, errors or omissions have to be reported to HMRC by sending a clearly marked “Amended” P11D, a revised P11D(b) is also recommended and a covering explanatory letter.

For further information:- https://www.gov.uk/employer-reporting-expenses-benefits/reporting-and-paying







Draft Reports 

Provides a number of employee focused reports with a "Draft" watermark to facilitate the process whereby reports are issued to employees as draft, followed by an amended statement and a final statement.





Additional "User defined notes" text can be added to each of the reports so as to provide a clear message to the employees to help explain the reporting process.   




EXAMPLE REPORTS


Example 1 - Draft P11D Benefit Statement (modern) with additional "user defined text".



Example 2 - Amended P11D Benefits Statement (modern) with additional "user defined text".



Example 3 - P11D Benefits Statement (modern) with additional "user defined text".




Available Reports

Having selected the appropriate report type “Tab” as above, a choice of report can be made from the list of reports displayed. The system provides a number of substitute HMRC facsimiles. These are exact copies of the HMRC forms P11D, P9D, P11D (b) and the P46 (car). HMRC approve of all of the system generated substitute forms each year.

Together with the mandatory HMRC forms, the system also generates a number of management and system reports. These can be sent to screen, print, file (PDF,XLS,CSV) or emailed as mail attachments.


NOTE: All reports are generated with real-time values. If you are producing analysis reports to compare to the HMRC submission, you may get a variance if you have made adjustments to the benefit data post-submission. Also, the Class1A analysis reports calculates based on the total benefits per person or benefit, whereas the live submission is calculated on the total submission value, which may lead to a small variance during comparison or re-charging to specific cost centres.


Each report type (tab) has a list of available reports relevant to that category:-

Employee Reports

Report Name Description 
P11D FacsimileSubstitute HMRC approved form.
P11D Facsimile (part)Substitute HMRC approved form - abbreviated to display only the sections of the P11D that have a benefit record assigned to an employee.
P11D Benefits Statement (both Standard & Modern)The widely used alternative employee P11D report – displays only the sections of the P11D that have a benefit assigned (both taxable & non-taxable) Also displays the employees home address, customizable text/guidance notes and an employer logo. 
P9D Facsimile (Obsolete after 2015/16 Tax year)Substitute HMRC approved form (under £8500 salary & BIK)  
P9D Benefits Statement (Obsolete after 2015/16 Tax year)Recommended employee report – displays only the sections of the P9D that have a benefit assigned (both taxable & non-taxable) Also displays customizable text/guidance notes & an employer logo 
P11D Benefits Statement BlankA report for employees who have NO reportable benefits or expenses.  
P11D Taxable Benefits Statement (both Standard and Modern)A report for employees to report taxable benefits only, as opposed to the standard benefit statement which will display ALL benefits both taxable and non-taxable. 
Employees Part 5 ITEPA2003 expenses claim formIn the absence of a dispensation, a claim form addressed from the employee to the HMRC to state all expenses are “wholly & exclusively” business related and therefore claim tax relief. 
Employees section 336 business mileage claim form Where an employee received less than the HMRC approved mileage rate (AMAP) for using their own car for business (currently £0.45) A claim form format report that is  addressed from the employee to the HMRC to compare the amount that they have received for mileage claims against the approved HMRC rate to then claim the difference in Tax relief. 
P46 (Car)
Substitute HMRC form for mid tax year company car changes (Replaced by on-line FBI filing)
Employees business mileage comparison
A report to compare the mileage values saved with the approved HMRC AMAP rates (currently £0.45 per mile)
Employees Business mileage statement 
Legacy report – (Where car mileage was recorded and used to calculate benefits under previous years legislation)
Employees Business mileage declaration
Legacy report – (Where car mileage was recorded and used to calculate benefits under previous years legislation)




Benefits Reports
Report Name Description 
A – Assets Transferred
B – Payments made  
C – Vouchers & Credit Cards
D – Living Accommodation
E – Mileage Allowance
F – Cars and car fuel
G – Vans & Van fuel                                            Report for each section of the P11D
H – Loans 
I –  Private medical treatment or insurance
J – Qualifying Relocation
K – Services Supplied
L – Assets placed
M – Other items
N – Expenses payments


Periodic Reports

Report Name Description 
P46 (Car)  Substitute HMRC form (Replaced by on-line FBI filing)
P46 (Car) Movements by employeeCar allocation/movements report
Company Car Class 1A NICLegacy report (no longer used)
Company Car Fuel Benefit VATOutput VAT report based on VAT Fuel Scale Charges
Absent Business MileageLegacy report (no longer used)
Input Business MileageLegacy report (no longer used)
Employees Business Mileage DeclarationLegacy report (no longer used)
Export to AccountsLegacy report (no longer used)
Export to PayrollLegacy report (no longer used)
P46 (Car) REPRINTSubstitute HMRC form (Replaced by on-line FBI filing)
P46 (Car) Movements by employee - REPRINTCar allocation/movements report



Fleet Reports

Report Name Description 
Company car movements by registration numberA report driven and sorted by car registration number to confirm all car allocations/movements in the Tax year
Company car listing & validation – ALLOCATED CarsLegacy report – before the introduction of the current import data validation, this report was used to highlight any potential problems in the car data that could lead to inaccurate benefit values being calculated (for cars already assigned/allocated)
Company car listing & validation – UNALLOCATED CarsLegacy report – before the introduction of the current import data validation, this report was used to highlight any potential problems in the car data that could lead to inaccurate benefit values being calculated (for cars not yet assigned/allocated)
Company car private use contributionsA report of the “private use” values entered against existing company car records.  
Company car capital contributions

A report of the “Capital contribution” values entered against company car records. 

Company car private fuel benefit

A report of the “private fuel benefit” values entered against company car records. (HMRC fuel scale charges) 

Company car Non-exclusive use

To report to check a potential benefit over-payment where company cars are being used with overlapping availability across more than company/employer 



Employer Reports

Report Name Description 
P11D(b) Employer’s declarationHMRC Approved report containing the Class 1A NIC payable value and a declaration for completion and signature.
Class 1A NIC summary by P11D SectionClass 1A NIC summary by P11D Section
Class 1A NIC summary by CostcentreClass 1A NIC summary by Costcentre
Class 1A NIC summary by EmployeeClass 1A NIC summary by Employee
List employees with associated detailsA list of all employee records - which can also be exported to a comprehensive spreadsheet of every employee field held in the system.
List employees with P11D Sections appliedA graphical report to show by icon which benefits have been assigned to an employee.
List employees with taxable valuesA report of taxable benefit value per employee for each section of the P11D in a column format.  
List all EmployersA list of all employer records in the system
Benefits distribution reportA “Head-count” type report by costcentre  to show the reporting status for each employee. Either a status category of No benefits, P11D or P9D.
Benefits distribution summaryA Summary report of the Benefits Distribution report
Loans – joint borrowers reportA report of loans where a loan has been applied to 2 individuals (e.g. a mortgage in joint names)  

HMRC Amendments

P11D Facsimile Amended (full & part) Substitute HMRC form containing an “Amendment” watermark - used to print and post to HMRC for any P11D’s that have been changed after the on-line Gateway end of year return has been made. 
P9D Facsimile Amended
(Obsolete after 2015/16 Tax year)
Substitute HMRC form containing an “Amendment” watermark - used to print and post to HMRC for any P11D’s that have been changed after the on-line Gateway end of year return has been made. 
P11D Benefits statement Amended (standard and modern)Substitute employee form containing an “Amendment” watermark - used to deliver to employees for any P11D’s that have been changed after the on-line Gateway end of year return has been made. 
P11D Taxable Benefits statement Amended (standard and modern)Substitute employee form containing an “Amendment” watermark - used to deliver to employees for any P11D’s that have been changed after the on-line Gateway end of year return has been made. 
P46 (Car) REPRINT

Substitute HMRC form (Replaced by on-line FBI filing) - this report can be used to print and post to HMRC for any P46(car) records that have been changed after the on-line Gateway P46(car) mid-year return has been made. 


Draft Reports

Report Name Description 
P11D Facsimile Draft 
(full & part)

Substitute HMRC form containing a “Draft” watermark - used to deliver a "draft" P11D to employees prior to providing them a subsequent or final P11D.
P11D Benefits statement Draft (standard and modernSubstitute employee form containing an “Draft” watermark - used to deliver a "draft" P11D to employees prior to providing them a subsequent or final P11D. 
P11D Taxable Benefits statement Draft (standard and modern)Substitute employee form containing an “Draft” watermark - used to deliver a "draft" P11D to employees prior to providing them a subsequent or final P11D. 





Scope

The Scope selection of the reports wizard allows you to select the range of employees that a report is to be generated for. The system captures and categorises employee groupings in 4 levels, Employee, Active Lookup, Employer and Everybody.


This Employee

The chosen report will be generated for the selected employee only.


This Lookup

After initiating a search using the “Find” Screen, the resulting list of employees is defined as an "Active Lookup". For example a search for all employees belonging to a certain Location, Department or Cost centre or by a specific filter for all employees "with an email address" or "without an email address" etc. (see help file for setup filter)


The chosen report will be created and output for the members of the “Active lookup” of employees only. (e.g. send to "print" all employees without an email address and send to "email" all employees with an email address.


This Employer

The chosen report will be generated for all employees for the selected Employer.

Everybody
The chosen report will be generated for all employees for all employers contained in the system.



Order by

The Reports wizard allows a selection to be made for the printed output to be ordered using up to a total of 4 order-by statements (see screenshot above).

For example, this will enable you to print out employees benefit statements ordered initially by the employees Location, then by their CostCentre, then by their Department, then by Surname for ease of distribution.



Report to

The reports wizard allows you to generate reports with a number of different output options. For example, delivery of Employees benefit statements can be chosen to be sent by e-mail, or a company car report can be exported to an Excel file. 


There are four selectable "R
eport to" options; Screen, Printer, File or Email


Screen

Generates a preview of the selected report to screen


Printer

Generate the selected report to your default printer (the system will display an intermediate printer selector window to select the desired printer to use)

Double sided printing

You can choose to either simplex or duplex print, which will automate the printing of documents on both sides using a duplex capable printer. 

Ctrl Shift S sets the selected report to Simplex mode or Ctrl Shift D sets the selected report to Duplex mode.

 

File

Generate the selected report output to a file type of PDF, CSV, XLS, XLSX or DBF  

The system will display a 'Save As' dialogue box to select a choice of file type and save location for the output file. By default the system will output files to an EXPORT sub folder contained within the system’s installation directory e.g. 

C:\Program Files\P11D\IMPORT\20182019\EXPORT


Employee reports sent to file are output as a PDF files with a choice of uniquely named PDF's or combined into a single PDF file. This can be used to facilitate an in-house/intranet means of delivering reports to employees using an employee self-service portal. The system uses the Employees Surname, Forenames, N I Number, Unique System ID, Report Name, and Tax Year to create the unique file names. e.g. BLOGGS_FRED_YK281676D_202099_P11D_Benefits_Statement_20182019


Having selected to create a benefit statement or similar employee benefits report, the system will display a pop-up window giving you the option to create either a single PDF file (check-box ticked to “Concatenate” and set the batch number value) or individual PDF’s for each and every employee (unchecked the “Concatenate PDF documents” option). You also get the option to hide the National Insurance Number from being displayed on the Benefit Statement by check the "hide" box.



The system will prompt you to choose a folder to save the PDF’s to your chosen location.






Email

The P11D Organiser provides functionality to send emails to employees with their P11D or Benefits statement as PDF file attachments. It is designed to interact with Microsoft Outlook and will logon to the user's email profile (or that of a group email profile such as "payroll team" etc.) and send the chosen report using the outlook system. 

The system can also be configured to use its own email functionality and accommodate other email systems using the alternative SMTP settings (see separate help section on this subject)


Outlook settings


SMTP settings



The system will generate individually addressed emails, and attach a PDF version of the selected report created by the system using the P11D Organiser PDF printer driver to perform this function.


The system will send the emails to the email addresses saved in the employee records. If the employee record has a blank email address, the system will by default send the email to the email address set up as the email administrator in the Employers record.



NOTE: The emails will be sent by the account selected/logged into at the time so it may be advisable to use a generic email group account rather than the individual's own personal email account. (e.g payroll@mycompany.com rather than sally.smith@mycompany.com)  




Email body "Notes" text

The system allows you to create the body of text for the outgoing emails using the NOTES option. 

To add the email body text, select your preferred benefits statement, select Email in the Report to tab, click the 

"USER DEFINED EMAIL MESSAGE" button  and enter your email text into the "Message" box (screenshot below).


The text can be either keyed in directly to the notes text box, copy (Ctrl C) /pasted (Ctrl V) from another open document. 



Using the USER DEFINED NOTES button, any notes saved will also appear as a body of text on the chosen employee report/statement. 



To send the emails out, click on the Email button from the email screen to first preview and then send the first email, the system will then display the same email pre-screen for the next alphabetical employee record for you to send the remaining emails by clicking the Rest button.



Screenshot - Using internet mail SMTP 


Screenshot - Using Microsoft Outlook








Advanced settings

There are a number of additional features that can be used to set advanced reporting functionality:-

Export Benefits



Functionality to allow your export all benefit records into separate P11D section category reports/spreadsheets. 

Choose a “Save in” folder location for the output and the exported reports/files will saved to this location. A choice of file types (PDF/XLS/XLSX/CSV etc.) can be made for the exported output files.




View Sent Items


Functionality to show a log of items previously emailed using the systems own SMTP email functionality. 

These are categorised in specific categories: -

Emailed

Displays a list of all employee records that have been successfully sent the selected report by email.


Modified 

This lists any email recipients whose Employee records have been modified since the email was issued e.g. Change of name or address etc.


Changed

This option lists all employees whose P11D Taxable values have been changed since their email was sent e.g. correction to the list price of a company car or a change to the medical benefit value.


Errored

Lists all employee records whose email delivery (of the selected report) was unsuccessful for one reason or another e.g. the employee had no email address or the system had not been correctly configured to handle your particular email functionality (see advanced settings section also). 


View

Displays the benefit statement to screen (or other employee .PDF report that was attached to the email) 


Lookup

Creates an "active lookup" of all employee records currently displayed (e.g. can be used to resend a new email to this specific lookup of employees, for example, those that were NOT emailed successfully and therefore need to be printed instead or attempted to be emailed again)



NOTE: A R/H mouse click on the "Lookup" button provides additional functionality to "Exclude" employees from the current lookup. For example, when used in conjunction with the "Emailed" list of records, the system will create a revised lookup of employees who have not been emailed successfully.




Advanced settings 


Email


Settings screen to configure email system functionality:- 


Email system - Drop-down selection to choose which email client to use in conjunction with the P11D Organiser. The system can be used to send employee benefit statements, a selection between Outlook or Internet mail SMTP can be made. 

Additional check-box options to:-
Use Microsoft outlook dialog or use P11D Organiser’s own dialogue box to view email functionality.

Set email sensitivity level – selections of Normal/Personal/Private/Confidential

Set email importance level – selections of Low/Normal/High

Set to request email read receipts
Set to request email delivery receipts

Set to use HTML in body of email

Set to Use automation

Set to Use Encryption

Send test email 

Rebuild Email Systems



SMTP



Settings screen to facilitate the use of SMTP email functionality (contact your own IT team for additional help for these SMTP email settings)




How to use the reports wizard to print an individual employee's Benefit Statement?

STEP 1 - Select the particular employee using the "Find" employee functionality Finding Employees


STEP 2 - Select the report wizard by clicking on the PRINTER icon. The system will take you to the reports wizard screen.


STEP 3 -
Select the 1. EMPLOYEE report type from the 7 available "View Reports" categories on the left.



STEP 4 - Select the P11D Benefits Statement (choose between modern or standard) report from the list of available reports – Click NEXT


STEP 5 – Set the SCOPE setting for the report - THIS EMPLOYEE (in this example) – Click NEXT

 

STEP 6 – Set the REPORT TO option as PRINTER and click on FINISH to print the Benefit Statement to the printer of your choice. – Click FINISH


STEP 7 – Choose a Printer to use from the drop-down PRINT TO selector – Click OK



The Benefits Statement report will now have been sent to the chosen printer. 




HMRC approved facsimiles/substitute forms

Each year Personal Audit Systems Ltd gain approval of the substitute HMRC forms for P11D, P46(car) and P11D(b), these are acceptable to HMRC should you need to print and post them to HMRC.



P11D (2019) (Substitute) PAS Ltd




P9D (2016) (Substitute) PAS Ltd (obsolete after 2015-16 Tax year)

  






P46 (car) (2019) (Substitute) PAS Ltd







P11D(b) (2019)