Course
Accountant — India Job-Ready
The books, GST, TDS, Tally Prime, Excel, and interview practice Indian employers actually test for a first accounts job. Working picture as of August 2026 — confirm live rates on the official portals before you file.
India · first accounting job · 12 units
Unit 1: Unit 1 — The India accounting job
Indian first-job titles are practical, not CA-syllabus titles. A typical JD for Accounts Executive / Junior Accountant / GST Executive / Tally Operator asks you to record day-books in Tally Prime, raise GST invoices, file GSTR-1 and GSTR-3B, deduct TDS, do bank reconciliation, and send the owner a weekly MIS. Freshers are hired on Tally + GST + Excel + a clean trial-balance, not on Ind AS 116. This course trains that job, then the interview.
Teach: what the first 90 days actually look like
Monday at Mehra Traders (a Pune trading company, ~₹8 Cr turnover): 1. Download the HDFC current-account statement and match it to Tally. 2. Record yesterday's sales invoices (GST 18% on most goods after GST 2.0). 3. Book the transporter bill; check whether 194C TDS applies. 4. Pull GSTR-2B and tick off purchase invoices that match. 5. Drop a one-page MIS to the owner: sales, collections, overdue debtors. That is the job. CA Intermediate theory helps later. The hire/no-hire decision is: can you keep books clean, not miss a GST due date, and explain a ₹12,400 difference on the bank rec without panicking.
Teach: how to read an Indian accounts JD
Translate keywords into proof you will show in the interview: • 'Tally Prime / Tally ERP 9' → name the vouchers you can pass (Sales, Purchase, Payment, Receipt, Contra, Journal, Debit/Credit Note). • 'GST returns' → GSTR-1 by the 11th (monthly), GSTR-3B by the 20th, ITC only after it appears in GSTR-2B. • 'TDS' → 194C/194J/192, deduct at credit or payment, deposit, then 26Q/24Q. • 'Finalisation' → trial balance → grouping → P&L + Balance Sheet. • 'MIS / Excel' → ageing, VLOOKUP/XLOOKUP, pivot of sales by HSN/party. Salary band (typical 2026 metro/tier-2 fresher): roughly ₹12k–₹25k/month for Tally+GST desks; CA-firm articleship is a different path. This course is the company / CA-firm executive desk, not the CA exam.
Exercises
- Decode this JD in 4 bullets — JD: 'Accounts Executive — Tally Prime, GST filing, TDS, BRS, MIS. B.Com preferred. 0–2 yrs.' Write the four weekly tasks you would claim you can already do, in employer language.
- CA firm vs company desk — Name two tasks that show up more in a CA firm and two that show up more on an in-house company accounts desk.
- Which document answers which question? — Match: (a) did we pay this vendor? (b) can we claim this ITC? (c) why is cash book ₹8,200 above the bank? (d) was TDS deducted on last quarter's contractor? — to bank statement / GSTR-2B / BRS workings / Form 26AS (or AIS).
Practice problems
- Rewrite your resume against one live Naukri/Internshala accounts JD
- List every document in a vendor payment file
- Shadow (or watch a walkthrough of) one GSTR-3B filing
Unit 2: Unit 2 — Debit, credit, and the golden rules
Every accounting entry has equal debit and credit. The accounting equation Assets = Liabilities + Capital (Equity) must stay true. Indian classrooms still teach the three golden rules (personal, real, nominal). Offices think in five types: asset, liability, equity, income, expense. You need both: golden rules to pass the interview oral, modern types to post in Tally without mixing ledgers.
Teach: five transactions, one equation
Mehra Traders starts the day with: Cash ₹50,000 + Stock ₹80,000 = Capital ₹1,30,000. 1. Owner introduces ₹20,000 cash → Dr Cash 20,000 / Cr Capital 20,000. Assets +20k, Capital +20k. 2. Buy goods ₹30,000 on credit from Patel Mills → Dr Purchases 30,000 / Cr Patel Mills 30,000. Expense up, liability up. 3. Sell goods (cost 18,000) for ₹25,000 cash → Dr Cash 25,000 / Cr Sales 25,000. (Costing/stock is a later unit; first-job books often use periodic inventory.) 4. Pay shop rent ₹8,000 → Dr Rent 8,000 / Cr Cash 8,000. 5. Receive ₹12,000 from a debtor → Dr Cash 12,000 / Cr Debtor 12,000. Asset form changes; total assets unchanged. After 1–4 (ignore 5's debtor opening): Cash = 50+20+25−8 = ₹87,000; Stock 80,000; Purchases 30,000; Rent 8,000; Sales 25,000; Patel 30,000; Capital 1,50,000. Debits = credits. That is the only pass/fail test.
Teach: golden rules vs Tally groups
Interview: 'What is the golden rule for a nominal account?' Answer: debit all expenses and losses, credit all incomes and gains. Rent is nominal → debit Rent. Tally: Rent sits under Indirect Expenses; Sales under Sales Accounts; Patel Mills under Sundry Creditors; Cash under Cash-in-Hand. The group decides where the number lands on the P&L or Balance Sheet. Common fresher bug: putting GST Input under Indirect Expenses. GST Input is an asset (or a current asset / duties & taxes control), not an expense. GST Output is a liability. Mixing those two destroys both your P&L and your GSTR-3B.
Exercises
- Classify and side — For each, say type (asset/liability/equity/income/expense) and whether an increase is debit or credit: Cash, Bank OD, Sales, Purchase return, Capital, GST Output, Salary, Furniture.
- Journal these three — Pass journal entries (no GST yet): (1) bought furniture ₹40,000 by cheque; (2) paid ₹5,000 cash to creditor Ramesh; (3) proprietor withdrew ₹3,000 cash for personal use.
- Find the missing credit — A voucher is: Dr Purchases 1,18,000 (goods 1,00,000 + CGST 9,000 + SGST 9,000). What is the credit side if the supplier invoice is on credit and GST is recoverable?
Practice problems
- Write golden rules from memory
- Take 10 household spends and journal them
- Open Tally 'Chart of Accounts' and name 8 default groups
Unit 3: Unit 3 — Journal, ledger, trial balance
The books of account are a pipeline. Journal (or day-book / voucher) is the first record. Ledger is the same data sorted by account. Trial balance lists every ledger's closing balance; total debits must equal total credits. A TB that tallies can still be wrong (wrong ledger, omitted entry that is omitted on both sides). A TB that does not tally is always unfinished work.
Teach: one week's books for Mehra Traders
Opening: Cash ₹20,000; Bank ₹80,000; Capital ₹1,00,000. 1 Apr Dr Bank 50,000 / Cr Cash 50,000 (cash deposited — Contra). 2 Apr Dr Purchases 40,000 / Cr Shah Traders 40,000. 3 Apr Dr Ritu Stores 25,000 / Cr Sales 25,000. 4 Apr Dr Shah Traders 15,000 / Cr Bank 15,000. 5 Apr Dr Cash 10,000 / Cr Ritu Stores 10,000. Cash ledger: 20,000 + 10,000 − 50,000 = Dr (overdrawn? wait) 20 + 10 − 50 = −20,000. You cannot have negative cash. This is the teaching bug on purpose: you would stop and check the 1 Apr contra. Correct 1 Apr if only ₹10,000 was meant to be deposited, or the opening cash was understated. Books that 'just post' without reading the cash ledger create ghost OD. Fix for the lesson: opening cash was ₹70,000. Then cash = 70−50+10 = ₹30,000 Dr. Bank = 80+50−15 = ₹1,15,000 Dr.
Teach: trial balance and the errors it will not catch
TB columns: ledger name | Dr | Cr. Include opening stock on Dr if you keep it as a ledger; include sales on Cr, purchases on Dr. Errors a tallied TB will NOT catch: • complete omission (sale never recorded); • posting to the wrong account of the same side (Rent posted to Stationery — both expenses); • compensating errors; • principle error (asset posted as expense). Errors it WILL catch: single-sided posting, transposition on one side, Dr/Cr swapped on one ledger only. Interview closer: 'TB is a check on arithmetic, not on truth.'
Exercises
- Post and close a creditor — Shah Traders: opening Cr ₹8,000; credit purchase ₹40,000; we paid ₹15,000 by bank; we returned goods ₹2,000. Closing balance?
- Build a mini TB — From: Capital 1,00,000; Cash 30,000; Bank 1,15,000; Purchases 40,000; Sales 25,000; Shah Traders 25,000; Ritu Stores 15,000; Drawings 0. List Dr and Cr columns. Do they tally? If not, what is missing?
- Which error is this? — A ₹9,000 purchase from Shah was posted to Shah's ledger as ₹9,000 and to Purchases as ₹90,000. TB difference? Error type?
Practice problems
- Write 8 journals and post them to T-accounts on paper
- Extract a TB from those T-accounts
- Name four errors a tallied TB will not catch
Unit 4: Unit 4 — Cash book and bank reconciliation
The cash book is our record of cash and bank. The passbook / bank statement is the bank's record. They disagree for timing reasons (cheques issued but not presented, cheques deposited but not cleared) and for items only the bank knows (charges, interest, ECS, direct credits). A Bank Reconciliation Statement (BRS) starts from one balance and walks to the other. Employers treat a clean monthly BRS as the #1 signal you can be trusted with money.
Teach: a full BRS from the cash book
Mehra Traders, 31 May. Bank column of cash book: Dr ₹1,42,800. Bank statement: ₹1,28,350 Cr (favourable). Findings: • Cheque issued to Shah ₹18,000 not yet presented. • Cheque deposited from Ritu ₹12,000 not yet cleared. • Bank charges ₹450 not in cash book. • Customer NEFT ₹4,000 credited by bank, not in cash book. • A cheque of ₹6,000 deposited earlier was returned (bounce); we had not reversed it. Start from cash-book ₹1,42,800: − uncleared deposit 12,000 + unpresented cheque 18,000 − bank charges 450 (if we treat them as already needing a book entry, the BRS-to-passbook walk subtracts them because books are higher) + NEFT 4,000 (bank is higher) − bounced 6,000 (books still think the money is in) 1,42,800 − 12,000 + 18,000 − 450 + 4,000 − 6,000 = 1,46,350. That does not yet equal 1,28,350 — so a real BRS would stop here and find the remaining ₹18,000 (often a second unpresented cheque already counted, or a date-cut error). The skill is the walk, not forcing the number. In the interview, show the walk and say what you would check next (another unpresented cheque, a stale entry). Teaching set that DOES tie (use this as the drill): Cash book 1,42,800; unpresented 18,000; uncleared 12,000; charges 450; NEFT 4,000; bounce 6,000. Passbook target = 1,42,800 −12,000 +18,000 −450 +4,000 −6,000 = ₹1,46,350. If the PDF says 1,46,350, you are done. If it does not, you do not invent a plug.
Teach: book the bank-only items, then BRS shrinks
After you see bank charges ₹450 and NEFT ₹4,000 on the statement: Dr Bank charges 450 / Cr Bank 450. Dr Bank 4,000 / Cr the customer (or Sundry debtors) 4,000. Dr the customer 6,000 / Cr Bank 6,000 for the bounce (and restart collection). Now those three items leave the BRS. Only timing items (unpresented / uncleared) remain. A BRS that still lists last month's bank charges means last month's books were never updated — a red flag in every audit and every interview.
Exercises
- Add or subtract from cash book? — Starting from a favourable cash-book balance, do you add or subtract to reach the passbook: (1) unpresented cheque (2) uncleared deposit (3) bank interest credited (4) ECS electricity the book missed?
- Compute the passbook balance — Cash-book bank Dr ₹86,000. Unpresented cheques ₹14,500. Uncleared deposits ₹9,200. Bank charges ₹300 not booked. Direct deposit by customer ₹5,000 not booked. What is the passbook balance?
- Overdraft BRS — Cash-book bank shows OD (Cr) ₹22,000. Unpresented cheques ₹7,000. Uncleared deposits ₹3,000. Passbook OD?
Practice problems
- BRS from your own UPI/bank PDF vs a handwritten cash book
- List last month's bank-only items and the journals they need
- Explain a bounce entry out loud in 30 seconds
Unit 5: Unit 5 — GST for the working accountant
GST is the daily tax on supplies of goods and services. After the 56th GST Council (3 Sep 2025), GST 2.0 is the working structure from 22 Sep 2025: a merit rate of 5%, a standard rate of 18%, and a special de-merit rate of 40% on notified luxury/sin goods. Older JDs still say '5/12/18/28' — know the history, file at the live rate on the invoice date. Intra-state supply splits into CGST+SGST; inter-state is IGST. Your job: tax invoice, e-invoice when applicable, e-way bill, ITC only when it appears in GSTR-2B, GSTR-1 (outward) by the 11th for monthly filers, GSTR-3B (summary + payment) by the 20th. Composition dealers are a different, simpler track.
Teach: one tax invoice, intra-state vs inter-state
Mehra Traders GSTIN 27AAAAA0000A1Z5 (MH). Sells packaged goods at the 18% standard rate. Invoice to a Pune customer (MH): taxable ₹10,000; CGST 9% = ₹900; SGST 9% = ₹900; invoice total ₹11,800. Place of supply = Maharashtra. Invoice to a Bengaluru customer (KA): taxable ₹10,000; IGST 18% = ₹1,800; total ₹11,800. Same burden, different ledger. Tally: party GSTIN decides the tax type if place of supply is set correctly. Wrong state on the party master is the #1 silent GSTR-1 error — the return will show IGST when the customer is next door. Mandatory invoice fields you must be able to list: supplier GSTIN + name/address, invoice no/date, customer GSTIN (if registered), HSN, taxable value, rate, tax break-up, place of supply, signature / IRN.
Teach: ITC, GSTR-2B, and the two returns
Input tax credit is the GST you paid on inward supplies that you set off against outward GST. Conditions (working set): you have a tax invoice, you received the goods/services, the supplier has filed and the credit appears in YOUR GSTR-2B, and the goods are for business (blocked credits: motor cars in many cases, personal use, composition purchases). Month-end walk: 1. Download GSTR-2B from the GST portal. 2. Tick every purchase invoice in Tally that matches 2B (GSTIN, invoice no, tax amount). 3. Unmatched invoices: do NOT claim ITC this month. Chase the vendor. 4. GSTR-1: upload B2B invoices (and B2C large / summary as required) by the 11th of the next month (monthly filer; QRMP taxpayers follow the IFF / quarterly GSTR-1 calendar — 13th of the month after the quarter). 5. GSTR-3B by the 20th (monthly). QRMP 3B is generally 22nd or 24th of the month after the quarter, by state group. 3B liability = outward tax − eligible ITC. Pay the net via the portal before you file. Filing without payment is how late-fee + interest start.
Exercises
- Raise the invoice — Sell goods worth ₹50,000 taxable to a registered dealer in the same state at 18%. Write taxable, CGST, SGST, total. Then the same sale to another state.
- How much ITC this month? — Purchases in Tally this month: Invoice A GST ₹18,000 (in 2B), Invoice B GST ₹7,200 (NOT in 2B), Invoice C GST ₹3,600 (in 2B but goods not yet received). Outward GST ₹40,000. What ITC do you claim in 3B, and what is the net payable?
- July 2026 compliance calendar — Mehra is a monthly filer. Name the due dates for July-2026 GSTR-1 and GSTR-3B, and one thing that must be finished before 3B.
- GST 2.0 vs old JD language — A 2024 textbook lists slabs 5, 12, 18, 28. What do you say in a 2026 interview about the live structure?
Practice problems
- Walk the GST portal (sandbox or a supervised login) to GSTR-2B
- Build an invoice checklist of mandatory fields
- Reconcile 10 purchase invoices to a dummy 2B sheet in Excel
Unit 6: Unit 6 — TDS the accounts desk actually deducts
TDS (Tax Deducted at Source) is income-tax you deduct when the company pays (or credits) certain sums, then deposit with the government. The payee claims the credit on 26AS / AIS. First-job sections: 192 (salary, slab rates), 194C (contractors — 1% individual/HUF, 2% others; threshold ₹30,000 single / ₹1,00,000 in the FY), 194J (professional 10%, technical/call-centre 2%; working threshold ₹50,000 per FY for FY 2025-26), 194Q (buyer of goods, 0.1% on purchases above ₹50 lakh when the buyer's prior-year turnover exceeds ₹10 Cr). Deduct at earlier of credit or payment. No PAN → generally 20%. From 1 Apr 2026 the Income-tax Act, 2025 restates these as a table under new section numbers; rates and thresholds were retained — employers will still say '194C' for years. Confirm on incometax.gov.in.
Teach: contractor bill under 194C
Mehra hires Rapid Logistics (a company) to move stock. Bill ₹80,000 + GST 18% = ₹94,400. Section 194C applies to the contractual amount, not to the GST if GST is shown separately (standard working practice: deduct on ₹80,000). Rate for a company contractor = 2%. TDS = ₹1,600. Net paid to Rapid = 94,400 − 1,600 = ₹92,800. Books: Dr Freight / Transportation 80,000 Dr CGST Input 7,200 / Dr SGST Input 7,200 (if intra-state and eligible) Cr Rapid Logistics 94,400 Then on payment: Dr Rapid 94,400 Cr Bank 92,800 Cr TDS payable 194C 1,600 Deposit ₹1,600 via income-tax e-pay / TIN, then include the line in quarterly 26Q. Rapid should see ₹1,600 in 26AS. If Rapid were an individual with a valid PAN and this was the only ₹80,000 job, rate is 1% = ₹800 — but the ₹30,000 single-payment threshold is already crossed, so you still deduct.
Teach: 194J vs 192 vs 'do not deduct'
CA firm invoice for statutory audit ₹60,000 + GST: 194J professional at 10% on ₹60,000 = ₹6,000 (threshold ₹50,000 crossed). Software AMC that is 'fees for technical services': 194J at 2%. Employee salary: 192, compute estimated annual tax under the regime the employee has chosen, deduct monthly. Not a flat %. Rent of machinery vs rent of land/building use different sections (194-I). Do not shove everything into 194C. Purchase of goods from a wholesaler when Mehra's turnover is ₹8 Cr (under ₹10 Cr): 194Q does not apply to Mehra as buyer. If next year turnover crosses ₹10 Cr, 194Q 0.1% starts on purchases from a seller above ₹50 lakh in that FY. Reimbursement of an actual expense with a third-party bill in the third party's name is often not TDS-able; a lump-sum 'out of pocket' without bills often is. When unsure, ask the senior — do not guess downward.
Exercises
- Compute 194C — Pay an individual contractor ₹45,000 (GST extra, shown separately). PAN available. First payment to him this FY. TDS? Net of tax on the ₹45,000?
- Advocate vs software support — Two bills, both ₹70,000 + GST, both PAN available: (1) advocate legal opinion (2) technical support described as FTS. TDS on each?
- Deduct or not? — Four cases: (a) stationery shop invoice ₹8,000; (b) individual painter ₹22,000 first job this year; (c) company contractor ₹22,000 but already paid ₹90,000 earlier this FY; (d) salary to staff.
Practice problems
- Build a one-page TDS rate card for 192 / 194C / 194J / 194Q
- Walk through a dummy 26Q line (PAN, section, amount, TDS)
- Open a sample 26AS and find the TDS credit row
Unit 7: Unit 7 — Payroll, PF, ESI, and the payslip
A payslip turns CTC into net pay. Indian statutory pieces you will meet on day one: EPF (employees' PF — typically 12% of PF wages from the employee and 12% from the employer; statutory wage ceiling ₹15,000 per month for the mandated 12% unless the company is voluntarily higher), ESI (0.75% employee + 3.25% employer on ESI wages, coverage generally up to ₹21,000 gross), Professional Tax (state-specific; Maharashtra is a common interview example), and TDS u/s 192 if estimated annual tax is positive. CTC is not take-home. Interviewers love asking you to walk CTC → net.
Teach: one payslip, numbers visible
Priya, accounts assistant, Pune. Monthly structure: Basic ₹15,000; HRA ₹6,000; Special allowance ₹4,000. Gross = ₹25,000. PF wages = Basic ₹15,000 (at the statutory ceiling). Employee PF 12% = ₹1,800. Employer PF 12% = ₹1,800 (of which a part is EPS — you do not need the EPS split to print a first-job payslip, but know it exists). ESI: gross ₹25,000 is above ₹21,000, so ESI usually does not apply this month if she is already out of coverage. If gross were ₹20,000 in a covered unit: EE 0.75% = ₹150; ER 3.25% = ₹650. PT (MH typical interview figure): often ₹200 in months above the slab (confirm the current MH chart — February is special in MH). TDS: estimate annual taxable salary, apply the regime she declared, divide by remaining months. For a ₹25k × 12 = ₹3.00 L gross with standard deduction, many new-regime freshers have nil 192 — still show the working. Net (no ESI, PT ₹200, nil TDS) = 25,000 − 1,800 − 200 = ₹23,000. CTC for the JD: 25,000 + employer PF 1,800 = ₹26,800 / month (plus ESI/gratuity if any). That is why CTC ads look bigger than cash.
Teach: journals the accounts desk passes on payday
Dr Salary expense 25,000 Dr Employer PF expense 1,800 Cr PF payable (EE+ER) 3,600 Cr PT payable 200 Cr Staff payable / Bank 23,000 (If you book salary at gross and statutory as deductions from a net-pay clearing account, stay consistent.) Deposit PF via the EPFO ECR by the due date (working interview answer: 15th of the next month — confirm live). ESI via the ESIC portal. PT per the state calendar. A missed PF payment is not a 'small delay'. It becomes interest, damages, and an interview story you do not want.
Exercises
- Compute net pay — Gross ₹18,000 (all ESI-eligible), PF wages ₹15,000, PT ₹200, nil TDS, covered ESI unit. Employee PF, ESI, PT, net?
- CTC vs take-home — Same person: employer PF ₹1,800, employer ESI ₹585. Monthly CTC? Why is the offer letter ₹2.44 LPA not what hits the bank?
- Does ESI apply? — Gross this month ₹21,500 in a covered factory. ESI this month? Why?
Practice problems
- Build a 5-employee payroll sheet (gross, PF, ESI, PT, net, CTC)
- Write the payday journal from that sheet
- Find the current EPFO ECR due date on epfindia.gov.in
Unit 8: Unit 8 — Tally Prime, every day
Tally Prime is the default books product in Indian MSMEs. You must create a company, enable GST, create ledgers under the right groups, and pass the six daily vouchers: Sales (F8), Purchase (F9), Payment (F5), Receipt (F6), Contra (F4), Journal (F7), plus Debit/Credit Note. GST masters (party GSTIN, state, registration type, HSN, tax ledgers) decide whether GSTR-1 comes out clean. Reports you will be asked to open in the interview: Day Book, Ledger, Trial Balance, Balance Sheet, Stock Summary, GST reports (GSTR-1 / GSTR-3B view).
Teach: GST sale voucher, click by click
Gateway of Tally → Vouchers → F8 Sales. Party: Ritu Stores (Sundry Debtors, state MH, GSTIN filled, regular). Sales ledger: Sales 18% (Sales Accounts, GST applicable, integrated tax 18% or CGST+SGST 9+9). Item or HSN: 18%. Qty / rate so taxable = ₹10,000. Tally fills CGST ₹900, SGST ₹900. Total ₹11,800. Accept. Open the invoice print: GSTIN, HSN, tax break-up must show. If tax is zero, the sales ledger or item is not GST-enabled — fix the master, do not type tax as a narration. Then Gateway → Display More Reports → GST → GSTR-1: the B2B section should list Ritu ₹10,000 + tax. That is the file you will upload.
Teach: the six vouchers in one afternoon
F4 Contra: cash deposited in HDFC ₹20,000. Dr Bank / Cr Cash. If you pass this as Payment, cash book still works but 'funds transfer' reports and bank-only views get noisy. F5 Payment: rent to landlord ₹8,000. Dr Rent / Cr Bank. Attach the UTR in narration. F6 Receipt: Ritu pays ₹5,000 NEFT. Dr Bank / Cr Ritu. F7 Journal: depreciation, provisions, TDS transfer — not daily cash. F9 Purchase: Patel Mills credit bill with GST. Dr Purchase + Input taxes / Cr Patel. Credit Note (Ctrl+F8): sales return. Debit Note: purchase return. Interview demo (they will watch you): create a dummy company, enable GST, pass one sale and one purchase, open TB. If you can do that in ten minutes, you are hireable.
Exercises
- Which voucher? — Pick voucher type: (1) cash withdrawn from bank for office; (2) credit sale; (3) electricity paid by UPI; (4) customer pays an old invoice; (5) year-end depreciation.
- Pick the group — Group for: HDFC Current A/c, Patel Mills (supplier), GST Input CGST, Freight inward, Drawings, Sales 18%.
- The GST is coming out at 0% — A sales voucher to a registered MH customer shows ₹10,000 and no tax. List four masters/settings you check, in order.
Practice problems
- Create a dummy Tally company and pass 10 mixed vouchers
- Export GSTR-1 from Tally and read the B2B sheet
- Open Stock Summary and Trial Balance without notes
Unit 9: Unit 9 — Excel the accounts desk cannot skip
Excel is how you reconcile Tally to the world: GSTR-2B, the bank CSV, the debtor ageing the owner asked for at 6 pm. You need filters, Freeze Panes, SUMIF/SUMIFS, XLOOKUP (or VLOOKUP), Pivot Tables, Text-to-Columns, TRIM/CLEAN, and a simple ageing formula. Pretty charts are optional. A 2B match that is wrong is not.
Teach: GSTR-2B vs Tally purchase match
Sheet 'Tally': columns GSTIN | InvNo | Taxable | CGST | SGST | IGST. Sheet '2B': the same headers from the portal export. In Tally, add Match: =XLOOKUP(A2&B2, '2B'!A:A& won't work as an array in older Excel — so make a helper key =A2&"|"&B2 on both sheets. Then =XLOOKUP(G2, '2B'!G:G, '2B'!D:D, "MISSING"). If MISSING → no ITC this month. If found but tax differs by more than ₹1 → flag 'AMOUNT MISMATCH' and open the PDF. SUMIFS on Tally tax where Match<>"MISSING" is your ITC working. That number is what you take to GSTR-3B, not the raw Tally GST total.
Teach: debtor ageing the owner understands
From Tally: outstanding bills with party, invoice date, amount. Days = =$H$1-C2 (H1 = statement date, not TODAY() if you are closing May). Bucket: =IFS(E2<=30,"0-30",E2<=60,"31-60",E2<=90,"61-90",TRUE,"90+"). Pivot: rows = Party, columns = Bucket, values = SUM of Amount. The 90+ column is the collection call list. Highlight it. This single sheet is the MIS most MSME owners actually read.
Exercises
- Write the SUMIFS — Sales table A:B:C = Party | HSN | Taxable. Total taxable of party "Ritu Stores" for HSN 8708?
- Find the 2B tax — Helper key is in Tally!G and 2B!G. You want CGST from 2B column D. Write an XLOOKUP that returns 0 if missing (not #N/A).
- Bucket one invoice — Statement date 31-Jul-2026, invoice 15-May-2026. Days and bucket?
Practice problems
- Rebuild a 2B match on 15 dummy rows
- Pivot a month of sales by party
- Age a 20-row debtor list and write a 4-line collection mail
Unit 10: Unit 10 — P&L, Balance Sheet, and owner MIS
The trial balance is regrouped into a Profit & Loss account (incomes − expenses = profit) and a Balance Sheet (assets = liabilities + capital). Indian MSME interviews still use the T-form / vertical statement, not a full Ind AS pack. You also owe the owner a one-page MIS: sales, gross margin, collections, overdue, cash, GST payable. Ratios they may ask: current ratio, gross margin %, debtor days.
Teach: TB to P&L to Balance Sheet
Mini TB (₹): Capital 2,00,000; Cash 30,000; Bank 70,000; Debtors 40,000; Creditors 25,000; Opening stock 50,000; Purchases 1,20,000; Sales 2,00,000; Rent 12,000; Salaries 18,000; Furniture 85,000. Closing stock (physical) ₹55,000. No other adjustments. COGS = 50,000 + 1,20,000 − 55,000 = 1,15,000. Gross profit = 2,00,000 − 1,15,000 = 85,000. Net profit = 85,000 − 12,000 − 18,000 = 55,000. Balance Sheet: Capital 2,00,000 + NP 55,000 = 2,55,000. Creditors 25,000. Total 2,80,000. Furniture 85,000; Stock 55,000; Debtors 40,000; Bank 70,000; Cash 30,000. Total 2,80,000. If the two sides do not meet, you dropped closing stock or the NP.
Teach: three numbers the owner asks every Monday
1) Sales this month vs last month (and vs the same month last year if you have it). 2) Cash + bank today, and GST/TDS/PF payable this week so they do not spend the tax money. 3) Debtors 90+ and the top three names. Optional fourth: gross margin %. If sales rose but margin fell, someone is discounting or purchase rates moved. Put it on one page. No 14-tab workbook. Interviewers for MSME roles will ask you to sketch this on paper.
Exercises
- Gross and net profit — Sales 5,00,000; opening stock 80,000; purchases 3,20,000; closing stock 70,000; wages (direct) 20,000; office rent 15,000. GP and NP?
- Current ratio and debtor days — Current assets 4,00,000; current liabilities 2,50,000; debtors 80,000; credit sales 9,60,000. Current ratio and debtor days (use 360 days)?
- Outstanding rent — Rent paid ₹12,000 is in the TB. One month (₹1,000) is still unpaid. What hits P&L, and what extra Balance Sheet line appears?
Practice problems
- Convert any tallied TB into P&L + BS on paper
- Draft a one-page Monday MIS for Mehra Traders
- Compute GP%, current ratio, debtor days on a dummy year
Unit 11: Unit 11 — Documents, e-invoice, e-way bill, month-end close
A working accountant is a document controller. Every rupee in Tally should point at a bill, UTR, or approved voucher. E-invoicing is mandatory for taxpayers whose aggregate turnover exceeded ₹5 Cr in any year since 2017-18 (working 2026 rule — B2B/export via the IRP, IRN + QR). E-way bill is generally required for inter-state movement of goods above ₹50,000; intra-state limits are state-notified (many ₹50,000, some ₹1,00,000). Month-end close is a calendar, not a mood: lock vouchers, BRS, 2B match, provisions, GST payment, PF/TDS deposits.
Teach: the document pack for one vendor payment
Before you click F5 Payment on Patel Mills ₹1,18,000: 1. Purchase invoice (GST tax invoice, not a delivery challan). 2. GRN / inward note or the warehouse tick that goods arrived. 3. 2B appearance if you already claimed ITC — or a note that ITC is waiting. 4. TDS working if 194C/194Q/194J applies. 5. Approval (email / WhatsApp from the owner is still an approval — save it). 6. UTR pasted in Tally narration after the bank pays. That pack is what an auditor, a CA senior, or a new boss will ask for. If any piece is missing, you are not 'almost done'.
Teach: a monthly close calendar (regular GST, monthly)
Working calendar (confirm live extensions every month): • Day 1–3: lock last month's Tally, finish BRS, stock count if any. • Day 3–8: 2B vs purchase match; chase missing vendor invoices. • By 7th: deposit previous month's TDS (usual due date). • By 11th: GSTR-1. • By 15th: PF ECR (confirm live). • By 20th: pay GST and file GSTR-3B. • Same week: 26Q/24Q if a quarter just ended (due dates are later in the following month — look up the quarter you are in). E-invoice: if Mehra crosses the ₹5 Cr AATO test, every B2B invoice goes through the IRP. You do not 'print first and IRN later' once the mandate applies — the IRN is the invoice. E-way bill: Pune → Bengaluru, goods ₹75,000 → e-way bill required (inter-state > ₹50,000). Pune local delivery of ₹20,000 → usually not.
Exercises
- E-way bill or not? — Need an e-way bill? (1) MH → KA, goods ₹80,000 (2) Pune local, ₹20,000 (3) MH → KA, ₹30,000 (4) MH intra-state ₹80,000 — what else do you check?
- Who must e-invoice? — Mehra AATO last year ₹6.2 Cr. A neighbour shop AATO ₹1.4 Cr. Who must generate IRN for a B2B sale in 2026, and what is the working threshold?
- Order the first 20 days — Put in order: GSTR-3B, BRS, GSTR-1, TDS deposit, 2B match.
Practice problems
- Write Mehra's month-end checklist with owners and due dates
- Assemble a dummy vendor payment file (6 documents)
- Read one live e-way bill / e-invoice FAQ on the government site
Unit 12: Unit 12 — Interview, resume, and the first 90 days
Accounts interviews in India are oral + a Tally/Excel screen + a few numericals. They will ask golden rules, BRS, GST due dates, a 194C working, and 'what reports do you use in Tally?'. Resume bullets must name tools and artefacts (GSTR-3B, BRS, 26AS), not 'hardworking B.Com'. The first 90 days are: learn their voucher numbering, close one month without a late fee, and send the Monday MIS without being asked twice.
Teach: 12 questions you will actually get
1. Golden rules / what is a real account? 2. Pass the entry: goods sold on credit with GST. 3. What is a BRS? Give two timing differences. 4. GSTR-1 vs GSTR-3B vs GSTR-2B. 5. Due dates for a monthly filer. 6. CGST/SGST vs IGST — when? 7. Can you claim ITC if the invoice is not in 2B? 8. 194C rates and thresholds. 9. CTC vs net pay, one example. 10. Which Tally voucher for cash deposited in bank? 11. How do you age debtors in Excel? 12. Tell me about a mistake you caught. Good answer shape for (7): 'No. ITC waits until it appears in my GSTR-2B and I have the invoice and the goods. I would chase the vendor to file, not book the credit to look good this month.'
Teach: resume bullets that get a call
Weak: 'Responsible for accounting and GST.' Strong: 'Recorded 200+ monthly vouchers in Tally Prime (sales, purchase, payment, receipt, contra) for a GST-registered trading firm.' Strong: 'Reconciled GSTR-2B to the purchase register; claimed ITC only on matched invoices and followed up 11 missing vendor filings.' Strong: 'Prepared monthly BRS for two current accounts; investigated and booked bank charges, NEFT and bounced cheques the same week.' Strong: 'Filed GSTR-1 (11th) and GSTR-3B (20th) with a written close checklist; no late fee in the months I owned.' If you have no job yet, use college fest accounts, a family shop, or this course's dummy company — and say so honestly: 'Practice set on Dojo / dummy Tally company covering …'.
Exercises
- Write one STAR story — Situation-Task-Action-Result, 6–8 lines: you found a ₹18,000 unpresented cheque that made the owner think the bank was short.
- 60-second GST answer — Answer out loud (then write): 'What is GSTR-2B and why do you wait for it?'
- Rewrite this bullet — Rewrite: 'Looked after all accounting work and taxation.'
Practice problems
- Do a 20-minute mock in Dojo with role = Accountant
- Sit a Tally dummy-company screen share with a friend
- Apply to three JDs with the rewritten resume