The system does not have a full audit trail of every change made to the system records but it does have functionality to view a list of employees who's benefit values have been modified AFTER an end of year FBI submission to the Government Gateway. The process involved: -


1. Select the required TAX YEAR



2. Select the HMRC Filing> EOY Filing By Internet - FBI screen


3. Select the M button to create a list of employees that have been modified after the submission  


Confirm Yes to the confirmation dialogue box

blob1476955709597.png


Confirm OK to the confirmation dialogue box

blob1476955911356.png



The resulting employees in the "active lookup" can then be used to create a report/spreadsheet and comparisons made between the EOY reported values and the values currently saved against their records. 


1. Reports wizard

blob1476955947991.png


2. "List employees with all associated details" report (from 5. Employer reports tab)

blob1476956063650.png


3. This Lookup

blob1476956109756.png


4. To FILE

blob1476956172932.png



5. Select folder/location and save the Spreadsheet 

blob1476956246653.png





Having opened the spreadsheet, the taxable BIK values can be used to compare with those that were actually reported during the Gateway FBI submission


1. The spreadsheet report of all modified employees 

blob1476956438721.png



2. Comparison of the reported values in the EOY FBI XML file that was submitted to the HMRC (searching the file for the employees concerned by their NI Number)

blob1476957435228.png




NOTE - It is recommended to use a copy of the end of year FBI XML file and not the original file to protect it from accidental revision!


1.  Email yourself a copy of the XML file using the FBI EOY screen


or create a copy of the XML file from the P11D Organiser wwwfbi folder


1. R/H click to select to "open the file location"

blob1476957925739.png


2. Open the WWWFBI sub folder

blob1476957979171.png


3. Open the required Tax Year folder

blob1476958012981.png


4. Select the relevant XML file to be copied and R/H click to "Copy"

blob1476958206040.png




Finally, paste the file to a folder of your choice so that you can then open it to make the desired comparison. 

blob1476968446451.png


We recommend that you use MS Excel to view the XML file, however it can be viewed in other programs such as notepad or internet explorer etc.


EXCEL

blob1476968734330.png



NOTEPAD

blob1476968482444.png


INTERNET EXPLORER

blob1476968528875.png