Which columns KFIN fills for you, the ones you complete yourself, how the ZIP of signed invoices must line up, the on-screen upload option, 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 GST Invoice Management. There you can download your GST invoices and credit notes, AMC-wise or all funds together, in PDF and Excel, and see the status of everything you have submitted.
When you are ready to upload, open Signed GST Invoice Upload, click the Excel Based Upload tab, pick the month, and 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 |
|---|---|
| KFIN's data columns | Month, Fund Code, AMC, AMC GSTR Number, Invoice Reference No, Taxable Income and GST Amt come prefilled from KFIN's records. Do not change them, not even formatting. They are how KFIN matches your upload to its own records. |
| Invoice Number | Prefilled. Uploading KFIN generated invoices? Leave it as it is. Uploading your own MFD generated invoices? Change it to your own invoice number, the same number printed on the signed copy. |
| Invoice Date | Prefilled, same rule: leave it for KFIN generated invoices, change it to your own date for MFD generated invoices. |
| File Name | Always yours to fill: the exact filename of the matching signed invoice inside your ZIP, character for character. |
One more allowance: if you raised more than one of your own invoices against a single payment, add extra rows for that fund by copying the prefilled values as they are. The invoice amounts together must match the payment amount.
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.
The Excel based upload asks for two files together: the completed Excel, and a single ZIP containing your signed invoices (PDF or JPEG). The invoices must be signed before they go in the ZIP: print, sign and scan them, or sign them digitally. Two rules decide whether the upload goes through:
Beside the Excel based tab sits On Screen Upload. Pick the month, then choose your invoice source: KFIN generated invoice (invoice number and date are filled in automatically and cannot be edited) or MFD generated invoice (you type the number and date). Then attach the signed file against each fund house directly in the grid, and the status column shows what is still pending. Handy when you have one or two funds to finish; with many fund houses, the Excel way is faster.
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, freeAlways the File Name column. Invoice Number and Invoice Date come prefilled: leave them for KFIN generated invoices, or change them to your own for MFD generated invoices. The KFIN data columns must not be changed.
The KFIN data columns (month, fund, AMC GSTR number, amounts) must be left exactly as they are; changing them is a common cause of rejected uploads. Invoice Number and Invoice Date are editable only when you upload your own MFD generated invoices.
Yes. The On Screen Upload tab lets you attach the signed file per fund house, with invoice number and date automatic for KFIN generated invoices or typed in for MFD generated ones.
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.