Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Answered

Canadian Payroll - Lump Sum Payment and taxes

Posted on by 185

I'm working with a client who is running GP 18.3 and wanted to get verification the program is working as intended for lump sum payments.

We setup an Income Paycode for Severance pay with a Reference = Lump Sum Payment.  We created a transaction with this pay code for $4000 and calculated the batch.  The tax calculated was $400.  We agree this is the correct amount (10%).

We reviewed the employees previous payroll check which consisted only of hourly pay and made note of the tax amount.

We then created a new batch with the Severance code for $4000 and the employees normal hourly pay code with an amount of $500.  When we calculated the batch, the taxes appear to be much higher than when the pay is processed is a separate batch.  It appears the calculation is taxing the entire $4500 at the normal tax rates.

I saw an article for GP 10.0 which stated the Lump Sum Payments needed to be paid in a separate batch.  I wanted to verify the program is still designed this way, and the user will need to process their Lump Sum entries separately from any other pay.

Thanks - Ron

  • Ron Alexander Profile Picture
    Ron Alexander 185 on at
    RE: Canadian Payroll - Lump Sum Payment and taxes

    Thanks Cheryl - I appreciate the detailed information on how the taxes are calculated in this situation.

  • Verified answer
    RE: Canadian Payroll - Lump Sum Payment and taxes

    Hello,

    Yes, when you process the lump sum amount (Bonus) by itself, it will use the flat amount of 10/20/30% if no other income codes are present.   However, when you process the bonus with other income codes in the same batch, then it uses a different calculation for the taxes, which is also approved by the CRA.  It figures the tax both ways on the bonus and takes the higher of the two, which is most likely why you have seen the higher tax amount in your testing.   This calculation is also an acceptable calculation b the CRA.  Remember that taxes are just an 'estimate' and we calculate the best we can.  Canadian Payroll is flexible too so you can edit the tax amount on the fly too if you wish, but it is an acceptable calculation so you can leave it too.  Otherwise, you would have to process it in a batch by itself if you want the straight 10/20/30 rule.

    Hope that helps.

    Thanks

    Cheryl W

    Microsoft Support  

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,564 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,651 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans