Scheduled Transactions for Payroll - How to Show Overall Total on Current Account?

Maf. King maf at chilwell.net
Fri Feb 4 16:11:02 EST 2011


On Friday 04 February 2011 20:51:51 Jane Stowe wrote:
> Hi there,
>
> I've set up scheduled transactions for payroll (a separate one for each
> employee) as follows  (where EE is Employee & ER is Employer):
>
>
> Assets:Current Account                                                   EE
> Net Salary
> Expenses:Payroll                      EE Gross Salary
> Liabilities: Tax1
>     EE Tax1
> Liabilities:
> Tax2                                                               EE Tax2
> Liabilities: Tax1
>     ER Tax1
> Expenses: Taxes                     ER Tax1
>
>
> When I do the payroll through the bank, only the overall total for the
> employees salaries shows up on the statement, but currently the individual
> Employee Net Salaries show up on Gnucash with the transactions set as
> above. For reconciling, it would be easier if the overall total was shown
> in Gnucash too, rather than having to count up the net salaries to see if
> it matches the total on the bank statement. Any ideas on how best to do
> this? Would the best way be to create an account as Assets: Undeposited
> Withdrawals & then in the scheduled transactions set the EE Net Salary to
> this account. Then after all the scheduled transactions have run, do a
> transfer from Assets:Undeposited Withdrawals to Assets: Current Account so
> that the total shown on the current account would match the bank statement?
> Or any other ideas? Thanks.

Hi,

Yeah, I think I'd use an intermediate account, so that the salaries go to 
something like Liability:TotalPayroll, rather than Assets:Current, and then 
do a once-a-month transfer between Assets:Current and Liability:TotalPayroll.

Maf.






More information about the gnucash-user mailing list