Skip to content
AI & No-Code AutomationPracticeGuru Learnings

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.

#JobTime per month (typical)Worth automating?Lesson
1Asking clients for ITR documents and chasing the missing ones15 to 25 hours in seasonYes, high1, 2
2Monthly GST data reminders (sales, purchase, bank statement)6 to 10 hoursYes, high2, 3
3Answering the same WhatsApp questions ("Is my return filed?", "What is the due date?")8 to 12 hoursYes, medium3
4Sorting the inbox: notices, client mails, portal alerts, bank mails5 to 8 hoursYes, high4
5Copying data from monthly files into one master sheet4 to 10 hoursYes, high5
6Moving, renaming and filing downloaded challans, returns and acknowledgements4 to 6 hoursYes, medium6, 8
7Writing first drafts: client mails, engagement letters, checklists5 to 8 hoursYes, with care7
8DSC expiry tracking and renewal reminders1 to 2 hours, but costly when missedYes, high (risk)2, 10
9Fee follow-ups for unpaid bills3 to 5 hoursPartly: reminders yes, the hard call no2, 10
10"Who is doing what?" status checks and the weekly review4 to 6 hoursYes, medium10

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:

  1. How often? Daily or weekly scores 3. Once a year scores 1.
  2. How many steps are the same every time? If the steps never change, score 3. If every case is different, score 1.
  3. What happens if it is missed? A missed DSC renewal or due date scores 3. A late thank-you mail scores 1.
  4. 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

ToolWhat it automates
Google Forms, Sheets, Calendar, Gmail, Drive and Apps ScriptDocument collection, trackers, reminders, filters, scripts
Microsoft Excel with Power QueryCombining and refreshing data
Outlook rules and scheduled sendSorting mail, sending at the right time
Power Automate for desktop (on Windows)Repetitive clicks and file moves on your own PC
WhatsApp Business appQuick replies, labels, greeting and away messages
Free AI assistants with saved instructionsFirst 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

  1. Copy the table of 10 jobs onto paper and write your own office's time for each.
  2. Score each job on the four questions. Circle the top three.
  3. Ask each staff member: "Which task do you do the same way every week?" Add anything new to the list.
Log in or register free to save your progress.

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.