Payroll beginning balance tasks

Applies To: Microsoft Dynamics AX 2012 R3

If you change from a different payroll system to Microsoft Dynamics AX in the middle of the calendar year, you must enter beginning balances for earnings, deductions, contributions, benefits, and taxes so that you can complete W-2s and other year-end tasks.

This illustration shows what you have to do to enter payroll beginning balances. The numbers correspond to the procedures later in this topic.

This task is part of a bigger process

This illustration shows the relationship between this topic and the overall process of setting up Payroll for the first time.

For an overview of the process, see Setting up payroll: Basic topics.

Prerequisites

The following table shows the prerequisites that must be in place before you start.

For more information on the planning prerequisites, see Setting up payroll: Basic topics.

1. Generate earnings statements and pay statements that have beginning balances

Before you can generate pay statements that have beginning balances, you must manually create an earnings statement for each worker. This earnings statement must have earning lines that match the earning amounts in the previous payroll system as of the worker’s last pay period.

To generate an earnings statement and a pay statement that have beginning balances for a worker, follow these steps:

1. Click Payroll > Common > Earnings statements > Earnings statements.

2. On the Action Pane, click Earnings statement.

3. Select the worker to create an earnings statement for.

4. Select the pay cycle that corresponds with the last pay period for the selected worker.

5. Select the dates that represent the starting and ending dates of the last pay period.

6. Add a line to the statement for each earning code that was represented in the previous system.

   Example

   A worker named William Flemming has earned 30,750 in regular pay so far this year, 4,250 in bonus pay, and 1,299 in commission. He is paid semimonthly. When you create an earnings statement for William Flemming, you add these lines.

   Lines	Fields	Values
   Line 1	Earning code	RegularPay
   	Quantity	1025
   	Unit type	Hourly
   	Rate	30.00
   Line 2	Earning code	Bonus
   	Quantity	1.0000
   	Unit type	Each
   	Rate	4,250.00
   Line 3	Earning code	Commission
   	Quantity	1.0000
   	Unit type	Each
   	Rate	1,299.00

7. In the Line details area, select the Manual check box for each earning code line that you added for the worker.

   重要

   This step is important. Be sure to select the Manual check box for each earnings statement line.

8. On the Action Pane, click Release earnings statement.

9. On the Action Pane, click Pay statement.

10. In the Generate pay statements form, complete these fields, and then click OK.

    Field	Value
    Payment date	Enter the last day of worker’s last pay period.
    Payment run type	Select Manual.
    Disable accounting	Select this check box. 注意 Your payroll transactions were likely recorded in the general ledger of the previous payroll system. To prevent recording these transactions again in Microsoft Dynamics AX, you must select the Disable accounting check box for each pay statement.

11. Repeat these steps for each worker.

2. Update pay statements that have beginning balances for benefits and taxes

After you generate pay statements that have beginning balances, you must verify that the pay statements in Microsoft Dynamics AX reflect accurate payroll data. You must also manually update the benefit and taxes information to match the values in the previous payroll system. After you verify that the amounts from the previous payroll system match the amounts on the Microsoft Dynamics AX pay statements, you must finalize the pay statements in Microsoft Dynamics AX.

To review, update, and then finalize a pay statement, follow these steps:

1. Click Payroll > Common > Pay statements > All pay statements.

2. Select a pay statement to finalize.

3. On the Action Pane, click Edit.

4. Review the earning lines on the pay statement to make sure that the lines match the worker’s information in the previous payroll system.

5. Click the Benefit calculations link.

6. On the Benefit deductions FastTab, add a line and enter a deduction amount for each benefit deduction. The amounts should match the worker’s deduction amounts in the previous payroll system.

7. On the Benefit contributions FastTab, add a line and enter a contribution amount for each benefit contribution. The amounts should match the worker’s contribution amounts in the previous payroll system.

8. Click the Tax calculations link.

9. On the Tax deductions FastTab, add a line and enter a deduction amount for each tax deduction. The amounts should match the worker’s deduction amounts in the previous payroll system.

10. On the Tax contributions FastTab, add a line and enter a contribution amount for each tax contribution. The amounts should match the worker’s contribution amounts in the previous payroll system.

11. On the message bar, click Finalize.

3. If required: Reverse pay statements

If you finalized a pay statement in Microsoft Dynamics AX and you later notice that the pay statement does not match the payroll amounts in the previous system, you can reverse the pay statement. You then have to generate a new pay statement for the worker.

To reverse a pay statement, follow these steps:

1. Click Payroll > Common > Pay statements > All pay statements.

2. Select the pay statement to reverse.

3. On the Action Pane, click Edit.

4. On the Action Pane, click Reverse.

After you reverse the pay statement, you can generate a new pay statement for the worker from the earnings statement that you created previously in the “Generate earnings statements and pay statements that have beginning balances” procedure earlier in this topic. Be sure to fix any incorrect lines on the earnings statement before you generate the new pay statement, and then repeat the “Update pay statements that have beginning balances for benefits and taxes” procedure in this topic.

Next step

After you have completed the basic setup of the Payroll module, advanced setup tasks might be required. For more information, see Setting up payroll: Advanced topics.

Related tasks

Generate earnings

Issue worker payments

Technical information for system administrators

If you don't have access to the pages that are used to complete this task, contact your system administrator and provide the information that is shown in the following table.