This guide is for the partner or administrator who sets up CA Office Manager for a firm. Follow the steps in order, one at a time. It takes about 30 minutes the first time and needs no programming. Each step says what to do, where to do it, what you should see and when you are done. Do not move on until you see the "done" result. Staff do not follow this guide; they only open the firm link you give them in Step 12.
Google sometimes changes the wording of its buttons slightly. If a button looks a little different, look for the one with the same meaning.
What you are going to do (overview)
| Step | What you do | Where |
|---|---|---|
| 1 | Decide which Google account will own the firm's data | Your head |
| 2 | Create a project | script.google.com |
| 3 | Paste the settings file (appsscript.json) | Apps Script editor |
| 4 | Paste the application code (Code_all.gs) | Apps Script editor |
| 5 | Publish it as a web app and copy its address | Apps Script editor |
| 6 | Check that the address responds | A new browser tab |
| 7 | Run the one-time setup | Apps Script editor |
| 8 | Activate your administrator account | CA Office Manager page |
| 9 | Register your firm with Techmin | CA Office Manager page (appears by itself) |
| 10 | Check the firm's details and settings | CA Office Manager page |
| 11 | Switch on the daily reminders and weekly backup | CA Office Manager page |
| 12 | Invite and approve your staff | CA Office Manager page |
| 13 | Do a short test | CA Office Manager page |
How your data is kept
- Everything you create in Steps 2 to 7 belongs to your Google account. Setup creates a spreadsheet called CA Office Work Management - Database and a Drive folder called CA Office Management in your Drive.
- All client records, tasks, fees, documents and email are stored there. Documents stay private in your Drive. Emails are sent by your Gmail.
- The page at
tools.complypro.co.in/ca-office-manager/is only the screen. It runs in your browser and talks directly to your workspace. It has no database of its own. Techmin does not receive, host or have access to your firm's records, unless you choose to share your spreadsheet or folder with Techmin. - What Techmin does receive: when you register the firm (Step 9) Techmin keeps a register of the firms using the software: firm name, address, PAN, GSTIN, contact person, email, mobile, the date you registered, the software version, the number of active users and the date you last used it. This lets Techmin support you, send you update and payment notices, and manage subscriptions. Techmin never receives your clients, tasks, documents, fees, invoices, staff records or emails.
- Two honest points: updates to the page come from Techmin; and the workspace runs your own copy of the application code, which you can read in the Apps Script editor.
Step 1 - Choose the Google account
Goal: pick the account that will own the data.
- Use a Google account that belongs to the firm, for example
office@yourfirm.inor a Google Workspace account. A personal account works for testing, but the firm loses access if that person leaves. - Make sure you can sign in to it on the computer you are using, and that no other Google account is in the way: open Chrome, click your profile picture at the top right, and check the email shown is the one you want. If not, use Add another account.
- Keep the second step of 2-Step Verification (phone or authenticator) handy in case Google asks.
You are done with this step when you can see the firm's account email at the top right of a Google page.
Step 2 - Create the project
Goal: make an empty Apps Script project in the firm's account.
- In the browser, open
https://script.google.com. - Click the blue New project button (top left). A page with a code box opens. The top left says Untitled project.
- Click Untitled project, type
CA Office Managerand click Rename. - Look at the left side. You will see icons for Editor (
<>), Triggers, Executions and Project Settings (a gear). The middle shows a file calledCode.gs.
You are done when the project is named CA Office Manager and the Editor is open.
Step 3 - Paste the settings file (appsscript.json)
Goal: tell Google which permissions the project needs and connect it to the shared CA Office Manager code. This is what makes future updates automatic.
- Click Project Settings (the gear icon on the left).
- Scroll to General settings and tick Show "appsscript.json" manifest file in editor.
- Click Editor (
<>) on the left. A file calledappsscript.jsonnow appears in the file list on the left. - Get the file contents. Use the button below; it copies the file to your clipboard:
- In the Editor, click
appsscript.json. Click inside the code box, press Ctrl+A (select all) and then Ctrl+V (paste). The old text is replaced. - Press Ctrl+S to save (or click the floppy-disk icon).
You are done when appsscript.json shows "timeZone": "Asia/Kolkata" and the word CAOMS, and the left side of the editor shows CAOMS under Libraries. Both are needed: the file gives the project its permissions (Drive, Sheets, Gmail), the library gives it the application.
If CAOMS is not listed under Libraries, the file was not saved or was pasted in the wrong place. Paste it again and press Ctrl+S. If it is still missing, add the library by hand and then check that the file still contains the permissions list:
- Click the + next to Libraries.
- In Script ID paste
1bnTuUUTTsbb9AR2SY-MB42E2_8UBswDx5U2jUFzu5aUOhjX56e3AJ8GXand click Look up. - Set Version to HEAD (Development mode), set Identifier to exactly
CAOMS(capitals), click Add and press Ctrl+S.
If Google cannot find the library, ask Techmin to confirm that it is shared with your account, or use the own-copy method at the end of this guide, which needs no library.
Step 4 - Paste the connector (Stub.gs)
Goal: add the small file that connects your project to the shared code.
- In the Editor, click the file
Code.gsin the left file list. - Get the file contents with the button below:
- Click inside the code box, press Ctrl+A and then Ctrl+V. The default text (
function myFunction() {...}) is replaced by a short file of about 20 lines. That is normal: the application itself is in the shared library. - Press Ctrl+S to save. Wait for the save to finish (a few seconds).
- Check: click the function drop-down at the top of the editor. You should see names such as
setupApplication,migrateSchema,installTriggersandshowHealth.
If the copy button does not work (some browsers block it), use the Download button next to it, open the downloaded file in Notepad, press Ctrl+A, Ctrl+C, and paste into the editor.
You are done when the function list contains setupApplication.
If you later see ReferenceError: CAOMS is not defined, the library in Step 3 is missing: go back to Step 3 and fix it, then deploy a new version (Deploy > Manage deployments > pencil > New version > Deploy).
Step 5 - Publish it as a web app
Goal: give your workspace an address that the page can talk to.
- Click the blue Deploy button at the top right and choose New deployment.
- In the window that opens, click the gear icon next to Select type and choose Web app.
- Fill in:
* Description: CA Office Manager * Execute as: Me (your account) * Who has access: Anyone
Anyone only lets the page reach your workspace. Nobody can read any data without signing in to the application with an activated account.
- Click Deploy.
- Google asks you to Authorize access. Click it, choose your firm's account, and read the permissions. They are for Sheets, Drive, Gmail (to send your staff's activation emails) and your email address.
- If you see Google hasn't verified this app, click Advanced, then Go to CA Office Manager (unsafe), then Allow. This warning is normal because the project is your own and has not been through Google's public review.
- A window shows Web app and a URL ending in
/exec. Click Copy next to it and paste it somewhere safe (a text file or an email to yourself). This is your workspace address. - Click Done.
You are done when you have your workspace address saved. It looks like https://script.google.com/macros/s/AKfycb.../exec.
Step 6 - Check that the address responds
Goal: make sure the web app is working before you continue.
- Open a new browser tab and paste your workspace address, then add
?ping=1at the end. Example:https://script.google.com/macros/s/AKfycb.../exec?ping=1 - Press Enter. You should see a short line of text:
{"ok":true,"name":"CA Office Work Management System","version":"1.0.0"}.
If you see "Sorry, unable to open the file at this time" (or any Google error page or sign-in request), try these in order:
- Open the address in a private window. In Chrome press Ctrl+Shift+N, paste the address with
?ping=1at the end and press Enter. This message very often appears when you are signed in to more than one Google account in the same browser; Google then opens the address under the wrong account. If the private window shows the line of text, the web app is fine: carry on to Step 7. - Check the address. It must be the Web app URL from Step 5, starting
https://script.google.com/macros/s/and ending/exec. It is not the Deployment ID, not the editor address, and not a URL ending in/dev. It must be copied completely, with no spaces. - Check the access settings. Go back to the Apps Script tab: Deploy → Manage deployments → pencil icon. Check Execute as: Me and Who has access: Anyone (not Anyone with Google account). Under Version choose New version and click Deploy.
- Check that Step 5 finished. If you never saw the Authorize access step, run setupApplication once from the editor (Step 7) and allow the permissions, then deploy again.
- Wait one minute and try again; a new deployment can take a short while to start.
If the private window still fails, do not continue; write to Techmin support with a screenshot.
Step 7 - Run the one-time setup
Goal: create the database, the Drive folders and your administrator account, and have your activation key emailed to you.
- Go back to the Apps Script tab. Click Editor.
- In the drop-down next to Run and Debug at the top, choose setupApplication.
- Click Run. Wait about 30 seconds. Google may ask you to authorize again; allow it as before.
- At the bottom a panel called Execution log appears. When it shows Execution completed and a message starting SETUP COMPLETE, setup worked. The log also shows the link to your new database and your activation key (10 letters and digits).
- Write the activation key down. Setup has also emailed it to your own Gmail inbox, with a subject Your CA Office Manager administrator activation key. Check Spam if it is not there.
- If the log says Set Script property ADMIN_EMAIL: click Project Settings, scroll to Script properties, click Add script property, type
ADMIN_EMAILas the property and your own email address as the value, click Save script properties, return to the Editor and run setupApplication again.
The activation key works once and expires in 3 days. If you lose it, set the script property ADMIN_EMAIL as in point 6 and run resetAdminAccess to get a new key.
You are done when you have the activation key and you can see a new spreadsheet CA Office Work Management - Database in your Google Drive.
Step 8 - Activate your administrator account
Goal: choose your password and sign in for the first time.
- Open
https://tools.complypro.co.in/ca-office-manager/(the page address in the email from Step 7). - The page asks for your workspace address. This is the Web app URL you copied in Step 5. If you did not save it, get it again: in the Apps Script tab click Deploy → Manage deployments; the Web app URL is shown there with a Copy button. It starts
https://script.google.com/macros/s/and ends/exec. Paste it into the box.
- Click Connect. The sign-in card now says Connected to and shows your workspace.
- Click First time? Activate your account with your activation key.
- Enter your email address (the firm account's email), the activation key, and a new password: at least 10 characters with an upper-case letter, a lower-case letter and a digit.
- Click Activate account. You see Account activated.
- Enter your email and the new password and click Sign in. You are the Firm Administrator and you see the Dashboard.
Important: the email from Step 7 may show a firm link ending in /dev, or no address at all. That happens because setup was run from the script editor, which only knows the owner-only test address. Do not use an address ending in /dev; it cannot be opened by anyone else and the page will refuse it. Use the /exec Web app URL as described above. Once you are signed in, Administration → Settings shows the correct firm link for your staff.
If you have a firm link (a long address containing ?ws=), you can either open it in the browser's address bar and press Connect, or paste the whole link into the workspace box; both work.
What you should see next: because you are the administrator and the firm is not yet registered with Techmin, a page titled Register your firm with Techmin opens instead of the Dashboard. That is Step 9.
Step 9 - Register your firm with Techmin
Goal: tell Techmin that your firm uses the software, so Techmin can support you and send you update and payment notices. This is a one-time form that opens by itself after your first sign-in.
- On the page Register your firm with Techmin, fill in every field marked with a star: Firm name, Address, City, Pincode (6 digits), State (choose from the list), Firm PAN (for example
ABCDE1234F), Contact person, Mobile (10 digits) and Firm email. - GSTIN and ICAI firm registration number are optional. If you enter a GSTIN, characters 3 to 12 must be the same as the PAN.
- Read the grey box What Techmin receives / What Techmin never receives. Your clients and all other records are never sent.
- Tick the consent box and click Register firm.
- If a red message appears, read it, correct the field it names and click Register firm again. A message ending in [DUPLICATE] means this PAN is already registered: contact Techmin support. [RATE] means too many attempts: wait an hour.
- If Techmin cannot be reached (for example no internet), you can click Cannot reach Techmin right now? Continue for this session. The registration form appears again at your next sign-in until it succeeds.
What you should see: the Dashboard opens, a message Your firm is registered with Techmin appears. Under Administration → Techmin account you see your firm id, registration date and status.
You are done when Administration → Techmin account shows a firm id starting with F-.
Step 10 - Check the firm's details and settings
Goal: check the details copied from the registration form and set the working rules. Nothing here is shared with Techmin.
- In the left menu click Administration, then the Settings tab.
- At the top you will see the card Firm link for your staff. Click Copy link and keep it: this is the exact link to send to your staff (Step 12). The card also shows the workspace address with its own Copy address button, for anyone who is asked for it instead of using the link.
- Check
firm_name,firm_address,firm_email,firm_gstinandfirm_state; they were filled in from Step 9. To change details that Techmin also holds, use Administration → Techmin account instead, so both stay the same. Setwork_daysandholidaysif they differ from the defaults. - Registration settings:
open_registration=Ylets staff register themselves;registration_approval=Y(recommended) means you approve each person before they can sign in;registration_default_roleis the role a self-registered person gets (normallyCLERK). - Click Save settings.
You are done when Settings saved appears.
Step 11 - Check the daily reminders and the mandatory backup
Goal: turn on the automatic jobs.
- Click Administration, then the Backup & triggers tab.
- The jobs install themselves when the administrator signs in. If the trigger list is empty, click Install / re-install triggers. They are a daily job (about 7 am: reminders, recurring tasks, stopping forgotten timers) and a nightly backup check (2 am).
- In Automatic backup, choose the day your firm wants (every day, or one weekday) and press Save day. Backups are mandatory and cannot be switched off; if none succeeds for too long, administrators get an alert.
- Click Back up database now once to prove that backups work. A dated copy appears in your Drive folder CA Office Management → Backups.
You are done when the trigger list shows two entries and the backup list shows OK.
Step 12 - Invite and approve your staff
Goal: give people access.
Option A: they register themselves (recommended). Send each person the firm link from Step 10. Each person:
- Opens the link and clicks Connect.
- Clicks New here? Create an account, enters name and email, ticks the consent box and clicks Register.
- Opens their email. A message Your activation key - (your firm name) arrives from your firm's Gmail account within a minute or two (check Spam).
- Clicks First time? Activate your account, enters their email, the key and a password.
- Waits for your approval if you left approval on.
You approve them: Administration → Users, find the person with the Pending approval badge and click Approve. They get an email. Afterwards you can change their role with Edit.
Option B: you add them. Administration → Users → Add user, fill in name, email and role. The system shows an activation key once; give it to the person privately. They follow steps 1, 2 and 4 above.
You are done when your staff can sign in and each sees only the menu items that fit their role.
Step 13 - Do a short test
- Add one test client: Clients → Add client.
- Create a task for it: Tasks → New task, assign it to a staff member.
- Sign in as that staff member in another browser, acknowledge the task, start the timer, tick the checklist and submit it for review.
- As partner, review and approve it.
- Leave: as the staff member open Time & leave → Leave → Apply for leave; the blue box shows who will decide it. As partner or administrator, open the alert, the dashboard card Leave waiting for my approval or Time & leave → Leave, and press Approve or Reject. If you are the administrator, your own leave goes to another approver; if the firm has no other approver it is recorded as approved automatically.
- Messages: open Messages → New message, send a message to a staff member, sign in as that person and open it; the sender then sees Read with the time. Replies stay in the same conversation, and sending and reading are recorded in the audit log (the text of a message is not).
- If you use fees: Fees → New invoice, issue it, record a receipt.
- Keep a note of these test records so that your team can ignore them, or use real clients from the start.
If something fails, note the error code in square brackets and see Error codes in Help.
Optional: send email from another address
By default emails come from the Google account that owns the workspace. To use another address of your firm:
- Open Gmail in the owner account. Click the gear → See all settings → Accounts → Send mail as → Add another email address.
- Enter the name and address, click Next Step, and complete the verification Gmail asks for (a code sent to that address).
- In the page, Administration → Settings: set
mail_fromto that address andmail_from_nameto the name to show. Save.
If Gmail refuses the address, the application sends from the account's own address and sets Reply-To to your chosen address, so nothing is lost.
Notices from Techmin
Techmin sends these from its own console. You do not need to do anything to receive them.
From time to time Techmin sends a notice, for example a new version, planned maintenance or a payment reminder.
- Where you see them: as a coloured strip at the top of every screen after you sign in, and in full under Administration → Techmin account. Notices about updates and payment are meant for administrators; general notices are shown to everyone.
- Colours: blue is information, amber is a warning, red is important. You can click Dismiss on blue and amber notices; red notices stay until Techmin withdraws them.
- Payment: if your payment is due or overdue, a strip Techmin account: payment due shows the amount and a note. Administration → Techmin account shows plan, payment status, paid-until date and amount due. For questions use the support email shown there.
- Email: Techmin may also email a notice to the firm email you registered.
- Privacy: getting notices does not send Techmin any client data. The administrator's screen sends Techmin only the software version and the number of active users, so Techmin can see that the firm is using the software.
Updating to a new version
With the shared code (Steps 3 and 4) you do nothing. Techmin publishes the new version once and every workspace uses it from the next request. Your data is not touched, your workspace address stays the same, and the first sign-in after an update brings the database up to date by itself.
If the page shows a yellow workspace code is out of date message, your project does not use the shared code. Fix it once: repeat Steps 3 and 4 in your existing project (paste appsscript.json and Stub.gs, save), then choose Deploy > Manage deployments > pencil > New version > Deploy. After that, updates are automatic.
A note on trust: the shared code runs inside your Google account with the permissions you approved in Step 5, exactly as a copy of the code would. Techmin controls what that code does, so use the shared method only if you are comfortable with that. The own-copy method below keeps the code under your control.
Advanced: your own copy of the code (no automatic updates)
Use this only if your firm wants to review and control every code change. In Step 3 paste appsscript_standalone.json instead of appsscript.json, and in Step 4 paste the full application code instead of the connector. You will then need to repeat the paste whenever the page shows the out of date message.
To update an own-copy project: copy the latest Code_all.gs above, open your project at script.google.com, click Code.gs, press Ctrl+A, Ctrl+V and Ctrl+S, then choose Deploy > Manage deployments > pencil > New version > Deploy. You do not need to run any function afterwards.
Backups and ownership
- Administration → Backup & triggers makes dated copies of the database in your Drive. Documents are not copied by a database backup; see the backup guide.
- Add a second person as an owner or editor of the Apps Script project, the database spreadsheet and the Drive folder (use Share in each), so the firm does not depend on one login.
- If the owner account is closed, the data is lost with it. Keep an off-account backup.
Common problems
| Problem | What to do |
|---|---|
| Authorization required when running | Run again and accept the permissions with the owner account |
| Google hasn't verified this app | Advanced → Go to CA Office Manager (unsafe) → Allow; it is your own project |
| Staff say they did not get a leave or message alert | Alerts refresh about every 2 minutes; ask them to press Ctrl+F5. Messages and leave requests also appear under Messages and Time & leave → Leave |
The email says the firm link ends in /dev, or the page refuses the address | Use the Web app URL ending /exec from Deploy → Manage deployments (Step 8); never use /dev |
| Step 6 shows Sorry, unable to open the file at this time, an error page or a sign-in request | Open the address in a private window (several Google accounts in one browser is the usual cause); check it is the Web app URL ending /exec; Deploy → Manage deployments → pencil → Execute as: Me, Who has access: Anyone → New version → Deploy. See Step 6 |
| The page says the address did not answer as a workspace | Check that the address ends in /exec and has no spaces; repeat Step 6 |
| No key email arrived | Look in Spam; the key is also in the Execution log (Step 7); or set the script property ADMIN_EMAIL and run resetAdminAccess |
| Activation failed | The key was already used, is older than 3 days or was typed wrongly; check you are connected to the right workspace (bottom of the sign-in card) |
| Step 9 says [DUPLICATE] | This PAN is already registered with Techmin; contact Techmin support with your firm name and PAN |
| Step 9 says [NET] | Techmin could not be reached; check the internet connection and try again, or continue for the session and register later |
| The Techmin account tab shows no details | Techmin could not be reached just now; click Refresh |
| Staff cannot sign in after registering | They are waiting for your approval: Administration → Users → Approve |
| Changes to the code do not appear | Create a New version of the deployment (Deploy → Manage deployments → pencil) |
The complete list of messages is in Error codes.