Device Ownership Workbook: Track Repairs and the Cost of Keeping Your Tech
Downloads / Resource 01 / Version 1.0
A device’s history gets harder to reconstruct after a few repairs, a charger purchase and a change of owner. This original TechReviewz workbook keeps the actual cash record and the service notes together, so the next decision starts with facts you can recover.
XLSX. Two worksheets: Overview and Repair log. Editable currency, 20 service records and a labelled worked example. No macros or external data connections.
Download the ownership workbookView all resourcesRecord what you have actually spent.
On Overview, enter the device model, your currency, purchase date, purchase price and necessary setup costs. Use one currency throughout. If an amount did not apply, enter zero rather than treating a missing amount as evidence of a real cost.
The net cash cost is purchase plus setup plus completed repair costs, less resale proceeds you have already received. It is a historical record. It does not estimate market value, model depreciation, include financing charges or forecast the next repair.
Give each repair one useful record.
Add one row to Repair log for each repair or service. Record the date, device or part, symptom or work, actual cost, status, next due date and an action or invoice reference. Keep the detailed invoice privately; a reference is enough to connect the workbook to your records.
Mark an unresolved job Open. Mark it Completed only when the work and actual cost are confirmed. A cancelled job stays out of the total. The Overview adds completed costs and counts open entries, so a quote you have not accepted does not silently become a completed expense.
A worked example you can check.
| Illustrative entry | Amount in one currency |
|---|---|
| Purchase | 80,000 |
| Necessary setup | 5,000 |
| Completed repairs | 7,000 |
| Received resale | 30,000 |
| Net cash cost | 62,000 |
An additional open repair quote of 2,000 would remain visible as an unresolved entry. It enters the completed-cost total only when the corresponding status changes to Completed. The workbook includes the separate illustrative calculation so you can compare its method with your own record.
Use the record at the next decision.
Before buying another machine, review repeated faults, outstanding work and the accessories you actually needed. Then compare future alternatives over the same horizon with our repair-versus-replace calculator. Historical spending and future costs answer different questions; the workbook does not decide that replacement is necessary because a past expense was large.
Save your own copy before editing. Yellow cells are inputs. Preserve formula cells and check that your spreadsheet application recalculates after changing a status. Do not store account passwords or full payment details in the log. To report an error, send the cell reference and non-sensitive example inputs.
