HMRC P11D Generation

Outsourced Payroll Provider

Project Brief

A solution is needed to help us meet our obligations for disclosing benefits and expenses for our members to HMRC via the P11D statutory form.  The solution should aggregate fees and allowances from both Payroll and our Dynamics CRM based administration system.  We need to be able to deliver (via email) completed forms to the scheme members themselves for their records and to the HMRC.

 

Solution Implmented

A small internal website was delivered to act as the aggregation point between CRM and Sage Payroll.  All data is collated into SQL Server providing an archive so that previous P11D's can be reproduced as needed.  

On creation each members P11D is generated server side as a PDF and saved to the member's file store on the LAN.  A checking and sign off process allows for spot checking before the P11D's are eventually emailed out to the recipients.

Alongside the primary website, several SQL Reporting Services were also delivered providing MIS and reporting against the P11D database. 

 

Return to Completed Projects

Services Provided

  • Database Design Database Design
  • Development Development
  • Systems Integration Systems Integration
  • Analysis and System Design Analysis and System Design
  • Management Reporting Management Reporting
  • Website Design Website Design
  • Website Implementation Website Implementation

Built Using

  • Microsoft Visual Studio Microsoft Visual Studio
  • Microsoft SQL Server Microsoft SQL Server
  • Crystal Reports Crystal Reports
  • Microsoft .Net Framework Microsoft .Net Framework
  • Microsoft C# .Net Microsoft C# .Net
  • Microsoft Dynamics CRM Microsoft Dynamics CRM
  • Microsoft Excel Microsoft Excel
  • Microsoft Reporting Services Microsoft Reporting Services
  • Sage Line 50 SDK Sage Line 50 SDK