Employee list

Question

Is it possible to extract a list of employees that includes their department per the analysis tab? 
 
 I thought that I would just be able to download the employee list to Excel, but this isn't an option.

John Howells · Answer

Hi David, 
 Thanks for using Community Hub 
 You could use Data Export to get this in Excel. 
 
 Select the employees to include on your employee list. 
 Click File then Data Export . 
 Click Payroll Data Export then click Next . 
 Select Employee Details then click Next . 
 Click Browse to set where you'd like to save the file and enter a filename. 
 Click Save , then Next . 
 Click Finish . 
 
 Open the file you exported. You can make the spreadsheet easier to use by deleting all columns you don't need. 
 The department number is under column BV, and you can verify departments and their numbers in your software by clicking Company , Settings then the Analysis tab. 
 If this has answered your question, please click Verify Answer . 
 Regards, 
 John Howells Sage UKI

Sage 50 Payroll

Employee list

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING