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 field Type Description
 Name  Str 31  Name of the fixed asset item
 IsActive  Bool  Whether item is active in QuickBooks true or false
 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