Importing payroll information

R. Victor Klassen rvklassen at gmail.com
Wed Jan 15 09:14:31 EST 2014


On Jan 13, 2014, at 2:13 PM, Derek Atkins <warlord at MIT.EDU> wrote:

>> Notes:
>> 1) When I import, I get an extraneous semi-blank split entry (0 value, account
>> Chequing Account, memo blank).   I have tried various ways to eliminate that
>> line, as it appears a  blank line with a zero amount on the cheque stub.   Any
>> idea how to eliminate this, other than manually deleting the split line after
>> importing?
> 
> QIF always includes a "default account" which is the "current account"
> of the transaction.  That's the blank split you get..  The only fix is
> to include that in the transaction itself (e.g. the "Net Amount" split).
> And make the default account the Net Amount checking account.  I.e.,
> don't make it a zero-sum transaction in QIF itself; assign part of it to
> the default account.

I was afraid of that.  I have it set up so that the memo fields of the split provide all the needed text to make a pay slip on the stub attached below the cheque.  So it appears that I have the choice of not producing that line when I write the QIF, and then manually typing “Net Pay” in the automatically generated line, or producing it and deleting the line.  Since typing it in requires clicking on the split and then clicking on delete, that is slightly less work (per paycheque) than clicking on the split and typing 7 characters.  And forgetting to do one or the other is about equally likely, so neither one is significantly less error-prone.





More information about the gnucash-user mailing list