How should donated items be recorded?

Set Acquisition type to Donated, record the donor’s name (with permission) and enter a fair estimate of value. If a gift came with conditions, note them so the item is used as the donor intended.

Should we record items lent to the church?

Yes, as “On loan (not owned)”. Listing them means they are returned when no longer needed and are not counted in the church’s totals or insured as church property by mistake.

Do churches need to depreciate assets?

It depends on how your accounts are prepared and what your regulator or denomination requires. Many churches only record cost and insurance value; the template supports optional straight-line depreciation if you need it. Check with your treasurer or accountant.

Can we import this into Asetavo?

Yes. Standard columns use Asetavo’s asset field names, so the self-serve Excel/CSV import wizard can match them; church-specific columns can be skipped or merged into Notes. The free Starter plan holds up to 100 assets and 2 users.

Free template · Excel, CSV & printable PDF

Church asset register template

A free church assets register for Excel or Google Sheets. Record sanctuary furniture, sound and AV, instruments, vehicles and hall equipment — who donated each item, what it would cost to replace, whether it is insured, and which ministry looks after it.

Download Excel (.xlsx)Download CSV Printable version

No email required Working formulas & dropdowns Excel, Google Sheets, LibreOffice

What’s inside

Sheets in the workbook

Each workbook opens on an Instructions sheet and includes clearly labelled example rows to delete before you start.

Church asset register

28 columns you fill in, plus optional depreciation, net book value and an insurance check for every item.

Summary

Items, cost and insurance value by category; donated items; items not insured or with no insurance value; items on loan; items needing replacement.

Settings

Reporting date for optional depreciation.

Instructions & Lists

Eleven church asset categories and the acquisition types (Purchased, Donated, On loan), all editable.

XLSXasetavo-church-asset-register.xlsxExcel workbook · opens in Excel, Google Sheets, LibreOffice and Numbers CSVasetavo-church-asset-register.csvCSV · input columns and example rows only, for importing or pasting

How to use it

5 steps to a working church asset register

Download the workbook, read the yellow example rows, then delete them.
Walk the buildings room by room — sanctuary, vestry, sound booth, hall, kitchen, offices, stores — with the printable inventory sheet below.
Add one row per item, or per set for things like stacking chairs. Mark donated and borrowed items correctly.
Enter an insurance (replacement) value for each item and whether it is insured, then use the Summary totals at insurance renewal.
Label items discreetly with their Asset ID and re-check the inventory at least once a year, updating “Last verified”.

Column guide

The church-specific columns

Alongside the standard asset fields, these columns cover what churches are most often asked about by trustees and insurers.

Column	Type	What to enter
Category	Dropdown	Sanctuary furniture, Audio-visual & sound, Musical instruments, Liturgical & worship items, Kitchen & hall equipment, Office & ICT equipment, Vehicles, Buildings & land, Grounds & maintenance, Children & youth ministry, Other.
Department	You fill in	The ministry or team that looks after the item — worship, media, youth, facilities.
Acquisition type	Dropdown	Purchased, Donated, or On loan (not owned) — so borrowed items are not counted or insured as church property.
Donor name	You fill in	Record with the donor’s permission. Useful for thank-you letters, memorial gifts and restricted funds.
Purchase cost	You fill in	The price paid, or a fair estimate of value for donated items.
Insurance value, Insured?, Insurance reference	You fill in	What it would cost to replace today, whether it is covered, and under which policy.
Insurance check	Formula	OK, Not insured, No insurance value, or Owner insures (for items on loan).
Accumulated depreciation, Net book value	Formula	Only if you choose Straight-line; most churches can leave the method as None.

The formulas, in case you want to adapt them

Insurance check (column AE)

=IF(A2="","",IF(L2="On loan (not owned)","Owner insures",IF(R2="No","Not insured",IF(Q2="","No insurance value","OK"))))

Insurance value by category (Summary)

=SUMIFS(register!Q:Q, register!D:D, category, register!L:L, "<>On loan (not owned)", register!U:U, "<>Disposed", …)

Example

Worked example: five church items

Example rows from the workbook.

Asset	Room	Acquisition	Cost / value	Insurance value	Insurance check
CH-0001 Yamaha digital piano	Sanctuary	Donated	2,200.00	2,600.00	OK
CH-0002 Digital mixing console	Sound booth	Purchased	2,100.00	2,400.00	OK
CH-0003 Stacking chairs (set of 120)	Church hall	Purchased	3,600.00	4,200.00	OK
CH-0004 Toyota Hiace minibus	Car park	Purchased	32,000.00	24,000.00	OK
CH-0005 Portable PA system	AV store	On loan (not owned)	—	—	Owner insures

