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