Think Build Implement Repeat
London, UK +44 7367 067226
WhatsApp FOLLOW f in X
  1. Home
  2. Blog
  3. Our Asset Register Is a Spreadsheet Nobody Trusts. How Do We Keep It Accurate All Year?
Problems We Solve

Our Asset Register Is a Spreadsheet Nobody Trusts. How Do We Keep It Accurate All Year?

Town and parish council asset registers drift out of date between year ends. We build a register with locations, photos and changes logged as they happen.

Updated 3 min readBy SpiderHunts Technologies

Free estimateNo obligation

Get a free estimate

Tell us what you need. A senior engineer reads every enquiry.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →

Quick answer — TL;DR

Asset registers drift because they are only updated at year end, from memory, by the clerk or RFO. We build an asset register with a map location and photo for each item, where additions, disposals and condition changes are logged when they happen, often straight from a purchase or a site check, so the year-end figure comes from records rather than a scramble.

Year end, and the list of benches

Year end is approaching, and the RFO opens the asset register spreadsheet. It lists benches, bins, bus shelters, noticeboards, the war memorial, play equipment, the pavilion, a mower and a strimmer, the office laptop, and some land. Several benches were replaced after vandalism. One bus shelter was removed when the route changed. A new defibrillator cabinet was bought, and possibly a second noticeboard. Nobody updated the register at the time.

The RFO emails councillors and the handyman asking what has changed. Replies trickle in. The insurance schedule, which should match the register, lists items the council no longer has. The auditor's question about a specific asset takes a morning to answer.

Why the register drifts

The register is treated as a year-end document, not a working list. Changes happen all year, through purchases, disposals, vandalism, donations and transfers, but none of them trigger an update. Items often have no photo or precise location, so it is hard to check them against what is actually out there.

  • Purchases are recorded in the accounts but not added to the register.
  • Disposals and removals are agreed at meetings and never reflected.
  • Donated items, such as memorial benches, are sometimes never recorded at all.
  • Descriptions are vague, so 'bench, High Street' could be any of three.
  • The insurance schedule is maintained separately.

The cost of an unreliable register

Year end takes longer and is more stressful than it should be. Insurance may cover things that no longer exist and miss things that do. When an asset is damaged, nobody can quickly say when it was bought or what it cost, which slows insurance claims. And councillors planning replacements have no reliable view of the age and condition of what the council owns.

How assets are valued and reported is a matter for your RFO, auditor and advisers. We build the record that sits underneath.

An asset register that is kept up all year

  1. Each asset is a record with a clear description, category, location on a map, photo, date acquired, cost or value on the basis your council uses, and insurance status.
  2. Existing records are loaded from your spreadsheet, and a one-off walk round with a phone fills in photos and locations and finds anything missing.
  3. When the RFO records a purchase in a category you choose, a prompt asks whether it is a new asset, and the details carry across.
  4. Disposals and removals are logged with date, reason and minute reference.
  5. Site checks, such as play area or bench checks, update the condition of assets as they happen.
  6. A year-end report produces the register in the format your RFO needs, with additions and disposals for the year listed separately.
  7. An insurance view lists insured items and values to compare with your schedule.
EventWhat updates the register
Bench replaced after vandalismDisposal of the old, addition of the new, from the purchase
Memorial bench donatedAddition with donor and plaque details
Bus shelter removedDisposal with the minute reference
Defibrillator cabinet boughtAddition prompted by the purchase

Year end with a current register

The RFO opens the register in March and it already reflects the year: new benches added when they were bought, the bus shelter removed when the council resolved it, the donated bench recorded with its plaque. The year-end report takes minutes. The insurance comparison shows two items to remove from the schedule. When the auditor asks about a specific asset, the record has a photo, location and purchase date.

The small things get easier too. When a bench is vandalised, the handyman finds it on the map, adds a photo and marks it damaged, and the clerk has the purchase date and cost ready for the insurance claim. When the council agrees to take on a new asset from the district, such as a bus shelter or a piece of land, it is added at the meeting with the minute reference. New councillors can open the map and see what the council actually owns, which is often a surprise to them.

Signs your register needs attention

  • The register is only updated at year end.
  • Items have no photo or precise location.
  • The insurance schedule does not match the register.
  • Donated items are not recorded.
  • Answering a question about one asset takes a morning.

FAQ

Frequently asked questions

The questions readers ask us after this guide.

Still have a question?

Ask us directly — a senior engineer will get back to you.

Ask about your project

Do we have to change how we value assets?

No. The register records values on whatever basis your council and auditor use.

Does it connect to our accounts package?

Where your package can export purchases, the register can pick them up for review. Otherwise purchases are added by the RFO from a prompt.

How long does the initial walk round take?

It depends on how many assets you have and how spread out they are. It is usually done in stages alongside routine site visits.

Can it store maintenance and inspection history too?

Yes. Checks and repairs can be linked to each asset.

What affects the cost?

The number of assets, whether a location survey is needed, and how it links to accounts and inspection records.

Keep reading

More on Problems We Solve

Start here

Tell us which council job still runs on paper

Describe the records involved, who fills them in and who needs to see them. We will tell you what we would build, what your accounts package or existing tools already do, and if a small change would sort it, we will say so rather than sell you a system.

  1. You tell us what you needTwo minutes on the form, or a message on WhatsApp.
  2. A senior engineer reviews itAnd comes back with questions, a realistic range and an honest view on fit.
  3. Free 30-minute scoping callWe talk through scope, options and a realistic estimate — with no obligation.
Free estimateNo obligation

Talk to someone who builds this

Send a short brief and we will come back with an honest view and a realistic range.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →