Docs
EBP Engagements

Run an EBP engagement with Agentive

Set up and run an Employee Benefit Plan audit with Agentive's EBP templates. Roll forward the baseline, publish plan provisions as Engagement Variables with the EBP Plan Analysis, tailor procedures to your client's documents with Co-Audit, and fine-tune accounting policies so each year's run is cleaner than the last.

The EBP templates are general-purpose templates for the employee benefit plan audits your firm runs throughout the year. They are not tied to one client. Each is a starting point you tailor to the plan in front of you. This guide walks through setting up and running an EBP engagement with the templates, then tuning them to your client's documents using Co-Audit and Agentive's advanced features so the engagement runs cleaner each year.

Every piece is modular. The EBP Template Engagement bundles 16 procedures, but you can take only the ones you need, and edit, skip, or roll forward each on its own. Only a few are required to get value: the EBP Plan Analysis and the testing procedures you actually perform.

What this guide covers

  • Setting up the engagement by rolling forward the EBP Template Engagement, or by starting blank and pulling in only the procedures you need.
  • Running the EBP Plan Analysis so plan provisions publish as Engagement Variables that every testing procedure reads automatically.
  • How to tailor each procedure to your client's actual documents using Co-Audit, including fixing broken column links and spinning up new procedures from the closest existing template.
  • Tips to fine-tune accounting policies in the Memo tab so client-specific quirks roll forward and next year's engagement starts ahead.

Set up your engagement

There are two ways to start an EBP engagement. Pick whichever fits how you work.

The EBP Template Engagement lives in Agentive Resources with all 16 procedures pre-configured. Roll it forward as your baseline to start from the full, tuned set.

Open the EBP Template Engagement

In Agentive Resources, find the EBP Template Engagement.

Confirm

All 16 procedures and their configurations carry forward.

If you only want certain procedures, start from a blank engagement and pull in the templates you need.

Choose a procedure

For example, EBP Plan Analysis, Eligibility Testing, or Distribution & Benefits Payments.

Click Use This Template

The procedure is added as its own task on the Task Board.


Run the EBP Plan Analysis first

Run the EBP Plan Analysis before any testing. It reads the plan documents and extracts the specific provisions that the rest of the engagement audits against (eligibility rules, the compensation definition, contribution and remittance rules, and so on). It groups the extracted provisions by Roman numeral (Plan Document Overview = I, Eligibility = II, Compensation = III, and so on), and each group ends with an overview row that re-reads the prior answers in that group. This extract, review, and summarize pattern improves accuracy.

Open the EBP Plan Analysis task

From the Task Board, open the EBP Plan Analysis task.

Provide the plan documents

Add the plan documents to the Document Group. See Choose how to provide plan documents for the two options and which to use.

Wait for all rows to complete

If the first pass leaves blank cells, use Fill Empty All. See Complete a partial run with Fill Empty All.

Plan Analysis publishes Engagement Variables automatically

When you run the EBP Plan Analysis, its overview rows are set as Engagement Variables, values referenceable across the whole engagement. The testing procedures read these variables as their plan-specific policy, so the same provisions flow into every test without re-entry.

Running the Plan Analysis automatically publishes:

  • Compensation Overview
  • Contributions Overview
  • Eligibility Overview
  • Employee Allocation Overview
  • Loans & Distributions Overview
  • Rollovers Overview
  • Vesting and Forfeitures Overview

You can review every value under Engagement Variables in Engagement Settings, and click any value to jump back to its source row.

The more precisely each overview reflects the plan document, the more reliable the downstream testing. A vague variable degrades every test that reads it. An Eligibility Overview that says "one year of service" without naming the hours-of-service standard or entry-date frequency leaves the eligibility determinations to default assumptions.

Choose how to provide plan documents

The Document Group accepts plan documents two ways. The template is tuned for the combined approach, but both work.

Merge the Plan Document, Adoption Agreement, SPD, IRS determination letter, and all amendments into one file, then provide that file. This produces the cleanest output and the fewest duplicate rows.

Providing all documents in one file also lets newer auditors ask the plan questions directly. For example, "a 20-year-old union employee enters after one week of work; are they eligible?" Agentive reads the full plan to answer.

