Export fixed assets

Export your fixed assets out of Xero to a CSV file.

About exporting fixed assets

  • Xero exports your entire fixed asset list (including disposed assets) to the CSV file, even if you limit by search criteria before you export it.
  • Xero groups the assets by status (Disposed, Draft, Registered), then lists the assets in each group in alphanumeric order by asset number.
  • If you've turned on tax reporting, tax depreciation information is included in the exported file.
  • The exported file contains data as at the export date. For example, for assets transferred to a pool, the export file doesn't show tax values prior to pooling. Instead, you can see this information in Xero.
  • Xero includes more columns in the export file than are included in the import template.

 

Export all your fixed assets

  1. In the Accounts menu, select Fixed Assets.
  2. Click Export.

    Xero downloads all your fixed assets in a CSV file to your computer.

Additional columns in the export file

The fixed assets export file has the same columns as the import file, with these additional columns:

No tax reporting

ColumnColumn headerDescription
CAssetStatus

Whether the asset is:

  • Draft
  • Registered
  • Disposed
VBook_BookValueThe asset's current book value
WAccumulatedDepreciationAccumulated book depreciation on the asset at the export date
XDepreciationToDateThe last date depreciation was run in Xero.
YDisposalDateIf the asset is disposed, the date of disposal.

Tax reporting turned on

ColumnColumn headerDescription
CAssetStatus

Whether the asset is:

  • Draft
  • Registered
  • Disposed
VBook_BookValueThe asset's current book value
WAccumulatedDepreciationAccumulated book depreciation on the asset at the export date
AITax_ValueThe asset's current tax value
AJTax_AccumulatedDepreciationAccumulated tax depreciation on the asset at the export date
AKDepreciationToDateThe last date depreciation was run in Xero
ALDisposalDateIf the asset is disposed, the date of disposal