Summary

This topic describes two methods of obtaining a “Final Pay Upon Death” value for reconciliations.

Grid Report

This method derives the “Final Pay Upon Death” value from data on the employee's Accum (ii) tab.

Important: You must use this method before you close the first pay of the new tax year.

1. Customise the Employees grid to show the following columns:

   Employee Code

   Last Name

   First Names

   Note: Alternatively, you could use Name instead of these two columns.

   Last Paid

   Payment Date

   Final Pay Upon Death.

2. Create an employee query with the following clauses:

   Last paid is greater than or equal to [current YTD start date] (such as 01/07/2010)

   and Last paid is less than or equal to [current YTD end date] (such as 30/06/2011)

   and Final pay upon death is greater than 0.

3. Activate the employee query.
4. Right-click the Employees grid and click Save As | Excel.
5. Save the Excel file in a convenient location.

   Note: PayGlobal will also send a copy to the Local Folders – Outbox.

6. Open the Excel file and apply an AutoSum to the Final Pay Upon Death column.

SQL Query

You would use this method if you had already closed pays in the new tax year or if you doubted the accuracy of the data on the employee's Accum (ii) tab.

Note: If you do not have sufficient access rights or knowledge, then your database administrator may have to complete this task.

1. Copy and paste the following text as a New Query in your SQL Server management tool:

   SELECT TM.EmployeeCode, Sum(TM.FinalPayUponDeath)

   FROM [database name].[dbo].[TransHistoricalMaster] TM

   Join TransPerPaySequence TPPS on TPPS.PaySequence = TM.PaySequence

   where TPPS.YTDCode = 'your YTD code'

   group by TM.EmployeeCode

    

   SELECT Sum(TM.FinalPayUponDeath)

   FROM [database name].[dbo].[TransHistoricalMaster] TM

   Join TransPerPaySequence TPPS on TPPS.PaySequence = TM.PaySequence

   where TPPS.YTDCode = 'your YTD code'

2. Replace the following text with values for your PayGlobal database:

   [database name]

   'your YTD code'

3. Execute the query.
4. SQL will produce two results:
   • Totals per employee (use this list for troubleshooting)
   • Total for all employees.