03333 445950
 |
 |
 |
Making I.T. Happen
Accounting and Information Technology, Assistance and Support
Fixed Asset V2010 and Above
The field order is specified below, for users using a spreadsheet to prepare data we have also included column letters.
| Field | Header Name | Notes | |
| 1 | A | Asset Refn | This must be just the letters A to Z and the Numbers 0 to 9 You can not have any spaces max size 8 chars |
| 2 | B | Location or Employee | |
| 3 | C | Description 1 | |
| 4 | D | Description 2 | |
| 5 | E | Description 3 | |
| 6 | F | Serial No | |
| 7 | G | Supplier Refn | |
| 8 | H | Bal Sheet Nom Refn | eg 0031 |
| 9 | I | P and L Nom Refn | eg 8000 |
| 10 | J | Depreciation Method | 0=Straight Line 1 = reducing Balance |
| 11 | K | Purchase Date | |
| 12 | L | Category | |
| 13 | M | Department | |
| 14 | N | Rate | 25 = 25% |
| 15 | O | Cost Price | |
| 16 | P | Net Book Value |
Refer to our field information table for the limitations of data values for these fields
Our Custom integration and import solution will allow you to have fields in any order and extract them from formats other than CSV eg: mailing labels printed to disk you can also import all the other fields associated with customers such as price lists.
