<!-- kaynak: https://aksco.com.tr/en/insights/maintenance-breakdown-log-template/ · dil: en · güncelleme: 2026-10-23 -->
<!-- başlık: Maintenance Breakdown Log Excel Template: Downtime and Parts -->
<!-- açıklama: Free maintenance breakdown log Excel template: record breakdowns, see downtime per equipment and open records, get a spare parts request list. -->
# Maintenance Breakdown Log: Downtime, Open Records and Spare Parts List (Excel)

> **Question:** How do you keep a maintenance breakdown log?
> **Short answer:** Write each breakdown on one row with a record number, the date and time it was reported, the equipment code, location, fault description, priority, who reported it and who it is assigned to; then add the response and closing times, the status (Open, Awaiting parts, Closed) and the spare part used / reserved or awaited.
> Source: https://aksco.com.tr/en/insights/maintenance-breakdown-log-template/ · Last updated: 2026-10-23 · Publisher: AKSCO Ticaret ve Tedarik

A free Excel log that records breakdowns with record number, reported, response and closing times, and works out downtime per equipment, open and awaiting-parts records and a spare parts request list.

Published: 2026-10-23 · Last updated: 2026-10-23 · 14 min read · Prepared by AKSCO · [Editorial standards](https://aksco.com.tr/en/editorial-standards/)

Contents

1. Short answer
2. When to use a breakdown log
3. Fields on the log
4. Several parts on one breakdown: additional part rows
5. How downtime is calculated
6. Two MTTR- and MTBF-like indicators (from your records)
7. Summary: breakdowns by equipment, open and awaiting-parts records
8. Spare parts and consumables request list
9. Check messages
10. What this file does not do

## How do you keep a maintenance breakdown log?

**Write each breakdown on one row with a record number, the date and time it was reported, the equipment code, location, fault description, priority, who reported it and who it is assigned to; then add the response and closing times, the status (Open, Awaiting parts, Closed) and the spare part used / reserved or awaited.** The time from report to close is the record’s downtime; totalled per equipment it shows which equipment produces how many breakdowns and how much downtime. The free Excel workbook below builds that summary, the open and awaiting-parts records and an unpriced request list from the parts automatically; it suggests no maintenance interval or target time.

## Free maintenance breakdown log (Excel)

Enter each breakdown as one row on the Breakdown Log sheet; the second and further parts of the same breakdown go on the rows below with the same record number. The Summary sheet shows, per equipment, the number of breakdowns, total downtime, average time to close and average time between breakdowns, plus the open and awaiting-parts records. The Spare Parts Request List totals awaiting and used / reserved parts. Prints on A4; no sign-up.

- [XLSX — Maintenance Breakdown Log (Excel, in English) — 300 record rows · breakdowns and downtime by equipment · open and awaiting-parts records · spare parts request list · no sign-up](https://aksco.com.tr/assets/docs/aksco-maintenance-breakdown-log.xlsx)

The workbook is a recording and listing tool; it suggests no maintenance interval, response or closing target time, priority rule or benchmark value. Rows starting “EXAMPLE —” are examples: clear them and enter your own records.

## When to use a breakdown log

A record is opened when a machine, device or asset stops unexpectedly, runs incorrectly or can no longer be used safely. The point of the record is to keep on one row when the breakdown was reported, who it was assigned to, when work started, when it was closed and which part was used or is awaited. As records build up, it becomes visible at a glance which equipment keeps breaking down, which records are still open and which parts are awaited.

Planned maintenance and statutory periodic inspections are a separate job; this log is for unplanned breakdowns. If you keep an asset register, use the same equipment code in both files so that records can be matched by code.

## Fields on the log

Fields on the Breakdown Log sheet

| Field | What to enter | Note |
| --- | --- | --- |
| Record no. | Your organisation’s breakdown or work-order number | The row where it first appears is the main record; an additional part row is linked by this number |
| Reported (date and time) | The moment the breakdown was reported: yyyy-mm-dd hh:mm | Start of the downtime |
| Equipment / asset code | Code of the machine, device or asset | The summary totals per equipment by this code |
| Equipment name, location | Name and place (line, floor, room) | The summary shows the name and location of the first record |
| Fault description | What happened and how it was noticed | Warning if blank |
| Priority | One of the names on the Lists sheet | You write the names; the file sets no priority rule |
| Reported by, assigned to | Person, team or contractor | The assignee appears in the open records list |
| Response (date and time) | The moment work started | Cannot be before reported |
| Closed (date and time) | The moment work finished | Only with status Closed; cannot be before reported or response |
| Status | Open · Awaiting parts · Closed | The part on an Awaiting parts record goes on the request list as “awaiting” |
| Spare part / consumable, quantity, unit | Item used / reserved or awaited | Totalled by matching part name + unit |
| Note | Free text | Not used in calculations |

Light-yellow cells are inputs, grey-blue cells are formulas. The Check column shows the first problem on each row.

Enter date and time in the same cell as yyyy-mm-dd hh:mm (e.g. 2027-03-15 09:30). If only a date is entered, the time counts as 00:00; for reported and closed the Check column warns about this, because the duration would be off by hours. Priority names are on the Lists sheet and are labels only: the file attaches no response or closing time to a priority.

## Several parts on one breakdown: additional part rows

If more than one part was used or is awaited for a breakdown, the first part goes on the main row; the others go on the rows below with **the same record number** and only part, quantity, unit and note. An additional part row takes the main record’s status and is not counted as a breakdown; if the main row has an error, so does the additional row.

The EXAMPLE has 2 additional part rows: Bearing 6204-2RS (2 each) on record BD-002, Compressor oil (5 litre) on record BD-003. If the same record number is given to another breakdown, the lower row shows the error “an additional part row holds only part, quantity, unit and note”, so a duplicated record number is caught as well.

## How downtime is calculated

Downtime (h) = (closed − reported) × 24. For a record not yet closed, (report time − reported) × 24; 0 if reported is after the report time.

EXAMPLE: for BD-001, reported 2026-10-01 08:15, closed 2026-10-01 13:45; downtime 5.5 h. For BD-003, reported 2026-10-07 10:00, status Awaiting parts; with a report time of 2026-10-20 17:00, downtime is 319.0 h. Excel stores dates as days, so the difference is multiplied by 24 to give hours.

The report time is at the top of the Summary sheet. If it is left blank, the current time is used and the file recalculates the open records each time it opens; to report as of a given moment, enter the date and time.

**This is calendar time.** If the equipment was fully stopped from report to close, it equals the actual downtime; if it kept running partly during the breakdown, it is longer than the actual downtime. Nights and weekends count too; the file has no shift-calendar correction.

## Two MTTR- and MTBF-like indicators (from your records)

MTTR and MTBF are two abbreviations used in maintenance reporting. MTBF stands for mean time between failures; how MTTR is expanded depends on the source (mean time to repair or mean time to restoration). The maintenance terminology standard is EN 13306; it is a paid standard and its definitions are not reproduced here. The two indicators in the file do not replace those definitions; what they calculate is shown below with the formula:

- **Average time to close (MTTR-like)** = total downtime of closed records ÷ number of closed records. It includes everything from report to close: waiting for a response, fault finding, waiting for parts and the repair.
- **Average time between breakdowns (MTBF-like, days)** = (last reported − first reported) ÷ (breakdown records − 1), when the same equipment has at least two records. It uses the calendar, not the equipment’s operating hours; if you track operating hours, a calculation based on them gives a different result. It does not count the time before the first breakdown, and the time between two reports includes the repair time of the earlier breakdown.

EXAMPLE: CMP-01 has 3 records; first reported 2026-10-01 08:15, last reported 2026-10-19 11:00, difference 18.11 days; 18.11 ÷ (3 − 1) ≈ 9.06 days, shown as 9.1 days (one decimal). The average time to close of its 2 closed records is 3.3 h.

Both indicators are calculated only from your records in this file. The file gives no target value, industry average or “good / bad” threshold; the indicators are for following your own equipment’s records. With only a few records for an item, a single long breakdown shifts the average markedly.

## Summary: breakdowns by equipment, open and awaiting-parts records

At the top of the Summary sheet is a totals line (breakdown records, open, awaiting parts, closed, total downtime, average time to close). Below it are three tables: number of breakdowns and downtime per equipment (in order of first appearance on the Breakdown Log), open records (Open and Awaiting parts) and records awaiting parts only. Leading and trailing spaces and upper / lower case in the equipment code are ignored; any other spelling counts as separate equipment.

Summary: breakdowns and downtime by equipment (EXAMPLE, report time 2026-10-20 17:00)

| Equipment | Breakdown records | Closed | Open | Total downtime (h) | Average time to close (h) | Average time between breakdowns (days) |
| --- | --- | --- | --- | --- | --- | --- |
| CMP-01 Screw compressor | 3 | 2 | 1 | 325.6 | 3.3 | 9.1 |
| CNV-02 Belt conveyor | 2 | 1 | 1 | 124.1 | 3.8 | 12.1 |
| AC-03 Air conditioner indoor unit | 1 | 1 | 0 | 49.8 | 49.8 | — |
| PMP-04 Booster pump | 1 | 0 | 1 | 57.5 | — | — |

Open and awaiting-parts records count up to the report time; as the report time moves on, total downtime grows. For equipment with no closed record the average time to close is not calculated, and for equipment with a single record the average time between breakdowns is not calculated (—). The figures are examples, not targets or benchmarks.

Total downtime of CMP-01 is 5.5 + 319.0 + 1.1 = 325.6 h; the open record BD-003 makes up most of it. Totals line for the EXAMPLE: 7 breakdown records, 1 open, 2 awaiting parts, 4 closed; total downtime 557 h, average time to close 15.1 h.

Summary: open and awaiting-parts records (EXAMPLE)

| Record no. | Equipment | Reported | Priority | Status | Hours since reported | Part rows |
| --- | --- | --- | --- | --- | --- | --- |
| BD-003 | CMP-01 | 2026-10-07 10:00 | Normal | Awaiting parts | 319.0 | 2 |
| BD-005 | CNV-02 | 2026-10-15 16:45 | Urgent | Open | 120.3 | 0 |
| BD-006 | PMP-04 | 2026-10-18 07:30 | Normal | Awaiting parts | 57.5 | 1 |

On the Summary sheet, open records (3) and records awaiting parts only (2) are two separate lists; both follow the order of the Breakdown Log.

## Spare parts and consumables request list

The request list totals the parts on Breakdown Log rows whose Check shows no error (main and additional part rows), matched by part name + unit. The quantity on Awaiting parts records goes into “awaiting”, the quantity on Open and Closed records into “used / reserved”: awaiting is the missing part that is holding up the work; a part on a closed record may be one you want to restock, while a part on an open record may not have been fitted yet and may only be reserved for the job. The same part spelled differently (in the EXAMPLE, “Safety valve DN15” and “ safety valve DN15 ”) is merged into one item because leading and trailing spaces and upper / lower case are ignored; a different unit makes it a separate item.

Spare Parts Request List (from the EXAMPLE rows)

| Spare part / consumable | Unit | Awaiting | Used / reserved | Total | Record rows |
| --- | --- | --- | --- | --- | --- |
| Safety valve DN15 | each | 0 | 2 | 2 | 2 |
| V-belt A-42 | each | 0 | 2 | 2 | 1 |
| Bearing 6204-2RS | each | 0 | 2 | 2 | 1 |
| Oil seal 35×52×7 | each | 1 | 0 | 1 | 1 |
| Compressor oil | litre | 5 | 0 | 5 | 1 |
| Drain hose | metre | 0 | 2 | 2 | 1 |
| Pressure switch | each | 1 | 0 | 1 | 1 |

7 items: 3 with an awaiting quantity, 4 with a used / reserved quantity. Awaiting: the quantity on Awaiting parts records; used / reserved: the quantity on Open and Closed records. Different units are not added together; the line above the list gives the number of items, not a quantity. No prices or brands; you decide the quantity to ask a quote for.

Copy the list (Paste Special → Values) into the [quote request form](https://aksco.com.tr/en/request-a-quote/) or e-mail the Excel file; a quote request creates no obligation to order. AKSCO is a corporate supplier based in Türkiye that works without a catalogue: it does not hold stock and is not a manufacturer or distributor. We take the list, source the items and show the lines we can quote line by line in a written quote. On standard items we aim to quote the same business day. Custom production, imports or 50+ line lists can take longer; when they do, we tell you the timeline in writing on the day we receive the request.

Product group: [Industrial MRO & Spare Parts](https://aksco.com.tr/en/products/industrial-mro-spares/). Adding the part number, dimensions and whether an equivalent brand is acceptable makes it easier to quote the right item. For deciding which parts to keep in stock, see the [spare parts min/max and reorder point calculator](https://aksco.com.tr/en/tools/spare-parts-stock-level-calculator/) and the [MRO guide](https://aksco.com.tr/en/insights/what-is-mro-industrial-consumables/); for stock movements, the [consumables stock card](https://aksco.com.tr/en/insights/consumables-stock-card/).

**Scope:** For the work covered on this page, we supply **materials**. We do not provide maintenance labour, overhaul or field service. Our commitment ends with delivering the right product, in the right quantity, on the stated date to the delivery point named on the quote — anywhere across Türkiye’s 81 provinces, or abroad under the agreed Incoterm.

## Check messages

The last column of the Breakdown Log checks every row. An error shows pink and takes the row out of the summary and the parts list; a row with a warning shows light orange (distinct from the light yellow of the input cells) and is counted. An additional part row without an error shows light blue.

What the Check column tells you

| Message | Result |
| --- | --- |
| Error: equipment code blank · reported date blank or not read · status blank or not valid | Row is left out of the summary and the parts list |
| Error: response or closed date not read · Closed but closed date blank · closed date entered but status not Closed | Row is left out of the summary and the parts list |
| Error: response before reported · closed before reported or response | Row is left out of the summary and the parts list |
| Error: record fields filled in on an additional part row · main row has an error · part blank | The additional row’s part is not listed |
| Warning: record no. blank · time seems to be missing (00:00) · reported after the report time | Row is counted and shows light orange |
| Warning: fault description or priority blank · priority not on Lists | Row is counted |
| Warning: part entered but quantity blank · quantity entered but part blank · unit blank | Row is counted; a part without a quantity is not listed |
| Warning: no part entered on an Awaiting parts record | Row is counted; no awaiting part reaches the list |
| OK · Additional part row | Information |

The first problem on each row is shown. The Status lines at the top of the Breakdown Log, the Summary and the request list count rows with errors and warnings, and also say if the “EXAMPLE —” rows have not been cleared.

## What this file does not do

- **It is not a maintenance plan:** it suggests no maintenance interval, preventive maintenance schedule or part replacement time.
- **It sets no targets:** it contains no response or closing target time, priority rule, MTTR / MTBF target or industry comparison; the indicators come only from your records.
- **It does not find the cause:** root cause analysis and a work-order approval flow are not in the file.
- **It is not a stock record:** it does not track receipts and issues of parts; for that, use the [consumables stock card](https://aksco.com.tr/en/insights/consumables-stock-card/).
- **It holds no prices:** the request list has no prices or brands.

The EXAMPLE rows in the file (9 rows: 7 breakdown records, 2 additional part rows) only show how the calculation works; the dates, times and parts are not recommendations.

## Frequently Asked Questions

What should a maintenance breakdown log include? 

Record number, reported date and time, equipment or asset code, location, fault description, priority, reported by, assigned to, response and closed date and time, status (Open, Awaiting parts, Closed) and the spare part used / reserved or awaited with its quantity. In this Excel workbook each breakdown is one row; further parts for the same breakdown go on the rows below with the same record number.

How is breakdown downtime calculated? 

Downtime (h) = (closed − reported) × 24; for a record not yet closed, the report time is used instead of the closed time. This is calendar time: if the equipment kept running partly during the breakdown, it is longer than the actual downtime. The file totals downtime per equipment automatically.

How are the MTTR- and MTBF-like indicators calculated in this file? 

Average time to close (MTTR-like) = total downtime of closed records ÷ number of closed records. Average time between breakdowns (MTBF-like) = (last reported − first reported) ÷ (breakdown records − 1), for equipment with at least two records. The time before the first breakdown is not counted, and the time between two reports includes the repair time of the earlier breakdown. Both are calculated only from your records, in calendar time; the file gives no target value or industry average.

How do I record several parts for one breakdown? 

Put the first part on the main row and the others on the rows below with the same record number and only part, quantity, unit and note. An additional part row takes the main record’s status, is not counted as a breakdown and its part goes on the request list.

Does the file suggest maintenance intervals or target response times? 

No. Maintenance intervals, priority rules, response or closing target times and MTTR / MTBF targets are not in the file. You write the priority names on the Lists sheet; the indicators are calculated only from the records you enter.

Does AKSCO provide maintenance or technical service? 

No. AKSCO supplies spare parts and consumables; we do not provide maintenance labour, overhaul or field service. Send the request list through the quote request form or by e-mail; we take the list, source the items and show the lines we can quote line by line in a written quote. On standard items we aim to quote the same business day. Custom production, imports or 50+ line lists can take longer; when they do, we tell you the timeline in writing on the day we receive the request.

## Related guides

### Industrial MRO & Spare Parts

Line-by-line quotes for bearings, belts, seals, filters and hydraulics.

[Read more](https://aksco.com.tr/en/products/industrial-mro-spares/)

### What Is MRO? Industrial Consumables Explained

How MRO supply differs from direct materials, the six MRO groups and a two-axis classification.

[Read more](https://aksco.com.tr/en/insights/what-is-mro-industrial-consumables/)

### Spare Parts Min/Max and Reorder Point Calculator

Safety stock from usage and lead-time spread, reorder point and min/max for one item.

[Read more](https://aksco.com.tr/en/tools/spare-parts-stock-level-calculator/)

### Consumables Stock Card Template

Item-level receipts and issues, balance and a reorder alert.

[Read more](https://aksco.com.tr/en/insights/consumables-stock-card/)

### Stock Count Sheet Template

Free Excel count sheet: variance, variance % and accuracy rate.

[Read more](https://aksco.com.tr/en/insights/stock-count-sheet-template/)

## Send your list — your quote is ready within 1 business day.

A list, a photo or an Excel file — whatever is easiest. On standard items we aim to quote the same business day. Custom production, imports or 50+ line lists can take longer; when they do, we tell you the timeline in writing on the day we receive the request.

[Request a Quote](https://aksco.com.tr/en/request-a-quote/)[ Send an Email](mailto:info@aksco.com.tr?subject=Quote%20request%20%E2%80%94%20AKSCO&body=Hello%2C%0D%0A%0D%0APlease%20quote%20for%20the%20list%20below%20%28or%20attached%29.%0D%0A%0D%0ACompany%3A%0D%0ADelivery%20city%20and%20country%3A%0D%0AWhen%20needed%3A%0D%0AItems%20%28product%20%E2%80%93%20quantity%20%E2%80%93%20brand/model%20if%20any%29%3A%0D%0A%0D%0A)[Message on WhatsApp](https://wa.me/905343356922?text=Hello%2C%20I%20would%20like%20a%20quote.%0ACompany%3A%0AItems%3A%0ADelivery%20city%3A)

---

AKSCO Ticaret ve Tedarik — https://aksco.com.tr
AKSCO Ticaret ve Tedarik · Esentepe Mah. Talat Paşa Cad. No:5 İç Kapı No:1, Şişli/İstanbul
Türkiye'nin 81 ili ve uluslararası sevkiyat
info@aksco.com.tr · +90 534 335 69 22
