Generate payroll with SAGE

Generate payroll with SAGE

STEP 1: Create a shortcut to Sage

From a computer with access to your Sage account:
  1. Go to your documents,
  2. Create a shortcut to your Sage directory :
    1. Click the right button of your mouse,
    2. In the menu that appears, choose New,
    3. In the submenu that appears, choose Shortcut,
    4. When asked for location, copy / paste: \\J0xxxFPC10\sageges$\punktel
    5. Change the xxx to your enterprise number.
  3. Click on the button Next,
  4. Name the shortcut: Punches.

STEP 2: Generate the payroll report

Exportation report

From an Emprez session with Administrator rights: 
  1. In the Pay menu,
  2. Choose Export pay,
  3. Take the right payroll company if you have more than one,
  4. Make sure you have the correct period to treat,
  5. Edit the export report to verify the information.

Pay Summary

Still from an Emprez session with Administrator rights:
  1. In the Pay menu, 
  2. Choose Pay Summary,
  3. Select the right payroll Enterprise if you have more than one,
  4. Make sure you have the correct period to treat,
  5. Choose the sort order for the classification of employees in the report,
  6. Generate.

STEP 3: Export data to Sage

From an Emprez session with "Administrator" rights.
  1. In the Pay menu, 
  2. Choose Export pay,
  3. Select the right payroll Enterprise if you have more than one,
  4. Make sure you have the correct period to treat,
  5. Generate.
By default, this file will be in the Downloads folder on your computer, if not, make a note of the directory where you saved it.
  1. Go to the folder where you saved the file,
  2. Copy the file POIN01.DBF previously export, 
    1. Make sure to remove the number in parentheses. Example: POIN01(2).DBF
    2. If requested, agree to replace/overwrite the existing file,
  3. Paste in the Punches shortcut you created in step 1, 
  4. Open Sage and read the punches.
Your export procedure is now complete!
If you manage more than one branch, process payroll for the next branch after submitting the first branch's information to Sage. Rename the files to remove the numbers in parentheses. Example: POIN01(2).DBF

Problems with payroll transmission

If Sage does not submit the information, please refer to the checklist below: 

Check the employee ID

  1. Start with employee files, make sure their numbers have a maximum of 7 digits.
  2. All Employee ID must be in one or the other of these two formats: 
  3. Without zeros: 23
  4. Or with zeros: 0000023

Check the timesheets

  1. Make sure employee timesheets are approved.
  2. No unapproved information can be processed by the export.

Check the configuration of the Payroll section

  1. In Pay > Export pay,
  2. Make sure you have the right payroll company, 
  3. Confirm that the correct pay period is selected,
  4. Check if the payroll service is Sage,
  5. Check the 3-digit branch number. This is usually three digits, eg.: 003 or 316.
  6. Confirm the pay week to export (Week 1 or Week 2).

Check the configuration of the shortcut to the Sage "Punches" directory

  1. Make sure the shortcut to the Sage punch directory is listed:    \\J0xxxFPC10\sageges$\punktel 
    1. The xxx in the shortcut must be replaced by the number of your branch
This must be done by you, because it must be connected to the PJC network to access this directory.
CentreRx removes access to the PJC network when it allows an external user to connect to the network computer, which prevents us, Emprez, from completing this verification with you.

Make sure the export file is named correctly

  1. The export file should always be named POIN01.DBF
  2. Check for duplicates, delete if there are any
  3. Delete the additional digits after POIN01 eg.: POIN01(8).DBF, POIN01(7).DBF, POIN01(6).DBF
The file will not be read if the file has the wrong name.


    • Related Articles

    • Pay anticipation

      There may be times when you want to anticipate payroll when you go on vacation, or if your payroll service closes during vacations such as the holidays. Anticipating payroll means you can pay employees on the future schedule, even if they haven't ...

    • First pay with the web service

      Generate your first pay with the Web Service For your first payroll transmission to your payroll system (Desjardins/Nethris), please follow the following steps: 1. Make sure all timesheets are approved Go to the Timesheets menu, Then, in the current ...

    • Import of pay slips

      Use Emprez to import pay slips from your payroll department, and distribute them to your employees. They will have access to these documents from the mobile application or the employee portal. This functionality is optimized for Web Service users. ...

    • Configuration of the Export section in the Pay menu

      Emprez allows you to export your employee's remuneration data to the payroll service of your choice. Depending on the service selected, the generated export file will allow you to fill in the necessary fields of your payroll service, allowing you to ...

    • Payroll information retrieval and employee update

      Emprez is also able to read and update salary information if your web service is activated. You can have the Web Service, available for Desjardins (Employer D) and Nethris by activating it yourself: Web Service Activation for your company You can ...