Claude Text prompt

Monthly GST Sales Summary Sheet

Build a sheet that sums your monthly sales by GST rate — ready to share with your accountant.

Free No login · Commercial use allowed · Copy and use
  • 0 times copied
  • 92 words
  • Updated November 10, 2026

The prompt

Help me build a Google Sheet that summarises my monthly sales for GST.
My invoice list columns: [columns, e.g. Date, Invoice No, Customer GSTIN, Taxable Value, GST Rate, CGST, SGST, IGST].

1. Design a 'Summary' tab that shows, for a chosen month: total taxable value and tax by GST rate (0%, 5%, 12%, 18%, 28%), split into B2B and B2C.
2. Give exact formulas (SUMIFS) and a month dropdown.
3. Add checks that flag invoices with missing GSTIN for B2B or wrong tax type.
Note clearly that final GST filing should be checked by a CA.

What to write in the [brackets]

ReplaceWith
[columns]Your invoice list columns

How to use this prompt

  1. Click "Copy prompt" above.
  2. Open Claude (the free version works for most prompts).
  3. Paste the prompt and replace every part in [square brackets] with your own details.
  4. Send it, then ask follow-up questions to improve the answer (e.g. "make it shorter", "write it in Hindi").
  5. Check facts, prices and numbers before you use the result with customers.

Tips for better results

  • Share the summary tab (not your whole data) with your CA.
  • GST rates and rules change — confirm current rates on the official portal.

Try these variations

After the first answer, send one of these as a follow-up message:

  • Add a purchase side summary for input tax credit.

FAQ

Does this prompt work only with Claude?

No. It works in ChatGPT, Gemini, Claude and most other AI chat tools. Results vary a little between tools.

Is this prompt free to use for my business?

Yes. All prompts in the Cracckk Prompt Library are free, including for commercial work. Always check AI output before you publish or send it.

Can I use it in Hindi or another Indian language?

Yes. Add a line like "Reply in Hindi" or "Use Hinglish" at the end of the prompt.