| Import employee timesheet values and divide them between various departments and/or cost centres (Multi-timesheet import) |
Description | If you want to import payment hours or values, but you don't want to allocate these values to specific departments or cost centres, you should use the single timesheet import option. |
Resolution | Enable the multi-timesheet option - Open Sage Payroll and log in to a payroll as normal.
- On the menu bar, click Help then click System Information.
- Click the Data Directory link.
- Locate and open the folder with your company’s payroll name.
- Right-click the file, PAYROLL.INI then click Open with Notepad.
- Edit the [Timesheet] section of the file, to show Sequence=3, AllMulti=1 and add “Type=Multi”. For example:
[Timesheet]
Sequence=3
AllMulti=1 Type=Multi
Random=,,,,
Sequential=,,,,
Automatic=,,,, - Click File, then click Save.
- To close the PAYROLL.INI file, click File then click Exit.
- Repeat steps 4 to 8 for each payroll you want to enable the multi- timesheet option in.
Create a multi-timesheet import file Before you can import payment or deduction information into Sage Payroll, you must prepare a CSV file in the required format. You can import a single CSV file containing both the payment and deduction details, or two separate CSV files (one for payment information and the second for deduction information). You can do this using Microsoft Excel or Windows Notepad. If you're using a time and attendance software, check with your software provider to see if they can create the CSV file for you. They will need to know:
- Your payment and/or deduction numbers - To run this information directly into a Microsoft Excel spreadsheet, follow the steps detailed in this article. You can then email the saved Microsoft Excel spreadsheet to your software provider.
- Your department and cost centre codes - Take a screenshot of the Company/Payroll > Departments window, and the Company/Payroll > Cost Centres window. Then email these images to your software provider.
The CSV file must contain one line per payment/deduction using the following order: Spreadsheet column | Payment information to enter | Deduction information to enter | A | Enter 2. This value tells Sage Payroll that you're importing payment information. | Enter D. This value tells Sage Payroll that you're importing deduction information. | B | Enter the employee's number. | Enter the employee's number. | C | Payment number. | Deduction number. | D | Department code. | | E | Cost centre code. | | F | Hours or value of the payment. | Value of the deduction. | G | Hourly rate. | | NOTE: If you're using Notepad, you must manually separate each piece of data with a comma. Example 1 - To create a CSV file with a hourly payment value You're currently processing period 5 of a weekly payroll and you want to import the following pay details for employee 0241: - 37.5 hours for payment element 2.
- The payment's hourly rate is 11.00.
- This payment should be allocated to department D1 and cost centre C2.
Using Microsoft Excel to create the CSV file | Using Notepad to create the CSV file | The information that appears on both the Microsoft Excel and Notepad files represent the following details: - Using multi-timesheet – 2.
- Employee number – 0241.
- Payment element number – 2.
- Department code – D1.
- Cost centre code – C2.
- Payment hours - 37.5.
- Hourly rate - 11.00.
Example 2 - To create a CSV file with a fixed or variable payment value You're currently processing period 5 of a weekly payroll and you want to import the following pay details for employee 0330: - A value of 250.00 for payment element 3.
- This payment should be allocated to department D1 and cost centre C2.
Using Microsoft Excel to create the CSV file | Using Notepad to create the CSV file | The information that appears on both the Microsoft Excel and Notepad files represent the following details: - Using multi-timesheet – 2.
- Employee number – 0330.
- Payment element number – 3.
- Department code – D1.
- Cost centre code – C2.
- Payment value - 250.00.
- Hourly rate - Not used.
Example 3 - To create a CSV file with a deduction value You're currently processing period 5 of a weekly payroll and you want to import the following deduction details for employee 0001: - A value of 150.00 for deduction number 3.
Using Microsoft Excel to create the CSV file | Using Notepad to create the CSV file | The information that appears on both the Microsoft Excel and Notepad files represent the following details: - Importing deduction values – D.
- Employee number – 0001.
- Deduction number – 3.
- Deduction value - 150.00.
Load the multi-timesheet import file into Sage Payroll Professional of your payroll data, then complete the following steps: - On the menu bar, click Processing then click Time and Pay.
- Next to the File Location box, click browse . Browse to and select the CSV file, then click Open.
- Click Continue.
TIP: Check the Time and Pay - Import window for any errors and warnings. You can't import a timesheet with errors, you must resolve them before proceeding. - To print a list of the data you're about to import, click Print Detailed View.
- Check your printer settings are correct, then click Print.
- To import and save the timesheet values, click Save Time and Pay then click OK.
Common issues and important notes about Multi-timesheet import - If you don't include hourly rates for hourly payments in the CSV file, Sage Payroll uses the hourly rates held in the Payments tab of Employee Details.
- You must use a separate row for each pay element. For example, if an employee has basic and overtime pay, you must use two separate rows.
- If an employee is set as pay type "Hourly", multi timesheet import will not supercede any “Standard Hours” or “Fixed” type payment amounts entered in the Employee Details > Payments tab> This will cause a duplication of those payments on the timesheet import panel i.e. no “Standard hours” or “Fixed” payment amounts should be entered in Employee Details > Payments tab if employee is to be paid by Timesheet import.
- If an employee is set as pay type “Salary” in the Employee Details > Pay/YTD tab, multi timesheet import will not supercede any “Fixed” type payment amounts in the Employee Details > Payments tab, causing a duplication of those payments on the timesheet import panel i.e. no “Fixed” type payment amounts” should be entered in Employee Details > Payments tab if employee is to be paid by Timesheet import.
- You can import as many payments as you want, as long as they're set up in Company/Payroll > Payments.
NOTE: The employee number on the import file must match the exact employee number in Sage Payroll. For example, if the employee is set up in Sage Payroll as number 0054, however is shown on the import file as 54, importing this file will fail to pay the correct employee. - Variable-type payments must have a value in the CSV import file, otherwise no values import for these payments.
- Fixed-type payments, such as salary, are always included in the timesheet import. However, you must reference the employee in the import file for their timesheet to save. To do this, you must either:
- Refer to the employee on the import file, for example, 2,0003. By doing this, you're telling Sage Payroll that employee number 0003 should be included in the import. You don't need to import a value for this employee as the payment's standard amount is already held in the Payments tab of Employee Details.
- Exclude the employee from the timesheet import CSV file and save the employee’s timesheets individually through another pay method – random, sequential or batch
- When you're saving the file, ensure the file type is CSV.
- Don't close the CSV file, until after you have imported it into Sage Payroll Professional.
- Importing the same CSV file twice within a single period will cause duplication of the imported information.
[BCB:202:Limitless - Sage Payroll (Ireland) - Import / Export:ECB] [BCB:22:IE - Sales message :ECB] |
|