cd /home/daytona/workspace/attachments/7bca2c3a-ab9d-4187-8657-ce8f799e5cd8/ && python3 -c " import pdfplumber with pdfplumber.open('Akash_Bhatiya_Payslip_May2026_Redesigned.pdf') as pdf: for i, page in enumerate(pdf.pages): print(f'--- PAGE {i+1} ---') text = page.extract_text() print(text) print() tables = page.extract_tables() for j, table in enumerate(tables): print(f'TABLE {j+1}:') for row in table: print(row) print() "

python3 << 'EOF' # ============================================================ # PAYSLIP FACT-CHECK SCRIPT # Orr Is Care Private Limited — Akash Bhatiya — April 2026 # ============================================================ print("=" * 60) print("PAYSLIP FACT-CHECK: Akash Bhatiya | April 2026") print("=" * 60) # --- RAW VALUES FROM PAYSLIP --- monthly_gross = 180000.00 basic_salary = 72000.00 hra = 36000.00 special_allowance = 60150.00 conveyance = 1600.00 medical = 1250.00 lta = 9000.00 pf_employee = 8640.00 professional_tax = 200.00 tds = 19175.00 other_deductions = 1985.00 gross_earnings_stated = 180000.00 total_deductions_stated = 30000.00 net_pay_stated = 150000.00 annual_ctc_stated = 2263680.00 errors = [] warnings = [] ok = [] print("\n--- EARNINGS CHECKS ---\n") # 1. Basic = 40% of Gross basic_expected = monthly_gross * 0.40 check = abs(basic_salary - basic_expected) < 0.01 status = "✅ PASS" if check else "❌ FAIL" print(f"Basic Salary (40% of ₹{monthly_gross:,.0f}):") print(f" Expected : ₹{basic_expected:,.2f}") print(f" On Slip : ₹{basic_salary:,.2f} → {status}") if not check: errors.append(f"Basic Salary mismatch: expected ₹{basic_expected:,.2f}, got ₹{basic_salary:,.2f}") else: ok.append("Basic Salary = 40% of Gross ✅") print() # 2. HRA = 20% of Gross (standard) hra_expected_20 = monthly_gross * 0.20 check_hra = abs(hra - hra_expected_20) < 0.01 status = "✅ PASS" if check_hra else "⚠️ NOTE" print(f"HRA (20% of Gross):") print(f" Expected : ₹{hra_expected_20:,.2f}") print(f" On Slip : ₹{hra:,.2f} → {status}") if not check_hra: warnings.append(f"HRA doesn't match 20% of Gross exactly. Got ₹{hra:,.2f}, expected ₹{hra_expected_20:,.2f}") else: ok.append("HRA = 20% of Gross ✅") print() # 3. Gross Earnings = Sum of all earnings gross_calc = basic_salary + hra + special_allowance + conveyance + medical + lta check_gross = abs(gross_calc - gross_earnings_stated) < 0.01 status = "✅ PASS" if check_gross else "❌ FAIL" print(f"Gross Earnings (sum of all components):") print(f" {basic_salary:,.2f} + {hra:,.2f} + {special_allowance:,.2f} + {conveyance:,.2f} + {medical:,.2f} + {lta:,.2f}") print(f" Calculated : ₹{gross_calc:,.2f}") print(f" On Slip : ₹{gross_earnings_stated:,.2f} → {status}") if not check_gross: errors.append(f"Gross Earnings mismatch: calculated ₹{gross_calc:,.2f}, stated ₹{gross_earnings_stated:,.2f}") else: ok.append("Gross Earnings sum is correct ✅") print() # 4. Special Allowance = Gross - (Basic + HRA + Conveyance + Medical + LTA) [plug number] special_expected = monthly_gross - basic_salary - hra - conveyance - medical - lta print(f"Special Allowance (plug = Gross - all other earnings):") print(f" Expected : ₹{special_expected:,.2f}") print(f" On Slip : ₹{special_allowance:,.2f} → {'✅ PASS' if abs(special_allowance - special_expected) < 0.01 else '❌ FAIL'}") if abs(special_allowance - special_expected) > 0.01: errors.append(f"Special Allowance mismatch: expected ₹{special_expected:,.2f}, got ₹{special_allowance:,.2f}") else: ok.append("Special Allowance (plug) is correct ✅") print() print("--- DEDUCTIONS CHECKS ---\n") # 5. PF = 12% of Basic pf_expected = basic_salary * 0.12 check_pf = abs(pf_employee - pf_expected) < 0.01 status = "✅ PASS" if check_pf else "❌ FAIL" print(f"Provident Fund (12% of Basic ₹{basic_salary:,.0f}):") print(f" Expected : ₹{pf_expected:,.2f}") print(f" On Slip : ₹{pf_employee:,.2f} → {status}") if not check_pf: errors.append(f"PF mismatch: expected ₹{pf_expected:,.2f}, got ₹{pf_employee:,.2f}") else: ok.append("PF = 12% of Basic ✅") print() # 6. Professional Tax — Gujarat slab # Gujarat PT: ₹200/month for salary > ₹12,000 pt_expected = 200.00 check_pt = abs(professional_tax - pt_expected) < 0.01 status = "✅ PASS" if check_pt else "❌ FAIL" print(f"Professional Tax (Gujarat slab for salary > ₹12,000):") print(f" Expected : ₹{pt_expected:,.2f}") print(f" On Slip : ₹{professional_tax:,.2f} → {status}") if not check_pt: errors.append(f"Professional Tax mismatch: expected ₹{pt_expected:,.2f}, got ₹{professional_tax:,.2f}") else: ok.append("Professional Tax (Gujarat ₹200) ✅") print() # 7. TDS — New Tax Regime FY2026-27 # Annual gross = 180000 * 12 = 2,160,000 # Standard deduction = 75,000 # Taxable income = 2,160,000 - 75,000 = 2,085,000 # New regime slabs FY26-27: # 0 - 400,000 : 0% # 400,001 - 800,000 : 5% → 20,000 # 800,001 - 1,200,000: 10% → 40,000 # 1,200,001 - 1,600,000: 15% → 60,000 # 1,600,001 - 2,000,000: 20% → 80,000 # 2,000,001 - 2,400,000: 25% → remaining # above 2,400,000 : 30% annual_gross = monthly_gross * 12 standard_deduction = 75000 taxable_income = annual_gross - standard_deduction tax = 0 slabs = [ (400000, 0.00), (400000, 0.05), (400000, 0.10), (400000, 0.15), (400000, 0.20), (400000, 0.25), (float('inf'), 0.30), ] remaining = taxable_income for slab_size, rate in slabs: if remaining <= 0: break taxable_in_slab = min(remaining, slab_size) tax += taxable_in_slab * rate remaining -= taxable_in_slab # Add 4% health & education cess cess = tax * 0.04 total_tax = tax + cess monthly_tds = total_tax / 12 print(f"TDS – Income Tax (New Regime FY26-27):") print(f" Annual Gross : ₹{annual_gross:,.2f}") print(f" Standard Deduction : ₹{standard_deduction:,.2f}") print(f" Taxable Income : ₹{taxable_income:,.2f}") print(f" Tax (before cess) : ₹{tax:,.2f}") print(f" Cess (4%) : ₹{cess:,.2f}") print(f" Total Annual Tax : ₹{total_tax:,.2f}") print(f" Monthly TDS : ₹{monthly_tds:,.2f}") print(f" On Slip : ₹{tds:,.2f}") tds_diff = abs(monthly_tds - tds) if tds_diff < 50: print(f" → ✅ PASS (difference of ₹{tds_diff:.2f} — rounding)") ok.append(f"TDS broadly correct (diff ₹{tds_diff:.2f}) ✅") elif tds_diff < 500: print(f" → ⚠️ MINOR DISCREPANCY (difference of ₹{tds_diff:.2f})") warnings.append(f"TDS: calculated ₹{monthly_tds:,.2f}, slip shows ₹{tds:,.2f} — diff ₹{tds_diff:.2f}") else: print(f" → ❌ FAIL (difference of ₹{tds_diff:.2f})") errors.append(f"TDS mismatch: calculated ₹{monthly_tds:,.2f}, slip shows ₹{tds:,.2f} — diff ₹{tds_diff:.2f}") print() # 8. Total Deductions total_ded_calc = pf_employee + professional_tax + tds + other_deductions check_ded = abs(total_ded_calc - total_deductions_stated) < 0.01 status = "✅ PASS" if check_ded else "❌ FAIL" print(f"Total Deductions (sum):") print(f" {pf_employee:,.2f} + {professional_tax:,.2f} + {tds:,.2f} + {other_deductions:,.2f}") print(f" Calculated : ₹{total_ded_calc:,.2f}") print(f" On Slip : ₹{total_deductions_stated:,.2f} → {status}") if not check_ded: errors.append(f"Total Deductions mismatch: calculated ₹{total_ded_calc:,.2f}, stated ₹{total_deductions_stated:,.2f}") else: ok.append("Total Deductions sum is correct ✅") print() # 9. Net Pay net_calc = gross_earnings_stated - total_deductions_stated check_net = abs(net_calc - net_pay_stated) < 0.01 status = "✅ PASS" if check_net else "❌ FAIL" print(f"Net Pay (Gross - Total Deductions):") print(f" ₹{gross_earnings_stated:,.2f} - ₹{total_deductions_stated:,.2f} = ₹{net_calc:,.2f}") print(f" On Slip : ₹{net_pay_stated:,.2f} → {status}") if not check_net: errors.append(f"Net Pay mismatch: calculated ₹{net_calc:,.2f}, stated ₹{net_pay_stated:,.2f}") else: ok.append("Net Pay = Gross - Deductions ✅") print() # 10. Annual CTC check # CTC = Annual Gross + Employer PF (12% of Basic × 12) employer_pf_annual = basic_salary * 0.12 * 12 annual_ctc_calc = annual_gross + employer_pf_annual check_ctc = abs(annual_ctc_calc - annual_ctc_stated) < 1.00 status = "✅ PASS" if check_ctc else "❌ FAIL" print(f"Annual CTC (Annual Gross + Employer PF):") print(f" Annual Gross : ₹{annual_gross:,.2f}") print(f" Employer PF (annual) : ₹{employer_pf_annual:,.2f}") print(f" Calculated CTC : ₹{annual_ctc_calc:,.2f}") print(f" On Slip : ₹{annual_ctc_stated:,.2f} → {status}") if not check_ctc: errors.append(f"Annual CTC mismatch: calculated ₹{annual_ctc_calc:,.2f}, stated ₹{annual_ctc_stated:,.2f}") else: ok.append("Annual CTC includes Employer PF correctly ✅") print() print("=" * 60) print("SUMMARY") print("=" * 60) print(f"\n✅ PASSED ({len(ok)}):") for item in ok: print(f" • {item}") if warnings: print(f"\n⚠️ WARNINGS ({len(warnings)}):") for w in warnings: print(f" • {w}") if errors: print(f"\n❌ ERRORS ({len(errors)}):") for e in errors: print(f" • {e}") else: print(f"\n✅ No critical errors found.") print("\n--- OTHER FLAGS (non-calculation) ---") print("⚠️ 'Other Deductions ₹1,985' has no description — must be labeled for visa use.") print("ℹ️ Pay Period image says '01 April 2026 – 30 April 2026' (30 days, correct).") print("ℹ️ PAN format HOYPB6293B — structurally valid (5L-4N-1L).") print("ℹ️ CIN U32500GJ2025PTC159907 — Gujarat Pvt Ltd 2025 registration, valid format.") EOF