Uploading / importing a fixed asset register

The help guide from Silverfin on how to do this is here. Please note that the reference to Working Papers workflow for FC refers to our 2. Preparation workflow. 

Also, you should ensure you have no commas in your figures in your Excel spreadsheet as this will cause issues. If you are having any other difficulties in the text or numbers not being imported correctly, refer to this guide on importing from Excel.

You need to ensure you have only one asset class selected at a time when importing - if you have more than one selected then it won't work.

If it doesn't come up with a "Collection" dropdown when importing your fixed asset register (as below), then come out of the screen and refresh or go back to the Silverfin main screen and then go back into your client and then try again.  If you don't do this, you may find that your asset register keeps overwriting the first collection at the top of your Fixed Asset Register and not the one you are intending to import.

If you have any disposals, you should import the fixed asset information as normal then mark them manually in Silverfin as disposals.

If you make any errors on importing your fixed asset register, DON'T PANIC, you can simply import your fixed asset register again over the top of the one you imported in error.

If you are rolling forward your data (for example 2020), go to the year you want to pull the data into (so 2020), and then select the prior year (so 2019) - if you do this the wrong way around, then you will clear your current year data!

In general we should be importing individual additions into Silverfin to maintain a fixed assets register. However, if there is significant work needed to import the b/f balance, this should be discussed with the manager or partner beforehand.

FC Chart of Accounts

Please note that we have an additional fixed assets category available in the FC Chart of Accounts for Computer Equipment and a spare "Additional Code" for every category of fixed assets (so you can have two separate categories for Land and Buildings, Plant and Machinery, etc). Whilst this will provide additional analysis and reconciliations within Silverfin, please do note there is only so much space on a piece of paper in a set of accounts, even if printing landscape, and you might to combine some categories. 

Finally we also have specific fixed asset categories for Farmers being:

  • Biological assets 
  • Heritage assets 
  • Dairy Biological Assets 
  • Beef Biological Assets 
  • Sheep Biological Assets 
  • Pigs Biological Assets 
  • Poultry Biological Assets 
  • Crop 1 Biological Assets 
  • Crop 2 Biological Assets 
  • Milk Quota 
  • Potato Quota 
  • Cow Quota 
  • Sheep Quota 
  • Capital Herd 1