Column | Column heading (field name) | Mandatory or optional | Rules for the data |
---|
A | Account code | Mandatory (if there are no Asset class names) Optional (if there are Asset class names) | Must exist in the chart of accounts |
B | Asset class | Mandatory (if there are no Account codes) Optional (if there are Account codes) | Must exist in the chart of accounts |
C | Asset type | Mandatory | Must be one of the following values (non-case-sensitive): To identify an asset as a general asset - GA
- General Asset
- GeneralAsset
To identify an asset as a small business pool asset: (AU only) - SB
- Small Business Pool
- SmallBusinessPool
To identify an asset as a small business pool asset: (AU only) - LV
- Low Value Pool
- LowValuePool
|
D | Asset code | Optional | Must be unique and less than 500 characters |
E | Asset name | Mandatory | Must be less than 200 characters |
F | Acquisition date | (Australia) Mandatory (if there is no start date for pools) Optional (if there are start dates) | Date format must be one of: - dd/mm/yyyy
- dd/mm/yy
- dd/mmm/yyyy
- dd/mmm/yy
- dd-mm-yyyy
- dd-mm-yy
- dd-mmm-yy
- dd-mmm-yyyy
|
G | Cost | Mandatory | - Must be numeric and can't be negative
- Up to 14 digits and 2 decimal points
Can contain the dollar symbol $ and commas. For example, $20,000.23, 20,000.23$, 20,000.34, 20000.00 and 30000.
|
H | Start date-TAX | Mandatory (if there is no Aquisition date) Optional (if there is an Aquisition date) | Date format must be one of: - dd/mm/yyyy
- dd/mm/yy
- dd/mmm/yyyy
- dd/mmm/yy
- dd-mm-yyyy
- dd-mm-yy
- dd-mmm-yy
- dd-mmm-yyyy
UI Text Box |
---|
| The system calculates the start date for pools |
|
I | Opening w.d.v.-TAX | Mandatory (for prior year asset) N/A (for current year asset) | - Must be less than the cost for the prior year asset
- Must be numeric and can't be negative
- Up to 14 digits and 2 decimal points
- Can contain the dollar symbol $ and commas. For example, $20,000.23, 20,000.23$, 20,000.34, 20000.00 and 30000.
|
J | Method-TAX | Mandatory | Must be one of the following values (non-case-sensitive): Australia - DV
- Diminishing Value
- DiminishingValue
- PC
- Prime Cost
- PrimeCost
- IWO
- Immediate Write Off
- ImmediateWriteOff
New Zealand - DV
- Diminishing Value
- DiminishingValue
- SL
- Straight Line
- StraightLine
- IWO
- Immediate Write Off
- ImmediateWriteOff
|
K | Depreciation rate1-TAX | Optional | Must be between: UI Text Box |
---|
| If the asset start date (H) is in the current year, it's mandatory to have a value in this field as well as L Depreciation rate2-TAX to calculate the correct depreciation. |
|
L | Depreciation rate2-TAX | Optional | Must be between: UI Text Box |
---|
| If the asset start date (H) is in the prior year, it's mandatory to have a value in this field to calculate the correct depreciation. |
|
M | Effect life years | Optional | Must be between: |
N | Effect life months | Optional | Must be between: |
O | PrivateUse-TAX | Optional | Must be between: UI Text Box |
---|
| - 0.34 is treated as 0.34%
- 34% imports as 34%
|
|
P | Accum PU-TAX | Optional | - Must be numeric and can't be negative.
- Up to 14 digits and 2 decimal points.
|
Q | Is motor vehicle | Optional | Must be either: UI Text Box |
---|
| A blank is treated as N. |
|
R | Start date-ACC | Mandatory (if there is no start date-TAX or acquisition date) Optional (if there are start date-TAX or acquisition date) | Date format must be one of: - dd/mm/yyyy
- dd/mm/yy
- dd/mmm/yyyy
- dd/mmm/yy
- dd-mm-yyyy
- dd-mm-yy
- dd-mmm-yy
- dd-mmm-yyyy
|
S | Opening w.d.v-ACC | Mandatory (for a prior year asset) N/A (for a current year asset) | Must be less than the cost for prior year asset Must be numeric and can't be negative Up to 14 digits and 2 decimal points Can contain the dollar symbol $ and commas. For example, $20,000.23, 20,000.23$, 20,000.34, 20000.00 and 30000.
|
T | Method-ACC | Optional | Accept one of the following values (non-case-sensitive): - DV
- Diminishing Value
- DiminishingValue
- PC
- Prime Cost
- PrimeCost
- IWO
- Immediate Write Off
- ImmediateWriteOff
- SL
- Straight Line
- StraightLine
- EFD
- Exempt from Depreciation
- ExemptFromDepreciation
|
U | Depreciation rate1-ACC | Optional | Must be between: |
V | Depreciation rate2-ACC | Optional | Must be between: |
W | Private Use-ACC | Optional | Must be between: |
X | Accum PU-ACC | Optional | - Must be numeric and can't be negative
- Up to 14 digits and 2 decimal points
|