To help make importing easier, we've created a template that already contains all the column headings in the required format. Download this template file and open it in Excel, then add your own data.
The CSV file should include all column headings. These can appear in a different order and are not case-sensitive.
You don't need to complete all the fields for a successful import, but make sure you don't delete any unused columns or rename any column headings.
-
The maximum CSV file size is 1MB
-
If your CSV file contains more than 500 assets, we recommend you split it into several files to avoid going over the size limit.
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 To identify an asset as a small business pool asset: (AU only) - SB To identify an asset as a small business pool asset: (AU only) - LV |
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 |
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 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 New Zealand - DV SL Straight Line StraightLine IWO Immediate Write Off ImmediateWriteOff |
K | Depreciation rate1-TAX | Optional | Must be between: 0.00% - 100.00% 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: 0.00% - 100.00% 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: 0 - 999 |
N | Effect life months | Optional | Must be between: 0 - 11 |
O | PrivateUse-TAX | Optional | Must be between: 0.00% - 100.00%
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: Y (For prior year assets, the opening w.d.v should be less than or equal to the motor vehicle threshold as defined by the ATO) N. 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: 0.00% - 100.00% |
V | Depreciation rate2-ACC | Optional | Must be between: 0.00% - 100.00% |
W | Private Use-ACC | Optional | Must be between: 0.00% - 100.00% |
X | Accum PU-ACC | Optional | Must be numeric and can't be negative Up to 14 digits and 2 decimal points |