Master Quran & Hifz Progress Tracker
The classical 3-tier memorization system (Sabaq, Sabqi, and Manzil) built into a modern, automated spreadsheet. Designed for Asatidh, Islamic schools, and independent Quran students.
Explore What's Inside the Hifz Workbook
Click across the 3 worksheets below to preview the daily recitation log, 30 Juz milestone tracker, and Tajweed grading standards.
Master Quran & Hifz Progress Tracker
Includes Daily Recitation Log (Sabaq/Sabqi/Manzil), 30 Juz Milestone Checklist & Tajweed Rubric.
| Date | Student Name | Sabaq (New Lesson) | Lines | Sabqi (Recent) | Manzil (Dhor) | Mistakes | Grade | Homework Target |
|---|---|---|---|---|---|---|---|---|
| 2026-09-21 | Zayd Al-Ansari | Al-Baqarah 1-10 | 10 | Juz 1, Pgs 1-3 | Juz 30 Complete | 0 | Mumtaz (A+) | Ayah 11-20 |
| 2026-09-21 | Yusuf Ibrahim | Ali Imran 45-52 | 8 | Ali Imran Pgs 40-44 | Juz 29 Complete | 1 | Jayyid Jiddan (A) | Review Ayah 50-52 |
| 2026-09-21 | Bilal Siddiqui | An-Nisa 1-8 | 12 | An-Nisa Pgs 1-2 | Juz 28 Complete | 2 | Jayyid (B) | Practice Makharij on Ayah 4 |
| 2026-09-21 | Maryam Hassan | Al-Ma'idah 10-15 | 7 | Al-Ma'idah Pgs 8-9 | Juz 1-2 Review | 0 | Mumtaz (A+) | Advance to Ayah 16-22 |
| 2026-09-21 | Fatima Zahra | Al-An'am 1-12 | 15 | Al-An'am Pgs 1-3 | Juz 27 Complete | 4 | Maqbool (C) | Repeat Ayah 1-12 tomorrow |
| 2026-09-22 | Zayd Al-Ansari | Al-Baqarah 11-20 | 10 | Juz 1, Pgs 1-5 | Juz 30 Complete | 0 | Mumtaz (A+) | Ayah 21-30 |
| 2026-09-22 | Yusuf Ibrahim | Ali Imran 53-60 | 9 | Ali Imran Pgs 45-48 | Juz 29 Complete | 0 | Mumtaz (A+) | Advance to Ayah 61-70 |
Classical 3-Tier System
Dedicated tracking columns for Sabaq (new lesson), Sabqi (recent review of current Juz), and Manzil / Dhor (cumulative retention of older Juz).
Automated 30 Juz Progress
Pre-configured =COUNTIF() formulas automatically tally completed Juz count, remaining pages, and milestone completion percentages.
Tajweed Rubric & Grading
Clear 4-tier grading scale (Mumtaz, Jayyid Jiddan, Jayyid, Maqbool) evaluating Makharij, Ghunnah, Ikhfa, and mistake frequency with color-coded badges.
Print-Ready or Digital
Formatted for clean A4/Letter physical binder printing with freeze panes for easy on-screen spreadsheet logging on iPads and laptops.
How to Use the 3-Tier Quran Memorization Method Successfully
For centuries, traditional Islamic Madaris have utilized the three-tier daily recitation cycle to ensure students don't just memorize new Ayahs, but retain previously memorized portions with unwavering strength. Here is how to configure your daily routine using this template:
Today's New Lesson
The student memorizes 5 to 15 lines daily. They must recite this to the teacher with zero hesitations and 100% accurate Tajweed before receiving the next day's Sabaq.
Recent Juz Revision
The student recites the last 3–5 pages of their current Juz immediately prior to today's Sabaq. This cements new memorization from short-term memory into intermediate memory.
Long-term Retention
The student recites 1/4th to 1 full Juz of older completed portions every single day on a rotating cycle. This guarantees no Surah is ever forgotten.
This .xlsx file is 100% natively compatible with Google Sheets without any formatting loss or broken formulas:
- Download the file above to your computer or device.
- Go to drive.google.com or sheets.google.com, click + New → File Upload, and select the downloaded file.
- Click the uploaded file to open it in Google Sheets. All sheets, freeze panes, and COUNTIF formulas will work immediately!
Frequently Asked Questions
Everything you need to know about tracking Quran recitation and Hifz progress.
What is the difference between Sabaq, Sabqi, and Manzil in this template?
This template follows the classical 3-tier Quran memorization methodology: Sabaq is the new lesson assigned for today (e.g. 5–10 lines or 1 page); Sabqi (or Amukhta) is the recent revision of the current Juz (typically the last 3–5 pages memorized); and Manzil (or Dhor) is the cumulative revision of older completed Juz to guarantee long-term retention.
Is this Hifz spreadsheet compatible with Google Sheets?
Yes, 100%. You can download the .xlsx file and upload it directly to Google Drive or Google Sheets. All cell formulas (=COUNTIF), freeze panes, and conditional formatting rules work seamlessly without any loss of functionality.
Can I print this Hifz tracker as a physical paper log for my Halaqah?
Absolutely. The sheets are pre-formatted for standard letter and A4 portrait printing. You can print out the blank Daily Recitation Log rows and distribute them to students or place them in a physical Madrasah teacher binder.
How does the automated 30 Juz milestone tracker work?
The 30 Juz checklist sheet includes built-in Excel formulas that calculate your student's total completed Juz count and overall completion percentage automatically whenever a Juz status is set to 'Completed'.
Why should a Madrasah upgrade from spreadsheets to MadrasahSync?
While spreadsheets work for 5–10 students, managing 30 to 100+ students across multiple Halaqahs becomes chaotic. MadrasahSync lets teachers log Sabaq, Sabqi, and Manzil in under 10 seconds per student on mobile, sends automatic WhatsApp progress updates to parents, and generates one-click quarterly report cards.
Log Quran Lessons in 10 Seconds • Keep Parents Fully In Sync
Spreadsheets require manual typing after every lesson. With MadrasahSync, Ustadhs tap a student's name, pick Surah and Ayah with one touch, and log Sabaq, Sabqi, and Manzil in under 10 seconds. Parents receive instant WhatsApp and mobile push notifications with homework reminders and quarterly milestone certificates.