FA-213 - Getting issue details... STATUS FA-201 - Getting issue details... STATUS
Sample CSV Template for Importing (exported file )
Import screen for Fixed Asset.
Columns
| # | 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 |
| Column | Comment | ||
| Imported Dep Thru | Added 5/25/2021 for importing | ||
| Import Dep To Date | Added 5/25/2021 for importing | ||
| Asset Description | |||
| Company Location | |||
| Serial Number | |||
| Notes | |||
| Date Acquired * | |||
| Date In Service * | |||
| Cost * | |||
| Currency * | |||
| Market Value | |||
| Insurance Value | |||
| Salvage Value * | |||
| Basis Description | |||
| Disposition Number | |||
| Disposition Amount | |||
| Pool Id | |||
| Accuitent | |||
| Manufacturer Name | |||
| Model Number | |||
| Asset Account Id | |||
| Expense Account Id | |||
| Depreciation Account Id | |||
| Accumulated Account Id | |||
| Gain Loss Account Id |
Overview
Content Tools