Mastering Excel for Accounting & GST Billing in West Bengal
Accounting & Billing-e Excel Keno Oporiharjo?
Tally Prime ba Marg ERP software thakleo, protiti business organization ebong CA firm-e data analysis, custom invoicing, audit reconciliation ebong tax reporting-er jonno MS Excel shobcheye beshi bebohar hoy.
West Bengal-er dharabahik babsaye GST compliance ebong bill calculation-er dorkare Excel-er kichu practical application niche alochona kora holo:
1. Automated GST Invoice Template in Excel
Ekta automated invoice toiri korte amader je formula gulo dorkar hoy:
- Taxable Value:
=Quantity * Rate - Discount Calculation:
=Taxable_Value * (Discount% / 100) - Intra-State Supply (West Bengal to West Bengal):
- CGST (9%):
=Taxable_Amount * 9% - SGST (9%):
=Taxable_Amount * 9%
- CGST (9%):
- Inter-State Supply (West Bengal to other State):
- IGST (18%):
=Taxable_Amount * 18%
- IGST (18%):
- Round Off Formula:
=ROUND(Subtotal + Taxes, 0) - (Subtotal + Taxes)
2. Reconciling GSTR-2B with Purchase Register
GST input tax credit (ITC) claim korar somoy GSTR-2B portal portal download kore nijer Tally purchase book-er sathe milano khub-i guruttwopurno. Ei kajti 5 min-e kora jay Excel diye:
- Both sheets-e Supplier GSTIN + Invoice Number concatenate kore Unique Key toiri korun:
=A2&"_"&B2 VLOOKUPbaXLOOKUPuse kore GSTR-2B theke Purchase book-er sathe Taxable Value compare korun:=IFERROR(VLOOKUP(UniqueKey, GSTR2B_Range, 5, FALSE), "Not in Portal")
- Difference cell toiri korun:
=Books_Tax - Portal_Tax. Conditional formatting diye difference thakle Red highlight korun.
3. Bank Reconciliation Statement (BRS) Automation
Bank passbook ebong cashbook ledger reconcile korte SUMIFS ebong COUNTIF bebohar kore un-cleared cheques ebong direct deposits ber kora hoy.
4. Salary Sheet & Payroll with West Bengal PTax
Employee salary register toiri korte basic salary, HRA, DA, PF (12%), ESI (0.75%) ebong WB Professional Tax (PTax slab) automate kora hoy VLOOKUP(Salary, PTax_Slab_Table, 2, TRUE) diye.
🎓 Join Our Tally Prime & Advanced Excel Combined Course
Pragati Skill Academy-te amra Tally Prime with GST-r sathe complete Excel Accounting project hands-on shikhiye thaki. Ramnagar campus-e admission nite phone korun 8016363962 e.
Official Course Study Notes & Practice Materials
Pragati Skill Academy provides complete chapter-by-chapter curriculum notes, 195+ solved MCQs, formula cheat sheets, and practical lab assignments with recognized government certifications.