Why are the totals different on my remittance summary?

SUGGESTED

I am trying to do the monthly payroll remittance, however, I noticed that the totals are different on my remittance summary in the "Amount" columns and the "Balance" columns. Why is this?

The Amount column is a lesser amount than the Balance column. Which one would be more accurate? How do I go about fixing the issue and making the columns match again?

When I go into payments for remittance as if I were going to record it in the system, it uses the Balance amount. Not sure if this is relevant? 

TIA

  • 0
    SUGGESTED

    HI Ashton, if there is a difference there had to be either an overpayment to CRA or In between payroll runs there was someone that was paid etc.  If you run a detailed remittance report you should be able to find the amounts you are looking for (the difference) and who it is for. Hope that helps.  

  • 0 in reply to Marj@Swab

    Hi Marj@Swab,

    Thank you for your response. I checked the remittance detail and there were no extra pays in between payroll runs, so then I checked the CRA account and turns out there was a slight over payment.

    I'm still unsure of how to correct the issue though. Do I still use the detailed remittance? If so, what am I comparing the numbers to? The Employee detail? I'm sorry, I am new to using Sage50. Thanks for your help!

  • 0 in reply to Ashton D.
    SUGGESTED

    Hi Ashton, if you are sure that you have made an overpayment just reduce your next payment to them and then your remittance will correct itself when you post the payments.  Then you will be back on track.  If you can see the breakdown how much tax, cpp and EI will also be beneficial. 

  • 0 in reply to Marj@Swab

    I'm not entirely sure if it's from the over payment now. I did make a boo-boo and I cancelled a paycheck for an employee from way back in May recently because he lost it. I made up a new cheque, in the same pay period as his previous cheque was and I think the deduction amounts were slightly different since it showed a difference in the cheque amount by a few dollars. I was rushing and didn't catch it until it was too late. 

    It seems this has changed the payroll remittance amounts for every month after that. I can't see the amount column and the balance column on my remittance summary being so greatly different just from a small over payment. 

  • 0 in reply to Ashton D.

    Morning Ashton, when you cancelled the fist cheque it should of backed out everything including the deductions and then would of put back in the new amounts when you re-run the second cheque.  Can you  tell what the difference is after you take that small amount off?  Can you include a screen shot of your remittance?