Which columns KFIN fills for you, the three you must fill yourself, how the ZIP of signed PDFs must line up, and the trail month rule. A plain guide for mutual fund distributors.
MFD Office fills the KFIN sheet for you, with every figure kept exactly as KFIN computed it. New to KFIN invoicing? Start with the full KFIN guide.
Everything happens on the KFIN distributor portal, dss.kfintech.com, under the GST Invoice Management tab. There you can download indicative invoices, one per fund house per month, which show the brokerage and GST figures KFIN has computed for you.
When you are ready to upload, use Generate Excel Template. This does not give you a blank sheet. It gives you a prefilled one, with one row for each invoice you are about to upload.
The split is simple, and it is the single most important thing about this template.
| Part of the sheet | What to do with it |
|---|---|
| First seven columns | Prefilled by KFIN with the details of each invoice. Do not change them, not even formatting. They are how KFIN matches your upload to its own records. |
| Invoice Number | You fill this in: your own invoice number for that fund house, the same number printed on the signed PDF. |
| Invoice Date | You fill this in: the date on that invoice. |
| File Name | You fill this in: the exact filename of the matching signed PDF inside your ZIP, character for character. |
The GST figures themselves, the 18% split into CGST plus SGST or IGST, come from KFIN's own computation and appear in the indicative invoices. For what the invoice itself must contain, see the GST invoice format and SAC code guide.
KFIN takes two separate uploads: the completed Excel, and a ZIP file containing your signed invoice PDFs. Two rules decide whether it goes through:
KFIN works on the trail month: the invoice relates to the month the brokerage belongs to. CAMS is different. It works on the payment month, the month the money reached you, which CAMS calls the received month.
If you file on both registrars, and most distributors do, keep the two conventions apart. Mixing them, for example dating a KFIN invoice by the payment month, is a common error. The CAMS side has its own sheet with its own rules, explained in the CAMS bulk upload format guide.
The upload window is usually the 7th to the 15th of each month. Upload late and the GST on that month's brokerage waits until you upload a valid signed invoice. Once your invoice is uploaded, remember your GST returns: the invoice must also appear in your GSTR-1 so the fund house sees it in its GSTR-2B. That loop is explained in the GSTR-2B and clawback guide.
Upload your KFIN file and see a real, signed invoice with the Excel completed to match. No signup, no card.
Try with your file, freeOnly three: Invoice Number, Invoice Date and File Name. The first seven columns come prefilled from KFIN and must not be changed.
No. The first seven columns are KFIN's own data and must be left exactly as they are. Changing them is a common cause of rejected uploads.
Usually because the number of Excel rows does not equal the number of PDFs in the ZIP, or a File Name does not match the actual filename exactly, or a prefilled column was changed.
The trail month, the month the brokerage relates to. CAMS uses the payment month instead, so do not carry dates from one registrar to the other. See the CAMS format guide.
Yes. Upload your KFIN brokerage file and it makes a signed invoice per fund house and fills the sheet to match, with every figure kept exactly as KFIN computed it. Try it free, or read the full KFIN guide.