Monday – Friday, 09:00 – 18:00 (UTC+3) WhatsApp 24/7

IT Asset Inventory, Equipment Assignments and Refresh Plan: Free Excel Template

A free Excel workbook that records IT devices such as computers, monitors and printers, tracks handovers and returns, and calculates warranty status and the yearly refresh count; you enter the useful life and the budget.

Short answer

How do you keep an IT asset inventory and equipment assignment log in Excel?

An IT asset inventory keeps, in one list, where each device is, who has it, when it was bought and when its warranty ends; the assignment log records whom a device was handed to and when it came back; and the refresh plan adds up, as a count, which devices are planned for refresh in which year. The free Excel workbook below combines all three. You enter the useful life, the warranty end date and the unit budget; the file suggests no period and no budget.

The workbook records each handover and return with a date, an asset number and a person or department; it has no signature line. To turn the yearly refresh counts into a bulk quote, see the quote section.

Free IT asset inventory, assignment log and refresh plan (Excel)

Enter each device on the Inventory sheet and each handover or return on the Assignments sheet. The person a device is assigned to, the planned refresh year and the warranty status fill in automatically; the Refresh Plan counts devices by year and type and, if you enter a unit budget, totals each year. An inconsistent assignment sequence, a duplicate asset number and a duplicate serial number are flagged on the row. Prints on A4; no sign-up.

The workbook is a record-keeping and planning tool; it suggests no useful life, warranty period, refresh cycle or budget. Rows starting “EXAMPLE —” are examples and their values are not real: delete them and enter your own records. Useful life, unit budget and the warranty alert period on Settings start blank.

Why keep an IT asset inventory?

An IT asset inventory is the list of an organisation’s devices, and it aims to answer four questions for each device from one place: where it is, who has it, when its warranty ends and when it is planned for refresh. When devices are spread across people, rooms and purchase dates, that information otherwise stays scattered across invoices, emails and memory; the list brings it into one table.

The refresh plan follows on from the inventory: if each device’s purchase year and the useful life your organisation sets are known, the number of devices planned for refresh in each year can be counted. That count is the input to budgeting and to a bulk quote list.

Which records to keep, and in how much detail, depends on your organisation’s own policy. This page is not a regulatory or audit guide; it offers a practical method for keeping the records.

Which fields does the inventory need?

The Inventory sheet asks for one row per device. You fill in the yellow cells; the grey-blue ones are formulas.

Fields on the Inventory sheet
FieldWhat goes inNote
Asset no.A unique number your organisation gives the deviceMust differ for every device; no *, ? or ~ and no leading, trailing or double spaces; a repeated number is flagged
TypeFrom the list: Laptop, Desktop, Monitor, Printer, Tablet, Phone, Network device, Server, OtherThese types are the Refresh Plan’s columns; use Other for anything not listed
Make and modelFree textThe file suggests no make or model
Serial no.The serial number on the deviceOptional; a serial number that is entered twice is flagged
Purchase dateInvoice or delivery dateThe planned refresh year is calculated from the year of this date
Warranty end dateThe end date read from the warranty documentThe file suggests no warranty period; leave it blank if the document gives no date
LocationRoom, floor or siteFree text
StatusFrom the list: In use, In storage, Faulty, DisposedA disposed device is left out of the plan and the warranty counts
Useful life (years)On the row, or per type on Settings, in whole yearsYour organisation’s decision, not the file’s; if blank, no planned year for that device
Assigned toNot entered; comes from the Assignments sheetIf the last movement is Handover, the person or department on that row
Planned refresh yearNot entered; calculatedYear of the purchase date + useful life
Warranty statusNot entered; calculatedEnded, ends today, or days left
CheckNot entered; calculatedNames the missing or invalid field, or the warning

The columns are in the same order as on the Inventory sheet.

Do not delete the row of a device you dispose of: set its status to Disposed. The record stays; the device is left out of the plan and the warranty counts.

Assignments: handover and return

