- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Each year, I prepare a list of fees charged for each client, to be modified and used in the mail merge of my Client Letter for the following year. I need it in Excel, for a couple of reasons.
In the past, I've created a custom report in Lacerte, but that gives me a pdf. I've then needed to use Acrobat to convert it to Excel, but doing so creates many Excel errors, like merged cells, that take a long time to fix.
Does anyone know how to create a list in Lacerte of clients and fees in a .csv format?
Thanks
Best Answer Click here
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
1) Select all your clients (F3 from the main screen)
2) Client, Export, Export to File
3) Select the fields you want and move them to the right-hand column by clicking the right arrow button. Total Fee - Invoice is the field I want; your needs may differ.
4) OK!
5) Open the .csv file in Excel.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Good summary of this very long article on HOW TO https://accountants.intuit.com/support/en-us/help-article/customer-list/exporting-lacerte-client-lis...
Answers are easy. Questions are hard!