Rules and requirements for completing the bulk edit template

Follow these rules and formatting requirements when you enter tax information in the bulk edit template for registered fixed assets.

Rules for entering tax depreciation details

  • Leave the first row in place as the header row.
  • Keep the columns in the same order, and don't remove any columns.
  • Don't change any asset numbers.
  • Any new assets added to the template will be ignored. To add new assets, use Xero's fixed asset import process.
  • Any changes made to fields other than the tax depreciation fields (columns X to AH) will be ignored.
  • Any assets uploaded with 'Pooled' as the tax depreciation method in the bulk edit template will be treated as pool additions. Transfers to pools need to be made outside the bulk edit process.

Template field requirements

ColumnColumn header in templateAsset field in XeroDescription
XTax_Depreciation
Method
Tax Value
Depreciation Method

Exact text of the depreciation method.

Non-pooled asset:

  • No Depreciation
  • Straight Line
  • Diminishing Value
  • Diminishing Value (150%)
  • Diminishing Value (200%)
  • Full Depreciation
    at Purchase

Pooled asset:

  • Pooled
YTax_PoolNameTax Value Pool
Name

Non-pooled asset:

Leave blank.

Pooled asset:

Exact pool name.

ZTax_PooledDateTax Value Pooled
Date

Non-pooled asset:

Leave blank.

Pooled asset:

Pooled date.

AATax_PooledAmountTax Value Pooled
Amount

Non-pooled asset:

Leave blank.

Pooled asset:

The pooled value of the asset on its pooling date.

Number (no currency symbol or commas). For example, 1250.75.

Can't be greater than PurchasePrice.

Can't be negative.

ABTax_Depreciation
StartDate
Tax Depreciation
StartDate

Non-pooled asset:

Date format.

Pooled asset:

Leave blank.

ACTax_CostLimitTax Value Cost
Limit

Non-pooled asset:

Number (no currency symbol or commas). For example, 1250.75.

Can't be greater than PurchasePrice.

Can't be negative.

Pooled asset:

Leave blank.

ADTax_ResidualValue Tax Value
Residual Value

Non-pooled asset:

Number (no currency symbol or commas). For example, 1250.75.

Can't be greater than Tax_CostLimit (if entered) or Purchase Price.

Can't be negative.

Pooled asset:

Leave blank.

AETax_AveragingMethod Tax Value Averaging
Method

Non-pooled asset:

Exact text of averaging method:

  • Actual Days

Pooled asset:

Leave blank.

AFTax_Rate Tax Depreciation
Rate

Enter information in either AF or AG, not both.

Non-pooled asset:

If the Tax_DepreciationMethod in column X is No Depreciation, Diminishing Value (150%), Diminishing Value (200%) or Full Depreciation at Purchase, leave this field blank. Otherwise enter either:

  • Depreciation rate - Enter a number, for example, 15.25
  • Years - For example, 5

Enter information in one column only.

Pooled asset:

Leave blank.

AGTax_EffectiveLife Tax Value Effective
Life (Yrs)
AHTax_OpeningAccumulated
Depreciation
Depreciation as at the end of the financial year before the year you start using tax depreciation in Xero.

Non-pooled asset:

Number (no currency symbol or commas). For example, 1250.75.

If you've previously depreciated this fixed asset outside Xero, enter the accumulated tax depreciation amount.

Pooled asset:

Leave blank.

AITax_ValueTax ValueFor information purposes only. Information in these columns is not imported into Xero.
AJTax_Accumulated
Depreciation
Tax Accumulated Depreciation

You might also be interested in