Day book for School fees collection

I want day book in excel format with have a column of students name, class mode of payment(online, cash) and balance
The total collection amount should be automatically calculated after how much cash has received and online payments and which type of currency it should all calculated automatically

and it should have particular day which it made simple