An assignment log records which person or department a device was handed to and when it came back (in Turkish, a zimmet record). The workbook keeps it as a list of movements:

  1. Enter the device on the Inventory. Asset no., type and the other fields.
  2. Write one row at handover. On the Assignments sheet: date, asset no. (from the list), movement Handover, the person or department receiving it, and who handed it over.
  3. Write one row at return. Same asset no., movement Return; person or department is optional.
  4. To move a device to someone else, write a Return first, then a new Handover. If both happen on the same day, the Return row must be higher in the list.
  5. Read the Assigned to column on the Inventory. If the last movement is Handover it shows the person or department; if Return, “Returned (date)”; with no movement, “No assignment record”.

Movements are read in date order. If there is more than one movement on the same day, the one lower in the list counts as later — which is why, when you enter a return and a new handover on the same day, the return row goes above. If an asset’s last movement is Handover, the device is currently assigned.

What the file says when the sequence is inconsistent
SituationWarning in the fileWhat to do
A second handover is entered for a device that was not returnedInconsistent: second handover without a returnAdd the missing return row, or correct the wrong handover
A return is entered for a device that was not handed over (or was last returned)Inconsistent: return without a handoverAdd the missing handover row, or correct the return

A flagged row is still counted, and the Check column for that device on the Inventory warns too. A row with a missing or invalid date, asset no. or movement (or with no person or department on a handover) is not counted.

EXAMPLE movements in the file (BT-002 and BT-004)
DateAsset no.MovementPerson / departmentCheck
2023-09-22EXAMPLE — BT-002HandoverEXAMPLE — Person 2OK
2024-06-03EXAMPLE — BT-002ReturnEXAMPLE — Person 2OK
2024-06-03EXAMPLE — BT-002HandoverEXAMPLE — Department AOK
2022-02-08EXAMPLE — BT-004HandoverEXAMPLE — Person 4OK
2023-04-05EXAMPLE — BT-004HandoverEXAMPLE — Person 5Inconsistent: second handover without a return

BT-002 was returned and handed over again on the same day: the last movement is Handover, so it is currently assigned to EXAMPLE — Department A. For BT-004, Person 4’s return was never entered: the file warns and shows the device as assigned to the last recipient, EXAMPLE — Person 5.

The names of people and departments in the assignment records are personal data: keep, share and delete the file and its records in line with your organisation’s policy for retaining and deleting personal data. The file sends no data anywhere.

Tracking warranties

You read the warranty end date from the warranty document or the purchase document and enter it on the Inventory. The length and coverage of a warranty depend on the document, the manufacturer or the seller; the file suggests no period and says nothing about coverage — it only compares the end date you enter with the calculation date.

Days left is the warranty end date minus the calculation date. If the calculation date on Settings is blank, it is today; if you enter a date, the report is taken as at that date. Below zero the status reads “Ended (N days ago)”, at zero “Ends today” (the end date itself counts as under warranty), and above zero “N days left”. The Refresh Plan counts the devices whose warranty ends within the next N days; you set N, and if it is blank that count is not made.

EXAMPLE warranty dates in the file, with a calculation date of 2026-10-13
DeviceWarranty end dateWarranty status
EXAMPLE — BT-0012025-03-15Ended (577 days ago)
EXAMPLE — BT-0072026-05-02Ended (164 days ago)
EXAMPLE — BT-0022026-11-3048 days left
EXAMPLE — BT-0082027-01-2099 days left
EXAMPLE — BT-0042027-02-05115 days left
EXAMPLE — BT-006 (Disposed)——

With no calculation date entered, the status is recalculated against today each time the file opens; the table holds when 2026-10-13 is entered. A device whose days left are equal to or below N is counted in “the next N days”: for example, the device with 48 days left is counted when N is 48 or more.

Useful life and the refresh plan

Useful life is a management decision about how many years a device is planned to be used in your organisation. Your organisation makes it; this page and the file suggest no period. The decision can come out differently depending on your own policy, the device’s role, the manufacturer’s support and software update schedule (read from the manufacturer’s own documentation), fault and maintenance records, and the budget.

The file takes the useful life from one of two places: on the Inventory row (specific to the device) or per type on Settings (the default). If the row has a value, that is used; if not, the type default; if both are blank, the device does not enter the plan. If the value on the row is invalid (for example a decimal or text), the file does not fall back to the type default; the Check column shows the error. Planned refresh year = year of the purchase date + useful life.

