Balance Category Eligibility for Initialization and Adjustment for the US
There are four categories of balances eligibile for initialization and adjustment. Each has its own adjustment requirements.
-
Legislative balances
- User-defined balances
-
Summary-level balances
-
Miscellaneous balances
For further info, see US Legislative Balances in the Help Center.
When identifying these balances, consider the following.
Issue |
Considerations |
---|---|
Overtime balances |
For example, for a payroll run using these dates:
You would calculate the following for the overlapping payroll start date and overtime period start and end dates.
|
Associated hours balances |
|
Inception-to-date balances |
When initializing Inception-to-Date balances, the payroll you reference in the batch must:
The process attempts to create a balance initialization in the previous year. The process goes as far back as required to distinguish between the dimensions in the batch. For example, if the batch contains only a period-to-date (PTD) and an inception-to-date (ITD), it must go back only as far as the beginning of an earlier period to be able to satisfy the rows written. However, if there are YTD and ITD lines, it uses the first day in the year for YTD and then looks for a day earlier than that to set the ITD. |
Year to Date dimension |
All dimension names refer only to the "Year to Date" dimension. You may need to load other periods, such as "Quarter to Date" or "Period to Date". The additional dimensions required depend on when you perform the upload activity takes place and your specific requirementsneeds of the customer. |
Relationship dimension |
All dimension names refer to the "Relationship" dimension, establishing a connection with the payroll relationship. Assignment-level dimensions may also be required, depending on the level of the element. |
Dimension eligibility |
In many cases, some dimensions are valid only for specific levels of balances, such as state and local-level taxes. For example, the City Gross balance has the "Relationship Area1,2,3 Year to Date" dimension. It requires this dimension because the Geography area codes 1, 2, and 3 accompanying it identify the jurisdiction to which the balance relates. Here's a breakdown of what the different areas represent in this case.
Based on this info, the combination of area codes 39 (Area1), 101 (Area2), and 3000 (Area3) refer to Philadelphia, Pennsylvania. For further info, see Geography Area Codes for the US in the Help Center. |
Employment model |
The payroll process calculates taxes at the relationship level, so it requires initialization of dimensions at this level. However, if you defined other elements at the assignment level, you must initialize dimensions at that level. |