The Fixed Assets Register
Description

If your company has assets, like a company car or expensive office equipment, you can record them as fixed assets. When you next run the month end, depreciation for these assets calculates automatically. This keeps track of what your company assets are actually worth, which is important when accurately valuing your company. Let's take a look.

Cause
Resolution

Create a fixed asset record

NOTE: Creating a fixed asset doesn't post any transactions to the audit trail.

  1. Click Fixed assets, then click  New.
  2. Complete the Asset Record window as follows:

     

  3. Click Save, then click Close.

 TIP: For further information about depreciation, you can use our guide on How to post asset depreciation. 

You've now successfully created a new record. The fixed asset starts to depreciate when you next run the Month End option and select the Post Depreciation check box.


Purchase of a fixed asset on hire purchase

If your company purchases a fixed asset and finances this with either a loan or hire purchase you must record this in your accounts.

Create the new nominal codes

If you already have these nominal codes then please proceed to the following section To record the hire purchase figures.

If you're using the default nominal ledger structure we suggest you

 

Record the hire purchase figures

Your company buys a new car for £/€12,225.00, including VAT at the UK rate of 20%. This figure also includes documentation fees of £/€50.00, an option fee of £/€25.00 and Road Tax of £/€150.00. You also pay a deposit of £/€500.00. Your interest repayments are £/€2,400 to be paid over four years.

  1. Click Nominal codes, then click Journal entry.
  2. Enter a reference, date and the journal information.

     

  3. Click Save, then click Close.

You've now recorded the hire purchase figures for the purchase of your new asset. When You're ready to post the monthly payments for the loan, please refer to the following section.

Post the monthly repayments

  1. Click Bank accounts, then click Payments and click Bank payment.
  2. Enter the relevant information into the Bank Payments window, for example:

    Bank Date Ref N/C Details Net T/C Tax
    1200 Due Date Ref 2310 Hire purchase repayment 244.27 T9 0.00
    1200 Due Date Ref 7904 Interest repayment 50.00 T9 0.00
  3. Click Save, then click Close.

You've now recorded your monthly hire purchase and interest repayments.

Asset Valuation

The Asset Valuation window displays the same information as the fixed assets list but also includes total cost, total depreciation to date and total value.

To access the Asset Valuation window click Fixed assets, then click Valuation.

The Asset Valuation window includes the following information:

Asset reference Record > Details.
Description Record > Details.
Cost price Record > Posting.
Depreciation to date Record > Posting.
Book Value Record > Posting.
Write off a fixed asset

From time to time you may need to write off a fixed asset from your accounts. This may be when the asset becomes obsolete, or when the depreciation postings are so negligible that it's easier to write off the value of the asset from your accounts. You should follow the steps in this article when You're writing off the asset, but it's still owned by the company.

NOTE: If you're using Sage Accounts and don't use the fixed assets register, you must manually write off the value of your fixed assets from your accounts. For further information about this, please refer to the section To record the sale by posting manual journal entries.

This section uses the example of a fixed asset with the following values:

  • Cost Price - £/€10,000
  • Depreciation To Date - £/€8,000
  • Book Value - £/€2,000
How to set a fixed asset record to write off
  1. Fixed assets > select the fixed asset to be written off > Edit > Posting.
  2. Depreciation Method > choose Write Off > Save.

You've now set the fixed asset record to automatically write off the asset the next time you run a month end for depreciation.

Run the month end option for depreciation only

Further information about the Month End option is available in our Month End guide.

NOTE: You should take a backup of your data before proceeding. 

  1. Help > About > Configuration Information > check the Last Month End Procedure Run date is correct.
  2. Tools > Period End > Month End.
  3. Set the Month end date by choosing the last day of the month > enter the last day of the month for which You're running the month end.
  4. Select the Include depreciation of fixed assets check box > Run Month End > Yes > OK.

The write off journals are posted, and the accumulated depreciation nominal code now contains the original value of the asset.

Complete the fixed asset write off
  1. Nominal codes > Journal entry.
  2. Enter a reference, date and the journal information.

    For this journal, we recommend you use the month end date in which the asset was written off, and the non-vatable tax code, T9 by default. For example:

    N/C Name Details T/C Debit Credit
    0050 Fixed Asset Write Off Asset T9   10,000.00
    0051 Accumulated Depreciation Write Off Asset T9 10,000.00  
  3. Save > Close.

You've now successfully written off the value of the asset from your accounts, and the value of the asset on the balance sheet report is now zero.

Remove a fixed asset from the fixed assets register
  • Fixed assets > select the asset to be removed > Delete > Yes.

You've now successfully removed the fixed asset record from the fixed assets register.

Stolen assets

If your fixed asset has been stolen, the value of that asset needs to be written off to an expense nominal code.

To do this, you need to:

  • Set up a new nominal code in the overheads range of nominal codes.
  • In the fixed asset record change the P&L Depreciation nominal code to the new nominal code.
  • Change the Depreciation Method to Write Off.
  • Complete the month end and write off routines detailed above.
