Drake Tax – Exporting Depreciation Listing to Spreadsheet

Drake Tax logo

Last Updated:

Article #: 11706


Overview

The Depreciation List is a report that displays depreciation information for selected clients. There are two methods for creating depreciation lists in Drake Tax:

  • Manually entering client SSN/EINs to be listed

  • Filtering the client database for clients that meet specified criteria (for example, by return type on the next screen)

Creating a Depreciation List

To create a depreciation list for one or more clients, from the Home window menu bar, select Reports > Depreciation List. The Depreciation List Client Selection dialog box is displayed. All recently opened returns are listed in the Client Name pane.

  1. Choose an option for selecting returns to calculate:

    • Begin typing an ID number (SSN or EIN) in the Client Selection box. Continue typing the complete ID number, and then press Enter (or double-click) to add the return to the Selected Clients list on the right side of the Depreciation List Client Selection window.

    • Alternately, click a client from the Client Name list and click the Select Client button (or double-click the client) to move that name to the Selected Clients list.

    • To help narrow your search, click the Recent Returns drop list and choose a return type (1040, 1120, etc.).

  2. Repeat the previous step until all clients for whom you wish to generate depreciation lists are listed under Selected Clients.

  3. Click Next.

Note To run a list using filters instead of naming individual clients, do not add any names to Selected Clients. Click Next and select the return types (or all returns) for which you want a report.

Print or Export the Depreciation List

When the Depreciation Listing window is opened, choose to print the depreciation list or to export to file:

  • Print — Send the list to the printer. In the Print dialog box, click Print.

  • Export to File — Depreciation lists exported to file are stored in Drake2025\Reports as CSV files. The program displays the name of the file. Click OK.

Exporting to a Spreadsheet

The exported CSV file is named DEPRLIST.CSV and is saved in the Drake2025 > Reports folder (for example, Drake25\Reports when using Drake Tax 2025). Use File Explorer to navigate to the file. Move the exported file to another location to work with it (such as your desktop), or open it and save a copy elsewhere.