Processing...

Upload Attendance File

Select your Excel file containing the Attendance-Master sheet

📁

Drop Excel file here

or click to browse  ·  .xlsx / .xls

Expected columns  →  B: Name   C: Department   G: Punch-In Time

Configure Rounds

Har round mein ek se zyada time slots — har slot ka apna range, late-day filter aur penalty

Reports Generated

📋 Final Summary

📋 VBA Macro Code

Paste into Excel — works with the Attendance-Master sheet

📌 How to use in Excel
1
Open VBA Editor
Press Alt + F11 in Excel — the VBA editor will open
2
Insert Module
Click Insert → Module — a new module window will appear
3
Paste Code
Click "Copy Code" above, then press Ctrl + V in the module window
4
Run Macro
Alt + F8 → select RunFullAttendanceReport → Run
AttendanceMaster_Fixed.bas

👤 Employee Detail Report

View date-wise attendance details for any employee

🏢 Departments
0 selected All None
🔍 Select Employees
0 selected All None
⏰ Penalty Time Slots

Define time ranges with different penalties. Each slot calculates penalty separately.

🧾 Bilty Report

No data picked yet.
📥 Paste Bilty Data

Excel/Sheet se rows copy karke niche paste karein. Tab-separated ya comma-separated dono chalenge.

📋 Picked Rows Preview
Paste data and click "Pick Data" to preview rows.
PS

Pavan Sharma

Developer & Business Operator

I am a developer and business operator. This website offers a free tool designed for attendance management and bilty tracking. I work with Navrang Apparels and my passion lies in building efficient business software solutions.

What I Do
Attendance Tools
Late report, employee tracking, Excel export
Bilty Management
Transport receipt tracking, WhatsApp share
Navrang Apparels
Apparel business - transport & logistics
Web Development
Chrome Extensions, Web Apps, Tools
Contact Info
#

Get in Touch

Have a question or suggestion? Feel free to contact me directly.

Send Email
wwepavansharma@gmail.com
WhatsApp
+91 9956901181
Send a Message
👨‍💻

Pavan Sharma

Developer & Business Operator

I am a developer and business operator. This website offers a free tool designed for attendance management and bilty tracking. I work with Navrang Apparels and my passion lies in building efficient business software solutions.

💼 What I Do
📊
Attendance Tools
Late report, employee tracking, Excel export
🧾
Bilty Management
Transport receipt tracking, WhatsApp share
🏢
Navrang Apparels
Apparel business — transport & logistics
💻
Web Development
Chrome Extensions, Web Apps, Tools
📞 Contact Info
👤
Name
Pavan Sharma
📱
📬

Get in Touch

Have a question or suggestion? Feel free to reach out!

📧
Send Email
wwepavansharma@gmail.com
💬
WhatsApp
+91 9956901181
✉️ Send a Message
🏛️
TaxFlow — TDS Calculator
Income Tax Department · Sec 392 (IT Act 2025) · Salary TDS
Tax Year 2026–27
IT Act 2025
Live Calc
Created by ✦ Pawan Sharma ✦ TaxFlow Pro
Professional TDS Calculator · Sec 392 · IT Act 2025
Salary Tax Deduction at Source
Apni salary aur periods enter karo — TDS, refund aur ITR balance real-time calculate hoga
Tax Year 2026–27
Tax Settings & Disclosures
Form 12B Submitted Previous employer salary disclosed
✦ Standard Deduction ₹75,000  ·  No 80C / HRA deductions  ·  Default from Tax Year 2026–27
Salary Periods
Jitni jobs ya periods hain — sab add karo
Summary
₹
Gross Annual
—
—
✂
Total TDS
—
—
⚖
Actual Tax Due
—
—
⚡
ITR Balance
—
—
Month-wise Breakdown
Month # Period Salary TDS Deducted In-Hand Eff. Rate
Visual — Salary vs TDS
TDS Calculation — Job-wise Breakdown
Tax Slabs & Reconciliation
Slabs Applied
Final Reconciliation
TaxFlow  ·  Tax Year 2026–27  ·  Sec 392 (IT Act 2025) — TDS on Salary  ·  New & Old Tax Regime
Designed & Developed by Pawan Sharma
⚠ Yeh tool sirf reference ke liye hai. Official filing ke liye CA se consult karein.