Accrual Balances Import - Revision history

Jeffrey at 20:06, 11 February 2026

2026-02-11T20:06:24Z

2026-02-11T19:54:42Z

2021-02-19T20:48:34Z

2019-05-21T23:31:21Z

2018-05-22T17:33:47Z

2018-03-29T22:06:52Z

2017-06-15T20:47:49Z

2017-04-07T15:39:00Z

2016-05-02T03:30:17Z

2016-05-02T03:28:02Z

@@ Line 25: / Line 25: @@
 | Pay Date
 | Date, Pay Date
-| If the pay date column is not supplied, then the pay date will be the date filled out in the Effective Date field on the options tab of the import window.
+| If the pay date column is not supplied, then the software will automatically use the first unlocked pay date it can find.
 | No

@@ Line 25: / Line 25: @@
 | Pay Date
 | Date, Pay Date
-| If the pay date column is not supplied, then the pay date will be the date following the end date of the latest closed pay period.
+| If the pay date column is not supplied, then the pay date will be the date filled out in the Effective Date field on the options tab of the import window.
 | No

← Older revision		Revision as of 20:48, 19 February 2021
Line 1:		Line 1:
−	The accrual balances import adds or updates the accrual balance or starting balance. If you are using the Accrual Validation module, then it ~~adds~~/updates the accrual balance. If you are using the Accruals module, then it ~~adds~~/updates the starting balance. If there is already a record for the employee (for the same accrual pay type), then it will update the date and the hours on that record. Otherwise, a new record is added.	+	The accrual balances import adds or updates the accrual balance or starting balance. If you are using the Accrual Validation module, then it creates/updates the accrual balance. If you are using the Accruals module, then it creates/updates the starting balance. If there is already a record for the employee (for the same accrual pay type), then it will update the date and the hours on that record. Otherwise, a new record is added.

	An accrual balances import is identified by the sheet name or file name containing the words "Accrual Balances".		An accrual balances import is identified by the sheet name or file name containing the words "Accrual Balances".

@@ Line 18: / Line 18: @@
 |-
 | Accrual Pay Type / Hours
-| Accrual Pay Type ID
+| ''Accrual Pay Type'' ID
 | The column header identifies the accrual pay type. The data in each row represents the starting balance for the accrual pay type. To import into Bank 2, add a " 2" to the column header, e.g. "SICK 2". To import unreleased balances add " Unreleased" to the column header, e.g. "SICK 2 Unreleased".
 | Yes

@@ Line 13: / Line 13: @@
 | Employee ID
 | Employee ID, Emp ID, ID
-| This is used to uniquely identify the employee. Note the distinction with the clock ID, SSN, and Payroll ID fields is the “_”. With a multi-facility configuration you must also provide the Facility column.
+| This is used to uniquely identify the employee. With a multi-facility configuration you must also provide the Facility column.
 | Yes

← Older revision		Revision as of 03:30, 2 May 2016
Line 1:		Line 1:
−	The accrual balances import adds or updates the accrual balance or starting balance. If you are using the Accrual Validation module, then it adds/updates the accrual balance. If you are using the Accruals module, then it adds/updates the starting balance. If there is already a record for the employee (for the same accrual pay type), then it will update the date and the hours on that record. Otherwise, a new record is added. An accrual balances import is identified by the sheet name or file name containing the words "Accrual Balances".	+	The accrual balances import adds or updates the accrual balance or starting balance. If you are using the Accrual Validation module, then it adds/updates the accrual balance. If you are using the Accruals module, then it adds/updates the starting balance. If there is already a record for the employee (for the same accrual pay type), then it will update the date and the hours on that record. Otherwise, a new record is added.
		+
		+	An accrual balances import is identified by the sheet name or file name containing the words "Accrual Balances".

	{\| class="wikitable"		{\| class="wikitable"

← Older revision		Revision as of 03:28, 2 May 2016
Line 1:		Line 1:
−	The accrual balances import adds or updates the accrual balance or starting balance. If you are using the Accrual Validation module, then it adds/updates the accrual balance. If you are using the Accruals module, then it adds/updates the starting balance. If there is already a record for the employee (for the same accrual pay type), then it will update the date and the hours on that record. Otherwise, a new record is added.	+	The accrual balances import adds or updates the accrual balance or starting balance. If you are using the Accrual Validation module, then it adds/updates the accrual balance. If you are using the Accruals module, then it adds/updates the starting balance. If there is already a record for the employee (for the same accrual pay type), then it will update the date and the hours on that record. Otherwise, a new record is added. An accrual balances import is identified by the sheet name or file name containing the words "Accrual Balances".

	{\| class="wikitable"		{\| class="wikitable"