Import Fixed Asset Items into QuickBooks

You can import fixed asset items from text files or from Excel spreadsheets directly into QuickBooks using the Zed Axis software. Download and install the Zed Axis software on your computer.

  1. Open your QuickBooks company file as Administrator and open Zed Axis
  2. Select your text file or spreadsheet which contains the fixed asset items that you want to import.
  3. Set up the a Mapping of the columns in your fixed asset items import file to the corresponding fields in QuickBooks
  4. Click Import and your fixed asset items will be directly added to your QuickBooks company file:

For more information about importing fixed asset items into QuickBooks, search the Knowledge Base, watch the movies in the Learning Centre, or raise a ticket with Zed Support

Download Fixed Asset template

 

 
QuickBooks fieldTypeDescription
 Name Str 31 Name of the fixed asset item
 IsActive Bool Whether item is active in QuickBooks true or false
 ClassRefFullNameStrFull name of the Class must match what is in QuickBooks
 AquiredAs Enum If item was New or Old when acquired
 PurchaseDesc Str 50 Description when purchased
 PurchaseDate Date Date of purchase
 PurchaseCost Price Cost of purchase
 VendorOrPayeeName Str 50 Name of vendor
 FixedAssetAccountName Str 159 Chart of Account name for asset
 SalesDesc Str 50 Description if sold
 SalesDate Date Date of sale
 SalesPrice Price Price of sale
 SalesExpense Price Expense incurred during sale
 AssetDesc Str 50 Description of the asset
 Location Str 50 Location of asset
 PONumber Str 30 Purchase order number for asset
 SerialNumber Str 30 Serial number for the asset
 WarrantyExpDate Date Date warranty expires
 Notes Str 4095 Notes
 AssetNumber Str 10 Number used to identify asset
 CostBasis Amt Total cost of the asset, used for depreciation calc
 YearEndAccumDepreciation Amt Amount lost in value since purchased
 YearEndBookValue Amt Value at the end of the year

Add Feedback