FAQ 948: ADP - Calculating ATM on failed ADP test without a Match Formula posted

Problem:

How does ASC calculate the ATM on a failed ADP test without a formula coded?


Solution:

If the system is not given a formula at all it will still generate an ATM by pro-rating the contributions (match/total deferral - including catchups).

In this case we have John Doe with an ATM of 1182.64.

This is calculated from his match/total deferral = 4230.16/22000=.192280 multiplied by his ADP excess of 6150.63
6150.63 * .192280 = 1182.64

Likewise, review Jane Doe who has an ATM of 1232.59.

This is calculated from her match/total deferral = 4569.24/21704.28 = .210523 multiplied by his ADP excess of 5854.91
5854.91 * .210523 = 1232.59