EXCEL TO DASHBOARD
Your school,
clearly organised.
Four simple worksheets. One clear view of your school.
Download blank Excel template ↓Try it with sample records
Fictional pupils. Changes stay in this preview.
1
What you fill in
| # | Student name * | Class * | Date of birth * | Gender * | Roll number | Section | Guardian name | Guardian phone |
|---|---|---|---|---|---|---|---|---|
| 2 | Akon Okon | Primary 1 | 2020-03-12 | female | 001 | A | Sample guardian 1 | |
| 3 | Emem Okon | Primary 1 | 2020-03-12 | male | 002 | A | Sample guardian 2 | |
| 4 | Ini Okon | Primary 1 | 2020-03-12 | female | 003 | A | Sample guardian 3 | |
| 5 | Uduak Okon | Primary 1 | 2020-03-12 | male | 004 | A | Sample guardian 4 | |
| 6 | Ekemini Okon | Primary 1 | 2020-03-12 | female | 005 | A | Sample guardian 5 | |
| 7 | Akon Bassey | Primary 1 | 2020-03-12 | male | 006 | A | Sample guardian 6 | |
| 8 | Emem Bassey | Primary 1 | 2020-03-12 | female | 007 | A | Sample guardian 7 | |
| 9 | Ini Bassey | Primary 1 | 2020-03-12 | male | 008 | A | Sample guardian 8 | |
| 10 | Uduak Bassey | Primary 1 | 2020-03-12 | female | 009 | A | Sample guardian 9 | |
| 11 | Ekemini Bassey | Primary 1 | 2020-03-12 | male | 010 | A | Sample guardian 10 | |
| 12 | Akon Udo | Primary 2 | 2019-06-15 | female | 011 | A | Sample guardian 11 | |
| 13 | Emem Udo | Primary 2 | 2019-06-15 | male | 012 | A | Sample guardian 12 | |
| 14 | Ini Udo | Primary 2 | 2019-06-15 | female | 013 | A | Sample guardian 13 | |
| 15 | Uduak Udo | Primary 2 | 2019-06-15 | male | 014 | A | Sample guardian 14 | |
| 16 | Ekemini Udo | Primary 2 | 2019-06-15 | female | 015 | A | Sample guardian 15 | |
| 17 | Akon Etim | Primary 2 | 2019-06-15 | male | 016 | A | Sample guardian 16 | |
| 18 | Emem Etim | Primary 2 | 2019-06-15 | female | 017 | A | Sample guardian 17 | |
| 19 | Ini Etim | Primary 2 | 2019-06-15 | male | 018 | A | Sample guardian 18 | |
| 20 | Uduak Etim | Primary 2 | 2019-06-15 | female | 019 | A | Sample guardian 19 | |
| 21 | Ekemini Etim | Primary 2 | 2019-06-15 | male | 020 | A | Sample guardian 20 |
* Required when you enter a row. Leave unused rows blank.
Try changing a class fee
Payments are optional and separate from fees.
2
What your dashboard shows
Sample school · First term
Fees charged₦1,100,000Class fee × pupils
Fees by class
| Pupil | Class | Paid | Owing |
|---|---|---|---|
| Akon Okon | Primary 1 | ₦0 | ₦50,000 |
| Emem Okon | Primary 1 | ₦0 | ₦50,000 |
| Ini Okon | Primary 1 | ₦0 | ₦50,000 |
| Uduak Okon | Primary 1 | ₦0 | ₦50,000 |
| Ekemini Okon | Primary 1 | ₦0 | ₦50,000 |
| Akon Bassey | Primary 1 | ₦0 | ₦50,000 |
| Emem Bassey | Primary 1 | ₦0 | ₦50,000 |
| Ini Bassey | Primary 1 | ₦0 | ₦50,000 |
| Uduak Bassey | Primary 1 | ₦0 | ₦50,000 |
| Ekemini Bassey | Primary 1 | ₦0 | ₦50,000 |
| Akon Udo | Primary 2 | ₦0 | ₦60,000 |
| Emem Udo | Primary 2 | ₦0 | ₦60,000 |
| Ini Udo | Primary 2 | ₦0 | ₦60,000 |
| Uduak Udo | Primary 2 | ₦0 | ₦60,000 |
| Ekemini Udo | Primary 2 | ₦0 | ₦60,000 |
| Akon Etim | Primary 2 | ₦0 | ₦60,000 |
| Emem Etim | Primary 2 | ₦0 | ₦60,000 |
| Ini Etim | Primary 2 | ₦0 | ₦60,000 |
| Uduak Etim | Primary 2 | ₦0 | ₦60,000 |
| Ekemini Etim | Primary 2 | ₦0 | ₦60,000 |
Your real dashboard updates after you review and publish your file.