Adding elements to Department analysis gross to net report

SUGGESTED

Hi All, 

 

Not sure if anyone can help with this, but i'd like to add some fields into the departmental analysis gross to net report, this is to enable us to see salary, overtime etc. on the report. I've spoken to a consultant at Sage and they said I can add in 1-30 data fields for pay elements and deductions. I'm struggling with what to do to add these, does anyone know??

 

Help would be greatly appreciated. 

 

Thanks 

  • 0
    SUGGESTED
    I know individually you can go to employee-employee record click on employment and then pay element on the bottom if you click on this you get payment deduction etc each page gives you the chance to chose a payment /deduction name and if you wish for it to be pre tax/Ni or not. Under Employee record you can also see an analysis column that give you the chance to chose what the department analysis and cost centre for each employees are I do it individually as the requirement for each individual member of staff is different . I usually do it as they join the company

    I hope this helps.

    Good luck

    Kereshmeh
  • 0
    Thank you. We do add them in that way for individual employees. What i'm wanting is to show all the pay elements that form gross pay on a gross-net report on one big report for all employees. This is to make it easier when posting the journal as at the minute our accounts team are going through each employees payslips to get the individual pay elements. Current set up in Sage accounts means we can't use the nominal link.

    Thanks
  • 0
    I am sorry I only use the payroll system I know there are several reports (main page) under the reports heading ,under employee heading a few are about cost centre analysis of deduction , payments see if they will be off help .
    Good luck

    Kereshmeh
  • 0
    SUGGESTED

    Hi Toni,

    You can add the variables DeductionAnalysis.Desc1 and DeductionAnalysis.Total1 to the report.

    Then repeat this for numbers 2,3,4 etc up to number 30.  Repeat for PaymentAnalysis in the same way.

    To check which elements the numbers refer to, please go to the main Payroll program > Company > Tasks > Custom Reports > Edit.  Please click here for more information on Custom Report Settings.

    For help with adding variables using Report Designer, please click here.