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

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