The Proration Utility program generates a spreadsheet which may be used to assist in calculating premium amounts for Worker's Compensation payments.
- Time Period: Select amounts based off the following time periods:
- Fiscal Year to date
- Calendar Year to date
- Month to date
- Account Filter: Select an existing account filter in order to include specific accounts in the spreadsheet. An account filter will need to be created if they do not have one for the accounts they want to prorate (i.e. 1xx object code Expenditure Accounts)
- File Name: Enter the Name of the spreadsheet
- Click on to create the spreadsheet.
Once the spreadsheet is created, you may enter a prorate amount in Column B, which will automatically prorate the amount entered to all of the accounts included in the spreadsheet, automatically calculating the prorate percentage and prorated amount to be charged to each account. You may edit the spreadsheet within the program or download it so it can be pulled into EXCEL. The spreadsheet includes the accounts codes (based off of the account filter entered), account description, the expenditure amount (based off of the time period selected), and the prorate percentage and prorated amount based on the total prorate amount entered in Column B. Accounts will be sorted in order by Full Account Code. Once the spreadsheet is complete, it can be used as a reference when creating your workers compensation requisition or purchase order.