The Spreadsheet Shop
for Standard and Bespoke spreadsheets





Spreadsheet Images

Click on the images below to enlarge them, then click on the Browser 'Back' button to return to this page.

The Settings Page

Enter your Financial Year Start Date and select different choices to run your Fixed Assets Register.

The Settings Page

Enter either the account codes or account names for each category of your Fixed Assets. Facility for up to 12 different Asset categories.

The Register

This is where the details of each Fixed Asset item is entered along with Depreciation details such as Straight Line or Reducing Balance method, and the period to depreciate over.

Also, when an item is disposed off, enter the details against the item on this page.

The Disposal Journal

Print out journals for each disposed item for the period.

The Printed Disposal Journal

Once entered into your accounts, keep this printed journal for audit purposes.

Prior to the Depreciation Journal

Enter the appropriate fixed asset cost account balances into these fields to ensure they agree with this Fixed Asset Register.

A warning will show up if the balances do not agree. Investigate these differences before posting depreciation figures.

The Depreciation Journal (Option One)

Option One, you can select to work out the depreciation figures for the period only according to this Register.

The Depreciation Journal (Option Two)

Option Two, you can enter your Asset Depreciation Account Balances in the appropriate fields on this page, then this Register will compare these figures against the accummulative figures in this Register and the differences will appear on the Depreciation Journal for the period.

The Depreciation Journal (Option Two)

The figures for both Option One and Two should, in theory, be the same. But if your have amended any of the items where it affects previous periods, this will cause a difference.

List of Current Assets

Each period, you can print off a report listing all your Fixed Assets by category which are still on the books.

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.