Free template · Purchase

Rate Contract Format (Free Excel) + Filled Example

A free rate contract format in Excel, blank and filled. Every column explained, a worked example from an engineering unit, and the mistakes that cost factories money.

Download the Excel template

A rate contract fixes the price a supplier will charge for each item for a set period, usually one year, without fixing the quantity. You then place purchase orders against it at the agreed rate whenever you need stock. A good rate contract format lists each item's code, specification, unit, estimated yearly quantity, agreed rate, GST, lead time and validity dates. It also sets the price-change and cancellation terms.

What is a rate contract?

A rate contract is a standing offer from your supplier. The supplier agrees to sell at a fixed rate for the contract period. You don't promise to buy any fixed quantity.

When stock runs low, you raise a purchase order at the contract rate. No fresh quote, no fresh negotiation.

Rate contract vs purchase order

PointRate contractPurchase order
What it fixesRate and termsItem, quantity, rate and delivery date
QuantityAn estimate onlyThe exact quantity you buy
PeriodUsually one yearOne order
Commits you to buyNoYes

For the full purchase order layout, see our purchase order format templates.

When a factory should use one

Use one for repeat items with a steady spec: steel, fasteners, packaging and shop consumables. Skip it for one-off buys and custom parts that need a drawing and a fresh quote.

Rate contract format: header and terms

Fill these fields once, at the top of the contract.

  • Buyer and supplier: legal names, addresses and GSTINs of both sides.
  • RC number and date: a unique number, so every PO can quote it.
  • Validity: the start date and the end date.
  • Price basis: ex-works or delivered to your gate, and who pays freight, packing and loading.
  • Payment terms: credit days, counted from the invoice date or the GRN date.
  • Delivery: lead time from the PO date, and the delivery address.
  • Price-change clause: when rates can be reviewed. Any change needs written agreement before it applies.
  • Fall clause: if the supplier sells the same item cheaper to another buyer, your rate drops too.
  • Cancellation: how many days' notice either side must give.
  • Signatures: name, designation, signature and stamp of each side's authorised signatory.

People often ask about the 7 rules of a contract. A rate contract is a normal commercial contract, so the same basics apply. It needs clear parties, an offer and its acceptance, a lawful price and purpose, and signatures from people allowed to sign.

Have a lawyer review your terms before the first signing.

Item schedule: every column explained

One row per item. These are the 12 columns in the Excel download.

  • Item code: your internal code. Use the same code your stores and BOMs use.
  • Item description and specification: size, grade, finish, make and pack size. This stops a cheaper grade arriving at the same rate.
  • Unit: Nos, kg, litre, metre or box. Keep the same unit on every PO and invoice.
  • Est. yearly qty: your best guess for the year, from last year's POs. It guides the supplier's price but doesn't bind you.
  • Basic rate (₹): the supplier's price per unit before discount.
  • Discount %: the discount you negotiated on the basic rate.
  • Net rate (₹): basic rate × (1 − discount). Every PO must carry this rate.
  • GST %: the GST rate for the item's HSN code. Confirm it with your accountant.
  • Rate incl. GST (₹): net rate × (1 + GST %). Accounts use it to check invoices.
  • Lead time (days): days from the PO date to delivery at your gate.
  • Est. yearly value (₹): estimated yearly qty × net rate, before GST.
  • Remarks: minimum order quantity, approved make or test certificate needs.

Where TranZact fills this for you

A rate contract only works if every PO, GRN and invoice follows it. In the patchwork of Excel, WhatsApp and Tally, that check depends on someone remembering. The software leaves it to people.

TranZact is manufacturing AI software used by 10,000+ manufacturers. Its purchase flow runs MRP report → indent → RFQ → PO → GRN → payment, with vendor coordination, in one system.

The MRP engine runs through your orders and BOMs, then tells you what to buy and when. Approvals and alerts and 65+ reports come with every plan.

Accounting stays in Tally. Operations run in TranZact, with a one-way sync and no double entry. Busy, Zoho Books and Excel / Google Sheets connect too.

On the Dominate plan, custom document formats let your POs carry your own layout. TranZact goes live in 2–3 weeks. See the purchase management features and plans. Your contract terms still need your lawyer's review.

Book a demo →

