Column | Column headings (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 | Mandatory (if there are no Start dates for Pools, AU only) Optional (if there are Start dates) | Date format must be either: - 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 symbol $ and commas (for example $20,000.23, 20,000.23$, 20,000.34, 20000.00 or 30000 are valid formats)
|
H | Start date-TAX | Mandatory (if there are no Aquisition dates) Optional (if there are Aquisition dates) | Date format must be either: - dd/mm/yyyy
- dd/mm/yy
- dd/mmm/yyyy
- dd/mmm/yy
- dd-mm-yyyy
- dd-mm-yy
- dd-mmm-yy
- dd-mmm-yyyy
Note: Start date will be system calculated 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 prior year asset
- Must be numeric and can't be negative
- Up to 14 digits and 2 decimal points
- Can contain symbol $ and commas (for example $20,000.23, 20,000.23$, 20,000.34, 20000.00 or 30000 are valid formats)
|
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 | Accept value between: |
L | Depreciation rate2-TAX | Optional | Accept value between: |
M | Effect life years | Optional | Accept value between: |
N | Effect life months | Optional | Accept value between: |
O | PrivateUse-TAX | Optional | Accept value between: Note: - 0.34 will be treated as 0.34%
- Enter 34% will import the value 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: - Y (For prior year assets, the Opening w.d.v should be less than or equal to the motor vehicle threshold as defined by ATO)
- N
Note: blank will be treated as N |
R | Start date-ACC | Mandatory (if there are no Start date-TAX or Acquisition date) Optional (if there are Start date-TAX or Acquisition date) | Date format must be either: - 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 prior year asset) N/A (for 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 symbol $ and commas (for example $20,000.23, 20,000.23$, 20,000.34, 20000.00 or 30000 are valid formats)
|
T | Method-ACC | Optional | Accept one of the following values (non-case-sensitive): For Australia and New Zealand - 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 | Accept value between: |
V | Depreciation rate2-ACC | Optional | Accept value between: |
W | Private Use-ACC | Optional | Accept value between: |
X | Accum PU-ACC | Optional | - Must be numeric and can't be negative
- Up to 14 digits and 2 decimal points
|