Thanks Chris, I'll try this next time (in May!). I appreciate the guidance.
Cheers, Simon On Sat, Feb 4, 2023 at 10:52 AM Chris Skudder <cskud...@earthlink.net> wrote: > 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. > -- 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.
