Home and property

Cement, steel and sand: a purchase log for self-construction

A purchase log for self-construction with one row per delivery: supplier, quantity, rate, bill number and photo, plus a check of bought against used.

Editorial illustration for Cement, steel and sand: a purchase log for self-construction

For a house you are building yourself, the cleanest record is one row per delivery. Note the date, the supplier, the material, the quantity and unit, the rate, the amount, the bill number and a photo of what arrived. Once every delivery is logged, you can compare what you bought with what the contractor says went into the structure.

What columns should the log have?

  • Date and supplier name.
  • Material: cement, steel, sand, aggregate, bricks, whatever you buy.
  • Quantity and unit, exactly as the supplier counts it: bags, kg, tonnes, loads, cubic feet, pieces.
  • Rate per unit and total amount.
  • Bill or challan number, and whether you paid or it is pending.
  • Stage, so purchases total by phase of construction.
  • Delivery photo, and the name of the person who received the material.

What formulas keep it honest?

Put the quantity in column E, the rate in F and the amount billed in G. Then use the following, with data from row 2.

  • Calculated amount in H2: =E2*F2
  • Difference from the bill in I2: =G2-H2. Anything other than zero deserves a look, for example a transport charge or a rate that changed.
  • Total quantity of one material, with the material name in column C and the one you want in K1: =SUMIFS($E$2:$E$500, $C$2:$C$500, $K$1)
  • Total spent on one material: =SUMIFS($G$2:$G$500, $C$2:$C$500, $K$1)

Remember to keep the same spelling of each material in column C, or SUMIFS will treat 'Cement' and 'cement bags' as different things.

How do I check bought against used?

Ask the contractor or the mestri to tell you, in writing, how much of each material went into the work in a given period. Then compare it with what you bought. A made-up example for cement: bought across deliveries 500 bags, reported as used 470, so about 30 should remain. If you count 22 bags on site, 30 minus 22 leaves 8 bags to ask about.

One gap does not prove anything. Bags may be damaged, some may be used for small jobs, and counts can be off. The value of the check is that you ask early and keep asking, so the gap does not grow without anyone noticing.

What should I do about bills and rates?

  • Ask for a written bill for every purchase, even a small one.
  • Compare the rate with at least one other quotation when you place a large order, and note both.
  • If a supplier changes the rate between order and delivery, ask for a message confirming the new rate.
  • Keep paid bills in a folder by material.

When a sheet stops being enough

A log like this is a good fit for a sheet because of its columns and checks. If you also want the bank payments to suppliers in your overall spending view, upload the statement to SpendixAI and review the rows. Photos of bills can be kept with the matching transaction. The quantity checks still live in your own sheet.

What about rate changes and returns?

Steel and cement prices can move between orders, so log every purchase at the rate on that bill, never at the rate you remember. If you return material, add a negative row with the same material name and a note, for example a row with a quantity of -10 bags and the return slip number. SUMIFS will then give you the net quantity automatically. Mark credit notes and refunds with the date the money actually came back.

A monthly check

  1. Total each material for the month and compare with the contractor's stage claim.
  2. Tick every bill against a payment.
  3. List pending bills and the date each is due.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports