Solution Properties
Solution ID:
250321114532250
Last Modified Date:
Fri Mar 21 15:01:55 UTC 2025
Taxonomy Path:
Case category//How do I...//import/export
Author:
[email protected]
Fixed asset records data fields you can import
Description

You can use the Import option to import data into your accounts, either to create your Fixed asset records.

Here you can check which data fields you can import and find out more about the format required for each field.

 TIP: There are reports in Sage 50 Accounts that you can use to export your existing data in the correct format for CSV files.

Fixed asset records

 NOTE: This option is only available in Sage 50 Accounts Professional and Client Manager. If you're interested in upgrading, leave your details and we'll be in touch.

Field

 Type Size Left blank? Format Excel column Report to use
Asset Reference Text 8 No Up to 8 characters with no spaces. A Fixed Asset CSV
Location or Employee Text 15 Yes   B Fixed Asset CSV
Description 1 Text 60 Yes   C Fixed Asset CSV
Description 2 Text 60 Yes   D Fixed Asset CSV
Description 3 Text 60 Yes   E Fixed Asset CSV
Serial No Text 60 Yes   F Fixed Asset CSV
Supplier Reference Text 8 Yes Up to 8 characters. The supplier account must exist within the accounts data. G Fixed Asset CSV
Balance Sheet Nominal Reference Text 8 No Up to 8 characters. The nominal code must exist within the accounts data. H Fixed Asset CSV
P and L Nominal Reference Text 8 No Up to 8 characters. The nominal code must exist within the accounts data. I Fixed Asset CSV
Depreciation Method Integer 1 No This must be 1, 2 or 3.

1 = Straight line
2 = Reducing balance
3 = Write off		 J Fixed Asset CSV
Purchase Date Date 10 Yes - Uses the current program date. This must be in the format DD/MM/YYYY. K Fixed Asset CSV
Category Integer 3 Yes Enter a number between 1 - 100 with no decimal places. L Fixed Asset CSV
Department Integer 3 Yes Enter a number between 1 - 999 with no decimal places. M Fixed Asset CSV
Rate Decimal 11 No Enter a number between 0 - 99.99. N Fixed Asset CSV
Cost Price Decimal 11 No 8 digits + 2 decimal places. O Fixed Asset CSV
Net Book Value Decimal 11 No 8 digits + 2 decimal places. P Fixed Asset CSV