How can I report a list of employee numbers

  • 1
  • Question
  • Updated 2 months ago
Setting up for STP, and note that I need to allocate unique employee numbers. Some of our employees already had numbers, some didn't. 
How can I generate a list of employee numbers already used (for both active and inactive employees) to make sure I'm not duplicating numbers? 
I can imagine this is something I'll want to do now, and in the future when onboarding new staff (ie "what's the next number"). 
I've tried adding the employee number to other reports (eg the Employee Contact List), but it refuses to appear. Am I missing something? 
Photo of Wendy

Wendy

  • 648 Points 500 badge 2x thumb

Posted 4 months ago

  • 1
Hi Wendy

Where in the employee record are you entering the employee number?
There is a designated field (now compulsory in RA/RAH) under the "Employee Info" tab:

  

When you add the "Employee No." column to your Employee Contact List report, it will show whatever is entered in this field. 

Shaz Hughes Dip(Fin) ACQ NSW, MICB

Reckon Accredited Professional Partner Bookkeeper / Registered BAS Agent (No: 92314 015)

Accounted 4 Bookkeeping Services

Ballajura, WA

0422 886 003

shazinoz2@bigpond.com

 



Photo of Wendy

Wendy

  • 648 Points 500 badge 2x thumb
This is what I've tried, but it refuses to add into the report. I don't get any extra columns in the report when I tick Employee No. However if I select something else (just for testing) it does appear.
Photo of Michelle

Michelle

  • 462 Points 250 badge 2x thumb
The same thing happens to me.  
Photo of Gillian

Gillian, Accredited Partner

  • 1,476 Points 1k badge 2x thumb
Hi Michelle,

keep reading below
Photo of Adrian

Adrian

  • 3,630 Points 3k badge 2x thumb
Hello Wendy

Reports, Employee Contact List.

Modify the report and add in the Employee No.

Remove fields not required address etc.

Save it as a memorised report.

Adrian
Photo of Wendy

Wendy

  • 648 Points 500 badge 2x thumb
This is what I've tried, but it refuses to add into the report. I don't get any extra columns in the report when I tick Employee No. However if I select something else (just for testing) it does appear. 
Photo of Gillian

Gillian, Accredited Partner

  • 1,476 Points 1k badge 2x thumb
Hi Wendy, 
I feel like the column is a bite hidden. Try again and make sure you expnad all columns by clicking and dragging each diamond to the right
Gillian
Photo of Gillian

Gillian, Accredited Partner

  • 1,476 Points 1k badge 2x thumb
haha - I mean a bit hidden :)
Photo of Gillian

Gillian, Accredited Partner

  • 1,476 Points 1k badge 2x thumb
then you can also sort by Empl no.
So If you are using the employee contact list, modify...untick left margin, tick active status, untick phone, untick address, untick gender and tick Employee No..  Then Click Sort by and select Employee no and then select descending order...... Then click filters tab and click active status, select ALL  - run report - expand the last diamond.

Memorise this report - it will always give you the last/highest number used so you can easily select the next num for your employees. - I would start at say eg 101 so you can go forward from there. - Make sure your employee number in Reckon matches your employee numbers in super clearing house if they are already set up there (so if you upload files all will match!)
Photo of Wendy

Wendy

  • 648 Points 500 badge 2x thumb
Thanks Gillian, you were right, it was hidden. I had expanded it but didn't realise there were two diamonds, with two hidden columns. When I expanded the diamond and got the "gender" column I didn't realise there was another diamond alongside of it. 
Photo of Gil Bryen

Gil Bryen

  • 70 Points
I have also set up my STP process but have tried to unsuccessfully export a pay run file. Only four employees, two with employee numbers and two without. I can't create the file because of the two employees without numbers. Have found the "Employee Number" still exists in the setting up a new employee but cant find where I can add a number to an existing employee. Any help appreciated. Thank you....Gil
Photo of Glenda Veale

Glenda Veale

  • 2,190 Points 2k badge 2x thumb
Its on the Employment Info tab where you fill in the employment start date, hours
 etc.
(Edited)
Photo of Gil Bryen

Gil Bryen

  • 70 Points
Thanks heaps Glenda. Only took a few minutes to rectify with you help.   Cheers
Photo of Glenda Veale

Glenda Veale

  • 2,190 Points 2k badge 2x thumb
Your welcome. Happy to be able to help.