Reconcilable Blog

Accounting and Reconciliation

World's best Excel Workbook for Fixed Assets

Thu, Oct 22, 2015

It’s been 7 or 8 years since I finished constructing my fixed assets workbook. It’s still in regular use and continues to do its job of recording assets, calculating depreciation and providing the reports for my accounts.

A long stretch of accurate operation without any need for tinkering or correcting, in the field of fixed asset workbooks at least, is cause for satisfaction. I’ve used some less successful designs in the past, as you may have too, so I’m making mine publicly available now in case you want to make use of it.

But is it the best fixed assets workbook in the world?

Claiming a superlative design should be justified. What would you say about your spreadsheet when you believe it’s the best?

The calculations in my spreadsheet are perfectly correct

I certainly hope so, but correctness alone doesn’t win any awards. It might be correct now, but what about in the future? Will it still be correct – or might you make an error the next time you use it?

I know how to use it without making mistakes

Not really good enough. When you are promoted and someone else takes over your job, will they be as skilled or as careful as you? Will they grasp the essentials of your workbook design so that they also can use it without mistakes?

Anyone could use my workbook without making mistakes

Great! But not yet good enough. Can your workbook be used efficiently? Do you have to duplicate your inputs, in detail or in summary? Do you have to copy and paste functions or recreate reports to get your final output?

My workbook is highly efficient to use

Pleased to hear it. But still not good enough. Can you reliably find your current workbook or does it’s design force you to create a new copy each period? Are there lots of copies of it on your network? Tracking and picking the right one every time is a pain.

My workbook is easy to find and exists only once (apart from backups)

Fantastic. Maybe you’ve created the best Excel Workbook in the world for recording fixed assets and calculating depreciation. But…
Is your workbook as good as mine?
Well there’s no need to guess. Download mine now and see what you think…