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

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 warrenty 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

Article ID: 150, Created On: 10/21/2011, Modified: 10/21/2011