ProConnect HelpIntuit HelpIntuit

Exporting the Lacerte client list to a spreadsheet file

by Intuit Updated 1 month ago

This article will show you how to export the Lacerte client list to a spreadsheet file. The steps below reference default installation paths and use YY to reference the tax year in 20YY format.  C: will always indicate the local drive and X: will always indicate the network drive.

Stay up to date on what's current! Check out Lacerte Hot Topics and bookmark it using Ctrl+D.

Detailed information, such as the name of payer for interest, dividends, or the description of property, date acquired and sold for dispositions, etc. aren't available for export. Only the total interest, dividend, and capital gain are in the available export fields.

For more Print & PDF resources, check out our Troubleshooting page for Print & PDF where you'll find answers to the most commonly asked questions.

Follow these steps to export the client list to a spreadsheet:

  1. Go to the Clients tab.
  2. Highlight the client(s) to export.
    • You can also press F3 on your keyboard to open the Client Group Selection window, which will allow you to select multiple clients at once.
  3. From the Client menu, select Export and choose Export to File from the dropdown list.
  4. Click on Browse to select a different directory or leave the default directory.
    • For example, the default is usually C:\LACERTE\YYTAX\IDATA\EXPORT.
  5. Enter a File name or leave the default file name.
    •  The current file name is usually EXPORT.

When naming the export file it uses Windows file naming structure. The file names can't include / ? * : < > " or | characters since Windows will not recognize them as part of a file name, causing Lacerte to produce an error. If a period is included in the name, it won't change the file extension.

  1. Select the Export Type as Comma Delimited.
  2. Check the box labeled Print Summary File to create and print summary information about the exported file.
  3. Click on the plus sign (+) next to any category under the Available section.
  4. Double-click the items you want to export, or highlight the item and click the ( > ) button to move the item to the Display section.
    • To remove an item from the Display section, highlight it and click ( < ).
    • To change the order the program writes the items to the file, select an item in the Display section, and click the Up or Down button to arrange it in the list.
  5. Click OK to create the file.
  6. Click Exit to close the Export Client window after the file is created.
  7. Browse to the directory where the file was saved.
    • The default is C:\LACERTE\YYTAX\IDATA\EXPORT.
  8. Double-click on the .CSV file to view the exported information in your default spreadsheet program.
    • If you didn't change the file name in step 5, the name of the file is EXPORT.CSV.

Follow these steps to import CSV to Outlook

If this export is being done specifically for an outlook mailing list, we recommend exporting Taxpayer First Name, Taxpayer Last Name, and Taxpayer E-mail Address. Follow the steps below to do so:

  1. Click on Taxpayer First Name.
  2. Click on the > button to move the item to the Display section.
  3. Click on Taxpayer Last Name.
  4. Click on the > button to move the item to the Display section.
  5. Click on Taxpayer E-mail Address.

Follow these steps to import CSV to Outlook:

  1. Open Microsoft Outlook.
  2. Click on File.
  3. Click on Open & Export.
  4. Click on Import/Export. In prior years Outlook change the Files of Type to All Files.
  5. Select Import from another program or file.
  6. Click Next.
  7. Select Comma Separated Values.
  8. Click Next.
  9. Click on Browse and locate the file to import.
  10. Click OK.
  11. Select the applicable Options:
    • Replace duplicates with items imported
    • Allow duplicates to be creates
    • Do not import duplicate items
  12. Click Next.
  13. Select the Contacts destination folder.
  14. Click Next.
  15. Click on Map Custom Fields.
  16. Drag the Values from the From section on the left side and drop them on the appropriate destination field on the right.
  17. Click OK.
  18. Click Finish.

When including zip codes during export, clients in Maine, Vermont, New Hampshire, Massachusetts, Rhode Island, Connecticut, New Jersey and U.S. Territory Puerto Rico will import into Excel without the 0 at the start of the zip code. For example, the zip code 04401 would display as 4401 in the spreadsheet.

You can change this by changing the Number format to Special for the zip code. Refer to this article for instructions on changing the Number format to Special.

Lacerte Tax 2018Lacerte Tax 2019Lacerte Tax 2020Lacerte Tax 2021

Sign in now for personalized help

Ask questions, get answers, and join our large community of Intuit Accountants users.

More like this

Dynamic AdsDynamic Ads