What goes in the CAMS bulk upload Excel, the rules that get files rejected, and which month goes on the invoice. A plain guide for mutual fund distributors.
MFD Office fills the CAMS sheet for you, with every figure kept exactly as CAMS computed it. New to CAMS invoicing? Start with the full CAMS guide.
The CAMS upload window runs each month, usually the 7th to the 15th. Inside that window you submit two files:
The invoices must be signed, and during the upload you tick a checkbox to confirm they carry a signature. If either file has a problem, the upload fails and you must fix it and try again before the window closes.
The CAMS bulk upload Excel has exactly nine columns. Here is what goes in each.
| Column | What goes in it |
|---|---|
| BROKER GST NUMBER | Your GSTIN. It must be identical on every row. |
| MONTHYEAR | The month in MMYYYY format. June 2026 is written 062026. Same value on every row. |
| CAMS INVOICE NUMBER | The invoice number CAMS gives for the month. Same value on every row. |
| BROKER INVOICE NUMBER | Your own invoice number, the one printed on that fund house's invoice in your PDF. |
| TOTAL INVOICE VALUE | The total value of that invoice. It must match CAMS's figure to within about 1 rupee. |
| IGST AMOUNT | The IGST on that invoice, when the fund house is in a different state from you. |
| CGST AMOUNT | The CGST on that invoice, when the fund house is in your own state. |
| SGST AMOUNT | The SGST on that invoice, paired with CGST for a same-state fund house. |
| BROKER CODE | Your ARN, for example ARN-12345. Same value on every row. |
The tax columns follow the normal GST rule: the 18% GST on your brokerage is split as CGST plus SGST when the fund house's GST state matches yours, and charged as IGST when it does not. For the full field-by-field invoice layout and the SAC code, see the GST invoice format guide.
This trips up many distributors. On CAMS, the invoice date must follow the payment month, which CAMS calls the received month. That is the month the brokerage was paid to you, not the month it was earned.
KFIN does the opposite: it works on the trail month. If you file on both registrars, keep the two conventions separate, because mixing them is one of the most common errors. See the KFIN Excel template guide for how KFIN's sheet works.
Upload your CAMS file and see a real, signed invoice with the Excel completed to match. No signup, no card.
Try with your file, freeNine: BROKER GST NUMBER, MONTHYEAR, CAMS INVOICE NUMBER, BROKER INVOICE NUMBER, TOTAL INVOICE VALUE, IGST AMOUNT, CGST AMOUNT, SGST AMOUNT and BROKER CODE (your ARN). Four of them, your GST number, the month, the CAMS invoice number and your ARN, must be identical on every row.
MMYYYY: the two digit month followed by the four digit year, so June 2026 is 062026. The same value goes on every row.
Usually one of three things: a total that differs from CAMS's figure by more than about 1 rupee, a wrong MONTHYEAR format, or the constant columns not being identical on every row.
The payment month, which CAMS calls the received month. Not the month the brokerage was earned. KFIN works on the trail month instead, so do not copy dates from one registrar to the other.
Yes. You upload your CAMS brokerage file, and it makes a signed invoice for every fund house and fills the CAMS Excel to match, with every figure kept exactly as CAMS computed it. Try it free, or read the full CAMS guide.