Adding Accrual Balances

The Accrual Balances link in the Maintenance Menu allows for you or a Client level user of an account to manually enter paid leave balances. Normally, this tool will be used to enter existing balances when client is starting an accrual policy in the system.

This tool can also be used after entering the initial balances to add hours to an employee’s balance or even “reset” their balance.
Note: This tool only shows up when an accruals Processing Rule is configured and active.


Who Has Access to the Tool?

This is a tool that only the client level user can access.  Supervisors cannot adjust balances.

The Accrual Balances tool has two options:

Manual Adjustment Method

You can make adjustments "as of" any date in an unfinalize pay period. If you cannot select a certain date, it is because that pay period has been finalized. You will need to unfinalize the pay period to continue.

You cannot adjust balances in a finalized pay period

Setup Options

When using the tool, you will have the following options to set:
  • Employee Filter- This will allow you to choose which employees you view when running the tool.
  • Which category- choose which of your time off categories you want to adjust
  • Choose an effective date for this change- IMPORTANT: This is a critical setting. It establishes on which date the balance is available. Whatever amount you enter for the balances will not be available to the employee until this date. If you are implementing a new accrual system for a client, make sure that this date corresponds with the date on which you have a known and accurate accrual balance for each employee. 
  • Click Show Employees and Balances and you will be taken to a new screen
What Happens If I Put in the Wrong Date?
Bear in mind that if you add balances on the wrong date, you will want to do another adjustment on that same date that reduces the balance by the same amount you added. Changes on multiple dates can be cumulative based on how they are done. For instance, if you add 40 hours on May 1st and then add 40 hours on April 1st, then on May 1st, the employees balance will be 80 hours instead of 40.

Add Balance Screen 

The next screen will show a list of the employees and the balance they have (as of the effective date you entered in the previous screen).  Note: This balance will not show future additions or subtractions to the bucket nor will it show if anyone has adjusted the balance on a future effective date. 

When adjusting balances, each employee's balance "as of the current date" will be displayed
  • Select with the dropdown at the top of the screen to either
    • Add to existing balances will add or subtract to the current balance on the effective date.
    • Change balance, replace any existing balance will wipe out the balances available with a new value as of your effective date.
  • The expiration date of any added balance is optional. 
  • In the amount column, enter the values for each employee
  • Click Save Changes near the bottom of the page.

File Import

  1. If this is your first time using the File Import option, it is recommended to use the DOWNLOAD TEMPLATE* button to create a sample spreadsheet that already has a list of your employees and the necessary columns needed for the import.
  2. Fill out the spreadsheet with the balance for each corresponding category (listed in the column headers). You can also set an expiration for each balance. The amounts entered through this method will "set" the balances to that value on the selected effective date. However, it will not change any balances that existed prior to the effective date, nor will it wipe out any additions/subtractions made prior to this import and effective on a future date.
  3. Save the spreadsheet
  4. Choose the effective date for the balance adjustment. This is the date on which the balances will be added. That means if you set the balance to 20 hours on Sept. 26th, and the employee uses 8 hours on Sept. 25th, they will not have those 20 hours available to satisfy the request. This date can be in the past, but not in a Finalized Period. 
  5. Click the Choose File button and select the spreadsheet from your computer.
  6. Click UPLOAD FILE
  7. If the system finds no errors in your file, it will ask for confirmation of the upload.
*IMPORTANT: If your client uses leading 0s in the Employee Code field, Excel will drop these 0s by default. This will cause problems when you import the balances so you can either use Excel's "Get External Data" options to open this file in a manner that preserves the value of the Employee Code column or manually add the leading 0s.

Did you find this article helpful?