Atrieve Payroll

Storage Bank Control

The Storage Bank Control is used to define storage banks for accumulation or calculation of items such as holiday pay or sick leave. The storage bank code supplies an accumulation or calculation definition (storage bank type) also with default values for definition of individual storage bank tables. Each storage bank must have at least one storage bank table defined. Any number of storage bank tables using various percentages or amounts per storage bank table may be defined.

The first three prompts apply to All storage bank types

Bank Code

  • Enter a 2-digit storage bank code from 01 through to 99.

Description

  • Enter up to 30 characters of description for this storage bank.

Bank Type

The Bank Type defines how the storage bank will calculate, accumulate or pay out. This field cannot be changed once a storage bank is established.

  • A = Accrual           A percentage of eligible earnings and/or hours is deposited during the payroll run.

  • I = Increment        A fixed increment amount can be deposited into the storage bank during payroll run.

  • P = Pay Bank        This type of bank does not store values.  A Pay Bank can pay out a percentage of eligible earnings or flat amount in the current pay period. A custom Pay Bank setup can also be used to enforce gross pay, which traps and reverses out pennies to ensure a zero gross pay.

  • D = Days Bank      This storage bank will calculate and accumulate the number of working days (taken from the payroll calendar) for an employee. This bank is primarily used by the ATRF (Alberta Teachers Retirement) system. When active, the percentage employed will be applied to reduce the stored working days per pay period. An employee may have multiple Days banks if needed, as the Days bank used by the ATRF system should never be adjusted.

  • G = Global Bank   A global storage bank can be used to extract a portion of the employees accrual/increment for deposit into this pool bank.

  • S = Deduction Bank A deduction storage bank can be used to copy an employee's current deduction amounts into a storage bank. This storage bank is intended to accumulate employee's savings for future payout. Having the amount accumulated under a storage bank allow for reporting and displaying of the value on the earning statements.

Multiple Tables

This field applies to all storage bank types and only appears on the storage bank controls.

  • Enter 'Y' to allow an employee to have more than one storage bank table under this specific storage bank.

  • Enter 'N' to restrict an employee to have only one storage bank table under this specific storage bank.

All other fields on the storage banks are defaults only. Values defined here will be used as defaults during storage bank table additions. Calculations of all storage banks will take the values as defined on each storage bank table. These default fields are optional.

Accrual Storage Bank

Transactions

  • Enter 'H' to accumulate hourly totals.

  • Enter 'E' to accumulate earnings totals.

  • Enter 'HE' or 'EH' to accumulate both hours and earnings totals.

Bank Cycle 

Leave the storage bank cycle code blank when the storage bank is to be calculated whenever eligible hours/earnings are available.

  • Enter a default storage bank cycle code which will control when the storage bank will be calculated.

Rollover Bank

  • Enter a default rollover storage bank code. When a storage bank is cleared the values can be rolled into another storage bank. When left blank the clearing will zero the storage banks balances.

The rollover process takes place before the calculation of storage banks for the period defined by the clearing.

Pay Out Pay Code

Accrual earnings can be set to be paid out. Enter a default pay code to be used when the storage bank earnings are to be paid out.

Pay Out Pay Accrual  

When an earnings storage bank has been defined to be paid out, should that pay out pay periods accrued earnings also be paid out?  The 'pay out period' being the payroll calendar pay period where the storage bank is defined to be paid out.

  • Enter 'Y' to include the payout pay periods accrued earnings.  Include the storage bank amount calculated on that pay out period or just up to the beginning of that pay out period.

  • Enter 'N' to storage the payout pay periods accrued earnings and only pay out the earnings up to that pay period.

Pay Out Negatives     

  • Enter 'N' to block negative balances from being paid out / recouped.

  • Enter 'Y' to pay out negative earnings which will reduce the employee's cheque.

GL Liability Account         

Accrual earnings can be setup to be costed at the time of deposit.

  • Enter a default liability GL account if the accrual earnings are to be costed. Refer to the banking phase of the cost center database if costing is to be done.

Accrual Hours

When the storage bank has a bank type which includes 'H'ours enter the pay codes which are to be included or excluded in the hours accrual calculation.

  • Enter I/##,##,##, where the ## are the pay codes to be included as eligible hours for this storage bank calculation.
    or   (if the list is shorter):

  • Enter E/##,##,##, where the ## are the pay codes to be excluded from the hours calculation, all other pay codes will be included.

Accrual Earns

When the storage bank has a bank type which includes 'E'arnings enter the pay codes which are to be included or excluded in the earnings accrual calculation.

  • Enter I/##,##,##, where the ## are the pay codes to be included as eligible earnings for this storage bank calculation.
    or (if the list is shorter):

  • Enter E/##,##,##, where the ## are the pay codes to be excluded from the earnings calculation, all other pay codes will be included.

