BillBuddy | Salary Module — TheWealthBuddy

Upload Monthly Salary Sheet

Upload an Excel (.xlsx) file with one row per employee. BillBuddy will auto-detect columns, map names to Tally ledgers, and calculate PF/ESIC/Net.

Salary Period

Default PF Employer %

Default ESIC Employer %

📊

Click to upload .xlsx or drag and drop

Expected columns: Name, Emp Code, Tally Ledger, Gross, Basic, HRA, Allowances, LOP, PF Emp, PF Er, ESIC Emp, ESIC Er, PT, TDS, Advance, Advance Ledger, Security, Security Ledger, Net. Per-person ledger columns are optional — if blank, BillBuddy uses the default from Statutory Ledger Mapping.

⬇ Download Template

⚙️ Statutory Ledger Mapping (set once, reused every month)

Type or pick the Tally ledger name for each line below. These are saved in your browser and used automatically when generating the Tally JV.

Salary & Wages (Dr • Indirect Expenses)

Employer PF Contribution (Dr • Indirect Expenses)

Employer ESIC Contribution (Dr • Indirect Expenses)

PF Payable — Emp + Er combined (Cr • Duties & Taxes)

ESIC Payable — Emp + Er combined (Cr • Duties & Taxes)

Professional Tax Payable (Cr • Duties & Taxes)

TDS on Salary Payable (Cr • Duties & Taxes)

Employee Advance (recovered) (Cr • Loans & Advances)

Employee Security Deposit (Cr • Current Liabilities)

Salary Payable (consolidated) (Cr • Current Liabilities)

💡 Accounting used in JV: Dr Salary & Wages (gross) + Dr Employer PF + Dr Employer ESIC → Cr each employee's net (or Salary Payable) + Cr PF Payable (Emp+Er) + Cr ESIC Payable (Emp+Er) + Cr PT + Cr TDS + Cr Advance + Cr Security Deposit.

Review Salary Rows

Verify employee → ledger mapping. green = matched in Tally, orange = new employee, red = needs attention.

Rows

Total Gross

₹0

PF (Emp+Er)

₹0

ESIC (Emp+Er)

₹0

Deductions

₹0

Net Payable

₹0

#	Employee Name	Tally Ledger	Gross	Basic	HRA	Allow.	LOP	PF Emp	PF Er	ESIC Emp	ESIC Er	PT	TDS	Adv.	Advance Ledger	Security	Security Ledger	Net	Match

Upload Monthly Salary Sheet

⚙️ Statutory Ledger Mapping (set once, reused every month)

Review Salary Rows

Downloads (generated after Save & Post)

Employees Master

Salary Runs History