Skip to main content
Level 6
November 3, 2024
Solved

Fee report

  • November 3, 2024
  • 1 reply
  • 18 views

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

This topic has been closed for replies.
Best answer by PhoebeRoberts

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.

1 reply

PhoebeRoberts
Intuit Community Champion
November 4, 2024

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
Level 15
November 4, 2024