We are pleased to bring you useful Excel templates. In order to download the file, kindly click on the download button below each file.
Bank Payment Voucher
Save the file as macro-enabled as there are two macros in it. One to convert the amount into words and other the “create new voucher” button. The button will create new blank Payment voucher template in a new sheet for you to enter a new voucher.
Sales Reports Pivot Table
Sales Reports prepared using Pivot table. You can either use as it is or modifies it as per your needs.
Attendance Sheet – School
The attendance sheet is used as a control factor in school. You can use the attendance sheet in a printed form or change it as per your needs.
Daily Working Schedule
Planning is very important in order to get tasks done on time and to have check & balance. Daily working schedule sheet is exactly having the same purpose and is prepared to keep the daily task list in mind. The sheet is prepared with the sample conditional formatting formula.
Attendance & Timesheet (Staff)
Monthly Reports (Personal Income Vs Expenses)
This useful document consists of three sub-sheets. The data need to be entered in data entry sheet. The middle sheet consists of Income and Expense categories. The final and the most important one is similar to the image shown below. You will change the month and the charts and reports will update itself.
School Fee Voucher
Another useful form linked to the detail student fee. If properly understood and used, will save precious staff time. Vlookup function is used to build this template which extracts data based on the unique criteria i.e. Student ID. Change the student ID and it will accumulate data based on the ID.
This file contains a Balance Sheet and Profit & Loss statements. You can modify it according to your needs.