Excel formula to allocate basic Safe Harbor Match contribution

[Guest Amy Harle]

Anyone have an excel formula I can use to allocate the basic Safe Harbor Match contribution?

[R. Butler]

This should work, but I put it together quick so test it a few times. Salary & Deferral are data entry, the match calculates.

SH_Basic_Match.xls

[Guest Amy Harle]

Thanks SO much - this is perfect!

[MWeddell]

That formula assumes that wages are limited to the 401(a)(17) compensation cap already.

[R. Butler]

That formula assumes that wages are limited to the 401(a)(17) compensation cap already.

Correct. All that formula does calculate the match. User responsible for monitoring comp. & deferrals.