My CTC Worksheet for FY 2025–26
I am sharing my IT CTC Worksheet for the financial year 2025–26 as a real-world example to help employees understand something that is often confusing: how an annual CTC figure is broken down across monthly salary, reimbursements, benefits and other components.
Important: This is my own CTC worksheet from my employment. Personal or identifying information should be removed or redacted before publishing. The figures shown are specific to my employment and should not be treated as a standard CTC structure for every employee.
What Is a CTC Worksheet?
A CTC worksheet provides a consolidated view of an employee's compensation and related company-paid components for a financial year.
My worksheet explains the compensation applicable from April 2025 through March 2026 and includes salary, reimbursements, benefits and other CTC-related information. It also distinguishes between values already paid and projected values for later months.
This makes the document different from a normal monthly payslip.
A payslip tells you what happened in a particular payroll month.
A CTC worksheet can give you a broader view of compensation across an entire financial year.
My Total Fixed Pay
My CTC worksheet shows:
Total Fixed Pay: ₹17,65,990
The worksheet identifies the period as:
April 1, 2025 to March 31, 2026
and records the relevant employment date separately.
The annual fixed-pay figure is then reflected in the monthly salary calculations.
My Monthly CTC Calculation
The salary section of my worksheet shows a monthly CTC of approximately:
₹1,47,166
for each month in the worksheet.
The salary table runs from April 2025 through March 2026.
The worksheet shows the following recurring components:
Basic: ₹1,05,000
HRA: ₹29,565
Employer PF: ₹12,600
The remaining columns in the worksheet cover other allowances, deductions, unclaimed CTC and recovery-related items.
My Monthly Salary Structure
Based on the worksheet, the recurring monthly structure can be summarized as:
| Component | Monthly Amount |
|---|---|
| Basic | ₹1,05,000 |
| HRA | ₹29,565 |
| Employer PF | ₹12,600 |
| Monthly CTC | ₹1,47,166 |
These are the figures shown in the CTC worksheet and are useful for understanding how annual fixed pay is represented on a monthly basis.
Why My Monthly CTC Is Not the Same as Take-Home Salary
This is one of the biggest areas of confusion among employees.
The monthly CTC shown in my worksheet is not the same thing as the amount credited to my bank account.
The worksheet includes employer-paid components such as employer provident fund.
A payslip, on the other hand, shows employee earnings and deductions used to arrive at net pay.
Therefore, employees should not simply look at the CTC worksheet and assume that the monthly CTC is their monthly take-home salary.
CTC Worksheet vs Payslip
The two documents serve different purposes.
CTC Worksheet
My CTC worksheet provides an annual view of compensation and related components.
It includes salary details, reimbursements, benefits and the CTC calculation for the financial year.
Payslip
A payslip focuses on a particular payroll month and shows earnings, deductions and net pay.
For example, my earlier monthly payslips show gross earnings and net pay for individual months.
This means the two documents complement each other rather than replacing each other.
The Interesting Part: My CTC Worksheet Shows a ₹11 Balance
One of the most unusual details in my worksheet is the final Balance Payable CTC of ₹11.
The worksheet provides the calculation as:
T1 − (T2 + T3 + T4)
where the relevant totals are:
Prorated CTC: ₹17,65,991
Salary: ₹17,65,980
Reimbursements: ₹0
Benefits: ₹0
Balance Payable CTC: ₹11
So, according to the worksheet, the difference is only ₹11.
This is a good example of why the CTC worksheet is more detailed than simply looking at annual salary.
Why Would There Be a Small Balance Payable?
In my case, the worksheet itself records a ₹11 difference between the prorated CTC and the sum of salary, reimbursements and benefits.
A small balance like this can arise from how compensation components are calculated, rounded or allocated across payroll records.
However, the document itself does not explain the exact reason for the ₹11 difference.
Therefore, I would not claim a specific cause beyond what the worksheet actually shows.
The important point is that the system has identified ₹11 as the balance payable CTC.
What Are Reimbursements?
The CTC worksheet has a separate Reimbursements Details section.
It includes categories such as:
Leave Travel Assistance
Car Maintenance
Car Insurance
Car Running Expenses
Driver Salary
The worksheet shows zero amounts across the reimbursement section for the months displayed.
This means that these particular reimbursement categories did not contribute to the CTC shown in this worksheet during the displayed period.
What Are Benefits?
The worksheet also includes a separate Benefits section.
It lists:
Food Coupons
Car Lease
The displayed values are zero, resulting in a total of zero for the benefits section.
This demonstrates that not every possible benefit category necessarily contributes to an employee's annual CTC.
Actual vs Projected CTC
One particularly useful feature of this document is its explanation of actual and projected values.
The worksheet states that it displays salary, reimbursements and perks paid from April 2025 up to the previous month, while projected values for later months are displayed separately.
This is important because an employee looking at a yearly CTC worksheet should understand that not every number represents money that has already been paid.
Some values can represent the expected or projected compensation for the remainder of the financial year.
Why a CTC Worksheet Can Be Useful
A yearly worksheet can help an employee understand the relationship between different parts of compensation.
Instead of looking at one monthly payslip at a time, the employee can review the entire financial-year picture.
It can also help identify:
Monthly fixed salary
Employer contributions
Reimbursements
Benefits
Unclaimed CTC
CTC recovery
Balance payable or recoverable CTC
The document specifically instructs employees to pay attention to unpaid or unclaimed CTC shown as balance payable or recoverable CTC.
My CTC Worksheet Month by Month
The salary table in my worksheet covers all twelve months of the financial year:
April 2025
May 2025
June 2025
July 2025
August 2025
September 2025
October 2025
November 2025
December 2025
January 2026
February 2026
March 2026
The displayed monthly values remain consistent in the worksheet, with monthly CTC shown at approximately ₹1,47,166.
Why CTC Can Be Different From Actual Salary Paid
A CTC figure is a broader compensation concept.
Some elements may be employer contributions or benefits rather than direct salary.
Some components may also be paid at different times.
My own CTC worksheet shows why an employee should not equate the annual CTC figure with the amount received every month.
The worksheet separately tracks salary, reimbursements and benefits.
How My Annual CTC Adds Up
The worksheet's main CTC figures provide an interesting annual comparison:
Prorated CTC: ₹17,65,991
Salary: ₹17,65,980
Reimbursements: ₹0
Benefits: ₹0
Balance payable CTC: ₹11
The result is a very small outstanding amount compared with the overall annual compensation.
What Is “Unclaimed CTC”?
The worksheet includes a column for Unclaimed CTC.
This is a useful concept because CTC can contain components that are not immediately paid as regular salary.
The exact treatment depends on the employer's compensation structure and policies.
In my worksheet, the displayed monthly unclaimed CTC and recovery values are zero.
What Is CTC Recovery?
The worksheet includes a separate CTC Recovery column.
Recovery entries can be used in payroll systems to account for amounts that need to be recovered or adjusted according to the applicable compensation arrangement.
In the monthly rows displayed in this worksheet, the recovery values are zero.
Why Employees Should Check Their CTC Worksheet
A yearly CTC worksheet can reveal information that is not obvious from a regular payslip.
For example, an employee may discover:
A benefit that was not used
A reimbursement that was not claimed
A small CTC balance
A difference caused by adjustments
Projected values for future months
The document itself specifically advises employees to take stock of unpaid or unclaimed CTC.
How I Read My CTC Worksheet
When I look at this document, I separate it into four parts:
1. Fixed Pay
This is the main annual compensation figure.
2. Salary Details
This shows how the fixed pay is represented across monthly salary components.
3. Reimbursements
This shows additional eligible categories such as travel or vehicle-related items.
4. Benefits
This captures other benefit categories included in the CTC calculation.
The worksheet then brings these components together in the final CTC summary.
My Main Takeaway From This Document
The biggest lesson from my CTC worksheet is simple:
CTC is more than monthly salary.
A compensation package can contain several components, and an annual worksheet can bring them together in one place.
The most useful part for me is seeing the complete financial-year picture rather than looking at one month in isolation.
Should Every Employee Have the Same CTC Structure?
No.
Employees can have different compensation structures depending on their role, level, employer, location, benefits and individual employment terms.
For that reason, my worksheet should be treated as a real-world example from my own employment, not as a standard CTC template.
Why I Am Sharing My CTC Worksheet
I am sharing this document because CTC is one of the most misunderstood parts of an IT salary package.
Many people know their annual CTC but do not know how the number is constructed.
A real CTC worksheet makes the relationship between annual fixed pay, monthly salary, employer contributions, reimbursements and benefits much easier to understand.
That is the reason I wanted to document this example.
Frequently Asked Questions
What is a CTC worksheet?
A CTC worksheet is a compensation document that brings together salary, reimbursements, benefits and other CTC-related components for a specified period.
What period does my CTC worksheet cover?
The worksheet covers the financial year from April 2025 through March 2026.
What is my total fixed pay in this worksheet?
The worksheet shows ₹17,65,990 as Total Fixed Pay.
What is my monthly CTC?
The worksheet shows approximately ₹1,47,166 per month in the salary details.
What are the main monthly salary components?
The displayed recurring components include ₹1,05,000 Basic, ₹29,565 HRA and ₹12,600 Employer PF.
Does monthly CTC equal take-home salary?
No. CTC includes components that are not necessarily deposited directly into the employee's bank account.
Does the worksheet include reimbursements?
Yes. It has a separate reimbursement section covering categories such as Leave Travel Assistance and vehicle-related expenses.
Did I have reimbursements in this worksheet?
The displayed reimbursement amounts are zero.
Did I have benefits in this worksheet?
The displayed Food Coupons and Car Lease benefit amounts are zero.
Why is there an ₹11 balance payable CTC?
The worksheet shows prorated CTC of ₹17,65,991 less salary of ₹17,65,980, with zero reimbursements and benefits, resulting in an ₹11 balance payable CTC. The worksheet itself does not provide a specific explanation for why the difference is ₹11.
Does every month's CTC have to be identical?
No. CTC structures can vary, and additional payments or adjustments can change monthly values. In this particular worksheet, the displayed monthly salary figures are consistent across the listed months.
Are all the values in a CTC worksheet already paid?
Not necessarily. The document explains that it includes amounts paid up to the previous month as well as projected values for later months.
Is this a standard CTC structure for IT employees?
No. This is my personal CTC worksheet and should be viewed only as a real-world example.
Final Thoughts
This CTC worksheet gives a much clearer picture of my compensation than a single monthly payslip.
It shows how an annual fixed-pay figure can be connected to monthly salary, employer PF, reimbursements, benefits and the final CTC calculation.
One of the most interesting details is the ₹11 balance payable CTC, which shows how even a very small difference can appear in a yearly compensation reconciliation.
For me, this document is useful because it provides a complete financial-year view rather than focusing on just one month's salary.
I am sharing it as a real-world personal example so other IT professionals can better understand what a CTC worksheet can contain and how to read one.
Disclaimer: This article is based on my personal CTC worksheet and is provided for educational and informational purposes. The figures and structure apply to my own employment situation and should not be treated as a standard salary structure for other employees. Compensation structures, benefits, reimbursements, payroll practices and company policies can vary by employer, role, location and year.
No comments:
Post a Comment