Fee report

[GGL58]

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

[PhoebeRoberts · Accepted solution]

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.

[George4Tacks]

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...

[GGL58]

Thanks!