Reporting for agency teams

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.

Nov 3 · SettledMTD
Unit Alpha · 3 advisors
AllACLivesNSC
1Maria SantosAlpha Unit₱17,228
2Jose ReyesAlpha Unit₱4,000
3Ana VillanuevaAlpha Unit₱1,500
TotalAC ₱22,728
SAMPLE DATA
4levels, each with its own view
3measures: AC, Lives and NSC
4poster layouts for recognition
100%of your data in your own Sheet
See it work

Watch JCC Agency Reporting in action.

Production

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
AC settled · by dayMonth to date
Tap a bar to see its breakdown.
34567910 17K2K12K9K10K
Nov 3₱17,228
Nov 4₱2,258
SAMPLE DATA
Achievements and medallion

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
MedallionDetailed
Unit AlphaGold
AC ₱2,692,094Balance to Platinum ₱307,906
AC settled this year₱2,692,094
Platinum target₱3,000,000
Balance₱307,906
Unit BravoSilver
AC ₱1,320,000Balance to Gold ₱480,000
SAMPLE DATA
Persistency

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
ALPHA UNIT22 people
IN PROGRESS
NowBasicTriple A
AC settled₱3.69M₱4.0M₱4.0M
Persistency78.76%80%80%
New advisors444
Manpower833
SAMPLE DATA
Recognition

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
Hero of the Day poster, Current layout, sample name
Current
Hero of the Day poster, Aesthetic layout, sample name
Aesthetic
Hero of the Day poster, Professional layout, sample name
Professional
Hero of the Day poster, Elegant layout, sample name
Elegant
HERO OF THE DAY · FOUR LAYOUTS · SAMPLE NAME
Submissions

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
New submissionStep 2 of 3
₱250,000
MonthlyQuarterlySemi-annualAnnual
The amount is used as entered. The mode is recorded for reference only.
SAMPLE FORM
Take the tour

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.

abc-branch.vercel.app
JCC Agency Reporting screen, sample data
Branch Production Overview. Settled and submitted production for the month, quarter or year, with the MTD, QTD and YTD switch.
JCC Agency Reporting By-advisor popup screen, sample data
Tap a bar. Tap any bar to see every advisor ranked highest to lowest for that day or month, one tab each for AC, Lives and NSC.
JCC Agency Reporting screen, sample data
Personal goal tracker. Each advisor sees their own Medallion, Macaulay and MDRT progress and what is still needed.
JCC Agency Reporting screen, sample data
Plan B cash bonus. Plan B bonus, three-month NSC, cut-off figures and persistency in one place.
JCC Agency Reporting screen, sample data
Medallion and contests. Levels by advisor, unit, sales manager and branch, with the balance to the next level.
JCC Agency Reporting screen, sample data
Ranking with persistency. Ranked from highest to lowest Plan B, with persistency, class and NSC balance per advisor.
JCC Agency Reporting screen, sample data
Branch validation. Who is validated, who is in progress, and how far each advisor is from the requirement.
JCC Agency Reporting screen, sample data
Branch, team and unit. Rankings by AC and lives for each contest period, with ranking points.
JCC Agency Reporting screen, sample data
Company promos. Qualified and in-progress advisors for each promo, grouped by unit.
JCC Agency Reporting screen, sample data
OMG and EQGB. Growth rates and bonus computation for advisors, unit managers and sales managers.
JCC Agency Reporting screen, sample data
Coded and in process. Recruits by stage, direct manager and unit, plus the coded count by month.
JCC Agency Reporting Submit Application screen, sample data
Nine short steps. A guided form that records the submission and shows it as pending production.
Built for the whole branch

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.

Your data

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
Role-based views
AdvisorOwn production
Unit ManagerUnit and advisors
Sales ManagerTeam and units
Branch ManagerWhole branch
How it works

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.

Ready when you are

Your agency deserves daily clarity.

Message JCC Business Solutions to see a live demo and get your branch set up.

Get JCC Agency Reporting