Importing payroll information

[R. Victor Klassen]

After what feels like an extensive search I found some information on importing payroll information, which appears to be for importing pay check/cheque information into a personal file.

What I need to do is import payroll information into a business account.  In essence, since GnuCash doesn’t directly handle payroll, and I’ve done it manually for a year, I’m thinking of increasing the level of automation, and would like to generate what will be imported happily by GnuCash into a split transaction for each of the payroll cheques I generate.  

I tried putting a sample transaction in a dummy file, and exporting it as CSV, but as far as I can tell, GnuCash doesn’t import a CSV file that it exports, at least not that file.

A “typical” transaction might look like:

2014-01-09	1003	Barb Aloot	
					Pay period ending 08-Jan-2013
			2002	Gross wages for 31 hour		Expenses:Payroll:Wages		345.00
			3001	Employer contribution to WSIB	Expenses:Payroll:Wages		12.94
			4001	Employer contribution to CPP		Expenses:Payroll:Wages		20.45
			…
			8001	Total payable to CPP	Liabilities:Accounts Payable:CPP Payable		40.90
			1003	Net Pay		Assets:Current Assets:Chequing Account		294.75



My guess is that CSV import does not support a split like this?  If so, am I best off generating QIF or something else?  Does someone have a sample of a valid importable file (any importable format) that is close to what I’m doing?