The Spreadsheet Shop
for Standard and Bespoke spreadsheets





Fixed Asset Register Spreadsheet Details

Need to keep track of your Fixed Assets?  Need to work out your monthly or annual Depreciation?

Our Fixed Asset Register can handle the following:

Both Straight Line or Reducing Balance depreciation methods, select as Default System Option and override per item.

Depreciation from Month of Purchase or Beginning of Financial Year, System Option only.

Automatic or Manual assignment of Serial Numbers to Fixed Asset items (if required).

Up to 12 different Fixed Asset Categories.

Enter Account Codes / Names relating to each category for Cost, Depreciation, Sale of Assets and Write Off's.

Allocate each Fixed Asset item to a category.

Register can handle up to 500 items at any time.

Space for remarks against each item.

The Register, in Normal mode, only allows you to enter future transactions / items.

There is a 'Amend' mode which allows you to go backwards in the Register.

During each period, you can print off Disposal Journals for items disposed off during that period.

At the end of each period, Depreciation Journals can be printed out.

Two options for working out the depreciation:

Option 1 - The actual depreciation as worked out per Fixed Asset item for the period.

Option 2 - The difference between the accumulative total of all Fixed Asset items still on the books (broken down by category) and the balances on your Balance Sheet Depreciations accounts.

To support your Depreciation Journals, at the end of each period you can print out a List of Fixed Assets still on the books and included in the depreciation figures for that period.

At anytime, you can also print off a Fixed Asset Schedule (along with detailed lists of additions and disposals) for the previous financial year and the current financial year to date.  Very handy for accountants producing year end financial accounts.

Cost

From only £50.00 + vat  [More...] 

Specifications

Will work on Microsoft Excel 2003 and 2007

Spreadsheet Size (approx) before any data 9 MB

Share Workbook Function - Not Recommended

Need Macros Enabled - Yes

Max. No. of Years of Transactions - 15  years

Max. No. of Current Transactions - 500 Current Transactions

Help Page - No

Visit our other websites

www.accountingandpayroll.co.uk for all our accounting and payroll software related services
www.spreadsheettraining.co.uk for our spreadsheet training services

 
Contact us now on
0 8 4 5   2 2 6   0 6 9 6
   
Click Here for Terms of Use To report errors on this website,
e-mail webmaster@infomac.co.uk
© Copyright INFOMAC 2008
"INFOMAC" the INFOMAC Logo, are trademarks and/or service marks of INFOMAC. All other trademarks are trademarks or registered trademarks of their respective owners.