How can I report a list of employee numbers

Wendy_7689800
Wendy_7689800 Member Posts: 49 ✭✭
edited September 2019 in Accounts Hosted
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? 

Comments

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,366 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert
    edited September 2019
    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

     



    Shaz Hughes Dip(Fin) ACQ NSW, MICB

    *** Reckon Accredited Partner (AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! ***

    * Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *

    Accounted 4 Bookkeeping Services

    Ballajura, WA

    shaz@accounted4.com.au

    https://accounted4.com.au

    (NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)
  • Adrian_6974554
    Adrian_6974554 Member Posts: 191 ✭✭
    edited June 2019
    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
  • Wendy_7689800
    Wendy_7689800 Member Posts: 49 ✭✭
    edited April 2019
    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. 

  • Wendy_7689800
    Wendy_7689800 Member Posts: 49 ✭✭
    edited April 2019
    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.
  • Gillian_8166819
    Gillian_8166819 Member Posts: 89
    edited April 2019
    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
  • Gillian_8166819
    Gillian_8166819 Member Posts: 89
    edited April 2019
    haha - I mean a bit hidden :)

  • Gillian_8166819
    Gillian_8166819 Member Posts: 89
    edited April 2019
    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!)
  • Wendy_7689800
    Wendy_7689800 Member Posts: 49 ✭✭
    edited April 2019
    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. 


  • Michelle_9656470
    Michelle_9656470 Member Posts: 31
    edited June 2019
    The same thing happens to me.  
  • Gillian_8166819
    Gillian_8166819 Member Posts: 89
    edited June 2019
    Hi Michelle,

    keep reading below
  • Gil Bryen
    Gil Bryen Member Posts: 2
    edited June 2019
    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
  • glendaveale
    glendaveale Member Posts: 176 ✭✭
    edited June 2019
    Its on the Employment Info tab where you fill in the employment start date, hours
     etc.
  • Gil Bryen
    Gil Bryen Member Posts: 2
    edited June 2019
    Thanks heaps Glenda. Only took a few minutes to rectify with you help.   Cheers
  • glendaveale
    glendaveale Member Posts: 176 ✭✭
    edited June 2019
    Your welcome. Happy to be able to help.