Entering payroll into the payroll module from a journal entry

SOLVED

HI, I am rebuilding a year for a friend, and all she has is the print out of journal entries for the year and the bank statement.  I am doing ok for everything but the payroll

I need to input in the payroll module, but with only the journal entries I can't get any paycheque to work.  Everything works except I am stumped with what I am entering as the CPP Payable and EI Payable, as they calculate the EII Expense and CPP Expense. but can't figure out a formula that works.  I know that the CPP is half of what is the Credit when posting in the payroll module, but how do I figure out what figure I need to multiply the EII by to get the correct figure. 

EX -                           Debit             Credit

5300 Wages         660.96

5310 EII Expense   17.40

5320 CPP Expense 26.05

1070 Chq account                                573.19

2310EII Payable                                     29.83

2320 CPP Payable                                 52.10

2330 Income Tax Payable                     49.29

Parents
  • 0

    I have a quick question about this. I’m new to book keeping and I thought that when you debits and credits that they had to be balanced but when you add up these debits versus credits it’s not balanced. Or Is that just understood that it won’t be balanced for payroll due to deductions? 

Reply
  • 0

    I have a quick question about this. I’m new to book keeping and I thought that when you debits and credits that they had to be balanced but when you add up these debits versus credits it’s not balanced. Or Is that just understood that it won’t be balanced for payroll due to deductions? 

Children
  • 0 in reply to Alaybolt

    You should probably post your own message instead of responding to a 6 year old one that doesn't have anything to do with your issue.  That way you will get better and more timely results.

    Because you have not been clear in your question regarding your specific issue nor which module you are in, I can only suggest that you check out the Report menu on any data entry screen (if available).  It will show you the debits and credits before you post.  They always balance, so I don't know where you are seeing you can post without them balancing.

  • 0 in reply to Alaybolt

    The example above is balanced, as every single entry in Sage is balanced.  You cannot post in sage, unless it is balanced.