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

[Jane Stowe]

Hi Phil,

sorry it was wrapping....here's it in a grid so should be clearer.

   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

The problem wasn't gross salary from the current account, it was just I'd
like the bank statement total (e.g. 2000) to match against a Gnucash Current
account total, rather than having to add up the individual net salaries
showing up on the Gnucash current account (e.g. 500+500+750+250). The
problem is resolved by using an interim account (e.g. Liabilities:Payroll) &
posting the net salaries to this account rather than the current account &
then transfer the total from Liabilities:Payroll to the Current
account....then it's plain sailing for reconciling...happy days!


On 4 February 2011 22:02, Phil Frost <indigo at bitglue.com> wrote:

> On Fri, Feb 04, 2011 at 08:51:51PM +0000, 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):
> >
> > [...]
> >
> > 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.
>
> I'm having a hard time understanding exactly what you are doing. It
> looks like maybe the lines in your emails are being re-wrapped.
>
> In any case, it sounds like you are crediting your bank account for an
> employee's gross salary, but only their net pay is withdrawn from your
> bank account, because you are witholding taxes.
>
> If this is the case, it is not correct. You should credit the bank
> account for the same amount as the check the employee receives. You
> should debit your salary expense account for each employee's gross pay,
> and the difference between net and gross pay (their deductions) is
> recorded in your liability accounts, which presumably you will later pay
> to some tax authority or payroll company.
>
> Regarding tracking uncashed checks, the simplest way to do this is with
> the "cleared" flag. It's the column of single letters in the register.
> When checks clear, click it and the "n" (not cleared) changes to "c"
> (cleared). The summary bar at the bottom of the register gives you a
> couple different totals for only cleared items, etc.
>