B.Com Accounting Skills Checklist for Accounts Executive Jobs
A practical, portfolio-backed checklist covering journal entries, ledger posting, bank reconciliation, GST basics, Tally Prime, Excel, and month-end tasks — everything a B.Com fresher needs to land an accounts executive role.
By the SuperAccountant Editorial Team
Why Your B.Com Degree Alone Won't Get You the Job
You have your B.Com marksheet. You passed Financial Accounting, Cost Accounting, maybe even Auditing. But the HR person screening your CV for an Accounts Executive position doesn't care about your marks — they want to know what you can do on Day 1.
That gap between "studied accounting" and "can do accounting" is exactly why freshers with similar marks have very different outcomes in interviews. The good news: the skills gap is specific and closeable. This checklist names every skill, explains what "good enough" looks like, and — crucially — tells you what output to build so you can prove it in an interview or on a task-based assessment.
Work through this list honestly. Tick what you can already demonstrate. Treat the rest as your study plan for the next four to six weeks.
Skill 1 — Journal Entries and the Double-Entry Foundation
What the job actually requires: An Accounts Executive at a small or mid-size firm posts 20–80 transactions a day. Errors compound fast, so your journal entries must be right the first time.
What "good enough" looks like:
- You can pass entries for cash purchases, credit sales, depreciation, salary payable, TDS deduction, and GST collected — without looking up the debit/credit rule each time.
- You understand why both sides of an entry must equal, and you can explain it to a non-accountant colleague.
Mini example: Your company buys stationery for ₹5,000 cash, paying GST at 18% (₹900 CGST ₹450, SGST ₹450):
| Account | Dr (₹) | Cr (₹) |
|---|---|---|
| Stationery Expense A/c | 5,000 | — |
| Input CGST A/c | 450 | — |
| Input SGST A/c | 450 | — |
| Cash A/c | — | 5,900 |
Portfolio output to build: A handwritten or Excel journal of 30 mixed transactions — cash, credit, GST, TDS, depreciation — with narrations. Show this in an interview.
Skill 2 — Ledger Posting and Trial Balance Preparation
What the job actually requires: After journal entries come ledgers. You need to post entries accurately, balance each account, and extract a trial balance that actually balances.
What "good enough" looks like:
- You can prepare ledger accounts for at least 10–15 heads: Sales, Purchases, Debtors, Creditors, Bank, GST Output, GST Input, TDS Payable, Salary, Rent.
- Your trial balance agrees — debit total equals credit total.
Mini example: If Sales A/c shows ₹3,20,000 on the credit side across a month, your trial balance must carry that ₹3,20,000 to the credit column. A one-paisa difference is enough to fail a practical test.
Portfolio output to build: A neatly formatted trial balance for a fictional small business (at least 15 accounts, one full month of data). Name it "Trial Balance — M/s ABC Traders — March 2025."
Skill 3 — Bank Reconciliation Statement (BRS)
This is the single most commonly tested skill in fresher accounting interviews. Almost every Accounts Executive role mentions BRS in the job description.
What the job actually requires: Match the company's Cash Book with the Bank Statement, identify timing differences (unpresented cheques, uncredited deposits), and pass adjustment entries where needed.
What "good enough" looks like:
- You can prepare a BRS from scratch when given a passbook and a cash book with four or five differences.
- You know why the closing balance in the two books can differ — and can explain it without sounding confused.
Mini example: Cash Book balance: ₹42,500 (Dr) Passbook balance: ₹39,200
Differences found:
- Cheque issued ₹4,800 not yet presented to bank
- Bank charged ₹500 service fee not yet entered in Cash Book
BRS (starting from Cash Book balance):
- Less: Bank charges not recorded — ₹500 → Adjusted Cash Book balance = ₹42,000
- Less: Unpresented cheque — ₹4,800 → Passbook adjusted balance = ₹37,200
(Note: in a full BRS, you reconcile both sides; this is a simplified illustration for the concept.)
Portfolio output to build: A reconciled BRS for one month — real or fictional — with the passbook and Cash Book data attached. This single document impresses 90% of hiring managers at the SME level.
Skill 4 — GST Basics Every Accounts Executive Must Know
India's Goods and Services Tax framework is non-negotiable for any accounting role. You don't need to be a GST consultant, but you must understand the daily transactional layer.
What the job actually requires:
- Distinguish CGST, SGST, and IGST (intra-state vs inter-state supply under Section 8 and 7 of the CGST Act respectively).
- Record Input Tax Credit (ITC) and Output Tax correctly.
- Know that ITC eligibility under Section 16(2)(c) of the CGST Act depends on the supplier filing their GSTR-1 and the amount reflecting in your GSTR-2B.
- Understand that GSTR-3B is the monthly self-assessed return and GSTR-1 reports outward supplies. The official CBIC portal at cbic-gst.gov.in is the primary reference for rates and notifications.
Mini example: Intra-state sale of ₹1,00,000 at 18% GST:
- CGST collected: ₹9,000
- SGST collected: ₹9,000
- Invoice total: ₹1,18,000
Inter-state sale of same goods:
- IGST collected: ₹18,000
- Invoice total: ₹1,18,000
Portfolio output to build: A set of 10 GST transactions — mix of purchases and sales, intra-state and inter-state — with correct CGST/SGST/IGST split, posted into a ledger. Label it your "GST Transaction Set."
Skill 5 — Tally Prime (The Software Skill That Opens Doors)
If you can use Tally Prime confidently, you are immediately employable at thousands of SMEs across India. It is the most widely used accounting software at the small and mid-market level.
What "good enough" looks like:
- Create a company, set financial year, enable GST.
- Create ledgers under correct groups (Sales under Sales Accounts, TDS Payable under Current Liabilities, etc.).
- Pass vouchers: Payment, Receipt, Journal, Sales, Purchase.
- Generate a Trial Balance, Profit & Loss, and Balance Sheet from the software.
- Pull a GSTR-1 or GSTR-3B report from Tally Prime's compliance module.
Common fresher mistake: Knowing the theory of Tally but never practising on actual data. Download the free educational version from the official Tally Solutions site and build a 30-day company yourself.
Portfolio output to build: Screenshots (or a screen recording) of a Trial Balance and a GST Summary Report generated from your practice company. Save these as a PDF.
Skill 6 — Excel for Accounting Tasks
Excel is not optional. Even firms that use Tally rely on Excel for analysis, MIS reports, and anything that needs a custom format.
Minimum skills for an Accounts Executive role:
| Excel Task | Why It Matters |
|---|---|
| SUM, SUMIF, SUMIFS | Totalling ledger data by category or date |
| VLOOKUP / XLOOKUP | Matching invoice numbers across two sheets |
| Pivot Tables | Month-wise sales or expense summary in seconds |
| Conditional Formatting | Highlighting overdue invoices or negative balances |
| Basic data validation | Preventing entry errors in shared workbooks |
| IF and nested IF | Flagging TDS applicable transactions |
Portfolio output to build: A month-end workbook with three sheets: (1) Raw transactions, (2) Pivot summary by expense head, (3) A simple MIS showing total sales, purchases, and gross margin. This is your "Month-End Workbook."
Skill 7 — Month-End Support Tasks
Accounts Executives don't just post daily entries — they support the month-end close. Knowing this process signals that you've thought beyond Day 1.
What the job actually requires:
- Reconcile debtor and creditor balances against invoices.
- Ensure all expense accruals and prepayments are posted.
- Confirm TDS payable is computed and ready for deposit by the 7th of the following month (as per Section 200 of the Income Tax Act 1961 — refer to incometax.gov.in for official due-date calendars).
- Support preparation of the monthly P&L for management review.
- File or assist in filing GSTR-3B on time (20th of following month for most taxpayers).
Portfolio output to build: A one-page month-end checklist document — your name, the fictional company name, and a tick-box list of 10–12 close tasks with dates. It signals process thinking.
Your Complete Portfolio Checklist at a Glance
Before you walk into an interview — or submit a task-based assessment — make sure you can produce or demonstrate each of these:
- ✅ Journal of 30 mixed transactions (cash, credit, GST, TDS, depreciation)
- ✅ Trial balance for a fictional business (minimum 15 accounts, one month)
- ✅ Bank Reconciliation Statement (one month, with passbook and Cash Book data)
- ✅ GST Transaction Set (10 transactions, correct CGST/SGST/IGST split)
- ✅ Tally Prime screenshots: Trial Balance + GST Summary Report
- ✅ Excel Month-End Workbook (raw data → pivot summary → MIS sheet)
- ✅ Month-End Close Checklist (10–12 tasks with due dates)
Seven documents. That's your portfolio. Most freshers applying for the same role have zero demonstrable outputs. You'll stand out immediately.
Preparing for the Accounts Executive Interview
Knowing the skills is half the battle. Communicating them confidently is the other half.
Three questions you will almost certainly be asked:
-
"Walk me through how you would do a bank reconciliation." — Describe the process step by step: compare Cash Book to passbook, list differences, adjust for bank charges and direct deposits, confirm closing balances agree.
-
"What is the difference between CGST and IGST?" — Intra-state supplies attract CGST + SGST in equal halves. Inter-state supplies attract IGST at the full rate. Both are governed by the CGST Act and IGST Act respectively.
-
"Have you worked on Tally?" — Even if your experience is only self-practice, name the specific tasks you performed: creating ledgers, passing purchase vouchers, generating a Trial Balance.
If you want to benchmark yourself against real accounts executive vacancies, the SuperAccountant Jobs board lists current openings so you can read actual JDs and map them back to this checklist.
Also worth exploring: if you want structured practice with feedback rather than self-study, the SuperAccountant cohort programme takes you through exactly these practical skills with worked problems and mock assessments — designed specifically for B.Com and CA Inter students.
A Realistic Four-Week Action Plan
Week 1: Journal entries and ledger posting. Build your 30-transaction journal and trial balance. No software yet — do it in Excel or by hand first.
Week 2: Bank reconciliation and GST transactions. Create your BRS and GST Transaction Set. Focus on getting the CGST/SGST/IGST split right every single time.
Week 3: Tally Prime. Download the software, build your practice company, post the same 30 transactions, and extract reports. Take screenshots.
Week 4: Excel workbook and interview practice. Build the Month-End Workbook. Run through the three interview questions above with a friend or record yourself.
By the end of Week 4, you have a seven-piece portfolio and clear answers to the most common interview questions. That is a meaningful, measurable improvement over where most B.Com freshers start.
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.