Fixed Asset help
Lacerte : 2010Hi, I have over 150 fixed assets to enter. What is the best way to get them in Lacerte from Quickbooks? Is there a tutorial somewhere?
1
347
dJGAqMibGr4yUOacwZ5xHE
12/06/11 6:45am PST
1 Reply
LacerteGuru
Questions asked: 97
Questions answered: 2626
Points earned: 6075
Questions answered: 2626
Points earned: 6075
Intuit Superstar
Employee who makes outstanding contributions to the community
12/06/11 7:22am PST
Latest post
Get them exported from QB (can't be that hard). Then Under Tools menu in Lacerte, import. Here's some tips on formatting:
-
Single File Import: Only one file can be selected and imported at a time.
-
Password-Protection: Password-protected Excel files are not supported.
-
File Extensions: If you select to import a 2007 .xlsx Excel file, the wizard will indicate that this is not a supported file. Please simply open the file in Excel and save it with a .xls extension, then import the file again.
-
Required Fields: The following columns with valid data are required for importing: Date Placed in Service, Cost or Basis, and Description.
-
Blank Rows: Blank or hidden rows or columns in the Excel or comma delimited file will not be imported.
-
Rows and Columns: Each asset will appear as a single row in the wizard (assets using more than one row in your original file should be condensed into a single row format). Each column in the wizard represents a single input field.
-
Rounding: Amounts shown on the wizard screens will include decimals, but all amounts will then be rounded to the dollar when imported into the tax program.
-
Category Column: In the Category column, only numeric entries are valid for import. In your spreadsheet, be sure to enter numbers in the Category column according to this list:
1 = Auto
2 = Furniture & Fixtures
3 = Machinery & Equipment
4 = Buildings
5 = Improvements
6 = Land
7 = Miscellaneous
8 = Amortization
