Skip to content

AgentPay customer help

Structured Compensation Data Import Guide

Review an approved structured compensation spreadsheet locally, confirm its generic categories, and import verified compensation history into AgentPay.

Updated October 24, 2026

Before you begin

Export your own authorized structured compensation workbook from the compensation portal. AgentPay supports the approved structured spreadsheet format and validates its pay periods and aggregate compensation totals before confirmation.

Data-safety check: Use an aggregate compensation export. Do not select a workbook containing customer names, policy numbers, addresses, claims, customer identifiers, medical information, payment-card information, passwords, or identity documents.

Refreshers in AgentPay

Once you are signed in, Help in AgentPay shows the one thing your forecast needs next and two short refreshers:

Review and import structured data

  1. Save the approved workbook. Keep the original structured columns, pay dates, and aggregate category rows.
  2. Open Add & Update in AgentPay. Choose the structured spreadsheet review action.
  3. Select the workbook. AgentPay reads and validates it locally in your browser. The raw workbook is not sent to AgentPay storage.
  4. Review every pay period. Confirm the pay dates, generic compensation categories, and reconciliation status.
  5. Resolve any requested category choice. AgentPay asks only when a generic Auto renewal destination cannot be proven from the workbook structure.
  6. Confirm Import. Every reviewed period is saved together, or none is saved if validation fails.

Privacy and support

Only the confirmed generic compensation values are sent for persistence. Workbook bytes, filenames, worksheet names, source labels, and local file paths are excluded.

For more information, read the Privacy Policy. If an approved structured workbook is rejected, contact support@agentpayforecast.com without attaching the workbook to ordinary email.

Structured Compensation Data Import Guide | AgentPay