Page History
...
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 |
Overview
Content Tools