Using the general journal for entering payroll

SOLVED


I was searching on the feeds in here about using the general journal to enter payroll. I was told how to do it by a training and was given the accounts to use and I found one from 6 years ago that explained what accounts to use from the chart of accounts and it set up the same way as mine is. I attached a screen shot from the post above showing the accounts and the debits and credits. But when I tally up the debits and credits above they don’t balance. This happens to me as well when I enter the deductions in the general journal for my payroll.  I’m not sure why this occurs unless I’m not debiting and crediting the right accounts. Can some explain this to me or offer some advice. I’m using Sage 50 pro accounting. Not sure if I explained this clearly enough. 

Parents Reply Children
  • 0 in reply to Richard S. Ridings

    Hello, thank you for pointing that out. I completely miss counted. I guess I was getting frustrated and wasn't looking at it clearly. I'm going to attach a picture of what my own looks like and see if you or someone can spot my mistake. I used the payroll calculator from the CRA for the deduction calculations. For tax deductions I combined the federal, provincial and an extra 25$ as requested by the employee. (but It shows 2190 Federal income tax p)

  • 0 in reply to Richard S. Ridings

    Hello, thank you for pointing that out. I completely miss counted. I guess I was getting frustrated and wasn't looking at it clearly. I'm going to attach a picture of what my own looks like and see if you or someone can spot my mistake. I used the payroll calculator from the CRA for the deduction calculations. For tax deductions I combined the federal, provincial and an extra 25$ as requested by the employee. (but It shows 2190 Federal income tax p)

  • 0 in reply to Alaybolt

    Without all the details, I can't tell you if all the numbers are correct.  However, I can calculate the EI applicable on the journal entry and I can tell you the information in your journal entry is incorrect.

    So either you are entering the information into the PDOC incorrectly or reading the supplied Combined Result improperly or you are just calculating the amounts owing by the employer yourself incorrectly.

    $800 * 1.58% (EI rate for 2021) = $12.64

    $12.64 * 1.4 = $17.70 = EI Expense

    $12.64 + $17.70 = $30.34 = EI Payable

    If this is wrong, I would guess other parts are as well.  eg. CPP Payable = 2xCPP Expense in payroll entries because the employer pays what the employee pays.  I calculated $36.26 for $800 biweekly with Claim Code 1 for the employee so that is the expense for the employer.

    See the attached pdf.

    Employee name-(EE & ER)-PDOC-Date paid-2021-01-18.pdf

  • 0 in reply to Richard S. Ridings

    Thank you 

    I will double check the amounts with the CRA payroll calculator. 

  • 0 in reply to Alaybolt

    I figured out my mistake for account 5420 and 5430 I was putting the employee amount not the employer amount.