A water pump repair log is a table with one row per repair: date, fault, part, part cost, labour and the mechanic. Add a running count of repairs and a twelve-month spend total, and you can see when the motor has become a money drain instead of guessing from the last bill.
What columns does the log need?
Keep it plain so you actually fill it in. Open Excel or Google Sheets and set these headers in row 1.
- A: Date of repair
- B: Fault noticed, such as no water pressure, motor humming, tripping, leaking seal
- C: Part replaced, for example capacitor, winding, seal, cable
- D: Part cost in rupees
- E: Labour in rupees
- F: Total, worked out as D plus E
- G: Mechanic name and phone
- H: Running repair count
- I: Notes, such as warranty on the repair or what he said about remaining life
Which formulas make it useful?
In F2 type =D2+E2 and fill down. In H2 type =COUNTA($A$2:A2) and fill down; it counts how many repairs have been logged up to that row. To see the spend in the last twelve months, put this in any empty cell:
=SUMIFS($F$2:$F$200,$A$2:$A$200,">="&TODAY()-365)
That adds the totals in column F where the date in column A is within the last 365 days. It works the same in Excel and Google Sheets. Make sure column A holds real dates, not typed text, or the condition will skip them.
When does it make sense to repair, and when to replace?
There is no universal rule, so set your own line before the next breakdown, when you are calm. A common household approach is to decide in advance what share of a replacement quote repairs may reach in a year.
Say three repairs in a year cost ₹1,200, ₹2,800 and ₹900. That is ₹4,900. Say a quote for a new motor is ₹9,500. Then repairs have already reached about 52 percent of the replacement price, because 4,900 divided by 9,500 is 0.516. If your own line was one half, the log is telling you to get a second opinion on replacement.
What should go on the first page of the log?
Before the first repair row, write down the facts about the pump itself, because you will want them when a mechanic or a shop asks. They are easy to find now and hard to find when the pump has stopped.
- Make and model, and the motor rating printed on its plate
- Date of purchase and the shop, with where the bill is kept
- Warranty period from the paper, and the date it ends
- Depth or head, pipe size and whether it is a surface pump or a submersible
- The phone number of the mechanic who installed it
A photograph of the nameplate, saved in the same folder as the log, is worth more than a paragraph of description.
What about a borewell motor lifted from the bore?
A borewell submersible is different because pulling it out costs labour and sometimes a tripod or vehicle charge, even before any part. Give that its own column, so the log shows the lifting cost separately from the repair itself. Otherwise the history makes the motor look cheaper to keep than it is.
Where do the bills go?
Take a photo of each bill and file it under the same date you typed in column A. If you pay by UPI or cash, add the entry the same day. SpendixAI lets you add a cash expense by hand and keep the receipt with that transaction, which gives you the repair history under a Home repairs category without a separate folder. A sheet alone is fine if you prefer it.
A five-minute set-up
- Create the sheet with the headers above.
- Enter the last two or three repairs you remember, even roughly, and mark them as estimates in Notes.
- Add the two formulas.
- Write your repair-or-replace line at the top of the sheet.
- Add a row the same day every time the mechanic visits.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


