Sardar Patel University: Learning Payroll Inputs and Attendance Reconciliation as an Intern

Attendance reconciliation is the monthly job of matching what the attendance record says with what the leave records, holiday calendar and manager approvals say, so that payroll receives one agreed number of paid days per employee. An HR intern learns it by working through a small dataset line by line, flagging every mismatch and writing down how each was resolved. This guide gives you the leave codes, the error flags and a fully worked example for a five-person team, deliberately free of any real salary figures.

What payroll inputs are, and where attendance fits

Payroll software calculates pay from inputs. Some inputs are fixed, such as an employee’s pay structure. Others change every month: days worked, leave taken, loss-of-pay days, overtime, joiners, leavers and one-off additions or deductions. Attendance and leave data feed the first group of monthly inputs. If those inputs are wrong, every later step is wrong, however perfect the formula.

That is why a reconciliation comes before processing. It is a checking step, not a calculation step. The intern’s role is to prepare a clean input sheet, point out anything unusual and leave decisions about pay to the payroll owner. Treat everything here as practice material. Real organisations have their own policies, and nothing in a sample dataset should be copied into a live payroll.

If you want a supervised place to practise this kind of task, the free two-week online internship from CareerSwami includes human resources work where a sheet like this is a natural deliverable.

Sample leave and attendance codes for a monthly reconciliation sheet

The codes below are illustrative. Your employer will have its own list, so replace these with the official one before using them. Using short codes keeps the grid readable and lets formulas count days quickly.

Error flags that catch most attendance and leave mismatches

Create a flag column and give each problem a short code. That makes your summary to the payroll owner quick to read, and it makes patterns visible across months.

Worked example: reconciling one illustrative month for five employees

The data below is invented to show the method. It does not come from any company, and no tool was run to produce it. Names are replaced by IDs, and no pay figures appear anywhere.

Month setup

The illustrative month has 30 calendar days, including 4 weekly offs (WO) and 1 public holiday (PH). That leaves 25 working days to account for. Each employee’s working-day codes must therefore add up to 25.

Raw attendance and leave summary before checking

Reconciliation findings

1. E01: totals reach 25 and every leave day has an approval on file. No flag. Paid days: 22 + 2 + 1 working days, plus 4 WO and 1 PH, makes 30.
2. E02: two unmarked days (F1). After asking, the manager confirms one day as present and the other as unapproved absence. Revised codes: P 21, CL 1, LOP 3. Paid days: 30 minus 3 LOP days is 27.
3. E03: four WFH days with only three approvals on file (F4). The manager approves the fourth retrospectively before the cut-off, so it stays as WFH. Paid days: 30 minus 1 LOP day is 29.
4. E04: two CL days taken, but the leave ledger shows a balance of one (F3). The second day is treated as LOP under the illustrative rule, unless the payroll owner permits advance leave. Paid days: 28 under the strict rule.
5. E05: the codes add up to 24, not 25 (F2), and two days are unmarked (F1). Recounting shows one date entered twice and one date missing. After correction with the employee, the days are 23 P plus 2 LOP. Paid days: 28.

Output sheet handed to the payroll owner

Two points about the arithmetic. First, the check every time is that paid days plus LOP days equals the 30 calendar days. Second, E04 stays open because the intern should not decide the leave policy; the sheet shows the flag, the evidence and both possible outcomes, and the owner decides.

Step-by-step routine for a monthly attendance reconciliation

1. Freeze the attendance export and note the date and time. Corrections after that go through a logged process.
2. Build the calendar: calendar days, weekly offs, holidays and working days.
3. Import attendance codes and count each code per employee.
4. Add leave data from the ledger and approvals, and compare it with the codes.
5. Run the day-total check: working-day codes must equal working days.
6. List every flag with the evidence for it.
7. Send queries to employees and managers in one batch, with a clear reply deadline.
8. Update the sheet with each answer, keeping the original value visible in a notes column.
9. Prepare the output sheet with paid days, LOP days and open items.
10. Get it reviewed by the payroll owner before anything is entered into payroll software.

Sardar Patel University students: rules to check before taking a payroll or attendance internship

