Skip to content
  • BOQ
  • Bidding
  • e-procurement

BOQ in tenders: full form, meaning and how to fill it

BOQ full form is Bill of Quantities. What it is, how to read one, and how to fill the protected Excel file without getting your financial bid rejected.

A BOQ — Bill of Quantities — is the buyer’s fixed list of every work or supply item with a quantity against each, and your entire job is to type a rate into the open cells of the protected Excel file the portal gives you. Don’t touch anything else: structure changes reject more financial bids than bad pricing does.

A contractor I know cleared the technical stage on a municipal works tender, quoted a fair price, and lost anyway. His financial bid was declared non-responsive. The reason wasn’t his number. He’d opened the BOQ file the portal gave him, found the layout cramped, inserted two rows to make it readable, and uploaded it. Those two rows shifted the cells the portal was reading from. The system pulled garbage, his total didn’t tally, and the committee tossed the bid.

The win went to a firm that did nothing clever at all. They just typed their rates into the cells they were told to, and uploaded the file untouched.

That’s the BOQ in one story. It’s the most mechanical part of a tender, and it rejects more financial bids than bad pricing does. Here’s what a Bill of Quantities actually is, how the portal hands it to you, and how to fill it without disqualifying yourself.

What a BOQ is and why it exists

BOQ stands for Bill of Quantities. It’s a structured list of every item of work or supply in the tender, with the measured quantity against each, that the buyer prepares in advance. Item one might be earthwork in excavation, so many cubic metres. Item two, providing and laying PCC, so many cubic metres. Item three, reinforcement steel, so many kilograms.

The buyer has already worked out the quantities. Your job is to put a rate against each line. That’s it.

It exists for one reason: to make bids comparable. If every bidder priced the job their own way, on their own sheet, the committee could never line them up fairly and pick the lowest responsive bid. The BOQ forces everyone onto the same list with the same quantities, so the only variable left is your rate.

That’s also why the format is sacred. The whole point of the document is that all bids share an identical structure. Break the structure and you break comparability — which is exactly when committees stop reading and start rejecting.

You’ll mostly meet the BOQ in works and supply tenders on the e-procurement portals (CPPP at eprocure.gov.in and the state GePNIC instances), where the financial bid is a filled BOQ rather than a single price. If you’re still finding your feet on the basics, I’ve written separately on how to apply for a government tender end to end. This post is the financial-bid piece in detail.

Know your contract type before you type a figure

Not every BOQ asks you to price the same way. There are three common contract types, and you have to know which one you’re in before you type anything.

TypeWhat you enterWhere you see it
Item-rateYour own rate for every line itemMost works and supply tenders
Percentage-rateA single above/below percent on the buyer’s estimated ratesSome PWD and works tenders
LumpsumOne price for the whole scope, sometimes with a payment scheduleTurnkey and design-build work

Item-rate is the most common form and the one most of this post is about: you fill a rate for each item, and the sheet multiplies it by the quantity to get the amount.

In a percentage-rate contract the buyer has already fixed the rates. You quote a single percentage above or below the estimated cost. Quote “5% below” and you’re agreeing to do every item at 5% under the schedule. The trap here is direction — bidders fill the wrong cell, or quote “above” when they meant “below”, and there’s no fixing it after submission.

In a lumpsum contract you price the whole scope as one figure. The BOQ may still list items for reference, but the contract is the total. Read carefully whether you’re pricing line by line or pricing the lot.

Get this wrong and your price means something different from what you intended. The committee will read what you submitted, not what you meant.

How the portal hands you the BOQ

On the e-procurement portals the BOQ is a downloadable file, almost always a protected Excel workbook. You log in, open the tender, go to the financial bid or BOQ section, and download it. It’ll have a fixed filename the system generated, and that filename usually matters.

The file is protected on purpose. Most cells are locked — the item descriptions, the quantities, the units, the formulas that calculate amounts and totals, all of it. Only the rate cells are open for you to type into, and sometimes a column for taxes.

The protection isn’t an obstacle. It’s the portal telling you exactly where you’re allowed to write. If a cell won’t let you type, that’s by design, and trying to force it open is how bids go wrong.

So download it, and resist every instinct to tidy it up. You’re not meant to format it, widen it, recolour it, or improve it. You’re meant to enter numbers in the open cells and leave everything else exactly as it came.

The one rule that matters most: don’t touch the structure

Do not alter the BOQ format or structure. Full stop.

That means:

  • No inserting rows.
  • No deleting rows.
  • No adding columns.
  • No renaming the file.
  • No copying the contents into a fresh sheet.
  • No changing the order of items.
  • No “I’ll just merge these two cells.”

The portal that issued the file is going to read it back cell by cell, and many portals verify the file hash or its internal structure on upload. The moment the structure differs from what was issued, the system either rejects the upload outright or, worse, accepts a file it then misreads — and your total comes out wrong.

This is the single most avoidable financial-bid rejection in tendering, and it’s the same root cause behind the format errors I covered in why tenders get rejected. The contractor who inserted two rows didn’t make a pricing mistake. He made a structure mistake, and structure mistakes are fatal because they break the one thing the BOQ exists to protect.

If the layout is genuinely hard to read, read it in a copy. Keep the real file pristine, type only the rates into it, and upload that.

Where to enter your rates (and why you fill every line)

The open cells are your rate column. In an item-rate BOQ, you type your unit rate against each item, and the locked formula multiplies it by the quantity to produce the amount. You don’t type the amount yourself. You don’t type the total. The sheet does that.

