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.
Excel and Sheets automation · CA and finance teams
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.
Sound familiar?
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.
Exact matches first, then close matches on GSTIN, invoice number and amount, each with a reason column.
Formula cells are locked, inputs are colour-coded and a self-check row shows when totals stop matching.
A compliance tracker that lists what is due by client, with optional WhatsApp or email reminders.
A "Start here" sheet, a one-page guide and a short handover video, so anyone can run it.
Typical tools
Each one starts from your own sample file and your real exceptions.
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.
Due dates by client and return type, with status and owner. Reminders can go out by WhatsApp or email when a date is close.
Who is working on which client, what is pending and what is billed. A small dashboard of three to five numbers, one chart each.
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.
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 "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 with Power Query | Google Sheets with Apps Script | |
|---|---|---|
| Best when | Your team works offline on desktop Excel | Several people edit the same file online |
| Data import | Power Query cleans and joins downloaded files | Scripts pull from Drive folders or forms |
| Reminders | Usually paired with a small reminder service | Can send email reminders from the sheet itself |
| Who maintains it | Anyone comfortable with Excel tables | Anyone with edit access, with a change log tab |
How it works
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.
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.
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
We work from your actual columns and exceptions, not a template from the internet, so the tool fits the way your office already works.
The sheet follows rules your CA confirms. We never make a tax call, and the rule date is written on the sheet.
The workbook, scripts and any connected accounts are yours, with full edit access for your admin and a change log for every version.
Himanshu Soni leads the work from sample to handover. Fixed price per phase or a monthly rate, never hourly billing.
FAQ
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.
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.