Client Report

For a broad report of all clients on your account, including not only profile information but also key subscription and one-time invoice data, head to Clients in your left-hand sidebar!

Searching will only result in clients within the respective tabs.

By using the Filter function, you can restrict your view to the payment method types, then export the invoices into an Excel report or as PDFs.

Once you click on the filter, the Default Payment Method Type will show. From there, you can select the dropdown and click on the desired default payment methods to show in the filtered results for your clients.

Once filtered, you can also export those clients if needed.

Click Export in top right-hand corner to export the report in Excel format:

Items shown on the export include:

Client Email
Client First Name
Client Last Name
Display Name
Client ID
Advisor Name
Client Created Date (date added to AdvicePay)
Deleted At (Date deleted in AdvicePay)
Active Subscription Count
Unpaid Invoice Count
Total Revenue
Revenue YTD
Next Subscription Bill Date (only populated once the current invoice billed is updated to Paid and the upcoming invoice is generated)
Next Subscription Bill Amount (only populated once the current invoice billed is updated to Paid and the upcoming invoice is generated)
Next One-time Invoice Due Date
Next One-time Invoice Amount
Past Due Invoice (True/False)
Failed Payment (True/False)
Account registered (Registered/Unregistered)
Account Active (Active/Inactive status)
Client Attributes (each attribute created is listed in its own column; protected attributes will not be displayed)

Account Owners, Full-Access Advisors, and Admin/Analyst users can access this download for clients firm-wide!

All advisors with login access can download this report for their assigned clients.