Sardar Patel University is in Vallabh Vidyanagar, Gujarat. For management students, the most relevant published rule found is the MBA Semester II course PM02CMBA59 Summer Internship in the 2021-22 syllabus. It carries 4 credits and a duration of 6 to 8 weeks. Students work on a project under a manager in an organisation, in any functional area, and submit a report with a completion certificate. Human resource is named among the functions a student may learn. Evaluation is split between an internal report and an external viva, each at 50 percent.

For a student in that programme, a 14-day online HR internship is much shorter than the 6 to 8 weeks described, so it cannot be assumed to replace the summer internship. The syllabus is also from 2021-22, so the present version may differ. A payroll-input project of this kind could still be a strong part of your own evidence if your department allows an HR topic for the report, because it produces a concrete deliverable with clear numbers.

The university site shows placement cells at department level, for example on the Psychology department placement cell page, so the right office for guidance may be your own department, not a central one. Confirm this with your department rather than assuming.

Verification steps for SPU students planning an HR payroll-input internship

1. Ask your department office for the current syllabus of your programme and semester, and check whether the summer internship course still shows 4 credits and a 6 to 8 week duration.
2. Ask your internship faculty coordinator in writing whether a short online internship can supplement the report, and whether an HR project topic is acceptable.
3. Find out whether the report needs a certificate from a specific type of organisation, and what format the completion certificate must follow.
4. Ask which dates your internship window can use, so the 14 days do not overlap examinations or the formal internship period.
5. Confirm with your supervisor that you will only handle anonymised or practice data, because real employee records are confidential.

Confidentiality and judgement rules for interns handling payroll inputs

Attendance and leave data are personal information. Work with employee IDs, not names, in any practice or shared file. Never email a sheet to a personal account. Never discuss one employee’s leave with another. If you notice something that looks like a policy breach, such as a manager asking you to change a record without an approval, report it to your supervisor instead of correcting it quietly.

Interns should also avoid making calls that belong to the payroll owner: whether a late correction is accepted, whether a balance can go negative, whether an exception applies. Present the facts, the options and the evidence, then wait for the decision. That habit builds trust faster than speed does.

Turning an attendance reconciliation into evidence for your resume

Keep a clean template with the leave code list, the flag list and the output sheet, plus an anonymised version of your worked example. A resume line can then read: “Built a monthly attendance reconciliation sheet with leave codes, eight error flags and a payroll hand-over summary (practice dataset).” Label practice work as practice, and do not describe it as processing a real payroll.

Frequently Asked Questions

Why reconcile attendance before running payroll?

Because payroll multiplies whatever it is given. A missed unmarked day or an unapproved leave becomes an incorrect payment that must later be corrected. Reconciliation catches these when they are cheap to fix.

What is the quickest check that a monthly attendance sheet is complete?

Count the working-day codes for each employee and compare with the working days in the month. If the totals differ, there is a missing, duplicated or unmarked date to find.

How should an intern treat a leave day when the leave balance is exhausted?

Flag it as a negative balance and show the options, such as converting it to loss of pay or following an advance-leave rule if one exists. The decision belongs to the payroll owner or HR manager.

Should an intern ever change a record after the monthly cut-off?

Only through the process your employer sets. Late corrections are usually logged and approved by the payroll owner, and the intern’s job is to flag the request and attach the evidence.

Can I practise payroll inputs without real employee data?

Yes. Build an invented dataset like the five-employee example, with IDs instead of names and no salary figures. Practising on invented data teaches the same checks without any privacy risk.

Does a 14-day HR internship satisfy the MBA summer internship at Sardar Patel University?

Do not assume so. The 2021-22 syllabus describes a 6 to 8 week project with a report and viva, so ask your department in writing whether a shorter experience can count toward it or only supplement it.

What should a leave code list include for a small organisation?

At least present, weekly off, holiday, each paid leave type, loss of pay and an unmarked code. Add work-from-home and half-day codes if the employer uses them, and keep the meanings in a short legend on the same sheet.

Related Human Resources guides

• Jayoti Vidyapeeth Women's University: Asking for Flexibility and Safety in an HR Internship
• Gauhati University: Writing a One-Page HR Internship Summary for Faculty Evaluation
• IGDTUW: Women in Tech Hiring, an HR Internship Project on Diversity Data
• All Human Resources internship guides