[GNC] gnucash-user Digest, Vol 239, Issue 9

[Chris Skudder]

One way is to schedule a transaction to be created before you import the 
bank record. Then match the imported bank record to the scheduled 
transaction. The amounts on payrolls are often pretty consistent from 
one payroll run to the next, so it might match automatically, or you 
might have to select the match manually.

You might also have to edit the created transaction, to exactly match 
the amounts for the current payroll run. But at least you can program in 
the splits with the right GL accounts (with a default amount), 
descriptions, etc. That way at least the transaction is all set up, with 
the possible exception of some minor edits.

Chris

Similar situation -
I'm treasurer of our church, which has 4 employees and pays every 2 
weeks, with the same structure of 2 direct debits - one for what's paid 
to employees and the other for what's deposited to govt tax collection 
accts.
We charge the wages and taxes to 8-10 different GL acct's in our books.
The church is on Quickbooks Online which doesn't offer scheduled 
transactions unless you upgrade + pay them more money - argh.
So when I run payroll, I copy the previous payroll run's transactions 
and edit the amounts to match the current payroll run, change date etc.
The edited transactions match to the bank's record of the direct debits 
when they come in.

------------------------------------------------------------------------

On 2/4/23 11:43, gnucash-user-request at gnucash.org wrote:
> Date: Sat, 4 Feb 2023 08:23:00 -0700
> From: Simon Roberts<simon at dancingcloudservices.com>
> To: Gnucash Users<gnucash-user at gnucash.org>
> Subject: [GNC] Splitting an imported transaction?
> Message-ID:
> 	<CADsQA7iYEPreSD6WdkHY_2NiLu0Y812YFyOj2s9L+jFyZvS3Sw at mail.gmail.com>
> Content-Type: text/plain; charset="UTF-8"
>
> Hi all,
>
> I use a third party organization to run payroll, and they make two
> withdrawals from my bank. One is the amount actually paid to employees (two
> of us 😄 and the other is the sum of taxes collected from those employees,
> plus the employer's tax contributions.
>
> Unsurprisingly, when this imports, from the bank records, it shows as two
> transactions, and the tax stuff is all lumped into a single transaction.
>
> As yet, I've only handled this once and did it wrong anyway (I fixed it up
> by hand OK though). However, in three months it'll happen again so I figure
> if I ask now I could be ready to try to do it right next time.
>
> What I'd like--but suspect might be impossible, is to persuade the import
> operation to create a split to the two accounts (payroll taxes: employer
> and payroll taxes-employee). I'm not so concerned about how the money is
> allocated across the split (there's really no way for the system to know
> what to do about that, after all), but if there's a placeholder, that would
> be a nice start.
>
> Or perhaps there's some other approach that I've not thought of?
>
> What do folks recommend?
>
> Cheers,
> Simon
>
>
> -- Simon Roberts (303) 249 3613