Hours Bank Limit

  • Enter a default hours bank limit. The storage bank limit controls the maximum hours to be accrued. The limit does not relate to timesheet entry bank deposits.

Zero limit implies no limit has been applied.

Earnings Bank Limit  

  • Enter a default earnings bank limit. The storage bank limit controls the maximum earnings to be stored. The limit does not relate to timesheet entry bank deposits.

Zero limit implies no limit has been applied.

Print Balances

  • Enter 'Y' if the storage bank balance is to appear on the cheque and/or earnings statement. Suspended storage banks will not be included.

  • Enter 'N' to block the printing of the storage bank balance.

  • Enter 'S' if the storage bank balance is to be printed even if the storage bank is suspended.

Negative Balance

  • Enter 'Y' if a storage bank can go negative during storage bank withdrawal.

  • Enter 'N' if a storage bank is not allowed to go negative due to storage bank withdrawals. During timesheet entry you will be prevented from doing storage bank withdrawals if the results will generate a negative balance.

  • Enter 'W' if you want a warning message displayed during timesheet entry when a storage bank withdrawal will cause the storage bank to go negative.

The negative balance control will also be applied to negative storage bank deposits. NOTE: Refer to Negative Balance documentation under the Storage Bank Table introduction documentation.

Pool Bank Code/Table

  • Enter the global pool bank code followed by the global bank table code.

This prompt provides the ability to extract a portion of each employee's storage bank increment or accrual and allocate the amount to the global storage bank. The common application of this option is in situations where each employee contributes a percentage of their sick leave to a central sick leave. This is most common in union contract and normally this type of bank is managed by the union and requests for access to the poll benefits are made to the union.

Pool Bank Limit    

  • Enter 'N' to indicate the global pool bank will not regard the storage bank limit on this storage bank. The global pool bank continues to receive an increment/accrual percentage after the employee has reached the bank limit.

  • Enter 'Y' to indicate the global pool bank should regard the storage bank limit on this storage bank. The global pool bank will not receive an increase once an employee's bank limit has been reached.

Pool Bank %

  • Enter a default percentage of the employee's allocation which is to be contributed to the global pool bank. This amount is deducted from the employee's allocation and is transferred to the storage bank number identified in the pool bank code field.

  • Enter 20.0000 for take 20%.

Multiple Tables     

  • Enter 'Y' to allow an employee to have more than one storage bank table under this specific storage bank.

  • Enter 'N' to restrict an employee to have only one storage bank table under this specific storage bank.

Year Limit STR Period

  • Enter the starting pay period for a range of pay periods to define a year for use with the Year Accr Limiting feature. On each bank table you can define a total number of hours/earnings that can be accrued (accrual or increment entries only) for a given year, with the year being defined by this range of pay periods.

Year Limit End Period

  • Enter the ending pay period for a range of pay periods to define a year for use with the Year Accr Limiting feature.

Increment Storage Bank

Transactions

  • Enter 'H' to accumulate hourly totals.

  • Enter 'E' to accumulate earnings totals.

  • Enter 'HE' or 'EH' to accumulate both hours and earnings totals.

Bank Cycle

Leave the storage bank cycle code blank when the storage bank is to be calculated when ever eligible hours/earnings are available.

  • Enter a default storage bank cycle code which will control when the storage bank will be calculated.

Rollover Bank

  • Enter a default rollover storage bank code. When a storage bank is cleared the values can be rolled into another storage bank. Left blank and the rollover will drop the storage banks balances.

The rollover process takes place before the calculation of storage banks for the period defined by the clearing.

Increment by %

Increment storage banks normally give every employee in the payroll run the full increment. This option provides the ability to give a prorated portion of the increment to employees based on either the number of hours worked for a pay period compared against a base hour's value or based on the employee's function line FTE. For FTEs the Percentage Employed feature must be active and FTE only applies to pay types Fixed, Salaried, Annual and Contract.

  • Enter 'Y' if you want the increment prorated based on the number of hours worked per period compared to a base hour

  • Enter 'F' to indicate the increment should be prorated based on the employee's combined FTE for all active function lines.

  • Enter 'M' to indicate the increment should be prorated based on the employee's master function lines FTE.

  • Enter 'N' to give the increment regardless of the number of hours worked.

%Hour Base Hours

When increment by % of hours has been selected, you must provide the total number of hours that represents the base. these hours are used to calculate a percentage. The employee's hours of work are compared to the base hours and the percentage the employee has worked is calculated. This percentage is then used to adjust the full increment.

