kredosys
Chat on WhatsApp

Excel and Sheets automation · CA and finance teams

Excel automation for CA firms and finance teams in India

From hours of copy-paste to a sheet that checks itself

Kredosys builds Excel and Google Sheets automation for CA firms and finance teams in India. We turn a repeated manual task, such as GSTR-2B matching, a compliance due-date tracker or a staff and client MIS, into a locked, tested tool. It runs on your own files, flags exceptions with a reason and shows a green check when totals reconcile.

  • Excel or Google Sheets in the version your team already uses
  • Self-check row that turns green when totals reconcile
  • Tax logic confirmed by your CA, with the rule date noted

Sound familiar?

What CA firms and finance teams tell us

Every month the same work comes back. Download the statement, paste it next to the purchase register, sort, compare line by line and hope nobody broke a formula.

Most of that work follows rules your team already knows. A well-built sheet can follow the same rules and leave your staff only the exceptions.

  • “Matching GSTR-2B with our purchase register takes days every month.”

    Exact matches first, then close matches on GSTIN, invoice number and amount, each with a reason column.

  • “Someone overwrote a formula and nobody noticed for weeks.”

    Formula cells are locked, inputs are colour-coded and a self-check row shows when totals stop matching.

  • “We track client due dates on a whiteboard and in people's memory.”

    A compliance tracker that lists what is due by client, with optional WhatsApp or email reminders.

  • “Only one person in the office knows how this sheet works.”

    A "Start here" sheet, a one-page guide and a short handover video, so anyone can run it.

Typical tools

Excel tools we build for CA and finance teams

Each one starts from your own sample file and your real exceptions.

GSTR-2B vs purchase register

Exact matching first, then close matching on GSTIN, invoice number and amount within a tolerance you set. Every unmatched line gets a reason, such as missing GSTIN or a credit note.

Compliance due-date tracker

Due dates by client and return type, with status and owner. Reminders can go out by WhatsApp or email when a date is close.

Staff and client MIS

Who is working on which client, what is pending and what is billed. A small dashboard of three to five numbers, one chart each.

TDS and other calculators

Calculators built on the rules your CA gives us, with the rule version and date written on the sheet so it is clear when it needs an update.

Built so it does not break

Inputs kept apart and colour-coded, locked formula cells, data validation, structured tables and named ranges. No #REF or #N/A errors on your sample data.

A handover anyone can follow

A "Start here" sheet, a one-page guide, a three to five minute handover video and a change log tab, so the tool outlives any one person.

Compare

Excel or Google Sheets: which fits your team

Excel with Power QueryGoogle Sheets with Apps Script
Best whenYour team works offline on desktop ExcelSeveral people edit the same file online
Data importPower Query cleans and joins downloaded filesScripts pull from Drive folders or forms
RemindersUsually paired with a small reminder serviceCan send email reminders from the sheet itself
Who maintains itAnyone comfortable with Excel tablesAnyone with edit access, with a change log tab

How it works

How we build your Excel tool

  1. Map your sample file

    You share a masked sample of the real file. We map the columns, the exceptions such as missing GSTIN, odd invoice number formats, credit notes and rounding, and the output you want.

  2. Build and test on your data

    We build the tool in your Excel version or Google Sheets and test it on the masked sample until it runs with no errors and the self-check row turns green.

  3. Your CA confirms, then handover

    Your CA checks the tax logic and we note the rule version and date. You get the "Start here" sheet, a one-page guide and a short handover video.

Why Kredosys

Why build your Excel tools with Kredosys

Built from your real file

We work from your actual columns and exceptions, not a template from the internet, so the tool fits the way your office already works.

Tax decisions stay with your CA

The sheet follows rules your CA confirms. We never make a tax call, and the rule date is written on the sheet.

You own the file

The workbook, scripts and any connected accounts are yours, with full edit access for your admin and a change log for every version.

One accountable person

Himanshu Soni leads the work from sample to handover. Fixed price per phase or a monthly rate, never hourly billing.

FAQ

Questions, answered

Yes. The tool matches your GSTR-2B download with your purchase register, first exactly and then closely on GSTIN, invoice number and amount within a tolerance you set. Every unmatched line gets a reason column for your team to review.

Both. Excel with formulas and Power Query suits teams that work on desktop. Google Sheets with Apps Script suits teams that edit the same file online. We build in whichever version your team already uses.

We build and test on masked sample data, so real client names and numbers do not need to leave your office. The finished tool runs on your own computers or your own Google account.

Your CA does. We build the logic from the rules they give us, they confirm it before handover, and the sheet notes the rule version and date so everyone knows when it needs an update.

The change log and "Start here" sheet make small edits easy for your team. For bigger changes, such as a new download format, ask us on WhatsApp and we will update the tool and log the new version.

It depends on the task and the number of exceptions in your file. Share a masked sample on WhatsApp and we will write down a fixed price for the build before you sign.

No. Kredosys is based in Udaipur, Rajasthan, and works remotely with businesses across India and abroad. Discovery, demos and reviews happen over video calls and WhatsApp, with one accountable person, Himanshu Soni, leading the work.

Send us the sheet that eats your week.

Share a masked sample of the file and tell us what you do with it each month. We will tell you what can be automated and how the finished tool would work.