This is a planning decision, not accounting depreciation or a tax life. For depreciation and tax life, ask your accountant or tax adviser.

EXAMPLE devices in the file and their planned refresh year
Asset no.TypePurchase dateUseful life on the row (years, example)Planned refresh yearAssigned to
EXAMPLE — BT-001Laptop2022-03-1542026EXAMPLE — Person 1
EXAMPLE — BT-002Laptop2023-09-2052028EXAMPLE — Department A
EXAMPLE — BT-003Desktop2021-06-1062027Returned (2025-01-10)
EXAMPLE — BT-004Monitor2022-02-0552027EXAMPLE — Person 5
EXAMPLE — BT-005Printer2020-11-1262026EXAMPLE — Department B
EXAMPLE — BT-006 (Disposed)Network device2019-03-015—Returned (2023-08-01)
EXAMPLE — BT-007Phone2024-05-02blankEnter useful lifeNo assignment record
EXAMPLE — BT-008Tablet2025-01-2032028No assignment record

The useful life figures are EXAMPLE values placed in the file only to show how the calculation works; they are not a recommended period for any type and differ between rows on purpose (BT-001 and BT-002 are the same type with different useful lives). BT-007 has no useful life: it does not enter the plan and is counted in the Unplanned row.

The Refresh Plan sheet gives a year × type matrix. Each cell is the number of devices planned for refresh in that year; Disposed devices are not counted. The “Earlier years” row shows devices planned before the first year (overdue), and the “Unplanned” row devices with a missing useful life or purchase date; Total is their sum. If the first year on Settings is blank, it is the year of the calculation date.

Refresh plan for the EXAMPLE devices with a calculation date of 2026-10-13 (first year 2026)
Refresh yearLaptopDesktopMonitorPrinterTabletPhoneTotal count
20261001002
20270110002
20281000102
Unplanned0000011
Total (excluding Disposed)2111117

The Network device column and the other types are 0 (BT-006 is Disposed and not counted); only types with a count are shown. The figures come from the EXAMPLE rows in the file.

If you enter a unit budget (excluding VAT) for a type on Settings, the Refresh Plan totals each year’s budget: the type’s count is multiplied by its unit budget and the types are added up. Types with no unit budget are left out of the total, and their count is shown in a separate column so that a partial total is not mistaken for the full one. If no type has a budget, the budget column stays blank. Your organisation sets the unit budget, in the currency it budgets in; the file suggests no price.

From the yearly refresh list to a bulk quote

The yearly count on the Refresh Plan is a ready list for requesting quotes: device type, model or minimum technical specification, and quantity. AKSCO is an İstanbul-based procurement partner without a catalogue, and we do not hold stock: we take your list, source the items and show the items 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.

Put these on the quote list:

  • Device type and quantity (that year’s cell on the Refresh Plan)
  • Model or minimum technical specification (processor, memory, storage, screen and so on — the specification you already use)
  • Operating system and licence requirement
  • One-off or recurring; number of delivery addresses
  • Set-up or installation, if needed, as a separate line (within İstanbul only)

If you want a specific make and model, write the full model code; if you accept an equivalent, say so. A quote request creates no obligation to order; you can send the same list to other suppliers and compare the quotes line by line. To turn the device list into a specification, the technical specification templates (Word) and unit price schedules (Excel) are on one page.

We deliver to the delivery point named on the quote, anywhere in Türkiye or, for buyers abroad, as an export shipment — see export shipping from Türkiye. Range: IT Hardware & Technology. You can send your list with a quote request or by email to info@aksco.com.tr.

What this file is not

This workbook keeps the inventory of IT devices and their assignment movements; it has no signature line. If you need a signed handover form, use the free asset handover form (Word). Furniture, office equipment and similar items that are tracked by count, without a serial number or a personal assignment, are better kept in a separate list.

Accounting records and depreciation are a separate matter too: the useful life in this file is for planning, it is not an accounting or tax life, and it does not replace a fixed asset register. For those, ask your accountant or tax adviser.

