Your whole agency, reported daily.
Upload your company reports once. Every advisor, unit manager, sales manager and branch manager sees their own production, medallion, persistency and recognition, all running from your own Google Sheet.
See where every peso came from.
Daily, month-to-date, quarter-to-date and year-to-date production for AC, Lives and NSC. Tap any bar and the app lists the advisors behind it, ranked from highest to lowest.
- Charts by day for the month, and by month for the quarter and year
- Tap a bar or a breakdown row to see each advisor's total for that day or month
- Settled and pending production side by side
- Unit, sales team and branch views roll up automatically
Know the balance to the next level.
Advisors and managers see their current medallion level and exactly how much is left to reach the next one. Managers get a detailed view for the unit, sales team and branch, and a tabular view when they want it all at a glance.
- Current level and balance to the next level in one card
- Tap a card to open its breakdown line by line
- Contest targets and level amounts are set by you in Admin Settings
- Detailed or tabular view, whichever your managers prefer
The same number as your report.
Persistency for each unit, sales team and branch is worked out from your company reports and shown against every target, so managers know where they stand before the cut-off.
- Uses the 25th-month report; when December is not in yet, the latest report uploaded, actual or projected
- Unit and team totals match the combined ratio printed in the report
- Advisors who have left still count in their unit's total
- Requirements on one card: AC, persistency, new advisors and manpower
| Now | Basic | Triple A | |
|---|---|---|---|
| AC settled | ₱3.69M | ₱4.0M | ₱4.0M |
| Persistency | 78.76% | 80% | 80% |
| New advisors | 4 | 4 | 4 |
| Manpower | 8 | 3 | 3 |
Celebrate wins the moment they land.
The app builds a ready-to-share poster for your top performer and for big submissions, in your team's colors, so recognition goes out the same day.
- Hero of the Day poster with your unit or branch name under the advisor's name
- Just In poster when a submission reaches ₱100,000 premium received, tagged Regular Pay or Single Pay
- Pick the layouts and colors your team uses in Admin Settings
Log a submission in seconds.
Advisors record an application right from their phone. The premium received is counted exactly as typed, and the mode of payment is only a tag, so there is nothing to divide or convert.
- Premium received, with annual, semi-annual, quarterly or monthly as a tag
- Submitted applications show up as pending production for the advisor and their managers
- Big cases trigger the Just In poster on their own
Every page, one menu.
Real screens from a demo branch. Pick a page to see what it shows. All names and figures are sample data.
Scroll inside the frame to see the whole page.
One system, every role.
Everyone logs in and sees only what belongs to them. You decide the rules.
Four levels of view
Advisor, Unit Manager, Sales Manager and Branch Manager, each with their own dashboard, achievements and rankings.
Admin Settings
Set medallion levels, contests, poster layouts and colors, and who can see what, without touching any code.
Upload company reports
Production and persistency come from the Excel or CSV reports you already download. Upload them and the numbers update.
Contests and promos
Run branch contests and promos with their own targets and tiers, and show everyone how close they are.
Persistency upload
Upload actual and projected persistency to compute Plan B, Awards and Promos, so every qualifier is based on the real numbers.
Masterlist
One list of everyone in the branch, with position, unit, sales team and status, that drives every view.
It lives in your Google Sheet.
The app runs on a Google Sheet that belongs to your branch, in your own Google account. Your production, masterlist and settings stay in a file you own and can open any time.
- Sign-in per person, with each role limited to its own view
- Manager income summaries are hidden from the Admin and Secretary positions
- No separate database to manage or pay for
Up and running in four steps.
Connect your Sheet
Copy the branch Sheet and its script. It connects to the JCC library, so improvements reach you automatically.
Set the rules
Open Admin Settings: your medallion levels, contests, poster layouts and colors, and who sees what.
Upload the reports
Drop in your company production and persistency reports, actual or projected.
Let everyone in
Advisors and managers sign in on their phone and see their own numbers, every day.
Your agency deserves daily clarity.
Message JCC Business Solutions to see a live demo and get your branch set up.
Get JCC Agency Reporting