Provide each document as its own row. The procedure still runs, but the output contains more rows and may repeat content.

In practice the Adoption Agreement carries 75% or more of the provisions, with amendments often changing it materially. If the Adoption Agreement alone gives you the audit picture you need, providing only that document is a valid shortcut.

Clean up the overview rows

Overview rows hold AI-extracted text. Make them human-readable so a new team member can read the engagement and understand the plan without opening source documents.

Remove irrelevant entries

To remove an irrelevant entry, delete its text. That leaves the value blank.

Rewrite repetitive or unclear text

Click into the cell and rewrite it in plain language.

Save

Press Enter or click outside the cell to save. The edited text is what carries downstream as the Engagement Variable value.

Ask for more about the plan

The Plan Analysis extracts a standard set of provisions. When you need more, either a provision the template does not capture or a plain-language read of the plan for a newer auditor, you can extend it two ways.

Add an AI Prompt Column

Add a column with a specific question (for example, the plan's definition of a year of service, or how it treats rehires), then run it against the plan documents already provided.

Ask Co-Audit

Describe what you want in the Co-Audit panel (for example, "summarize this plan's hardship distribution rules") and it reads the full plan and answers. This is the fastest way to get a quick read on a plan without reading a 50–60 page document end to end.


EBP templates at a glance

The library includes 16 procedures. The core testing procedures, what each verifies, and the Plan Analysis variables each reads are below. Skip any procedure you do not perform by leaving its task in Backlog. Click any template name to open its setup reference under EBP Templates.

TemplateWhat it testsPlan Analysis variables it reads
Eligibility TestingRecalculates each participant's age and service at the beginning and end of the year against the plan's rules, confirms proper plan entry, and agrees employee and employer contributions from the payroll report to the plan census.Eligibility Overview, Compensation Overview
Compensation Definition TestingEvaluates each pay code against the plan's compensation definition (and IRC §§415(c)(3), 414(s)) and returns Eligible / Ineligible / Manual Review Required per code.Compensation Overview
Payrate TestingAgrees timecard hours to the payroll register and recalculates gross pay from the authorized rate in the personnel file.Compensation Overview
Contribution TestingRecalculates deferrals against the election, applies contribution and catch-up limits, and ties pre-tax and Roth amounts across the payroll report, W-2, pay stub, and trust statement.Compensation Overview, Contributions Overview
Remittance TestingAgrees pre-tax, Roth, and employer-match contributions from the trust statement to the payroll register and tests remittance timeliness against the plan's standard.Contributions Overview, Compensation Overview
Investment Allocation TestingConfirms each fund's contribution matches the participant's election within a 1% tolerance and traces fund-level amounts from the payroll journal to the participant statement and trust.Selection-driven: fund and allocation % entered per row
Investment Earnings & Valuation TestingCalculates plan-level and participant-level return on average balance per fund and compares them to surface misallocations or calculation errors.Selection-driven: plan-level balances entered per row
Distribution & Benefit Payment TestingRecalculates expected net distribution (gross minus taxes, fees, forfeitures), evaluates accordance with plan documents, and ties the gross amount and tax withheld to Form 1099-R.Loans & Distributions Overview
Loan TestingConfirms loans are within the vested-balance limit, supports terms over 60 months with home-purchase documentation, agrees the period-end balance to the amortization schedule, and reviews 1099-R Code L / Code M.Loans & Distributions Overview

Contribution Testing also reads IRC threshold variables (annual compensation limit and the age-50+, super, and SIMPLE catch-up limits) set during EBP Setup rather than from Plan Analysis.


Tailor a request to your client's documents with Co-Audit

The templates request a standard set of documents, but your client's documents will differ: a different report format, a different name for the same figure, a calculation that needs to tie out differently. Use Co-Audit to retool the request to match what the client actually provides.

The clearest case is a swapped source document. A template built to read an individual pay stub needs different extraction and tie-out logic than an annual payroll detail report, which carries every pay period for every employee in one file. Tell Co-Audit what you have, and it rewrites the document request, the extraction prompts, and the calculations to fit.

Describe the difference in the Co-Audit panel

For example: "the client provides an annual payroll detail report instead of individual pay stubs; update the procedures to read it and recalculate the tie-out from that report."

Let Co-Audit update the workflow

It revises the document groups, AI Prompt Columns, and calculations.

Review every change

Watch the custom columns for red text (it flags a reference that needs attention) and re-check anything involving math, where the AI tends to copy a number forward instead of recalculating.

The procedures link by column header name. The three required headers are Employee Name, Date of Hire, and Plan Entry Date, and the main identifier throughout is Employee Name. When a pasted-in column uses a different name (for example, DOH instead of Date of Hire), the data does not flow downstream and the dependent cells turn red instead of blue.

Blue chain, red break. A blue chain icon means the reference is linked. Red means it is broken.

Rename the header to the exact expected name

For example, rename DOH to Employee Name or Date of Hire so it matches what the dependent references expect.

Press Enter

Linked columns update throughout the workpaper.

If a required column was never brought forward in the selections, the dependent test stays red. Add the column, or move that procedure elsewhere if you do not perform it here.

Build a new procedure from a template

When you need a procedure the library does not include (rollover testing, for example), start from the closest existing template and have Co-Audit retool it, rather than building from scratch. Co-Audit knows how to manipulate columns and prompts to match audit standards, and it types far faster than a human, so use it for the first draft.

Open the closest template

For example, open Distribution & Benefits Payments and click Use This Template.

Rename it for the new procedure

For example, rename it to Rollover Testing.

Describe the change in the Co-Audit panel

For example: "update this workflow to be tailored to rollover testing for an EBP."

Let Co-Audit revise the workflow

Co-Audit makes executive decisions. It may add several columns (name, distribution date, receiving plan or IRA, gross distribution amount, rollover type) and a client-facing request message.

Review the custom prompts

Remove any column you will not use (an added column is usually referenced downstream), and rewrite any prompt that copies a number forward where your procedure calls for a recalculation.


Run and review the workpaper

A few Agentive features handle the common friction points when you run a tailored procedure against real client data.

Set match criteria for large populations

The Match Agent works best with the least information. Leaving the match criteria blank is the laziest option and the one to try first; with less to go on, it makes its own connections. When it finds competing reasons for a match, it shows counter-evidence as a red badge so you can confirm or reject it.

Give it a nudge only when you provide a full population or census, such as an annual payroll report with thousands of rows, or a single PDF holding many check copies. There, name the one thing to match on so it does not try to process the whole population.

Name the single identifier to match on

For example, "match based on the employee name."

Add more identifiers if available

If more identifying data is available in the selections, add it to narrow further. For example, also match on date of hire.

Excel runs faster than PDF. Agentive extracts Excel into a queryable database, so large spreadsheets (a 10,000-row payroll export, for example) process faster and are easier to sanity-check than the equivalent PDF. Keep the Excel open on a second screen while you review.

Agentive cannot read images embedded in Excel or Word documents. Flatten an image-based document (such as a Word file of check copies) to PDF, or provide the individual images.


Fine-tune automations

Every request has a Memo tab titled Accounting Policies. Before any procedure runs, its agents read this whole page for context. Use it to record not just a policy but how that policy shows up in this client's files, so the determination is made once and persists.

Name the policy and describe how it appears on the client support

Describe how the policy appears in the documents. Examples:

  • "Rehire standards: this client stores rehire dates in a column titled RH in the payroll report."
  • "Pre-tax deferrals appear as 401K PRE-TAX on this client's payroll report; employer match appears as SH MATCH."
  • "The plan document refers to the eligible compensation exclusion as 'special pay'; review any line labeled that way."

Any question touching that quirk (a nonstandard contribution code, an unusual column name, plan-specific verbiage to review) now has the context to look in the right place.

Accounting policies roll forward with the engagement, so recording a client's quirks once means the procedures are already tuned for that client next year. The first year takes the tuning work. The second-year run is smoother and more accurate because the determinations are already made when the client's documents come in.


Continue your journey

How is this guide?

On this page