Skip to content

x Want to ask a question or reply? Click here to join the group.
  • State Suggested Answer
  • Replies 1 reply
  • Answers 1 answer
  • Subscribers 8 subscribers
  • Views 387 views
  • Users 0 members are here
Browse Forums
Announcements
684
topics
55
replies
General Discussion UKI
3k
topics
6k
replies
Legislation
25
topics
40
replies
Online services
133
topics
236
replies
Processing your payroll
525
topics
985
replies
Sage 50 P11D General Discussion
166
topics
392
replies
Workplace pensions
141
topics
271
replies
Year End Discussion
129
topics
188
replies
More Content

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

Jess R
Suggested
Posted By

Despite using the template provided by Sage (CSV for import) I keep getting the same eroor message 'Invalid Medical Insurance CSV record '1': The mandatory field 'PAYEREF' is missing or has an invalid data type , skipping record...' The format of the PAYEREF is exactly the same as last year and all other cells are in the same format of last year which I uploaded successfully. Can anyone offer some guidance as to what I can try next please

  • 0
    Suggested

    Hi Jess,

    This error normally occurs if there is a mismatch between the PAYE/REF of the company in the P11D software and the equivalent in the CSV file. We'd recommend checking both to look for any discrepancies. In the software, the reference is found in the Employer Record: Employer > Employer Record > Details

    If you find that they match and the problem persists, then we'd recommend contacting Sage Technical Support so they can look further into it.

    Andy,
    Sage UKI

*Community Hub is the new name for Sage City