Asset disposal wizard

NOTE: If you're using a flat rate VAT scheme, for help disposing of an asset, please refer to the section Exceptions for capital assets on the following articles:

The asset disposal wizard guides you through entering the figures to show the disposal of a fixed asset in the nominal ledger, and deletes the asset from the fixed assets register.

Dispose of a fixed asset
  1. Fixed assets > Disposal.
  2. Complete the boxes as follows:

    Fixed asset to be disposed* Choose the asset you want to dispose of.
    Posting date* Enter the date of the disposal.
    Department* If required, enter a department.
    Original purchase nominal code* Select the nominal code that the asset was originally entered against in the nominal ledger.
    Original purchase tax code* The tax code defaults to T1. If required, you can change this. We can't advise you what tax code to use.
    Sales of assets nominal code* Enter the Sale of Assets nominal code.
    Bank account* If You're selling the asset, select the bank account that the money is to be paid in to.
    Gross sale value Enter the gross value, including VAT, for the disposal of the asset. This is the total amount that you received for the fixed asset.
    VAT on sale This value calculates automatically.
    Net sale value This value calculates automatically.
  3. Next > Post.

    The journal posts and the fixed assets record deletes.
Record sale by posting manual journals

NOTE: If you're using a flat rate VAT scheme, for help disposing of an asset, please refer to the section Exceptions for capital assets on the following articles:

These steps are based on the following example:

  • A vehicle which was originally purchased for £/€10,000.
  • Depreciation to date is £/€7,500.
  • The asset is sold for £/€500.
  1. Nominal codes > Journal entry.
  2. Enter a reference, date and the journal details to record the disposal of the fixed asset.

    For example, to transfer the original purchase price from the asset nominal code, post the following:

    N/C Name Details T/C Debit Credit
    0050 Motor Vehicle Disposal T9   10,000.00
    4200 Sales of Assets Disposal T9 10,000.00  


    To transfer the accumulated depreciation to date, post the following:

    N/C Name Details T/C Debit Credit
    0051 Motor Vehicle Depreciation Disposal T9 7,500.00  
    4200 Sales of Assets Disposal T9   7,500.00


    To record the proceeds from the sale, post the following:

    N/C Name Details T/C Debit Credit
    1200 Bank Current Account Disposal T9 500.00  
    4200 Sales of Assets Disposal T9   500.00

    If you're disposing of an asset and still have an HP loan outstanding, instead of posting the proceeds of the sale to your bank you should post it to the HP loan nominal code, for example 2310. If you're unsure, please contact your accountant for guidance.

  3. Save > Close.

You've now posted the journal entries to record the disposal of the asset. As a result of these journals the balance on the Sales of Assets nominal code is a £/€2,000 debit. This appears as a loss on the profit and loss report.

Depreciation was missed from a month end
Step 1 - Check the Date Last Posted
  1. Fixed assets > select an existing record > Edit.
  2. Posting > Date Last Posted.
Step 2 - Solution

Date Last Posted is prior to the missing period

  1. Set the program date back to the first missing period.
  2. Run month end for the missing periods.

    If new assets have been created and you don't want to include depreciation for these in the back dated periods, you must remove the Cost Price and Book Value before processing the month end for the missing periods. These must be re-entered before processing the month end for the first period in which they're to be depreciated.

Date Last Posted is after the missing period

Option 1 - Restore a backup

For example, if you intended to run August month end and ran September in error, in this instance it may be feasible to restore a backup and then process the month end for the correct period.

Option 2 - Not feasible to restore a backup
  1. Post a journal to reverse the depreciation for the periods posted beyond the missing period.
  2. Delete the asset records.

    NOTE: This must be done as the existing asset records will always be incorrect and can't be manually adjusted.

  3. Recreate the asset records, ensuring you enter the correct book value.

    TIP: You can use the Duplicate option to generate a new record before deleting the original record. However you must enter a new record reference number, cost price and book value.

  4. Run month end.

Example

  1. Post journals to reverse the depreciation already posted for a fixed asset in September.
  2. Delete the asset record.
  3. Recreate the asset record using the book value of August.

    TIP: If you don't know the book value for August, use the book value of the asset before it was deleted and add the value of any reversed depreciation journals to it.

  4. For the depreciation value only, post the missed month end for August.
  5. Post any subsequent months as normal.
Fixed asset was set up incorrectly
Option 1 - Restore a backup

This is the best option but depends on when the month end was run and how much information you have to re-enter.

Option 2 - Not feasible to restore a backup
  1. Post journals to reverse the depreciation already posted for the fixed asset.
  2. Delete the asset record.

    You can use the Duplicate option to generate a new record before deleting the original record. The details of the duplicate record can then be corrected.

  3. Recreate the asset record, ensuring that you enter the correct book value.
  4. Back date any month end postings.

    To do this set the program date to the required month then run the month end. Depreciation is posted only for those fixed asset records not already depreciated on or after the specified month.

 

[BCB:19:UK - Sales message :ECB]
Steps to duplicate
Related Solutions