Using the Excel workbook

  1. Settings. If you wish, enter the calculation date, the first year of the plan, the warranty alert period (N), a useful life per type and a unit budget; all start blank.
  2. Inventory. One row per device; type and status come from a list, and useful life goes on the row or on Settings.
  3. Assignments. One row per handover and per return; choose the asset no. from the list.
  4. Read the Status row. The row at the top of each sheet says whether the EXAMPLE rows have been cleared, how many rows have an error or a warning, and how many devices are counted; blank settings are shown as information, not as warnings.
  5. Refresh Plan. Nothing to enter; the year × type count, the budget total and the warranty counts are calculated.

The Check column has two levels. Error: asset no., type or status missing or invalid, or an invalid date or useful life (a missing date or useful life is not an error; the device lands in the Unplanned row of the Refresh Plan). A field with an error is left out of the related calculation for that row, and if the type or status is invalid the row is left out of every count. Warning: warranty ends before purchase, duplicate asset no. or serial no., or an inconsistent movement on Assignments; a row with a warning is still counted.

Scope and limits

This page and the workbook are a record-keeping and planning tool for the records, assignments and refresh count of IT devices. They suggest no useful life, warranty period, refresh cycle, unit budget or disposal criterion. They do not replace accounting records, a fixed asset register, a depreciation calculation or a warranty document. The file sends no notifications or emails: warnings appear when you open it. It is ready for 200 devices and 500 assignment movements; for more, follow the steps for adding rows on the How to Use sheet.

Frequently Asked Questions

What is an equipment assignment record, and how is it used for IT devices?

An assignment record notes that an item belonging to the organisation was handed to a named person, who then has it in their care; a signed handover form records that handover with a date, the item and a signature. For IT devices the record is kept as handover and return movements: date, asset no., movement (Handover or Return), person or department, and who handed it over. The Excel on this page keeps those movements and shows from the last one who has the device; it has no signature line, so a signed handover form, if you need one, is kept separately — a free asset handover form (Word) is on this site. This is a general description, not legal advice.

What is an IT asset inventory, and which fields does it hold?

It is the list of an organisation’s IT devices. The Inventory sheet in the file asks for the asset no., type, make and model, serial no., purchase date, warranty end date, location, status and useful life of each device; the person it is assigned to, the planned refresh year, the warranty status and a check come from formulas.

How do you record handovers and returns?

Each handover and each return is written as a separate row on the Assignments sheet: date, asset no., movement (Handover or Return), person or department, and who handed it over. If the last movement is Handover, the device is currently assigned and the Inventory shows that person. If there is more than one movement on the same day, the one lower in the list counts as later; the file warns if a second handover is entered for a device that was not returned, or a return for a device that was not handed over.

How many years of useful life should an IT device have?

There is no single right period: your organisation sets it from its own policy, the device’s role, the manufacturer’s support and software update schedule (read from the manufacturer’s documentation), fault and maintenance records, and its budget. That is why the file leaves useful life blank both on the row and on Settings; the useful lives in the EXAMPLE rows are not recommendations. Accounting and tax life are a separate matter: ask your accountant or tax adviser.

How do you track warranty end dates?

Read the end date from the warranty document and enter it on the Inventory. The file compares it with the calculation date: if it has passed it shows “Ended (N days ago)”, on the end date “Ends today”, and before that “N days left”. If you enter an N on Settings, devices whose warranty ends within the next N days are highlighted and counted on the Refresh Plan. What a warranty covers depends on the document; the file says nothing about coverage.

How do you build a hardware refresh plan and find the yearly count?

Each device’s planned refresh year is the year of its purchase date plus its useful life. The Refresh Plan sheet counts those years by type: each cell is the number of devices planned for refresh in that year. Disposed devices are not counted; devices with a missing useful life or purchase date appear in the Unplanned row. If you enter a unit budget per type on Settings, the yearly total is calculated too.

How do you request a bulk quote from the refresh list?

Put that year’s counts into a quote request together with the device type, the model or minimum technical specification, the operating system and licence requirement, the number of delivery addresses and any set-up you need. AKSCO is a procurement partner without a catalogue and holds no stock: we take your list, source it, and show every item we can quote on its own line in a written quote. A quote request creates no obligation to order.

Does this file calculate accounting depreciation?

No. The useful life in the file is a planning decision; accounting depreciation and tax life are outside the scope of this file and are not calculated. For a fixed asset register or a depreciation calculation, ask your accountant or tax adviser.

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.