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-requ...@gnucash.org wrote:
Date: Sat, 4 Feb 2023 08:23:00 -0700
From: Simon Roberts<si...@dancingcloudservices.com>
To: Gnucash Users<gnucash-user@gnucash.org>
Subject: [GNC] Splitting an imported transaction?
Message-ID:
<cadsqa7iyepresd6wdkhy_2nilu0y812yfyoj2s9l+jfyzvs...@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
_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
