Computer and MS Office basics plus TallyPrime, vouchers, inventory, GST, TDS/TCS examples, reconciliation and an office-accounting project.
What you will cover
Computer
MS Office basics plus TallyPrime
vouchers
inventory
GST
TDS/TCS examples
reconciliation
an office-accounting project
Topic list from the institute's programme record.
Certification
Certificate terms for this programme are confirmed by the institute at admission. Any ADIVAS course-completion certificate is an institute certificate; it is not a university degree, an externally accredited qualification or a vendor certification (such as AWS or Microsoft) unless the institute states so in writing.
The programme title is as supplied in the institute's list. Please confirm the awarding body and recognition with the institute before enrolling.
Curriculum 0.1 · Draft: written for ADIVAS and awaiting academic review and approval. Topics and weeks may change before your batch starts.
Your skill trail
You move through 7 stations. Each week builds one skill you can show, not just a topic you have heard.
1
Computer and online basics
Use a computer, organise files and stay safe online.
Week 1 Meet the computer
Week 2 Files, internet and safe habits
2
MS Office for the office
Create documents, spreadsheets and presentations with confidence.
Week 3 Word: creating documents
Week 4 Word: tables, letters and mail merge
Week 5 Excel: cells, formulas and formatting
Week 6 Excel: lists, charts and printing
Week 7 PowerPoint: clear presentations
Week 8 Office skills practice and AI assistant care
3
Accounting basics
Learn double entry and prepare a trial balance and final accounts.
Week 9 Accounting concepts and the equation
Week 10 Debit, credit, journal and ledger
Week 11 Trial balance and final accounts
4
TallyPrime vouchers and inventory
Set up a company, record vouchers and manage stock.
Week 12 TallyPrime company and ledgers
Week 13 Cash, bank and journal vouchers
Week 14 Sales and purchase vouchers
Week 15 Inventory basics
Week 16 Godowns, adjustments and checks
5
GST, TDS and TCS
Record GST, deduction and collection examples correctly.
Week 17 GST mechanism
Week 18 GST entries and reports
Week 19 TDS and TCS examples
6
Credit control and reconciliation
Manage bills and reconcile the bank.
Week 20 Receivables and payables
Week 21 Bank reconciliation
7
Office accounting project
Deliver a complete office-accounting project with reports.
Week 22 Project planning and data entry
Week 23 Project: GST, TDS, reconciliation and reports
Week 24 Project presentation and viva
★
Small Office: Documents to Accounts
Your project, reviewed by a trainer.
The ADIVAS mastery ladder: how each skill is recognised
Explored You have seen the idea and tried a first example.
Practising You can do it with hints and keep improving.
Proficient You complete the weekly practical task correctly on your own.
Proven You apply it in a project reviewed by your trainer.
Skill-level tracking is being added to the learner workspace. Your trainer already reviews weekly practical work.
What you will be able to do
Use a computer, manage files and folders safely and work online with basic security habits.
Create professional documents in Word and presentations in PowerPoint for office work.
Build and format Excel sheets with formulas, simple charts and sorted or filtered lists.
Explain double entry and prepare a trial balance and final accounts from transactions.
Set up a company in TallyPrime and enter vouchers, invoices and stock correctly.
Record GST transactions and review GST reports, using example rates with stated assumptions.
Record TDS and TCS using examples and manage receivables and payables.
Reconcile a bank statement, close a month and deliver an office-accounting project with reports.
Who it suits
School Students after Class 10 or 12 who are new to computers and want a complete path into office accounting.
College Arts, science and commerce students who want office skills and accounting software together.
Professional Beginners, homemakers and career changers who need both computer office skills and accounting software to start work.
Prerequisites: None. Ability to read simple English or Tamil is enough. Tools: Windows computer, Microsoft Word, Excel and PowerPoint (or LibreOffice equivalents for practice), TallyPrime, Web browser and a practice email account, Sample documents, invoices and bank statements supplied by the institute.
Weekly plan
Computer and online basics Weeks 1–2
Week 1: Meet the computer
Theory
Hardware, software and the input-process-output-storage idea
Keyboard, mouse and typing practice
Desktop, windows and settings
Basic care and safe shutdown
Lab
Identify parts of the lab computer, practise typing for 20 minutes with a free tutor and type a short introduction in a text editor.
Homework
Practise typing 15 minutes daily and note speed.
Deliverable
Typed introduction and typing record.
Weekly checkpoint
Short quiz and a typing check.
You will be able to
Use a computer, manage files and folders safely and work online with basic security habits.
Week 2: Files, internet and safe habits
Theory
Files, folders, extensions and backup
Browsers, search and judging a source
Email basics and professional wording
Passwords, OTP and avoiding scams
Lab
Create a folder structure for the course, back it up on a pen drive, search for an official source on a topic and draft a professional email without sharing private data.
Homework
List three signs of a scam message.
Deliverable
Folder structure, backup and email draft.
Weekly checkpoint
Scenario questions on scams and a file task.
You will be able to
Use a computer, manage files and folders safely and work online with basic security habits.
MS Office for the office Weeks 3–8
Week 3: Word: creating documents
Theory
Typing, selecting, copy and paste
Fonts, paragraphs, alignment and line spacing
Bullets, numbering and page setup
Saving, printing and PDF export
Lab
Create a one-page notice for an office event with a title, bullets and a contact line; save as Word and PDF.
Homework
Recreate a given letter format exactly.
Deliverable
A formatted notice and letter.
Weekly checkpoint
Formatting task on a given draft.
You will be able to
Create professional documents in Word and presentations in PowerPoint for office work.
Week 4: Word: tables, letters and mail merge
Theory
Tables and borders
Headers, footers and page numbers
Business letter format
Mail merge in outline
Lab
Create an invoice-style table, a letter with letterhead and a mail-merge of 5 invitations from a small list.
Homework
Design a fee-receipt layout.
Deliverable
Table-based invoice, letter and merged invitations.
Weekly checkpoint
Table task and mail-merge task.
You will be able to
Create professional documents in Word and presentations in PowerPoint for office work.
Week 5: Excel: cells, formulas and formatting
Theory
Cells, ranges, rows and columns
Formulas: SUM, AVERAGE, MIN, MAX, IF
Relative and absolute references
Number formats, borders and alignment
Lab
Build a stationery stock sheet with Qty, Rate and Amount, total with SUM and flag low stock with IF.
Homework
Create a household monthly expense sheet with totals.
Deliverable
Stock sheet and expense sheet.
Weekly checkpoint
Formula questions and a sheet-building task.
You will be able to
Build and format Excel sheets with formulas, simple charts and sorted or filtered lists.
Week 6: Excel: lists, charts and printing
Theory
Sorting and filtering
Simple charts: column, line, pie with correct labels
Conditional formatting
Printing, page layout and freezing panes
Lab
Take a 60-row fee collection list, sort by class, filter dues, create a chart and print one page with a header.
Homework
Create a chart that tells one clear message about the list.
Deliverable
Fee list report with chart.
Weekly checkpoint
Chart-reading questions and an Excel task.
You will be able to
Build and format Excel sheets with formulas, simple charts and sorted or filtered lists.
Week 7: PowerPoint: clear presentations
Theory
Slide layouts and themes
Text, images and tables on slides
Simple charts and timing
Presenting: speaking clearly and checking facts
Lab
Create a five-slide presentation introducing a small business with one chart and one table and present for three minutes.
Homework
Give and receive peer feedback on slide clarity.
Deliverable
Five-slide presentation.
Weekly checkpoint
Presentation review and rubric.
You will be able to
Create professional documents in Word and presentations in PowerPoint for office work.
Week 8: Office skills practice and AI assistant care
Theory
Combining Word, Excel and PowerPoint
Copying a chart from Excel to Word or PowerPoint
Using an AI assistant carefully: clear prompt, check the answer, protect private data
File naming and version habits
Lab
Complete a small office task: a fee notice in Word, a collection table in Excel and a summary slide; ask an AI assistant to draft a polite reminder and verify it.
Homework
Note one thing the AI got wrong.
Deliverable
Office pack in one folder.
Weekly checkpoint
Practical office-pack test.
You will be able to
Use a computer, manage files and folders safely and work online with basic security habits. Create professional documents in Word and presentations in PowerPoint for office work. Build and format Excel sheets with formulas, simple charts and sorted or filtered lists.
Accounting basics Weeks 9–11
Week 9: Accounting concepts and the equation
Theory
Purpose of accounting
Assets, liabilities, capital, income, expenses
Accounting equation and effect of transactions
Source documents
Lab
Analyse 25 events of a small bakery in an equation table.
Homework
Make an equation table for 10 events from a shop you know.
Deliverable
Equation table.
Weekly checkpoint
Quiz and an equation task.
You will be able to
Explain double entry and prepare a trial balance and final accounts from transactions.
Week 10: Debit, credit, journal and ledger
Theory
Rules of debit and credit
Journal entries and narration
Ledger posting and balancing
Cash book
Lab
Journalise 30 transactions of the bakery and post to ledgers.
Homework
Write entries for 10 transactions and justify.
Deliverable
Journal and ledgers.
Weekly checkpoint
Journal test.
You will be able to
Explain double entry and prepare a trial balance and final accounts from transactions.
Week 11: Trial balance and final accounts
Theory
Trial balance and errors
Adjustments: depreciation, accrued, prepaid
Profit and loss account and balance sheet
Reading statements
Lab
Prepare trial balance, post adjustments and prepare final accounts; find three planted errors.
Homework
Compute depreciation for three assets.
Deliverable
Trial balance and final accounts.
Weekly checkpoint
Adjustment test and statements task.
You will be able to
Explain double entry and prepare a trial balance and final accounts from transactions.
TallyPrime vouchers and inventory Weeks 12–16
Week 12: TallyPrime company and ledgers
Theory
Company creation and features
Groups and ledgers with naming discipline
Opening balances
Backup and restore
Lab
Create a company for a small office-supply shop, add 40 ledgers, enter openings and take a backup.
Homework
Rename five confusing ledgers.
Deliverable
Company and backup.
Weekly checkpoint
Setup practical.
You will be able to
Set up a company in TallyPrime and enter vouchers, invoices and stock correctly.
Week 13: Cash, bank and journal vouchers
Theory
Payment, receipt, contra and journal vouchers
Narration
Cash and bank books
Correcting entries
Lab
Enter 40 cash and bank transactions and review the daybook.
Homework
Check a cash count against Tally.
Deliverable
Daybook and correction log.
Weekly checkpoint
Voucher tests.
You will be able to
Set up a company in TallyPrime and enter vouchers, invoices and stock correctly.
Week 14: Sales and purchase vouchers
Theory
Item-invoice and accounting-invoice modes
Party ledgers
Credit and debit notes
Party statements
Lab
Record 20 sales, 15 purchases and 4 returns, and print party statements.
Homework
Correct a wrongly posted voucher.
Deliverable
Party statement set.
Weekly checkpoint
Entry task and scenario questions.
You will be able to
Set up a company in TallyPrime and enter vouchers, invoices and stock correctly.
Week 15: Inventory basics
Theory
Stock items, groups and units
Opening stock and valuation: weighted average and FIFO
Stock summary
Physical verification
Lab
Create 30 stock items, record movements and match a physical count.
Homework
Compute closing stock under both methods.
Deliverable
Stock summary and count sheet.
Weekly checkpoint
Valuation questions and a stock task.
You will be able to
Set up a company in TallyPrime and enter vouchers, invoices and stock correctly.
Week 16: Godowns, adjustments and checks
Theory
Godown transfers
Stock journal and damage write-off
Negative stock
Month-end checks
Lab
Transfer stock between godowns, post a damaged-goods write-off and clear a negative stock warning.
Homework
Write a control note to prevent negative stock.
Deliverable
Godown report and control note.
Weekly checkpoint
Practical test.
You will be able to
Set up a company in TallyPrime and enter vouchers, invoices and stock correctly.
GST, TDS and TCS Weeks 17–19
Week 17: GST mechanism
Theory
What GST is and input credit
CGST, SGST, IGST and place of supply
Tax invoice and bill of supply
Example rates and checking actual rates on the official portal
Lab
Classify 15 supplies as intra- or inter-state using trainer-given example rates and write the tax lines.
Homework
Collect a real invoice with permission and tick its mandatory fields.
Deliverable
Classification sheet and invoice checklist.
Weekly checkpoint
Mechanism questions.
You will be able to
Record GST transactions and review GST reports, using example rates with stated assumptions.
Week 18: GST entries and reports
Theory
GST ledgers and set-up in Tally
Sales and purchase vouchers with GST
Returns with GST
GST summary and input credit set-off
Reviewing mismatches with suppliers
Lab
Enter 15 GST sales and 15 purchases, review the net GST position and prepare a supplier follow-up list.
Homework
Write a polite supplier email for a missing invoice.
Deliverable
GST voucher set and net working.
Weekly checkpoint
Entry task and calculation questions.
You will be able to
Record GST transactions and review GST reports, using example rates with stated assumptions.
Week 19: TDS and TCS examples
Theory
TDS: deduct on payment and deposit with government
TCS: seller collects from buyer in specified cases
Recording with example rates and stated assumptions
Verifying current rules from official sources
Lab
Book a consultant fee with TDS and a sale with TCS using labelled example rates and deposit entries.
Homework
List items to verify from official sources.
Deliverable
TDS and TCS entries with assumption notes.
Weekly checkpoint
Calculation questions and a voucher task.
You will be able to
Record TDS and TCS using examples and manage receivables and payables.
Credit control and reconciliation Weeks 20–21
Week 20: Receivables and payables
Theory
Bill-wise tracking and ageing
Credit follow-up and reminders
Advance receipts and adjustments
Supplier payment planning
Lab
Analyse ageing data of 20 parties, rank follow-ups and draft reminders in Tamil and English.
Homework
Write a polite payment reminder.
Deliverable
Ageing analysis and reminders.
Weekly checkpoint
Case questions and a report task.
You will be able to
Record TDS and TCS using examples and manage receivables and payables.
Week 21: Bank reconciliation
Theory
Why books and bank differ
Timing differences and missing entries
Using bank reconciliation in TallyPrime
Reconciliation statement
Lab
Reconcile two months of a mock bank statement, record charges and prepare a statement.
Homework
Explain differences to a shop owner.
Deliverable
Reconciliation statements.
Weekly checkpoint
Numeric reconciliation test and Tally task.
You will be able to
Reconcile a bank statement, close a month and deliver an office-accounting project with reports.
Office accounting project Weeks 22–24
Week 22: Project planning and data entry
Theory
Reading a business brief
Setting up the project company
Entering a month of documents
Self-checking against source documents
Lab
Set up the office-accounting project company and enter the first half of the month's documents.
Homework
Make a list of questions for the business owner.
Deliverable
Project company with half the month entered.
Weekly checkpoint
Mid-project review.
You will be able to
Set up a company in TallyPrime and enter vouchers, invoices and stock correctly. Reconcile a bank statement, close a month and deliver an office-accounting project with reports.
Week 23: Project: GST, TDS, reconciliation and reports
Theory
Finishing entries including GST
TDS or TCS example entries
Bank reconciliation
Financial statements and an Excel export
Lab
Complete the project entries, reconcile the bank, produce statements and export reports to Excel with a simple chart.
Homework
Prepare an owner summary draft.
Deliverable
Completed project company and report workbook.
Weekly checkpoint
Review of entries and reports.
You will be able to
Record GST transactions and review GST reports, using example rates with stated assumptions. Record TDS and TCS using examples and manage receivables and payables. Reconcile a bank statement, close a month and deliver an office-accounting project with reports.
Week 24: Project presentation and viva
Theory
Preparing a presentation of the project
Explaining the reports to a non-accountant
Viva preparation
Next learning steps
Lab
Present the project with a PowerPoint summary and answer viva questions on three traced entries.
Homework
Self-assess with the rubric and list three improvements.
Deliverable
Final project report, presentation and owner summary.
Weekly checkpoint
Final assessment with a viva.
You will be able to
Create professional documents in Word and presentations in PowerPoint for office work. Reconcile a bank statement, close a month and deliver an office-accounting project with reports.
Sample lessons
Week 5
Spreadsheet formulas for an office
A spreadsheet stores numbers in cells named by column and row, such as B2. A formula starts with an equals sign and uses cell names, so when a number changes the answer updates automatically. SUM adds a range, AVERAGE finds the mean, and IF chooses between two results. Using cell references instead of typing numbers inside formulas keeps the sheet correct and easy to check.
Cell
Content
Result
B2
Qty 5
C2
Rate 120
D2
=B2*C2
600
D5
=SUM(D2:D4)
Total of D2 to D4
Step by step
Type headings in row 1: Item, Qty, Rate, Amount.
Enter three rows of data below the headings.
In D2 type =B2*C2 and copy it down.
In D5 type =SUM(D2:D4) for the total.
Add a column that shows "Reorder" when quantity is below 10 using =IF(B2<10,"Reorder","OK").
In real life
A school office keeps a list of stationery with quantity and rate. The clerk uses formulas to find the value of stock and which items to reorder before the term starts.
Worked example
Problem. Quantity is in B2 and rate in C2. How do you compute the amount with 5 per cent extra for packing, assuming the packing is a fixed example?
Solution. =B2*C2*1.05 gives amount plus 5 per cent. Better still, store 5% in a labelled cell, for example F1, and use =B2*C2*(1+F1) so the rate can be changed in one place.
Common mistakes
Typing numbers inside the formula so that changes are missed.
Forgetting the equals sign so Excel treats it as text.
Selecting the wrong range in SUM and missing a row.
Try it yourself
Build a monthly expense sheet with a total and an average using SUM and AVERAGE.
Add an IF column that flags expenses above ₹2,000.
Week 10
Double entry and the voucher
Every transaction has two sides. Something is received and something is given. Double entry records both, so total debits always equal total credits. In TallyPrime you enter each transaction as a voucher, such as Payment, Receipt, Sales or Journal, and Tally posts it to the correct ledgers. If you choose the wrong ledger or voucher type, reports will be wrong even though the voucher looks fine.
Transaction
Debit
Credit
Cash sale ₹2,000
Cash
Sales
Electricity paid ₹1,800
Electricity expense
Bank
Credit purchase ₹20,000
Purchases
Supplier
Customer pays ₹5,000
Bank
Customer
Step by step
Ask: what came in and what went out?
Choose the voucher type: Sales for a sale, Payment for money going out.
Select the correct ledgers and enter amounts and narration.
Check the posted effect in the ledger and the daybook.
Verify that the trial balance still balances.
In real life
A Madurai stationery shop sells notebooks worth ₹2,000 for cash. Cash increases (debit) and sales income increases (credit). The same voucher feeds the daybook, the cash ledger and the profit and loss account.
Worked example
Problem. The shop pays electricity bill ₹1,800 by bank transfer. Which accounts are debited and credited?
Solution. Debit Electricity Expense 1,800 because an expense is incurred; credit Bank 1,800 because the bank balance falls. Voucher type: Payment.
Common mistakes
Debiting the bank when money leaves it.
Using Journal for everyday cash and bank entries instead of Payment and Receipt.
Leaving narration empty so nobody can explain the entry later.
Try it yourself
Write the debit and credit for buying a computer for ₹40,000 by cheque.
Write the entry when a customer pays ₹5,000 against an earlier credit sale.
Week 21
Bank reconciliation step by step
The bank statement and your cash book rarely agree on the same date. Timing differences such as cheques issued but not yet presented, and deposits not yet credited, are normal. Items like bank charges or interest are in the bank but missing from your books. Reconciliation lists every difference, corrects your books for the real ones and explains the rest, so you know your true bank balance.
1Cash book balance
2Add/less items missing from books
3Adjusted book balance
4Add/less timing items
5Bank statement balance
Step by step
Tick each entry that appears in both the cash book and the statement.
List unticked cash book items: cheques not presented and deposits not credited.
List unticked statement items: charges, interest and direct credits not in your books.
Record the missing items in your books.
Confirm adjusted book balance matches the statement after timing differences.
In real life
A garment trader sees ₹84,500 in the books but the bank shows ₹86,250. Reconciliation finds a ₹6,000 cheque still with a supplier, a ₹4,000 deposit made after bank cut-off and ₹250 of charges not entered.
Worked example
Problem. Book balance ₹84,500; unpresented cheque ₹6,000; uncredited deposit ₹4,000; bank charges ₹250. Find the statement balance.
Treating timing differences as errors and changing the books.
Not recording bank charges and interest in the books.
Reconciling only the total without ticking individual entries.
Try it yourself
Reconcile a statement showing ₹52,000 when the books show ₹54,500 with two items in transit.
List three reasons a cheque you issued may not appear on the statement.
Try the questions
The same skills are asked at three levels: School (Classes 6–12), College and Professional. Switch the level and the language (English or Tamil), and say how sure you are before you check: knowing what you are unsure about is part of learning.
Classes 6–12: everyday examples, no prior knowledge. Practice only. Nothing here is graded or saved.
Question 1 / 5 · Accounting equation
Ravi's tea stall has assets worth ₹10,000. He owes ₹4,000 to a supplier. How much is Ravi's own money (capital) in the stall?
Projects
Small Office: Documents to Accounts
A small Madurai coaching office gives you fee receipts, supplier bills, bank statements and a staff list. Create its office documents in Word, a collection and expense workbook in Excel, keep its books in TallyPrime with GST using stated example rates, reconcile the bank and present your results in PowerPoint.
Tasks
Create a fee notice and a receipt format in Word.
Build a fee collection and expense workbook with formulas and a chart.
Set up the company in TallyPrime and enter all vouchers including purchases with GST.
Reconcile the bank statement and explain differences.
Produce statements and present five slides to the owner.
Sample input
Fee receipt 214: Student Priya, ₹3,500 by UPI; Supplier bill: printer paper, taxable value 4,000 plus example tax; Bank charge 177.
Expected output
A Word pack, an Excel workbook with totals and a chart, a TallyPrime file with an agreeing trial balance, a reconciliation statement and a five-slide summary.
How it is assessed
Criterion
Weight
Office documents and workbook quality
20%
Voucher and ledger accuracy
25%
GST treatment
15%
Reconciliation
15%
Reports and presentation
15%
Explanation and good practice
10%
Stretch challenge: Create a monthly template the office can reuse.
How you are assessed
Each week: eight questions plus one hands-on task. Office weeks use Word, Excel and PowerPoint tasks; accounting weeks use TallyPrime tasks on unseen data.
Practical work. Office skills are checked with a document, a spreadsheet and a presentation task; accounting skills are checked with vouchers, GST entries, reconciliation and reports on unseen data.
What trainers look for
Weight
Correct and complete work
40%
Office document quality
15%
Accounting and GST treatment
25%
Explanation and good practice
20%
Where this can lead
Prepares you for office-assistant, data-entry and accounts-assistant roles.
Builds the base for further accounting-software and GST studies.
These describe skills you will build. ADIVAS does not guarantee jobs, placement or salary.
Other programmes in Accounting, Finance & Business Applications
