← VK Labz / Dealer Payout Calculator

Dealer payout calculator

Upload your master payout file, dealer registry, and a quarter's sales data β€” get every dealer's tier and payout, with a full audit trail of what was excluded and why.

πŸ”’ Runs entirely in your browser β€” files never leave this tab.
1Master payout file

Defines which SKUs are in the program and the Silver / Gold / Platinum rate for each. Cached in this browser β€” you only need to re-upload when it changes.

No file cached yet
2Dealer registration file

The list of valid, registered dealer accounts. Also cached β€” re-upload only when a dealer is added, removed, or corrected.

No file cached yet
3Distributor sales data

This quarter's raw sales submissions from distributors. Not cached β€” upload a fresh file each time you run a calculation.

No file selected
4Select the quarter

Choose the quarter to calculate for. Rows outside this date range are excluded.

–
Total payout
–
Platinum
–
Gold
–
Silver
–
Not qualified
Dealer #Dealer nameDistributor Qualifying qtyTierPayout