Sage Pastel Payroll Export & Import to Excel

SOLVED

Hi,

I have tried searching for a way to export my employees master file data to excel including headers. Please tell me the steps on how to go about doing this. It seems that the present export function is to a text format only. I want to be able to export to an excel file, manipulate and add new employees and then import back to pastel.

Thanks in advance.

Parents
  • +1
    verified answer

    Good day KRaj,

    Thank you for the post.

    Yes it only exports in a .txt file.

    Please Navigate to you Help - Search for Help On - Go to the search tab - Type in Masterfile Layout - Employee Masterfile

    This can be done manually by coping the employees, however we cannot assist with the manual layout.

    If you want it in excel format, please email us on [email protected] so we can send it to you.

    Kind regards

    Christelle

  • 0 in reply to Christelle

    Hi, support to date has not responded. I have mananged to sort out the import of the masterfile howvere I have encountered another problem; after the import I have noted that the new employees do not have the standard statutary contributions and deductions linked to a profile. I have to manually insert these on those that are missing. I have tried a rebuild and a profile sync but it does not solve the problem. Any suggestions?

  • 0 in reply to KRaj

    I also used to do it with import function and also had similar problem, so from there I just manually rather capture them, VERY time consuming

Reply Children
No Data