CAP Integrated Data Preparation Tool V13

One entry tool for Pay Plans, What-If instructions, Associates, Sales and Commission Records. The relationships are maintained here; CAP receives four Excel import files plus a What-If request summary.

0Pay Plans
0Associates
0Sales
0Commission Records

Pay Plan Entry

Master Data

Plan Levels

LevelFrom ($)To ($)Rate (%)

Entered Pay Plans

0 plans
Plan NameComparatorBlendLevelsLevel StructureActions

What-If Plan Request

Scenario B Instructions

Choose an existing pay plan as the starting point. The app copies its comparator, blend setting and levels so you only need to change what you want CAP to test.

What-If Pay Plan Levels

These begin as a copy of the base plan. Edit only the levels/rates you want changed.
LevelFrom ($)To ($)Rate (%)

Off-the-Top Changes

Leave a side as No Change unless you want the scenario to use a different off-the-top amount.

Agent-Specific Off-the-Bottom Changes

Only associates assigned to the selected base plan are shown. Choose No Change, Add / Modify, or Remove for each associate.

AssociateIDActionDeduction TypeValuePercentage BasisNotes

Saved What-If Summary

Not Saved
No What-If request has been saved yet.

Associate Entry

Master Data
Assigned automatically and kept unique by the app.
Populated automatically from Pay Plans entered in this app.

Entered Associates

0 associates
IDNameOfficeAnniversaryPay PlanStarting PerformanceActions

Sale Entry

Transaction Data
Assigned automatically and kept unique by the app.
Enter 50 for 50%. Excel stores 0.50.

Entered Sales

0 sales
Sale No.TypeAddressSale PriceCloseBranchList %Sell %Actions

Commission Record Entry

Links Sale + Associate

Choose an existing sale and associate. Their IDs are inserted automatically, eliminating re-keying of the relational values.

Enter 100 for 100%. Excel stores 1.00.

Entered Commission Records

0 records
Sale No.PropertyAssociate IDAssociateRole PlayedPortion RateActions

Validate CAP Relationships

This checks the relational links before any files are generated.

Create CAP Import Package

Enter a company or project identifier. One click creates a ZIP package containing all four CAP Excel import files.

Used automatically in the ZIP and Excel filenames. The current date is also added.

Example: ABC_Realty_2026-09-09_CAP_Import.zip, containing PayPlans, Associates, Sales and CommCalcs workbooks.

Clear Current Data

Clear all information currently entered. Use this when you are ready to begin a new company or analysis.