Fill every line. This matters more than it sounds. A blank rate cell isn’t read as zero in your favour — it’s read as an incomplete bid, and an incomplete BOQ is non-responsive the same way a missing document is. If an item genuinely seems not to apply, don’t guess: it almost always does apply, because the buyer put it there. Price every line the buyer listed.

A few practical habits:

  • Type numbers only. No rupee symbols or text in a rate cell — text where a number is expected can break the formula.
  • Quote rates you can actually honour. A BOQ is a binding schedule, and you’ll be paid against these exact line rates for the duration of the contract.
  • Don’t load all your margin into one item and zero out others to game the cash flow. Unbalanced bids get flagged and sometimes rejected on their own.

Check the GST model before anything else

This varies by tender, and you have to read which model yours uses, because it changes the number you type.

Some BOQs ask for rates exclusive of GST, with a separate line or column where tax is added on top. Some ask for rates inclusive of GST, where the figure you quote already contains the tax and nothing is added. A few works tenders, especially older formats, leave GST out of the BOQ entirely and handle it through the contract terms.

The difference is enormous. If the tender wants exclusive rates and you quote inclusive ones, you’ve quoted higher than your competitors for the same work and you’ll lose. If it wants inclusive and you quote exclusive, you’ve under-quoted and may win a contract you then deliver at a loss.

The instruction is always in the tender document or in a note inside the BOQ itself. Find it before you fill anything. When the format is unclear, the pre-bid meeting is where you ask — never the bid.

Rounding and totals: let the sheet do the maths

The locked formulas calculate each amount and the grand total, and those are the figures the committee evaluates. Your job is the rates; the maths is the file’s.

Where you do have a choice, keep rates to whole rupees or to two decimals consistently, and don’t hand-round in a way that fights the formula. The classic failure is a bidder who types a rate, separately writes a total they computed themselves, and the two don’t match.

That arithmetic mismatch makes the bid non-responsive, and on a close tender a corrected total can change the ranking and quietly hand the job to someone else. Never overtype a calculated cell with your own number. If your manual total and the sheet’s total disagree, the sheet is what gets read — trust it, and check your rates instead.

The mistakes that actually get financial bids rejected

After all of the above, the rejections cluster into a short, ugly list:

  • Changing cells you shouldn’t touch — inserting or deleting rows, editing descriptions or quantities, unlocking protected cells. The structure no longer matches what was issued.
  • Leaving items blank. A missing rate makes the BOQ incomplete, and incomplete is non-responsive.
  • Uploading the wrong file: a previous tender’s BOQ, an unsaved copy, a renamed file the portal won’t recognise. Upload the exact file the portal issued for this tender, filled and saved under the name it expects.
  • An arithmetic mismatch — a self-typed total that doesn’t tally with the rates, usually from overwriting a formula or quoting GST in the wrong model.
  • Wrong contract-type entry: filling item rates in a percentage-rate tender, or quoting above when you meant below.

Every one of these is mechanical. None of them is about whether you’re a good contractor. They’re about whether you respected a file that was built to be filled one specific way.

And most of them share a cause: the BOQ got filled in a rush, the night before a deadline, on a tender found late.

What I’d tell anyone filling their first BOQ

Treat the BOQ file as evidence, not a worksheet. Download it, don’t reformat it, type your rates into the cells that open, fill every line, let the formulas total it, confirm the GST model, and upload the exact file the portal gave you.

That’s the whole discipline. The bidders who lose on the BOQ are almost never the ones with bad prices. They’re the ones who tried to be helpful with a file that didn’t want their help.

Frequently asked questions

What is a BOQ in a tender?

A BOQ, or Bill of Quantities, is a structured list of every item of work or supply in the tender with the measured quantity against each, prepared in advance by the buyer. Your job is to put a rate against each line. It exists to make bids comparable by forcing every bidder onto the same list with the same quantities.

Can I edit or reformat the BOQ Excel file?

No. Don't insert or delete rows, add columns, rename the file, copy contents into a fresh sheet, change the order of items, or merge cells. The portal reads the file back cell by cell, and many portals verify the file hash or internal structure on upload — any change can get the bid rejected or misread. If the layout is hard to read, read it in a copy and keep the real file pristine.

What happens if I leave a rate cell blank in the BOQ?

A blank rate cell is read as an incomplete bid, not as zero in your favour, and an incomplete BOQ is non-responsive the same way a missing document is. Price every line the buyer listed, because the item almost always applies.

What is the difference between item-rate, percentage-rate, and lumpsum contracts?

In an item-rate contract you fill a rate for each line item and the sheet multiplies it by the quantity. In a percentage-rate contract the buyer has fixed the rates and you quote a single percentage above or below the estimated cost. In a lumpsum contract you price the whole scope as one figure.

How is GST handled in a BOQ?

It varies by tender. Some BOQs ask for rates exclusive of GST with a separate line or column where tax is added, some ask for rates inclusive of GST, and a few older works tenders leave GST out of the BOQ entirely and handle it through the contract terms. Find the instruction in the tender document or a note inside the BOQ before you fill anything.

Why do financial bids get rejected on the BOQ?

The common causes are mechanical: changing cells you shouldn't touch, leaving items blank, uploading the wrong file, an arithmetic mismatch from a self-typed total, and wrong contract-type entry such as quoting above when you meant below. None of them is about whether you're a good contractor.

Written by Ketul Shah

Ketul Shah is the founder of TrackTender and Anekant AI. He works with Indian SMEs that bid on government contracts and writes about GeM, e-procurement and how smaller suppliers can compete and win.

More about TrackTender →

Stop reading about tenders. Start winning them.

Pick your states and categories and get matching tenders on Telegram and WhatsApp.

Start tracking