Tally Prime & Excel Skills for Fresher Accountant Jobs
A sequenced practice roadmap showing B.Com and M.Com freshers exactly which Tally Prime and Excel tasks to master — with real examples — before applying for entry-level accountant roles in India.
By the SuperAccountant Editorial Team
You have a B.Com degree (or you're almost there), you can write a journal entry in your sleep, but every job posting says "must know Tally Prime and Excel" — and you have no idea which features actually matter on day one. This post turns that vague requirement into a concrete, week-by-week practice list you can actually tick off.
Why Employers Keep Writing "Tally + Excel" in Every Job Description
Walk into any small or mid-sized firm in India — a CA's office, a trading company, an e-commerce seller — and you will find one Tally screen and one Excel sheet open side by side. Tally Prime handles the books of account, generates GST returns, and prints balance sheets. Excel handles the analysis, the reconciliations, and the data the boss wants formatted in a way Tally can't produce by default.
Neither tool alone is enough. That is why "Tally Prime and Excel skills for fresher accountant jobs" appears on hundreds of job boards every single week. The good news: both tools have a short, learnable core that covers 80 % of what a fresher will actually do in the first six months.
The Core Tally Prime Skills Every Fresher Must Practise
Think of Tally Prime as a structured data-entry system built on five building blocks: Company Creation → Ledgers → Vouchers → GST Configuration → Reports. Master these five in order and you will handle the daily work of most entry-level roles.
1. Company Creation and Ledger Setup
Create a sample company — say, "Ravi Traders" with a financial year starting 1 April 2025. Set the currency to INR. Now create ledgers:
- Sundry Debtors group for a customer "Mehta Enterprises"
- Sundry Creditors group for a supplier "Singh Suppliers"
- GST Output (18 %) under Duties & Taxes
- GST Input (18 %) under Duties & Taxes
- Bank Account for "HDFC Current A/c"
This five-ledger exercise teaches you that every transaction in Tally flows through a ledger, and every ledger sits in a group that determines where it appears in the final accounts.
2. Voucher Entry — The Daily Bread
Vouchers are where your textbook journal entries become Tally entries. Practice these six voucher types:
| Voucher Type | Shortcut | Real Example |
|---|---|---|
| Payment | F5 | Paid ₹12,000 rent via NEFT to landlord |
| Receipt | F6 | Received ₹50,000 from Mehta Enterprises |
| Contra | F4 | Transferred ₹20,000 from cash to HDFC bank |
| Sales | F8 | Sold goods worth ₹1,00,000 + 18 % GST to Mehta |
| Purchase | F9 | Bought goods worth ₹60,000 + 18 % GST from Singh |
| Journal | F7 | Depreciation entry for the year |
Practise each one at least ten times with made-up but realistic numbers. Speed matters in a real job — employers sometimes ask you to demonstrate data entry live during the interview.
3. GST Configuration in Tally Prime
This is the single skill that separates a job-ready fresher from one who is still studying. Under F11 (Features) → GST, enable GST for your company and set the state (say, Maharashtra, GSTIN: 27AABCR1234M1Z5 — a fictitious example). Then:
- Tag each ledger with the correct GST nature (intra-state or inter-state).
- Record a B2B Sales voucher: sell ₹1,00,000 of goods to a registered buyer in Maharashtra. Tally should auto-split the tax as CGST ₹9,000 + SGST ₹9,000 (both at 9 % under Section 9 of the CGST Act, 2017).
- Record the same sale to a buyer in Karnataka — Tally should post IGST ₹18,000 instead (Section 5, IGST Act, 2017).
- Generate GSTR-1 from Gateway → Display More Reports → GST Reports. Cross-check the B2B outward supply figures.
Understanding why CGST/SGST versus IGST matters — not just how to click the button — is what interviewers probe.
4. Bank Reconciliation in Tally Prime
Go to Banking → Bank Reconciliation, load your HDFC ledger, and manually clear each entry against an imaginary bank statement. This is a daily task in most accounting jobs and takes five minutes to learn but impresses interviewers who see many freshers skip it entirely.
The Excel Skills That Actually Come Up on the Job
You do not need to know VBA macros or pivot charts on day one. You need to be fast and accurate with the following:
Must-Know Functions for Accounting Work
- VLOOKUP / XLOOKUP — Match invoice numbers across two sheets. Example: match a column of 200 invoice numbers from Tally's export against a column in the bank statement to find unreconciled entries.
- SUMIF / SUMIFS — Total sales by state or by GST rate. Example:
=SUMIF(C2:C200,"Maharashtra",E2:E200)sums all sales where the state column says Maharashtra. - IF with nested conditions — Flag invoices where tax charged does not match the expected rate.
- TEXT and DATE functions — Convert Tally-exported dates (which sometimes land as text) back to date format so sorting works.
- Conditional Formatting — Highlight duplicate invoice numbers in red. Auditors love this; it shows you think about data quality.
The Two Sheets Every Fresher Should Build as Portfolio Pieces
-
GST Reconciliation Sheet: Import a GSTR-2B (available from the GST portal at gstin.gov.in) and your purchase register. Use VLOOKUP to flag invoices in the purchase register that are missing from GSTR-2B — a critical check under Section 16(2)(c) of the CGST Act before claiming input tax credit.
-
Trial Balance Checker: Export a trial balance from Tally to Excel. Use a SUM formula to verify that total debits equal total credits. Add a cell that shows "BALANCED ✓" in green or "MISMATCH ✗" in red using conditional formatting. It is simple, but it shows you understand what a trial balance is for.
Save both sheets in a folder called "Accounting Portfolio" and mention them in your CV. Most freshers have no portfolio whatsoever — this alone sets you apart.
A Six-Week Practice Roadmap
Here is the sequenced plan — do this alongside your college work or exam preparation:
Week 1–2: Tally Foundations Create three sample companies (a trader, a service firm, a manufacturer). Record 20 vouchers of each type. Generate a Trial Balance and a Profit & Loss report. Check that they balance.
Week 3: GST in Tally Enable GST. Record intra-state and inter-state sales. Generate GSTR-1 and cross-check the figures manually. Record a purchase and verify the input tax credit ledger.
Week 4: Excel Foundations Build the GST Reconciliation Sheet and the Trial Balance Checker described above. Practice VLOOKUP on 100-row sample data until you can write the formula without looking it up.
Week 5: Integration Practice Export Tally data to Excel (use Export → Excel from any report screen in Tally Prime). Clean the exported data — fix date formats, remove blank rows — using Excel functions. This is a real daily task.
Week 6: Speed and Accuracy Drills Time yourself entering 30 mixed vouchers in Tally in under 20 minutes. Time yourself building a SUMIFS summary table in Excel from raw data in under 10 minutes. These are realistic job targets.
If you want to track your progress against a structured curriculum — and get feedback on where your gaps actually are — explore the SuperAccountant cohort programme, which covers exactly these practical skills alongside the exam theory.
What to Say in an Interview (and What Not to)
Interviewers for fresher accountant roles ask three things about software: "Have you used it?", "Show me", and "What do you do when something doesn't reconcile?"
- Do say: "I have practised GST-enabled voucher entry in Tally Prime, generated GSTR-1 reports, and built a reconciliation sheet in Excel using VLOOKUP and SUMIF."
- Do not say: "I have done a Tally course" with no specifics. Every candidate says this.
- For the reconciliation question: walk through the logical steps — check for duplicate entries, check for date mismatches, check whether the supplier has filed their own returns (visible on the GST portal). This shows you understand process, not just software.
Also be ready to demonstrate on-screen. Keep your sample company file on a USB drive or in cloud storage so you can open it on any machine.
Building a CV That Proves These Skills
Your CV's skills section should list specifics, not generics:
Weak: "Proficient in Tally and MS Excel"
Strong: "Tally Prime: GST-enabled voucher entry (B2B/B2C), GSTR-1 generation, bank reconciliation. Excel: VLOOKUP, SUMIF, SUMIFS, conditional formatting, Tally data export and cleaning."
Add a one-line note: "Maintained a sample-company practice portfolio covering six weeks of daily entries." Hiring managers notice this because it signals self-discipline — a trait that is genuinely rare in freshers.
You can also look at current entry-level accountant job listings to see exactly which skills are appearing most often in real postings right now, and adjust your practice priorities accordingly.
The Honest Reality About Getting That First Job
The job market for fresher accountants in India is competitive but not impossible. The candidates who get shortlisted fastest are not necessarily the ones with the best theory marks — they are the ones who can sit down at a computer and do the work without hand-holding. Tally Prime is learnable in a few focused weeks. Excel's accounting-relevant subset is even smaller. The gap most freshers have is not knowledge — it is practice with real numbers under time pressure.
Start with the six-week roadmap above. Build the two portfolio sheets. Time yourself. Then apply.
If you're not sure where to start, take SuperAccountant's free 10-minute quiz at https://app.superaccountant.in/en/quiz?utm_source=blog&utm_medium=cta&utm_campaign=students — it places you at the exact phase of our curriculum that matches your current level, so you stop revising what you already know.