Local Administration

These spreadsheets have imbedded calculations to assist treasurers with budgeting with regard to salary amounts for ministry personnel and lay employees using the current benefits rates.

Using the Budgeting Tools

1. Choose a spreadsheet to download to your computer. Different versions are available depending on what type of computer software you are working with.

   These spreadsheets have two pages. Once you open the link, click on the tab at the bottom of the spreadsheet marked "Premium Calculation" to enter the salary and have the calculations done for you.

   2012 Budgeting Templates in Excel

   • Tools for Treasurers (Lay) [XLS: 62 KB]
   • Tools for Treasurers (Ministry) [XLS: 61 KB]

   2012 Budgeting Templates in OpenOffice

   • Tools for Treasurers (Lay) [ODS: 23 KB]
   • Tools for Treasurers (Ministry) [ODS: 23 KB]

   2011 Budgeting Templates in Excel

   • Tools for Treasurers (Lay) [XLS: 59 KB]
   • Tools for Treasurers (Ministry) [XLS: 61 KB]
   • Monthly Taxable Benefit for Group Insurance [XLS: 61 KB]

   2011 Budgeting Templates in OpenOffice

   • Tools for Treasurers (Lay) [ODS: 38 KB]
   • Tools for Treasurers (Ministry) [ODS: 37 KB]
   • Monthly Taxable Benefit for Group Insurance [ODS: 20 KB]
2. To begin working with the embedded calculations, first save the spreadsheet again with the member number/name in the name of the file. (When you have completed the steps below and are ready to move on to the next member, be sure to go back to the original spreadsheet and resave it named with the next member's name/number.)
3. Input the annual salary in the column labelled Earnings Annual Salary. For lay employees, there is no housing component; for ministry personnel, the housing component is added to each month's amount. Pensionable earnings are then calculated for you under Pensionable Earnings (PE).
4. Check the optional coverage of the member (lay or ministry personnel) on the tables at the foot of the spreadsheet. As the treasurer or payroll administrator, you can confirm coverages with the United Church Benefits Centre either by phone or online:
   United Church Benefits Centre
   Tel: 1-866-859-5025
   Treasurer/Administrator website: http://ybrcanada.hewitt.com/uccadmin
5. If you are in Ontario or Quebec, the taxes need to be added and calculated: Ontario at 8%; Quebec at 9%. Taxes are charged on only group insurance premiums (with some exceptions). Input the tax amount (0.08 or 0.09, as applicable) in the box at the top of the column with the border. If there are two columns for tax, ensure that you put the appropriate value in the correct column, and enter a zero in the other column. If you are not in either Ontario or Quebec, please be sure there are zero (0) values in all tax boxes.
6. There may be a $0.01 discrepancy in some of the calculations due to rounding. This could mean that there is a difference between these calculations and the invoiced totals of less than $1.00.

Questions

If you have any questions about this process, please don't hesitate to contact Ministry and Employment at 1-800-268-3781 (local: 416-231-5931).