Sage 50 Payroll

Welcome to the Sage 50 Payroll Support Group on Community Hub! Available 24/7, the forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

P11D v26- issues with data import - skipping records PAYEREF ?

Posted By Flavia Freitas over 2 years ago

Just doing P11D data upload and keep encountering same error.

Invalid CSV record '1': The mandatory field 'PAYEREF' is missing or has an invalid data type, skipping record...

It recognizes the data but SAGE P11D skips all records and doesn't import any of the information onto P11D.

I have checked the format of the CSV file and all fine but it skips records due to the PAYEREF column which was never a problem in previous years. I have tried to upload without forward dash '/'. So like 123123456 instead of 123/123456 and still skipping.

Anyone else having same issue?

0 Richard_H over 2 years ago

Hello Flavia,

Apologies for the delay in responding to your query.

Often when importing data from a CSV file, errors generally indicate there is an issue with the formatting of the CSV file being used to upload the data. If you have not done this already I would ensure you are using one of the pre set CSV templates we provide.

The CSV template are actually initially saved as XLS files, as this allow us to have comments on each column heading advising what the format needs to be. I have included a link below to our support article on CSV imports to assist you further, it includes steps on how to find and use the templates:

https://gb-kb.sage.com/portal/app/portlets/results/viewsolution.jsp?solutionid=200427112209570

Kind Regards

Richard
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 50 Payroll

P11D v26- issues with data import - skipping records PAYEREF ?

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING