CUSTOMER MASTER
Company: [Name] | Maintained by [Accounts Team] | Last updated [DD/MM/YYYY]
| Cust ID | Customer Name | GSTIN | State (Code) | Billing Address | Contact / Email | Credit Limit (₹) | Payment Terms |
|---|---|---|---|---|---|---|---|
| [C001] | [Alpha Retail Pvt Ltd] | [27AAACA1234A1Z5] | [Maharashtra (27)] | [Shop 4, MG Road, Pune 411001] | [+91 98xxxxxx / ap@alpha.in] | [2,00,000] | [Net 30 days] |
| [C002] | [Beta Enterprises] | [29ABBCB5678B1Z2] | [Karnataka (29)] | [No. 12, 5th Cross, Bengaluru 560001] | [+91 90xxxxxx / accts@beta.in] | [50,000] | [Advance / COD] |
| [C003] | [Gamma Traders (Unreg.)] | [URP – Unregistered] | [Delhi (07)] | [Plot 9, Karol Bagh, New Delhi 110005] | [+91 99xxxxxx / gamma@mail.in] | [25,000] | [Net 15 days] |
How to use: Assign a unique Customer ID and verify each GSTIN on the GST portal before onboarding. The 2-digit State Code drives whether you charge IGST (inter-state) or CGST+SGST (intra-state). Set a credit limit and payment terms per customer, and mark unregistered buyers as "URP". Review credit limits quarterly against the debtors ageing report.