Download Source Code: TaxCalculator.zip - 14.88KB
| Three open-source implementations of a Canadian Income Tax Calculator for 2008: an Excel spreadsheet, a client-side HTML solution in JavaScript and a server-side implementation in C#/ASP.NET. Last two solutions are also provided as online tools. | ||
Overview
Revenue Canada provides tables with income tax rates for 2008. Both federal income tax and provincial taxes are calculated and applied on different brackets of the total gross income. There is no automatic method to get the full estimate of total taxes to be paid on their web site.
Here is a graph with the total of Canadian federal and provincial income taxes depending on the province (click on the image to get a larger picture). First remark is higher the gross income, higher the tax is. Quebec looks like the province with the highest taxes:
Several tax calculators can be found on the web, but most of them are either too complex or not immediately available online. When all you need is a quick estimate of Canadian federal and provincial taxes for your income, you can use one of our online calculators. There are two online implementations because you may want to use it as a starting point in your own solution for a more complex tax system.
These calculators are provided AS IS and can be used to get a rough estimate of total Canadian income taxes. CPP, taxes on dividends and other deductions are not included here. We make no guarantee the results are fully accurate and tax rates can change in time. To build a more robust and accurate calculator, download the project file and change the parameters with your current values.
Canadian Income Tax Calculator in Excel
Canadian Income Tax Calculator 2008.xls has two spreadsheets. First spreadsheet has a dynamic table with tax rates for 2008, which generates in last columns the total of federal and provincial taxes (as both currency and percent values), as well as the remaining Net Income, for the Gross Income you can enter in the range $1..$10,000,000:

For up to five brackets, intermediate columns $Left and $Tax are dynamically calculated. Sum of $Tax columns for each line represents the total provincial tax for the income. First line gives the Federal tax, which later on is added to each Provincial tax amount.
Second spreadsheet has a table with federal and provincial taxes in each province, for a gross income of $10,000 to $120,000, incremented by $10,000. First image of this page is actually the graph representation of this table, included in Excel.
