Learnings › AI & No-Code Automation › First lesson
First lesson · Start here · Free
What to automate in a CA office
10 min read · Print this lesson
Walk around a small CA office in July and count how often the same job is done by hand. Someone types the same "please send your Form 16" message forty times. Someone else checks a register to see whose DSC expires this month. A partner opens six mails to find the one GST notice that matters. None of this needs a CA. It needs a system that does the boring part the same way every time.
This course shows you how to build those systems with tools you already have: a free Google account, a free Microsoft account, Windows, the Excel you own and the WhatsApp Business app. Every lesson teaches the free way first. Where a paid tool really adds something, a "Paid option" box says what you gain. We never quote prices, because they change. Check the current plan before you buy.
The rule for the whole course
Automate the boring, keep the judgement. A machine is good at doing the same thing on a fixed day, to a fixed list, in a fixed format. It is bad at deciding whether a client's capital gain is short-term, whether a notice needs a reply this week, or whether a fee reminder will upset a 20-year client. Let the system send, sort, file, remind and count. Let people read, decide and sign.
The 10 jobs that repeat most
These times are typical for a 5 to 8 person office. Your numbers will differ. Write your own next to them.
| # | Job | Time per month (typical) | Worth automating? | Lesson |
|---|---|---|---|---|
| 1 | Asking clients for ITR documents and chasing the missing ones | 15 to 25 hours in season | Yes, high | 1, 2 |
| 2 | Monthly GST data reminders (sales, purchase, bank statement) | 6 to 10 hours | Yes, high | 2, 3 |
| 3 | Answering the same WhatsApp questions ("Is my return filed?", "What is the due date?") | 8 to 12 hours | Yes, medium | 3 |
| 4 | Sorting the inbox: notices, client mails, portal alerts, bank mails | 5 to 8 hours | Yes, high | 4 |
| 5 | Copying data from monthly files into one master sheet | 4 to 10 hours | Yes, high | 5 |
| 6 | Moving, renaming and filing downloaded challans, returns and acknowledgements | 4 to 6 hours | Yes, medium | 6, 8 |
| 7 | Writing first drafts: client mails, engagement letters, checklists | 5 to 8 hours | Yes, with care | 7 |
| 8 | DSC expiry tracking and renewal reminders | 1 to 2 hours, but costly when missed | Yes, high (risk) | 2, 10 |
| 9 | Fee follow-ups for unpaid bills | 3 to 5 hours | Partly: reminders yes, the hard call no | 2, 10 |
| 10 | "Who is doing what?" status checks and the weekly review | 4 to 6 hours | Yes, medium | 10 |
Add up the middle column for your office. Most small offices find 50 to 80 hours a month of repeat work. Even saving a third of it gives one person back more than a week every month.
How to decide what to automate first
Score each job from 1 to 3 on four questions:
- How often? Daily or weekly scores 3. Once a year scores 1.
- How many steps are the same every time? If the steps never change, score 3. If every case is different, score 1.
- What happens if it is missed? A missed DSC renewal or due date scores 3. A late thank-you mail scores 1.
- How much client data does it touch? Here the scoring is reversed. Little or no personal data scores 3. PAN, bank and identity papers score 1, because these need the most care (lesson 11).
Start with the jobs that score 10 or more. In most offices these are: document collection, GST reminders, inbox sorting and the task tracker.
What not to automate
- Anything that needs a professional opinion. Tax positions, notice replies, audit judgements.
- Anything that signs, files or pays. A person presses the final button on a portal, signs with a DSC and approves every payment.
- Anything that needs a client's OTP, PIN or password. The client enters these themselves. No form, sheet, script or AI tool should ever hold them.
- Marketing messages to people who did not ask for them. The ICAI Code of Ethics restricts solicitation, and the 2026 edition changed some rules. Automation in this course is for operational messages to existing clients who agreed to receive them.
- A messy process. If the manual way is not clear, automating it makes the mess faster. Write the steps on paper first.
Free tools you probably already have
| Tool | What it automates |
|---|---|
| Google Forms, Sheets, Calendar, Gmail, Drive and Apps Script | Document collection, trackers, reminders, filters, scripts |
| Microsoft Excel with Power Query | Combining and refreshing data |
| Outlook rules and scheduled send | Sorting mail, sending at the right time |
| Power Automate for desktop (on Windows) | Repetitive clicks and file moves on your own PC |
| WhatsApp Business app | Quick replies, labels, greeting and away messages |
| Free AI assistants with saved instructions | First drafts and summaries (never with client data) |
How the course works
Each lesson ends with the same line: run the checklist in lesson 11 before you switch anything on. That checklist asks who owns the account, what data the automation uses, who can see it, how you test it and how you switch it off. It takes five minutes and prevents the mistakes that cost the most: a reminder sent to 300 clients by error, a form that collects Aadhaar numbers into an open sheet, a script nobody can stop after a staff member leaves.
Lesson 12 brings it together. You pick five automations, plan them over 30 days, measure the hours saved, and write each one in an automation register so the office knows what is running.
Safe use
Build every automation on a firm-owned account, not a staff member's personal Gmail. Test with sample data, not real clients. And keep a person in charge of each one. If nobody owns an automation, nobody notices when it goes wrong.
Download the Office Automation Kit (Word) The planner, 12 step-by-step recipes, the safety checklist and the automation register.
Do this today
- Copy the table of 10 jobs onto paper and write your own office's time for each.
- Score each job on the four questions. Circle the top three.
- Ask each staff member: "Which task do you do the same way every week?" Add anything new to the list.
Let the computer do the repeated work: unlock the other 12 lessons
Document forms, reminders, WhatsApp Business, email rules, no-code flows and saved AI assistants. Free tools first, paid options after, with a safety checklist and 12 ready recipes. Rs. 999 + GST, one time · or the Office Subscription Plan from Rs. 1,499 / year for every course, for you and your staff.