The borrowed PA system is listed so everyone knows it must be returned, but it is left out of the church’s totals and insurance values.

Church assets

What to include in a church inventory

Record anything the church would need to replace after a theft, fire or flood, and anything that is lent out. Typical church assets include:

Sanctuary: pews and chairs, lectern, pulpit, communion table, banners and furnishings.
Sound and AV: mixing desk, microphones, speakers, projectors, screens, cameras and streaming kit.
Musical instruments: piano, keyboards, drums, guitars and amplifiers.
Liturgical and worship items: chalices, candlesticks and other valuable or historic pieces (photograph them).
Hall and kitchen: tables, stacking chairs, cookers, fridges, urns.
Office and ICT, vehicles, and grounds equipment such as mowers.

Insurance & trustees

Using the register for insurance and trustee reports

Insurers usually ask for a contents value and, after a claim, for proof of what was lost. A register with replacement values, serial numbers and photos of high-value items makes both easier. Review insurance values each year rather than relying on the original price.

Denominations, dioceses, charity regulators and insurers each have their own requirements for inventories and fixed-asset accounting. This template is a neutral starting point — check what your trustees, denomination, insurer and accountant need and adjust it to match.

Asset tracking for churches and ministries

Google Sheets

Use it in Google Sheets

The workbook is a standard .xlsx file, so it opens in Google Sheets without a separate version. Upload it to Google Drive, open it, and choose File → Save as Google Sheets — or open a blank sheet and use File → Import → Upload → “Replace spreadsheet”.

Formulas, dropdown lists and frozen header rows carry over. If dates you type are not recognised, check File → Settings → Locale so the sheet expects the same date format you use.

Spreadsheet vs software

When to move the inventory into software

A shared spreadsheet becomes hard to keep current when several volunteers and ministries use the equipment. Consider software when:

AV and music equipment is lent between ministries, campuses or to members, and items go missing.
Several volunteers need to update the inventory and the file keeps diverging.
You run more than one site or campus.

Free asset tracking software Asset register feature

Printable version

Printable church inventory sheet

Print one sheet per room (or save it as a PDF) for the walk-round, then type the results into the register.

Choose “Save as PDF” as the printer to download a PDF. Only the document below prints.

Church inventory — room sheet

Church asset register — walk-round record

OrganisationRef.

Room details

Church / site

Room

Date

Ministry / team

Checked by

Page ___ of ___

Items in this room

Asset ID	Item & description	Serial no.	Purchased / donated / on loan	Donor	Replacement value	Condition	Photo ✓

Photograph high-value, historic and donated items and keep the photos with the register — they help with insurance claims and police reports.

Sign-off

Checked by

Name

Signature

Date

Church warden / administrator

Name

Signature

Date

Treasurer

Name

Signature

Date

Free template from asetavo.com/templates · Adapt it to your organisation’s policies.

In Asetavo · Asset register

Ready to move beyond the spreadsheet?

Keep the church inventory in one shared place: label items, record who looks after them, and check them room by room from a phone.

Start free: up to 100 assets and 2 users, QR and barcode labels
Import your completed spreadsheet yourself with the Excel/CSV import wizard
Export to Excel or CSV at any time, on every plan

Start free See asset register

FAQ

About this template

It is a list of everything the church owns or is responsible for — furniture, sound and AV, instruments, vehicles, hall and office equipment — with an ID, location, the ministry that looks after it, how it was acquired, its value for insurance, and its condition.

Excel

Fixed asset register (Excel, with depreciation)

An Excel fixed asset register with live formulas for straight-line, reducing-balance, DDB and SYD depreciation, net book value and disposal gain/loss — plus the 32-column CSV.

Excel

School asset register

A school fixed asset register by block, classroom and department, with funding source and donor, condition, optional depreciation and a printable classroom inventory.

Excel

Fixed asset verification report & certificate

Record a physical verification asset by asset, log unregistered items, calculate verification accuracy and sign a verification certificate.

School asset register template Asset label & QR generator Asset disposal form All free templates

Ready to account for every asset?

Tag, track and audit everything you own — from a handheld scanner to a boardroom report.

Start free Book a demo

No card required · Workspace ready in minutes · Simple USD pricing