Home Page link  

401K company match contributions

 

QuickBooks Discussion board - Discussions about the popular financial software by Intuit

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
401K company match contributions L 05-10-2007
Posted by L on May 10, 2007, 11:18 am
Please log in for more thread options
I've tried. Really. But I just can't figure out how to set up the company
match to our new 401K 'safe harbor' plan.

Our company will match up to 4% of an employee's wages. If the employee
selects to withhold 1-3%, we match dollar for dollar. At 4% we match 3.5%,
at 5%, we match 4%.

All this I can understand - set up a company match percentage default, and
change it for those who do not take the full 5%.

My confusion is where folks have entered a weekly dollar amount to deduct.

It's obvious to me that if the dollar amount equals or exceeds 5% of the
workers salary, a straight percentage in company match item will work.

But, for amounts that fall UNDER a full 5% of pay, how do I default the
match? What percentage do I enter into the QB company match payroll item?

Must I hand calculate the percentage of salary that the employee's dollar
amount represents - and THEN decide what to enter into company match?

How do I ensure that the amount the company contributes does not exceed the
amount the employee has contributed? If QB will cap the match to the
employee contribution, then I suspect a default of 3% in company match might
work.

Any help would be welcome.



Posted by Allan Martin on May 10, 2007, 12:02 pm
Please log in for more thread options

> I've tried. Really. But I just can't figure out how to set up the company
> match to our new 401K 'safe harbor' plan.
>
> Our company will match up to 4% of an employee's wages. If the employee
> selects to withhold 1-3%, we match dollar for dollar. At 4% we match 3.5%,
> at 5%, we match 4%.
>
> All this I can understand - set up a company match percentage default, and
> change it for those who do not take the full 5%.
>
> My confusion is where folks have entered a weekly dollar amount to deduct.
>
> It's obvious to me that if the dollar amount equals or exceeds 5% of the
> workers salary, a straight percentage in company match item will work.
>
> But, for amounts that fall UNDER a full 5% of pay, how do I default the
> match? What percentage do I enter into the QB company match payroll item?
>
> Must I hand calculate the percentage of salary that the employee's dollar
> amount represents - and THEN decide what to enter into company match?
>
> How do I ensure that the amount the company contributes does not exceed
> the amount the employee has contributed? If QB will cap the match to the
> employee contribution, then I suspect a default of 3% in company match
> might work.
>
> Any help would be welcome.

Request from management that employees should always be required to
stipulate a percentage to defer not a fixed dollar amount.






>
>



Posted by L on May 10, 2007, 1:02 pm
Please log in for more thread options
>
>> I've tried. Really. But I just can't figure out how to set up the company
>> match to our new 401K 'safe harbor' plan.
>>
>> Our company will match up to 4% of an employee's wages. If the employee
>> selects to withhold 1-3%, we match dollar for dollar. At 4% we match
>> 3.5%, at 5%, we match 4%.
>>
>> All this I can understand - set up a company match percentage default,
>> and change it for those who do not take the full 5%.
>>
>> My confusion is where folks have entered a weekly dollar amount to
>> deduct.
>>
>> It's obvious to me that if the dollar amount equals or exceeds 5% of the
>> workers salary, a straight percentage in company match item will work.
>>
>> But, for amounts that fall UNDER a full 5% of pay, how do I default the
>> match? What percentage do I enter into the QB company match payroll item?
>>
>> Must I hand calculate the percentage of salary that the employee's dollar
>> amount represents - and THEN decide what to enter into company match?
>>
>> How do I ensure that the amount the company contributes does not exceed
>> the amount the employee has contributed? If QB will cap the match to the
>> employee contribution, then I suspect a default of 3% in company match
>> might work.
>>
>> Any help would be welcome.
>
> Request from management that employees should always be required to
> stipulate a percentage to defer not a fixed dollar amount.
>
Yah.
Shoulda thought of that before the folks from the investment group came by
and explained the parameters to all the employees.

Management is unlikely to change it all now, as I just hate extra paperwork.



Posted by Allan Martin on May 10, 2007, 2:04 pm
Please log in for more thread options

