OOo Spreadsheet for Canadian Payroll Tax
Michael D. Crawford
crawford at goingware.com
Sat May 21 14:18:39 EDT 2005
Friends
Because Gnucash is not yet able to automatically calculate payroll tax
withholding, the other night I worked out The Mother of All Spreadsheets
in OpenOffice to calculate Nova Scotia/Canada Revenue withholding
according to the instructions found in Revenue Canada's booklet T4127
"Payroll Deductions for Computer Programs":
http://www.cra-arc.gc.ca/tax/business/topics/payroll/formulas-e.html
A nice feature of my spreadsheet is that I can fiddle with my gross pay
and the taxes and net pay update instantly, so I can zero in on a
take-home pay that covers the personal bills I need to pay while leaving
as much as possible in the business. Doing that with the withholding
tables is very laborious. I'm pretty sure any self-employed person on
the list will agree with me that this is a nice feature to have.
The spreadsheet does the job so far, but it's not really that good. I
think others would find it helpful if I gave it a good polish and put it
on my website under the GPL. Maybe I can also do the other provinces
and territories at the same time, with one spreadsheet page for each
province.
It even looks up the TD1 exemption by employee name - but it would be
better if it could do so by employee number, in such a way that the
names of my wife and myself weren't hardcoded into it.
I had a much more primitive spreadsheet that calculated IRS and Maine
Revenue withholding, but it wasn't that good and required a lot of
manual fiddling. Now that I finally figured out how to look up the tax
rate in a tax table using the OOo spreadsheet's IF function, I expect I
can make a US version too, but I don't think I'm going to try to cover
all the US states!
Ever Faithful,
Mike
--
Michael D. Crawford
GoingWare Inc. - Expert Software Development and Consulting
http://www.goingware.com
crawford at goingware.com
Tilting at Windmills for a Better Tomorrow.
"I give you this one rule of conduct. Do what you will, but speak
out always. Be shunned, be hated, be ridiculed, be scared,
be in doubt, but don't be gagged."
-- John J. Chapman, "Make a Bonfire of Your Reputations"
http://www.goingware.com/reputation/
More information about the gnucash-user
mailing list