The Employer Distribution program generates a worksheet to provide you with dollar amounts for the distribution of board paid deductions to the proper USAS accounts. This option allows the user to run Employer Distribution as many times as desired. The Employer Distribution uses the payroll history files to create the worksheet as specified in the reporting options selected when the program is run.

As long as the payroll you wish to include on the worksheet has been posted through the payroll program, the Employer Distribution can be processed. It does not have to be run at any specific time in the payroll processing sequence since it draws its information from the payroll history files.

Since board shares are paid through USAS, the Employer Distribution needs to know what object code should be charged for a particular Payroll Item. This is done by taking the USAS account from which this employee is being paid and substituting the board object code provided in the CORE/PAYROLL ITEM CONFIGURATION option in place of the employee's object code when the Employer Distribution worksheet is created.

**Note**

Employer Distribution looks for Active or Inactive Position.  If marked as Terminated, it will NOT be included in the report.

If the Object Code used to pay the employee cannot be matched, it will look at the employees 'live' Payroll accounts and find the first active account to charge. Example, employee paid using account 001-1100-115-0000-000000-000-00-000, Employer Distribution Report won't be able to use this account since it's an Object Code of 115 for a Certified employee. it will then look at the next Active Payroll Account for the employee, 467-1930-113-9120-000000-000-00-000 will be charged. 

**If an employee's account used during payroll was marked as 'No" for Employer Distribution and the Employer Distribution Report option "Use Only Employer Distribution Accounts' was marked as 'Yes', it will then look at the employee's Active payroll accounts for an account that is marked as "Employer Distribution" and use this account.

Example:

Open

Open

**If an employee's account, used during payroll, was marked as 'Yes' for Employer distribution and they run the report both ways, 'Yes' or 'No' to "Use Only Employer Distribution Accounts", this employee will be charged the same accounts on both reports.

Example:

The object code for Medicare and other board paid benefits would be different. This is defined on the Core>Payroll Item Configuration>Object Codes area:

Open

If the employee is paid from an object code between 100 and 139 (inclusive), the certified object code will be used to post the board share. The object codes must begin with the number 2xx since board share object codes fall in the 200 series. Typical examples of Payroll Items which will use these object codes are retirement (the board contributes 14%), and Medicare (the board matches the 1.45% paid by the employee).

Certificated object codes:

• 110, 111, 112, 113, 114, 119, 120, 121, 122, 123, 124, 125, 126, 127, 129, 130, 131, and 139

If the employee is paid from an object code between 140 and 169 (inclusive), the classified object code will be used to create a worksheet for the board share amounts.

Non-Certificated object codes

• 140, 141, 142, 143, 144, 149, 150, 151, 152, 153, 154, 155, 156, 157, 159, 160, 161, 169, 170, 171, 172, 179, and 190

Other Object codes

• If the employee is paid from the object code of 17x or 19x or 2xx, the "Other" object code as defined in CORE/PAYROLL ITEMS CONFIGURATION will be used to create the worksheet for the board share. This normally is used for student workers and board members but could affect anyone being paid from an object code outside the 110-169 range.

Once the object code is substituted, Employer Distribution uses the information on the System>Configuration>Account Mapping Configuration to determine what values of the account to carry forward.  Click here for more information regarding Account Mapping Configuration.  After the system has substituted the benefit object code and determined what account dimensions to carry forward, the system looks at the Utilities>Account Mapping.  Once an account matches an Original Account (left side) it is mapped to the Mapped Account (right side).  Click here for more information regarding Account Mapping Configuration. This becomes the final account the system charges.  

The report file created is called Employer Distributions Report.  If the district is in the STRS advance mode, the report will include an additional column which will display advance amounts for 691 deduction records. Grand totals for gross and board amounts are automatically included on the report.

Employer Distributions Report - Expenditure Accounts Invalid For USAS Posting

The Employer Distributions Report will produce an Expenditure Accounts Invalid For USAS Posting for any invalid accounts that are found and will be listed at the end of the Report Totals:

• Expenditure Account is not active

  • Go to USAS and update the account to be active and then use ‘USAS Account Synchronization’ to resynch accounts

• Expenditure Account not found

  • Mapping can be used to enter Account not found to an Account that is active in USAS to the correct account.

Open

Generate Report

Open

Field Definitions

• The default report file name is Employer Distributions Report.  The text file name cannot be changed.

• Select the Report Format

  • PDF (download)

  • Comma Separated Values (CSV)

  • Excel

• Enter Start Date is First Pay Date and End Date is the Last Pay Date. This field is mandatory.

• The Pay Cycle field offers the following choices: 

  • None

  • P - Every payroll

  • M - Monthly

  • Q - Quarterly

  • A - Annually

  • 1 - 9 - User defined cycles

• Sort Options:

  • Payroll Item Code - by selecting this sort option, Payroll Item Code Totals will show at the bottom of the report:

  • Open

    

  • Account Code

• Subtotal Options:

  • Payroll Item Code

  • Account Code

  • Fund

  • Function

• Do you want to use only those pay accounts flagged in CORE/PAY ACCOUNTS as being an Employer Distribution Accounts?

• From the drop-down boxes, select the Available Payroll Items and move them to the Selected Payroll Items box 

  Open

  

  .  If no Payroll Items are selected, then all available items will pull into the report:

  • Open

    

Click on 

Employer Distributions Report - Summarize By Account Code

Report Sorted By: Account Code