Importing payroll information

[Derek Atkins]

Hi,

On Thu, January 9, 2014 3:46 pm, R. Victor Klassen wrote:
> 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?

You DEFINITELY would want to use QIF for this, assuming you don't want to
use Scheme or Python to code the import.  but doing it in QIF is pretty
easy.  It's just a standard QIF split transaction.

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
       Derek Atkins                 617-623-3745
       derek at ihtfp.com             www.ihtfp.com
       Computer and Internet Security Consultant