>>
>>> I've tried. Really. But I just can't figure out how to set up the
>>> company match to our new 401K 'safe harbor' plan.
>>>
>>> Our company will match up to 4% of an employee's wages. If the employee
>>> selects to withhold 1-3%, we match dollar for dollar. At 4% we match
>>> 3.5%, at 5%, we match 4%.
>>>
>>> All this I can understand - set up a company match percentage default,
>>> and change it for those who do not take the full 5%.
>>>
>>> My confusion is where folks have entered a weekly dollar amount to
>>> deduct.
>>>
>>> It's obvious to me that if the dollar amount equals or exceeds 5% of the
>>> workers salary, a straight percentage in company match item will work.
>>>
>>> But, for amounts that fall UNDER a full 5% of pay, how do I default the
>>> match? What percentage do I enter into the QB company match payroll
>>> item?
>>>
>>> Must I hand calculate the percentage of salary that the employee's
>>> dollar amount represents - and THEN decide what to enter into company
>>> match?
>>>
>>> How do I ensure that the amount the company contributes does not exceed
>>> the amount the employee has contributed? If QB will cap the match to the
>>> employee contribution, then I suspect a default of 3% in company match
>>> might work.
>>>
>>> Any help would be welcome.
>>
>> Request from management that employees should always be required to
>> stipulate a percentage to defer not a fixed dollar amount.
>>
> Yah.
> Shoulda thought of that before the folks from the investment group came by
> and explained the parameters to all the employees.
>
> Management is unlikely to change it all now, as I just hate extra
> paperwork.

Is the employer matching based on a single weeks payroll or should you be
looking back to the beginning of the year to determine the YTD percentage? I
suspect the calculation may require a whole lot more than you realize.




>
>



Posted by Golden California Girls on May 10, 2007, 10:25 pm
Please log in for more thread options
Allan Martin wrote:
>>>> I've tried. Really. But I just can't figure out how to set up the
>>>> company match to our new 401K 'safe harbor' plan.
>>>>
>>>> Our company will match up to 4% of an employee's wages. If the employee
>>>> selects to withhold 1-3%, we match dollar for dollar. At 4% we match
>>>> 3.5%, at 5%, we match 4%.
>>>>
>>>> All this I can understand - set up a company match percentage default,
>>>> and change it for those who do not take the full 5%.
>>>>
>>>> My confusion is where folks have entered a weekly dollar amount to
>>>> deduct.
>>>>
>>>> It's obvious to me that if the dollar amount equals or exceeds 5% of the
>>>> workers salary, a straight percentage in company match item will work.
>>>>
>>>> But, for amounts that fall UNDER a full 5% of pay, how do I default the
>>>> match? What percentage do I enter into the QB company match payroll
>>>> item?
>>>>
>>>> Must I hand calculate the percentage of salary that the employee's
>>>> dollar amount represents - and THEN decide what to enter into company
>>>> match?
>>>>
>>>> How do I ensure that the amount the company contributes does not exceed
>>>> the amount the employee has contributed? If QB will cap the match to the
>>>> employee contribution, then I suspect a default of 3% in company match
>>>> might work.
>>>>
>>>> Any help would be welcome.
>>> Request from management that employees should always be required to
>>> stipulate a percentage to defer not a fixed dollar amount.
>>>
>> Yah.
>> Shoulda thought of that before the folks from the investment group came by
>> and explained the parameters to all the employees.
>>
>> Management is unlikely to change it all now, as I just hate extra
>> paperwork.
>
> Is the employer matching based on a single weeks payroll or should you be
> looking back to the beginning of the year to determine the YTD percentage? I
> suspect the calculation may require a whole lot more than you realize.

Yes, you need a copy of the master plan document. I would be surprised if it
wasn't on a per pay period basis, but until you read it and the IRC ...

And as far as QB, it either matches or it doesn't. No partial match. And I
don't think there is a way to set up multiple items to do it either.

My suggestion, tell management to get an outside payroll service and let them
set up the custom programming needed for that 401(k) that management bought.

Similar ThreadsPosted
TAX and NI contributions May 23, 2007, 11:38 am
How do I track a funder's contributions in QB (Class?) August 1, 2007, 2:53 pm
How to easily enter employer contributions for payrolls July 19, 2006, 3:27 pm
Match 1 downloaded transaction to 2 in the register August 23, 2006, 2:26 pm
you can only match transactions in your register which are uncleared April 7, 2007, 11:36 pm
BAS doesnt match with Profit/Loss Report July 12, 2006, 2:34 am
opening balance on reconcile screen does not match balance in QB and statement January 15, 2008, 3:42 pm
how do I sell to my self/my company July 13, 2007, 3:06 pm
Unable to set Company ID September 23, 2007, 4:08 pm
New Company - sort of December 30, 2007, 8:33 pm

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap