Average Benefit Percentage Worksheet Report


ABPT Worksheet Overview

Average Benefit Percentage Test Worksheet is used to manipulate your test results (to make it PASS) using Profit Sharing and Deferral Overrides. These changes can be seen in a single Worksheet page.  It can also be used to solve the Minimum Profit Sharing Contributions for the NHCEs.




1.ABPT Report Details Section - This section provides interface to manipulate the individual defined contribution overrides. 401(k) and Profit Sharing override values are the same values defined in Employees Census Screen as Deferral and Profit Sharing Overrides respectively.  


Checking the  “Override” checkbox will enable the Amount ($) and percentage (%) text boxes.


You can only modify on 401(k) and Profit Sharing columns (as shown above).  The participant/s with override/s will be marked with RED border/s. Any override changes made through the worksheet will be highlighted in BLUE. However, once “Apply Changes” button is clicked, the blue highlight will go away and will only retain red border for saved overrides.


Note that whenever you make a change in the Amount ($) or Percentage (%) it will be automatically re-calculate and it will display the new ABPT result.


2.Class Section – these are the same values defined in the Classes page containing Profit Sharing Amount ($) or Percentage (%).


3.Plan Details Section – these are the same values defined from Plan Specifications under 401(k) tab containing Deferrals, Safe Harbor and Match results. 


NOTE:  Unchecking the 401(k) checkbox from the Plan Details tab will disable the 401(k) columns.   Every  change on the values in the Class and Plan Detail Sections will re-calculate the results.


4.Results Section – this section displays the percentage and testing result of the ABP test. ABPT is computed as the Average EBAR of the NHCEs divided by the Average EBAR of the HCEs [(A) / (B)*100] and if the ABPT result is greater than or equal to 70.00 % it will display PASS. Otherwise, it will display FAIL.


IMPORTANT REMINDER:  Make sure to click on the “Apply Changes” button to save and apply the changes permanently.




 -  This button is used to save and re-calculate all the changes from the worksheet and it will save all changes to the Census Overrides, Classes and Plan Specs.


 -   This button is used to go back to the “NON-DISCRIMINATION TESTING RESULT” and will display a confirmation message “Any unsaved data will not be stored.  Continue anyway?”  to ignore your changes to the worksheet.


 -  This button is used to cancel all the changes from the worksheet, this will revert to its original values.

 Coming soon! This button is used to print all page contents including highlighted values.



See How to pass ABPT for this plan using the new Worksheet