Tally Prime & Excel Skills for Fresher Accountant Jobs India
A task-by-task breakdown of every Tally Prime and Excel skill that hiring managers actually test in B.Com accounting interviews — with a simulated company workflow, salary benchmarks, and a ready-to-use checklist.
By the SuperAccountant Editorial Team
You Passed B.Com. Now Prove You Can Actually Work in Tally
Here is the hard truth that placement cells rarely say aloud: the gap between a B.Com degree and a ₹15,000–₹22,000/month entry-level accounting offer is not your knowledge of accounting theory — it is your inability to demonstrate a complete end-to-end workflow inside Tally Prime and Excel on the day of the interview. Hiring managers at mid-sized manufacturing firms, trading companies, and CA offices are not testing whether you know the definition of a contra voucher; they are asking you to create one, reconcile it, and extract a report in under three minutes.
This post maps every repeating task in current B.Com accounting vacancies to the exact Tally Prime feature and Excel skill required, walks you through a single simulated company to practise on, and closes with interview questions you should be ready to answer cold.
What Fresher Accounting Job Descriptions Actually Ask For
Scan fifty current accounting vacancies on Naukri, LinkedIn, or the SuperAccountant jobs board and a consistent pattern emerges. The responsibilities column almost always contains some combination of the following:
- Day-to-day voucher entry (sales, purchase, receipt, payment, contra, journal)
- Ledger creation and maintenance under correct accounting groups
- Bank reconciliation statement (BRS) preparation — weekly or monthly
- Debtors / creditors ageing and follow-up MIS
- GST computation — GSTR-1 data preparation, GSTR-3B cross-check
- TDS deduction and Form 26Q working
- Excel MIS reports for management — P&L summary, outstanding statements
The skills column, almost without exception, lists: Tally Prime (mandatory), MS Excel (mandatory), and sometimes Zoho Books or SAP as a plus. Everything else — good communication, team player — is filler. Fix Tally and Excel first.
The Simulated Company: How to Practise Like a Professional
Generic Tally tutorials teach you where the buttons are. What they rarely do is drop you inside a running company and ask you to handle a full month. Here is how to build that experience yourself.
Create a practice company in Tally Prime called Sunrise Trading Co. Pvt. Ltd. — a fictional B2B electronics distributor based in Hyderabad, registered under GST (GSTIN format: 36AAAXX0000X1ZX), turnover ₹3.2 crore per year. Now work through these tasks in sequence:
- Create ledgers: Set up party ledgers for five suppliers (under Sundry Creditors) and five customers (under Sundry Debtors). Assign correct GST registration types and state codes.
- Enable GST in Tally Prime: Go to F11 → GST and activate it with your GSTIN. Set tax rates for your stock items (18% GST on electronics).
- Record a sales invoice: Raise a tax invoice for ₹50,000 (+ 18% GST = ₹9,000 IGST, assuming interstate supply) using the Sales Voucher (F8) with the correct party, stock item, and narration.
- Record a purchase bill: Enter a ₹30,000 purchase from a supplier, claiming Input Tax Credit (ITC) under Sec 16(2)(c) of the CGST Act, 2017 — the section that ties ITC eligibility to the supplier filing their return.
- TDS entry: Record a ₹20,000 professional fee payment with 10% TDS under Sec 194J of the Income Tax Act, 1961. In Tally Prime, enable TDS in F11 → TDS, create the TDS ledger under Duties & Taxes, and verify the deduction appears in the TDS Reports menu.
- Bank reconciliation: Enter five bank transactions, then go to Banking → Bank Reconciliation and match them against a fabricated bank statement. Flag one uncleared cheque.
- Generate GST reports: Pull the GSTR-1 report and GSTR-3B working from Gateway → GST Reports. Cross-verify output tax with the sales register.
Completing this circuit even once — not watching it on YouTube, but doing it with your own keystrokes — moves you from "I know Tally" to "I have worked in Tally."
Tally Prime Skills Checklist: What Gets You Hired
Use this checklist before every interview. If any item has a cross next to it, that is your revision priority for the week.
| Skill Area | Specific Task | Interview Test Likelihood |
|---|---|---|
| Voucher Entry | All 8 voucher types (F4–F10 + Memo) | Very High |
| Ledger Management | Create ledger under correct group | Very High |
| GST Compliance | Sales invoice with CGST/SGST split | Very High |
| GST Compliance | GSTR-1 / GSTR-3B report extraction | High |
| TDS | Deduction entry under Sec 194C / 194J | High |
| Banking | BRS via Banking → Bank Reconciliation | High |
| Reports | Balance Sheet, P&L, Trial Balance | Medium |
| Inventory | Stock item creation, godown allocation | Medium |
| Payroll | Basic salary voucher (small firms) | Low |
| Data Export | Export reports to Excel / PDF | Medium |
You can take a free skills diagnostic mapped to exactly these checkpoints at SuperAccountant's quiz — it gives you a gap report in under ten minutes.
Excel Skills for Entry-Level Accounting Jobs in India
Excel is not a "bonus" skill. At firms below ₹100 crore turnover — which is the majority of India's employer base — the monthly MIS report that the owner reads on Monday morning was built by the junior accountant in Excel on Sunday evening. Here are the functions and workflows that appear in actual assessments:
Must-know functions:
VLOOKUP/XLOOKUP— match party names from Tally export against payment trackerSUMIF/SUMIFS— total GST payable by tax rate or by monthIFand nestedIF— flag overdue invoices beyond 30 / 60 / 90 daysTEXTandDATEfunctions — format invoice dates for GSTR-1 uploadPIVOT TABLE— convert a raw ledger export into a vendor-wise payables summary in two minutes
Practical tasks to practise:
- Export a Tally ledger to Excel. Use
SUMIFto calculate total purchases from each supplier. - Build a debtors ageing report: bucket outstanding amounts into 0–30, 31–60, 61–90, and 90+ day columns using
IFformulas. - Create a GST working sheet with output tax, input tax, and net payable — formatted well enough to hand to a CA directly.
- Use conditional formatting to highlight any invoice above ₹2,50,000 (TDS applicability threshold under most sections).
Firms like Deloitte's business process outsourcing units and mid-market CA firms in Chennai, Pune, and Hyderabad routinely screen candidates with a fifteen-minute Excel test before the personal interview. Practise under timed conditions.
GST and TDS Documentation: The Compliance Layer Nobody Prepares For
Knowing where to click in Tally Prime is half the job. Understanding why is what separates candidates who get confirmed after probation from those who do not.
GST essentials for freshers:
- A B2B sales invoice must contain the supplier's GSTIN, HSN/SAC code, tax rate, and place of supply — all mandatory under Rule 46 of the CGST Rules, 2017.
- ITC can only be claimed when the supplier's invoice appears in your GSTR-2B (auto-populated from the supplier's GSTR-1). Always cross-check before filing GSTR-3B. The official portal for this is cbic-gst.gov.in.
- E-invoicing is mandatory for businesses above ₹5 crore turnover (as per the applicable CBIC notification threshold). If your employer crosses this limit, you will need to generate an IRN and QR code via the IRP portal before the invoice is valid.
TDS essentials for freshers:
- TDS deducted in a month must be deposited by the 7th of the following month (except March — due by 30th April) as per the Income Tax Act, 1961.
- Form 26Q (non-salary TDS) is filed quarterly. Errors here attract interest under Sec 201(1A) and late-filing fees under Sec 234E.
- Always cross-check deposited TDS at incometax.gov.in under View Form 26AS / AIS before issuing TDS certificates.
Being able to explain these compliance points in an interview — not just click through a Tally screen — is what makes a ₹18,000 offer become a ₹22,000 offer.
Salary Benchmarks and Realistic Expectations for Freshers
Let us be direct about numbers. Based on publicly listed vacancies across Naukri and LinkedIn in 2024–25:
- Junior Accountant / Accounts Assistant (fresher, B.Com): ₹12,000–₹18,000/month in Tier-2 cities; ₹18,000–₹25,000 in metros
- Accounts Executive with Tally + GST: ₹20,000–₹28,000/month after 6–12 months experience
- CA firm article/audit assistant (non-articleship): ₹10,000–₹15,000/month but extremely high learning density
- MNC BPO / finance shared services (Deloitte USI, KPMG Global Services, Genpact): ₹22,000–₹30,000 for P2P / O2C roles requiring Excel-heavy MIS
A ₹14,000/month offer from a manufacturing firm in Coimbatore or Surat is not an insult — it is the entry point for two years of practical experience that makes you competitive at ₹30,000+. Do not reject it without calculating the learning value.
If you want to benchmark your current skill level against what employers are actually asking for, the SuperAccountant cohort programme runs structured, task-based training across Tally Prime, Excel, GST, and TDS — with assessments and work samples you can show at interviews.
Five Interview Questions You Must Answer Without Hesitation
- "Walk me through how you would record a purchase return in Tally Prime." — Use Debit Note (Alt+F5). Explain that it reverses ITC claimed on the original purchase.
- "What is the difference between CGST+SGST and IGST? When does each apply?" — Intrastate supply attracts CGST + SGST (split 50:50 of the applicable rate); interstate supply attracts IGST at the full rate.
- "How do you reconcile a bank statement in Tally Prime?" — Banking → Bank Reconciliation → select bank ledger → match transactions → enter bank date for cleared items.
- "In Excel, how would you flag all invoices overdue by more than 60 days?" —
=IF((TODAY()-invoice_date)>60,"Overdue","OK")combined with conditional formatting. - "What happens if you miss the TDS deposit deadline?" — Interest at 1.5% per month under Sec 201(1A) from the date of deduction to the date of deposit, plus late-filing fee under Sec 234E at ₹200 per day up to the TDS amount.
Practise answering these aloud, in under ninety seconds each, until they feel automatic.
Browse current openings curated for new accounting graduates at https://app.superaccountant.in/en/jobs?utm_source=blog&utm_medium=cta&utm_campaign=graduates — we list both India and KSA roles, with filters by location and required skills, so you can apply where you actually fit.