how to fix payroll deductions

Fund Accounting, Accounts Payable, Accounts Receivable, Payroll

Moderators: Moderators, Tech Support

Post Reply
kimvdh
Posts: 91
Joined: Wed Oct 13, 2010 7:55 pm

how to fix payroll deductions

Post by kimvdh »

When i ran a balance sheet report, under liabilities the payroll deductions show as a negative $ amount. but they have been paid up to date so i am wondering if i am recording it wrong. We don't use the payroll module yet so i just make an invoice under accnt payable
this is how i have done it for the payment to CRA (the representing amounts)
CR 01-1110 mH checking $xxxx
DB 01-5156-005 CPP mH portion for K $
DB 01-5157-006 EI mH portion for K $
5066-005 CPP mh portion for V $
5067-006 EI mH portion for V $
2215 Taxes deducted from staff $
2216 EI deducted from staff $
2217 CPP deducted from staff $

so since i am not using payroll module shoul i not be using the 22__ numbers? is there another way to account for the extra money on the check to CRA from what i have with held from paychecks? is there a way to also credit those 22 numbers from pay check invoice?
for pay check invoice i do
CR 01-1110 mH checking $
DB 01-5064 SP health $
DB 01-5061 SP salary net $

hope this make some sence!

JohnDMeyers
Posts: 1338
Joined: Sun Oct 07, 2007 9:50 am
Location: Potsdam, NY
Contact:

Re: how to fix payroll deductions

Post by JohnDMeyers »

Take out the health care and other deductions, and look just at the Fed W/H transaction:

$500 Gross Pay
$100 Fed W/H

Would look like this:

Pay Employee
CR 01-1110-000 $500 <-- Use same employee vendor and the net is $400 to employee
DB 01-5067-005 $500 <-- Employee Gross Pay

DB 01-1110-000 $100 <-- Use same employee vendor and the net is $400 to employee
CR 01-2215-000 $100 <-- Fed W/H
-----------------
Pay Fed tax:
CR 01-1110-000 $100 <-- pay Fed tax
DB 01-2215-000 $100 <-- pay Fed tax
You can watch my PowerChurch tutorials now on YouTube!

Visit http://www.youtube.com/user/EmpowerYour ... ture=watch

kimvdh
Posts: 91
Joined: Wed Oct 13, 2010 7:55 pm

Re: how to fix payroll deductions

Post by kimvdh »

the health care is a amount we give him to get his own med plan so it is added on to his salary
so i need to keep it as an item as it shows why his check is more than the gross salary

when I pay fed tax it includes $ that has been deducted from 3 staff(employee portion) and our employer's portion so wont the 01-2215 be out of balance as i am only putting in the $ from emplyee deductions but taking out both employee and employer?

JohnDMeyers
Posts: 1338
Joined: Sun Oct 07, 2007 9:50 am
Location: Potsdam, NY
Contact:

Re: how to fix payroll deductions

Post by JohnDMeyers »

Fed W/H

If 01-2215-000 has a balance of $100, and you owe $50 on top of that, here's what you should do:
CR 01-1110-000 checking $150.00
DB 01-2215-000 Fed W/H liab $100
DB 01-5715-000 Fed W/H employer expense $50
--------------

I would separate out the employee's health adder from the gross wage:
01-5067-005 Employee Gross Pay
01-5110-005 Employee Health Ins Expense
You can watch my PowerChurch tutorials now on YouTube!

Visit http://www.youtube.com/user/EmpowerYour ... ture=watch

Post Reply