OOo Spreadsheet for Canadian Payroll Tax

[Neil Williams]

On Saturday 21 May 2005 7:18 pm, Michael D. Crawford wrote:
> Because Gnucash is not yet able to automatically calculate payroll tax
> withholding

It probably shouldn't take on payroll directly - that's why it's important to 
make the GnuCash data available to other processes more easily.

> , 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":

How do you get your GnuCash data into the spreadsheet?

I always intended to look at getting the new XML backend for GnuCash (via QOF) 
to be importable by OOo and other programs like GNumeric but it has slipped 
down the ToDo list.
:-(

We could work together on this if you like. I can organise sample XML code 
until G2 is available, see if we can't work out how to import live data.

> 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.

Absolutely.

How do you propose to keep the tables updated with each budget?

> 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.

That's where the nightmare begins. Extend that to the UK, France, Germany and 
beyond to GnuCash users elsewhere and you've opened a can of worms!

-- 

Neil Williams
=============
http://www.data-freedom.org/
http://www.nosoftwarepatents.com/
http://www.linux.codehelp.co.uk/

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
Url : http://lists.gnucash.org/pipermail/gnucash-user/attachments/20050521/46485fd6/attachment.bin