These spreadsheets have embedded 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
- 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.
2013 Budgeting Templates in Excel (updated October 2012)
2013 Budgeting Templates in OpenOffice (updated October 2012)
For 2012 or 2011 Budgeting Tools, please e-mail Ministry and Employment and we'll e-mail the files to you directly.
- 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.)
- 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).
- 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
Treasurer/Administrator website: http://ybrcanada.hewitt.com/uccadmin
- 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.
- 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.
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).