All/Paid Employees

  • Enter 'A' if the storage bank value is to be given to all active employees.

  • Enter 'P' if the storage bank value is to be given only to employees who received pay in the payroll run.

Accrual Hours

When the storage bank has been set to prorate the increment based on hours worked, the pay codes listed here are for defining eligible hours.

  • Enter I/##,##,##, where the ## are the pay codes to be included as eligible hours for this storage bank calculation.
    or (if the list is shorter):

  • Enter E/##,##,##, where the ## are the pay codes to be excluded from the hours calculation, all other pay codes will be included.

Hours Bank Limit

  • Enter a default hours bank limit. The storage bank limit controls the maximum hours to be stored. The limit does not relate to timesheet entry storage bank deposits.

  • Zero limit implies no limit has been applied.

Earnings Bank Limit

  • Enter a default earnings bank limit. The storage bank limit controls the maximum earnings to be stored. The limit does not relate to timesheet entry storage bank deposits.

  • Zero limit implies no limit has been applied.

Print Balances

  • Enter 'Y' if the storage bank balance is to appear on the cheque and/or earnings statement. Suspended storage banks will not be included.

  • Enter 'N' to block the printing of the storage bank balance.

  • Enter 'S' if the storage bank balance is to be printed even if the storage bank is suspended.

Negative Balance

  • Enter 'Y' is a storage bank can go negative during storage bank withdrawal.

  • Enter 'N' if a storage bank is not allowed to go negative due to storage bank withdrawals. During timesheet entry you will be prevented from doing storage bank withdrawals if the results will generate a negative balance.

  • Enter 'W' if you want a warning message displayed during timesheet entry when a storage bank withdrawal will cause the storage bank to go negative.

The negative balance control will also be applied to negative storage bank deposits. NOTE: Refer to Negative Balance documentation under the Storage Bank Table introduction documentation.

Pool Bank Code/Table

  • Enter the global pool bank code followed by the global bank table code.

This prompt provides the ability to extract a portion of each employee's storage bank increment or accrual and allocate the amount to the global storage bank. The common application of this option is in situations where each employee contributes a percentage of their sick leave to a central sick leave. This is most common in union contract and normally this type of storage bank is managed by the union and requests for access to the poll benefits are made to the union.

Pool Bank Limit

  • Enter 'N' to indicate the global pool bank will not regard the storage bank limit on this storage bank. The global pool bank will continue to receive an increment/accrual percentage after the employee has reached the storage bank limit.

  • Enter 'Y' to indicate the global pool bank should regard the storage bank limit on this storage bank. The global pool bank will not receive an increase once an employee's storage bank limit has been reached.

Pool Bank %

  • Enter a default percentage of the employee's allocation which is to be contributed to the global pool bank. This amount is deducted from the employee's allocation and is transferred to the storage bank number identified in the pool bank code field.

  • Enter 20.0000 for take 20%.

Multiple Tables

  • Enter 'Y' to allow an employee to have more than one storage bank table under this specific storage bank.

  • Enter 'N' to restrict an employee to have only one storage bank table under this specific storage bank.

Year Limit STR Period

  • Enter the starting pay period for a range of pay periods to define a year for use with the Year Accr Limiting feature. On each bank table you can define a total number of hours/earnings that can be accrued (accrual or increment entries only) for a given year, with the year being defined by this range of pay periods.

Year Limit End Period

  • Enter the ending pay period for a range of pay periods to define a year for use with the Year Accr Limiting feature.

One Increment per Table

  • Enter 'N', which is the default, to have the storage bank increment based on the bank cycle code defined on the storage bank table code.

  • Enter 'Y' to indicate this increment bank should only allow one increment per table level. When the increment bank table is active the system will look for a storage bank history entry of type IN, EJ or CE. When a history entry with one of these codes already exists for the employee's current storage bank table the increment will be omitted. Note: the system treats an employee's bank table as Suspended when no increment is applicable so for printing purposes this setting requires the option to print suspended bank tables.

The purpose of this setting is to allow a storage bank to be setup where the employee will receive one increment per table entry as the employee increments up through the tables of the storage bank. An example of this is for Supplementary Vacation where an employee gets an extra week of vacation every five years. Once the employee received an increment on the bank table level no further increments would take place until the employee moved up a level to a new bank table.

Pay Bank Storage Bank

Transactions

  • Enter 'E'. A pay bank can only pay out earnings.

Bank Cycle

  • Leave the storage bank cycle code blank when the pay bank is to be calculated when ever eligible hours/earnings are available.

Enter a default storage bank cycle code which will control when the pay bank will be calculated.

