S&P — Articles
Double-click a card to view & edit full details
Monthly Payroll
Yellow cells are editable. All other values auto-calculate from your employee master and uploaded leave/reimbursement data.
For Articles: stipend tiers apply automatically based on DOJ + test status. Leave ≤ 3 days/month is free; 4+ days deducts all.
S&P Articles
S&P Employees
Tiare Consilium Pvt Ltd
Upload Leave & Reimbursement Data
Files are mapped to the month selected above. Upload leaves and reimbursements for each month separately — data is stored per month and reflected in that month's payroll automatically.
📋 Leave Report Upload
Upload the filled Leave Upload Template. Column D (Leaves Taken) will be read for each employee by ID.
Click or drag Leave Template here
.xlsx / .csv accepted
💰 Reimbursement Upload
Upload the filled Reimbursement Template. Columns D (Reimbursement) and E (Arrears) will be read for each employee by ID.
Click or drag Reimbursement Template here
.xlsx / .csv accepted
Upload History
No uploads yet this session.
Exports & Downloads
Bank files are upload-ready. Amount column = Net Payable. Rows with missing bank details are highlighted red. Verify before uploading to your bank portal.
Export settings
Download templates (fill & upload)
S&P Bank Transfer File
Bank upload sheet for Sharma & Pagaria (Bank Code: SHAPAGA). NEFT / IFT format. Articles and Employees combined. Amount = Net Payable. Upload-ready.
Tiare Bank Transfer File
Bank upload sheet for Tiare Consilium Pvt Ltd (Bank Code: TIARECPT). Completely separate from S&P — never mixed. Amount = Net Payable. Upload-ready.
📧 Email Bank File to Bank
Mail S&P Bank File
Opens your mail client with the S&P bank file attached. Amount column is hidden in the attachment. No header row — data only.
Mail Tiare Bank File
Opens your mail client with the Tiare bank file attached. Amount column is hidden in the attachment. No header row — data only.
Miscellaneous
1 — Aggregate Leave Balance
Policy: 30 leaves / year · Opening → Used → Closing carried forward monthly
Policy: 30 leaves/year. Opening = leaves remaining at start of month (April opening = 30). Closing = Opening − Used this month. Click ✓ Save Balances after each month — closing becomes next month's opening automatically. LOP applies when used exceeds opening balance.
| # | Name | Entity | Opening Bal. | Used (This Month) | Closing Balance | Adjust |
|---|
2 — TDS, Arrears & Advance Deduction
Values entered here flow directly into the Payroll table and all salary sheet exports. TDS & Advance apply to Employees only. Arrears apply to all.
Sharma & Pagaria — Employees
| # | Name | Salary | TDS (₹) | Arrears (₹) | Advance Ded. (₹) | Net Impact |
|---|
Tiare Consilium Pvt Ltd — Employees
| # | Name | Salary | TDS (₹) | Arrears (₹) | Advance Ded. (₹) | Net Impact |
|---|
S&P Articles — Arrears only
| # | Name | Stipend | Test Status | Arrears (₹) | Net Impact |
|---|
Data — Backup & Restore
💾 Backup — Download your data
Downloads a single .json file containing everything — all 37 employees, bank details, every month's leave & reimbursement data, TDS figures, arrears, protect stamps, and leave balances. Save it to Google Drive, a pen drive, or email it to yourself. One file is all you need to restore on any machine.
Loading summary…
⬆ Restore — Load from backup file
Upload a backup .json file previously downloaded from this app. The system will show you exactly what's in the file before doing anything — you confirm, then it replaces all current data. This cannot be undone, so download a fresh backup first if you want to keep current data.
Click or drag backup .json file here
Only .json backup files from this app
Rules — Firm Policy Configuration
Changes here update the entire system immediately — all payroll calculations, leave deductions, and PT will use the new values from the next calculation onwards.
📋 Article Stipend Tiers
Months 0 to
Months
Month +
After this many months, test-based Tier 2 applies
Tenure-based promotion, no test needed
🖠Leave Policy
Leaves before full-month deduction kicks in
Annual limit — excess days are LOP
Excess deducted immediately each month
🛠Professional Tax
PT applies only above this salary
All months except February
February only (annual PT adjustment)
Accounts Utility
Breakdown by Entity
| Entity | Headcount | Gross Salary | Net Payable | TDS | Advance |
|---|
Professional Tax — Individual Breakdown
Salary figures are not shown. PT amounts only.
| # | Employee | Entity | PT (₹) |
|---|
🦠Bank Transfer Files
Amount column is hidden and password-protected in the Excel file. The bank can still process transfers — the data is present but not visible without the Partner password.