Table of Contents

Reconcile salary accounts and employee balances monthly

Use Account Statement, Payroll Register, and Employee Salary Statement A4L to check balances and movements from posted salary entries. Use the same period and balance type for every month-end close.

Prerequisites

  • The salary entries for the period that you want to check are posted.
  • The balance type and reporting period are defined.

Define the scope of the check

Before running the reports, define:

  • the payroll period;
  • the employee population;
  • the balance type to check;
  • the affected salary types;
  • the expected opening and closing balances.

The available balance types include Various, Vacation, Overtime, Additional Work, Flexible Working Hours, Scheduled Time, Actual Time, Night Work, Loan, and Vacation Pay.

Check balances with the Account Statement

  1. Open the Account Statement report.
  2. Filter by Employee No., department, or allocation group.
  3. Under Type, select the balance to check.
  4. Under Salary Types, narrow down the calculation basis if needed.
  5. Under Choice, select Amount, Quantity, or Days.
  6. Enter Date From and Date To.
  7. If needed, select New Page per Employee and Only Active Employees.
  8. Check the opening balance, movements, and closing balance.
Wichtig

Select a Type and a Choice. Without an unambiguous selection, the report doesn't provide meaningful results.

Check the Payroll Register monthly or annually

The Payroll Register report summarizes salary types by period:

  1. Select a date range, and under Period, select Day, Week, Month, Quarter, or Year.
  2. Decide whether to include Hypothetical Salary Types.
  3. If needed, use up to six additional comparison periods.
  4. Check allowances, deductions, expenses, and employer contributions against the posted runs.

For an employee overview up to the end of a month, use the Employee Salary Statement A4L report. Enter the Year Ending Date. The report can show details or a summary and include or exclude allowances, deductions, expenses, employer contributions, fictitious salary types, and hypothetical source tax.

Trace unusual values

When you find a difference, check:

  1. Is the period identical in all reports?
  2. Did you compare Amount, Quantity, or Days?
  3. Do the salary type and employee filters match?
  4. Are fictitious salary types treated the same way in both reports?
  5. Does the movement come from retroactive processing or an additional run?
  6. Is the relevant payroll run posted?
Hinweis

Report totals can differ when one report shows movements and another shows balances or different salary type categories. First align the filters and report type.

Complete the month-end check

Complete the reconciliation only when:

  • the opening balance plus movements equals the closing balance;
  • unusual amounts, quantities, and days are explained;
  • corrections are entered in the intended journal or payroll process;
  • the filters and reports that you used are documented.

Good to know

  • You run the report without an unambiguous Type and Choice—the results can't be interpreted.
  • You compare unfiltered movement and balance reports—different filters and report types create apparent differences.
  • You correct a value before tracing it to the salary type or employee—you address the wrong cause.

See also