Page History
...
Sample CSV Template for Importing (exported file )
Import screen for Fixed Asset.
...
| # | Letter | Column | Sample values |
|
| 1 | A | Asset Description | Duplicate (1) of AM-83 | |
| 2 | B | Company Location | MuddyRun | |
| 3 | C | Serial Number | 12345 | |
| 4 | D | Notes | ||
| 5 | E | Date Acquired * | 05/19/2020 | |
| 6 | F | Date In Service * | 05/19/2020 | |
| 7 | G | Depreciation Method Id | AM-47DM | |
| 8 | H | Cost * | 1000 | |
| 9 | I | Forex Rate | 1 | |
| 10 | J | Currency * | USD | |
| 11 | K | Market Value | 0 | |
| 12 | L | Insurance Value | 0 | |
| 13 | M | Salvage Value * | 500 | |
| 14 | N | Basis Description | ||
| 15 | O | Disposition Number | ||
| 16 | P | Disposition Amount | 0 | |
| 17 | Q | Pool Id | ||
| 18 | R | Accuitent | 0 | |
| 19 | S | Manufacturer Name | ||
| 20 | T | Model Number | ||
| 21 | U | Asset Account Id | 11015-00-00 | |
| 22 | V | Expense Account Id | 11050-00-00 | |
| 23 | W | Depreciation Account Id | 11100-00-00 | |
| 24 | X | Accumulated Account Id | 11375-00-01 | |
| 25 | Y | Gain Loss Account Id | 11375-00-02 | |
| 26 | Z | Imported Dep Thru | 11/16/2020 12:00:00 AM | |
| 27 | AA | Import GAAP Dep To Date | 150 | |
| 28 | AB | Import Tax Dep To Date |
...
Overview
Content Tools