Child pages
  • Proration Utility

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.


Once the spreadsheet is created, you may choose to 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), a default and the prorate percentage that can be modified and the resultant prorated amount based on the total prorate amount entered in Column BOnce  Once the spreadsheet is complete, it can be used as a reference when creating your workers comp compensation requisition or purchase order. 

Image RemovedImage Added