Skip to content

Cement Consumption Register Format

Self-carrying daily balance, receipts against challan, issues against item of work, monthly summary.

  • Excel (.xlsx)
  • 5 sheets
  • Free
  • Updated

What is in the file

  • Instructions
  • Project Details
  • Daily Register
  • Filled Sample
  • Monthly Summary

What is a cement consumption register on a construction site?

A cement consumption register is a daily record of cement received, issued and in stock, with the opening and closing balance worked out for each day. It is a standard site record, is contractually required on most departmental works, and is the source document behind the cement figures in a material reconciliation statement.

What is in the cement consumption register workbook?

  • Project Details — project, store and period particulars.
  • Daily Register — one row per day. Opening and closing balances are calculated.
  • Monthly Summary — month totals pulled from the register, set against physical stock.
  • Filled Sample — ten days of illustrative entries.

How does the cement consumption register sheet calculate?

  • Closing balance for each day = opening balance + bags received − bags issued.
  • Opening balance for each day is carried from the previous day's closing balance, so it is never typed twice.
  • Monthly summary: total available = opening balance + total received; the closing balance as per register is compared with the physically verified stock, and the difference is shown.

Worked example from the sample sheet: 400 bags are received on the first day. With 62 bags issued the next day and 58 the day after, the register carries 338 and then 280 bags forward without any retyping.

How do you use the cement consumption register template?

  1. Fill in the project, store and month on Project Details.
  2. Enter the opening balance in the first row of the Daily Register only. Every later row pulls its opening balance from the previous day's closing balance.
  3. Record each receipt against its challan or GRN number, and each issue against the item of work and the grade of concrete or mortar it went into.
  4. Verify physical stock at least weekly and enter it in the physical stock column.
  5. At month end, check the Monthly Summary sheet — it is already linked — and enter the physically verified closing stock.

What should you check before relying on the cement consumption register?

  • The register is only useful if entries are made on the day the material moves. Reconstructing it at month end defeats its purpose and is usually obvious to an auditor.
  • Every issue should name the specific item of work and grade. An entry reading only 'site' cannot be reconciled against theoretical consumption later.
  • Cement has a limited shelf life and is damaged by damp storage. Note bags written off separately rather than showing them as issued.
  • The same format can be reused for steel by changing the unit from bags to kilograms.

What does each column mean?

ColumnWhat goes in it
DateThe day of the entry. Make it on the day the material moves, not at month end.
Opening Balance (bags)Auto-filled from the previous day's closing balance. Type it only in the first row.
Received (bags)Bags received into store that day.
Challan / GRN No.The challan or goods-received-note number the receipt is booked against.
Issued (bags)Bags issued to work that day.
Item of Work / LocationThe specific item of work and location the cement went into. An entry reading only 'site' cannot be reconciled later.
Grade of Concrete or MortarThe mix the cement was used for — M20, CM 1:4, and so on.
Closing Balance (bags)Auto-calculated. Opening + received minus issued.
Physical Stock (bags)The physically counted stock, verified at least weekly.
RemarksDamaged, set or wasted bags — noted here and written off separately, never shown as issued.

Site consumption has to reconcile against the work actually done. The material reconciliation statement is where this record is compared with the theoretical quantity for the work executed.

Get the quantities from your drawings

These records only mean something against an accurate bill of the work. Upload your drawings and InstaBOQ produces the measured, itemised BOQ your consumption norms and reconciliations are checked against.

Questions

What is a cement consumption register?

A daily record of cement received on site, cement issued and the item of work it was issued for, and the running balance in the store. It is the source record the cement line of a material reconciliation is checked against.

Why record the grade of concrete or mortar against each issue?

Different mixes consume different amounts of cement. Recording the grade and the item of work lets the issues be compared with the theoretical consumption for the work actually done.

How much does a bag of cement weigh?

A standard bag of cement in India contains 50 kg.

How should damaged or set cement bags be recorded?

Through a separate write-off note signed off by the engineer, not absorbed silently into the difference between the register balance and the physical stock.

How often should cement stock be physically verified?

At least at the end of each month, when the monthly summary compares the register balance with the physically counted stock. Any difference must be explained and signed off.

Next in your work

Fill a BOQ item by item in your browser and export it to Excel. Free to start.