Prepare monthly CAMS & KFintech GST invoice-upload Excels. Free to use — your files are processed in memory and never stored. Enter your own firm's GST & broker details below.
Each month a GST-registered distributor invoices the AMCs for the commission they paid. CAMS and KFintech collect those invoices through their portals, each in its own format. This tool turns the statements they give you into the files their portals take, so you are not retyping invoice lines into Excel.
Get the month's consolidated PDF from CAMS, and the monthly Excel plus the AMC-wise invoice PDFs from KFintech.
Enter your GSTIN, ARN, invoice prefix, financial year and the next invoice number, then upload the three sets of files. You get one ZIP with the CAMS upload Excel, a KFin Excel to use before signing, and a signing map (CSV).
Print, sign, stamp and scan the KFin PDFs in the order listed in the signing map. Prefix the scans 01_, 02_ and so on so they match the CSV.
Upload the Step 1 KFin Excel, the signing map and the signed scans. You get the final KFin upload Excel and the scans renamed to match it, ready to upload on the KFintech portal.
Both registrars collect commission invoices from distributors, but they ask for different inputs. That is why this tool has one step for CAMS and two for KFintech.
| CAMS | KFintech | |
|---|---|---|
| What you start from | One consolidated PDF for the month | A monthly Excel plus one invoice PDF per AMC |
| What you upload to the portal | An invoice-upload Excel | An invoice-upload Excel and the signed invoice scans |
| Signature needed | No physical signing step in this tool | Yes — print, sign, stamp and scan each AMC invoice |
| Steps in this tool | Done in Step 1 | Step 1 to prepare, Step 2 after signing |
Invoice numbers must continue from last month. Enter the next unused number as the starting number, not 1, unless a new financial year has begun.
Step 2 matches signed scans to invoices using the signing map. Prefix scans 01_, 02_ and so on in the exact order the CSV lists them.
Select every KFintech AMC PDF for the month in Step 1. An AMC left out will be missing from the upload Excel.
Compare totals in the generated Excels against your CAMS and KFintech statements before you upload. The tool reformats your data; it does not audit it.