This article may be out of date!
Visit the New Knowledge Center

How to Generate a Revenue Report for Open or Closed Matters Only?




  • Clio Web App

Additional Information:

How to use VLOOKUP in Excel

How to Filter data in Excel


  1. Generate a Revenue Report (for all clients, in CSV format)
  2. Generate a Matter Export (CSV format)
  3. In Microsoft Excel, use a VLOOKUP to add the Status column from the Matter Export to the Revenue Report
  4. Filter the enhanced Revenue Report by Status, showing only Open or Closed Matters
Was this article helpful?
This information is confusing or wrong
This isn't the information that I was looking for
I don't like this functionality