Pay Code

Enter a default pay code to be used for paying of the calculated pay bank earnings.

Multiple Tables 

  • Enter 'Y' to allow an employee to have more than one storage bank table under this specific storage bank.

  • Enter 'N' to restrict an employee to have only one storage bank table under this specific storage bank.

Accrual Earns

  • Enter a default list of pay codes to include or exclude for determining the eligible earnings.

  • Enter I/##,##,##, where the ## are the pay codes to be included as eligible earnings for this pay bank calculation.
    or (if the list is shorter):

  • Enter E/##,##,##, where the ## are the pay codes to be excluded from the earnings calculation, all other pay codes will be included.

Days Storage Bank

Transactions 

  • Enter 'H'. A day's storage bank can only store hours.

Bank Cycle 

Leave the storage bank cycle code blank when the storage bank is to be calculated when ever eligible hours/earnings are available.

  • Enter a default storage bank cycle code which will control when the storage bank will be calculated.

Rollover Bank

  • Enter a default rollover storage bank code. When a storage bank is cleared the values can be rolled into another storage bank. Left blank and the rollover will drop the storage banks balances.

The rollover process takes place before the calculation of storage banks for the period defined by the clearing.

Multiple Tables

  • Enter 'Y' to allow an employee to have more than one storage bank table under this specific storage bank.

  • Enter 'N' to restrict an employee to have only one storage bank table under this specific storage bank.

Hours Bank Limit         

  • Enter a default hours bank limit. The storage bank limit controls the maximum hours to be stored. The limit does not relate to timesheet entry storage bank deposits. Zero limit implies no limit has been applied.

All/Paid Employees

  • Enter 'A' if the storage bank value is to be given to all active employees.

  • Enter 'P' if the storage bank value is to be given only to employees who received pay in the payroll run.

Print Balances

  • Enter 'Y' if the storage bank balance is to appear on the cheque and/or earnings statement. Suspended storage banks will not be included.

  • Enter 'N' to block the printing of the storage bank balance.

  • Enter 'S' to print the storage bank balance even if suspended.

Negative Balance

  • Enter 'Y' if a storage bank can go negative during storage bank withdrawal.

  • Enter 'N' if a storage bank is not allowed to go negative due to storage bank withdrawals. During timesheet entry you will be prevented from doing storage bank withdrawals if the results will generate a negative balance.

  • Enter 'W' if you want a warning message displayed during timesheet entry when a storage bank withdrawal will cause the storage bank to go negative.

The negative balance control will also be applied to negative storage bank deposits. NOTE: Refer to Negative Balance documentation under the Storage Bank Table introduction documentation.

Global Storage Bank

Transactions 

  • Enter 'H' to accumulate hourly totals.

  • Enter 'E' to accumulate earnings totals.

  • Enter 'HE' or 'EH' to accumulate both hours and earnings totals.

Print Balances

  • Enter 'Y' if the storage bank balance is to appear on the cheque and/or earnings statement. Suspended storage banks will not be included.

  • Enter 'N' to block the printing of the storage bank balance.

  • Enter 'S' if the storage bank balance is to be printed even if the storage bank is suspended.

Negative Balance

  • Enter 'Y' if a storage bank can go negative during storage bank withdrawal.

  • Enter 'N' if a storage bank is not allowed to go negative due to storage bank withdrawals. During timesheet entry you will be prevented from doing storage bank withdrawals if the results will generate a negative balance.

  • Enter 'W' if you want a warning message displayed during timesheet entry when a storage bank withdrawal will cause the storage bank to go negative.

The negative balance control will also be applied to negative storage bank deposits. NOTE: Refer to Negative Balance documentation under the Storage Bank Table introduction documentation.

Multiple Tables       

  • Enter 'Y' to allow an employee to have more than one storage bank table under this specific storage bank.

  • Enter 'N' to restrict an employee to have only one storage bank table under this specific storage bank.

Deduction Storage Bank

Transactions

Only 'E'arnings is applicable.

Print Balances  

  • Enter 'Y' if the storage bank balance is to appear on the cheque and/or earnings statement. Suspended storage banks will not be included.

  • Enter 'N' to block the printing of the storage bank balance.

  • Enter 'S' if the storage bank balance is to be printed even if the storage bank is suspended.

Deduction List

  • Enter a default list of deduction codes to include or exclude for determining the eligible earnings.

  • Enter I/##,##,##, where the ## are the deduction codes to be included as eligible earnings for this bank.
    or (if the list is shorter):

  • Enter E/##,##,##, where the ## are the deductions codes to be excluded from the earnings calculation, all other deduction codes will be included.