2027 Philippine Bar Review Tracker (Google Sheets)

A ready-made Google Sheets planner for the 2027 Philippine Bar. It has a week-by-week study plan, a daily review queue, all 1,495 syllabus topics and 93 Rosario ponencias. It comes with a 10-page start guide.

Stop wondering what to review today. The 2027 Bar Review Tracker builds your study plan, tells you every morning which topics are due for review, and shows your progress across all six Bar subjects.

Set it up once in about 5 minutes. After that it takes about 5 minutes a day to keep it up to date.

What you get

• A 10-page PDF start guide with a download button. It walks you through setup, your daily routine and common questions.
• The 2027 Bar Review Tracker as a Google Sheet that you save to your own Google Drive.

What’s inside the tracker

• Study Plan. Enter your start date and your 1st, 2nd and 3rd reading deadlines. It builds one row per week, labeled by phase, and compares your logged hours with your weekly target.
• Review Queue. Every topic due for review today, plus your weak topics. It fills itself from your confidence ratings.
• The full 2027 syllabus, 1,495 topics. Political, Commercial & Tax, Civil, Labor, Criminal, and Remedial & Ethics each get their own tab. Every topic has checkboxes for 1st, 2nd and 3rd read, Codal and Reviewer, plus a 1 to 5 confidence rating.
• Spaced repetition built in. Rate a topic and its next review date fills in by itself. Shaky topics come back in 1 to 3 days, and mastered ones in 30. You can change the intervals.
• Rosario Ponencias tab, 93 decisions. Decisions of Justice Ricardo R. Rosario, each tagged to a Bar subject and syllabus topic. Each has Read and Digested checkboxes, a notes column and an E-Library link.
• Dashboard. Days to the Bar, reading progress, hours this week, progress per subject and four charts, all updating automatically.
• Mock Exams. Log your scores and see your average per subject and a projected general average against the 75% passing mark.
• Study Log. Record each session. Your hours feed the Study Plan and Dashboard.
• Start Here tab. Step-by-step setup and a setup check that tells you if something in your plan doesn’t line up.

Built around the official 2027 Bar details

The exam schedule, subject weights, coverage cut-off and passing average are already loaded from Bar Bulletin No. 1-2027. You don’t need to touch them.

Who it’s for

Bar exam takers who want a structure to follow, and anyone who wants proof that they’re covering all six subjects instead of just feeling busy.

How you get it

1. After payment, download the PDF start guide.
2. Open it and press Download your tracker. Google Sheets asks you to make a copy.
3. Click Make a copy. Your own tracker is saved to your Google Drive.
4. Open the Start Here tab and set your start date and daily hours.

Good to know

• It works in Google Sheets, which is free. A Google account and an internet connection are required.
• On a phone, use the free Google Sheets app. The Dashboard is easiest to read on a computer or tablet.
• Your tracker starts empty on purpose. Percentages read 0% until you start ticking topics and logging sessions.
• It links to the Rosario decisions on the Supreme Court E-Library. It does not include the decision text or ready-made digests.
• It’s a planning and tracking tool, not a reviewer, and it doesn’t replace your lectures or the codals. It’s independent and not affiliated with the Supreme Court or the Office of the Bar Chair.
• Your purchase is for your own studying. Please don’t resell or share the file or the link.