Intuit HelpIntuit
Exporting depreciation data from Lacerte to a file
by Intuit•2• Updated 10 months ago
Lacerte offers the ability to export client depreciation data to a file.
Before you start:
It's recommended to create and save an Excel spreadsheet before starting the export, this makes it easier to find the file when browsing to save it.
To export the data:
- Select the client file containing the depreciation data to be exported.
- From the Client menu, select Export then select Export Depreciation to File.
- Choose the directory location to save the exported depreciation data and then select OK. The default location to save the exported depreciation data is Documents.
- The program calculates the return and exports the depreciation data into a comma-separated file (.CSV) for the selected clients. If a client's return doesn't calculate, the program won't export that client's depreciation data.
- If exporting multiple files, review the Depreciation Data Report to see a list which files were successfully exported and the file names for those returns.
- Select Print Report for a paper copy of the exported files or select Close when finished reviewing the report.
The exported depreciation data (.CSV file) can now be accessed using another application, such as Microsoft Excel.
To open the data in Excel
- Open Microsoft Excel.
- From the File dropdown menu, choose open.
- Go to the .csv file.
- Make sure the file type in the lower half of the window is set to csv, or you may not see it.
- Once it's opened in Excel it can be saved as an Excel file.
Once the file has been exported to Excel, the assets can be imported into another client file using Fixed Asset Manager. For FAQs regarding the use of Fixed Asset Manager, refer to Common questions about Fixed Asset Import.
Sign in now for personalized help
Ask questions, get answers, and join our large community of Intuit Accountants users.
More like this
- Entering a depreciable asset in Lacerteby Intuit•51•Updated over 1 year ago
- How to generate Form 4562 for depreciation in Lacerteby Intuit•64•Updated August 16, 2024
- How to export Schedule K-1s between tax returns in Lacerteby Intuit•574•Updated 3 weeks ago
- Special depreciation input and elections in Lacerteby Intuit•111•Updated 2 years ago
- How to calculate AMT depreciation for assets with special depreciation in Lacerteby Intuit•11•Updated over 1 year ago