How to fill a rate contract format, step by step

  1. List the items. Pull every repeat item from last year's purchase orders. Your bill of materials format helps you catch the rest.
  2. Estimate yearly quantity. Start from last year's total and adjust for the orders you expect.
  3. Send an RFQ. Ask two or three suppliers to quote on the same item list. Our RFQ guide shows what to include.
  4. Negotiate. Compare lead time, payment terms and delivery record, not just the rate. See our guide to vendor management.
  5. Fill the rates. Enter basic rate, discount, GST and lead time on each row.
  6. Agree the terms. Settle validity, price basis, the price-change clause and the notice period.
  7. Sign. Both sides sign and stamp every page.
  8. Share it. Send copies to stores, the purchase team and accounts, so each checks POs and invoices against it.

[[IMAGE {"type":"checklist","title":"Check each invoice against the rate contract","items":["RC number quoted on the PO","Net rate matches the contract rate","GST % matches the item's HSN code","Quantity matches the GRN","Delivered within the agreed lead time","Invoice date within contract validity"]}]]

Worked example: a rate contract for an engineering unit

Say an engineering unit signs a one-year rate contract with its fastener and consumables supplier. All numbers below are illustrative.

ItemEst. yearly qtyNet rate (₹)Est. yearly value (₹)
Hex bolt M10×50, Gr 8.8, zinc plated50,000 Nos12.006,00,000
Hex nut M10, Gr 8, zinc plated50,000 Nos3.801,90,000
Plain washer M10, zinc plated1,00,000 Nos1.001,00,000
Soluble cutting oil1,200 litres225.002,70,000
Grinding wheel 180×6×31.75 mm, A60400 Nos441.001,76,400
Total before GST13,36,400

How the price is calculated

Take the bolt. The basic rate is ₹12.50 and the discount is 4%. Net rate = 12.50 × (1 − 0.04) = ₹12.00.

Yearly value = 50,000 × ₹12.00 = ₹6,00,000. At 18% GST, the rate including GST is ₹14.16.

One PO raised against it

In May, stores need 5,000 bolts and 5,000 nuts. The buyer raises one PO that quotes the RC number and the contract rates.

Bolts: 5,000 × ₹12.00 = ₹60,000. Nuts: 5,000 × ₹3.80 = ₹19,000. The PO value is ₹79,000, plus ₹14,220 GST, so ₹93,220 in total.

No new quote was needed. The supplier delivers within the 7-day lead time in the contract.

Tracking orders against the rate contract

Signing is the easy part. Money leaks later, when POs go out at the wrong rate or the contract lapses unnoticed. The download holds the item schedule only. Add a simple order log as a second sheet in your own copy, with these four columns.

ColumnWhat to writeWhat it catches
PO no. and dateEach PO raised against this RCOrders placed outside the contract
Rate on PO vs RC rateBoth rates, side by sideRate drift
Qty drawn so farRunning total for each itemBuying far above or below the estimate
Days to expiryEnd date minus todayA lapsed contract still in use

Check the log every month. If an item has used most of its yearly estimate by month six, talk to the supplier early.

Common mistakes in rate contracts

  1. No end date. You keep buying at last year's rate, or the supplier says the rates have lapsed.
  2. Loose specs. "M10 bolt" is not enough. Write grade, length, finish and make.
  3. No price-change clause. The supplier raises the invoice rate mid-year, and you find out at payment time.
  4. Price basis left out. Freight, packing and loading turn up as extra lines on the invoice.
  5. Contract never shared. Stores and accounts never see it, so POs go out at old rates and invoices get paid unchecked.

See your own items, suppliers and purchase flow running in TranZact. Don't be the bottleneck. Become the AI-Run Factory.

Book a demo →

Frequently asked questions

Is a rate contract legally binding?

The signed terms bind both sides, but the contract fixes no quantity. The binding buy happens when you send a purchase order against it. Have a lawyer check your terms.

How long should a rate contract run?

Most run for one year. Government rules allow up to two years in exceptional cases. For steel or other volatile items, keep it shorter or add a price-review date.

Can the supplier increase the rate mid-contract?

Only if the contract has a price-change clause. Write when rates can be reviewed, and that any change must be agreed in writing before it applies.

Should the rate include GST?

Show the net rate before GST, the GST % and the rate including GST in separate columns. Then accounts and the supplier read the same number.

Can I have rate contracts with two suppliers for the same item?

Yes. Government buyers sign parallel rate contracts with more than one supplier. A factory can do the same for critical raw material and split orders by price and delivery record.

Don’t be the bottleneck.
Become the AI-Run Factory.

Book a demo

Born in India. Building for the world.