Invoices Page: Filters and Reporting

The Invoices page located in your sidebar ( Transactions > Invoices) contains a combined view of both your one-time and individual subscription invoices! You can use this page to easily find and manage things like:

  • All failed invoices
  • Invoices (both one-time and individual subscription invoices) that are in the Unpaid status
  • Past due subscription invoices
  • Payments that have completed transferring to your bank account within the last quarter
  • Paid invoices with a specific Description of Service
  • Refunded invoices for specific clients
  • Invoices created by an advisor during a specific time period
  • And more!

By using the Filter function you can restrict your view to a variety of specific scenarios, then export the invoices into an Excel report or as PDFs.

Note: We have recently added a new Status for Invoices called Clearing. You will see it on client payments that have been be charged via ACH (aka a checking account) to more accurately reflect their state! At this time, it not an available filter to search.

Why was it added? It takes approximately 5 business days for ACH payments to settle at the client's bank, during which point it's possible that they fail due to insufficient funds, incorrect account number, etc. Instead of immediately marking the status as "Paid" after the charge is made, we now mark it as "Clearing." This means the charge has been made, but it is still officially processing at the bank. Once it is successful, it will update to Paid. 🙂

How to Filter Invoices:

1. Click the Filters button

2. Click a Category's drop down arrow to reveal its filtering options. Select or enter the information you want to see. (You can fill out any number of categories to narrow your view even further!)

Tip: The Descriptions of Service category allows you to select invoices associated with saved descriptions under "List of services" at Firm Settings > Invoice and/or Account Settings > Invoice.

3. Select Apply Filters 

4. Optional: to download the filtered invoices into a single PDF file, select Actions > Download Invoices. To export the filtered invoices into an Excel report, select Actions > Export to .XLSX

5. To clear your filters/start over from scratch, select Filters > Reset Filters


Filter Options

Status:

  • Paid
  • Unpaid
  • Transferred
  • Refunded
  • Past Due
  • Failed
  • Upcoming

Type:

  • One Time Invoices
  • Subscription (this includes Upfront Invoices attached to subscriptions as well!)

Client:

  • Type in or select Client Name

Advisor:

  • Type in or select Advisor Name (only available to Full-Access Advisors and firm-level Admins/Analysts)

Date Invoiced:

  • From Date - To Date

Due Date:

  • From Date - To Date

Date Paid:

  • From Date - To Date

Date Transferred:

  • From Date - To Date

Description of Service:

  • Type in or select a saved Description of Service (can type in content of description or title to search)

Still need help? Contact Us Contact Us