Invoices Report
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 transfer 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.
What does the 'Clearing' status mean?
You'll see a Clearing status on invoices that a client has recently paid via ACH!
This status reflects that it takes approximately 5 business days for ACH payments to settle at the client's bank, at which point they may fail due to insufficient funds, incorrect account numbers, etc. Instead of immediately marking the status as "Paid" after the charge is made, we mark it as "Clearing" to show that the charge has been made and it's still officially processed at the bank. Once it's successful, it will update to Paid. At this time it's not a filter option on the Invoices page.
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. Once selected you'll see this information filtered automatically. (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. 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
Items shown on the Excel export include:
- Status (e.g. Paid, Unpaid, Refunded, Failed, Upcoming)
- Client Name
- Advisor Name
- Invoice ID
- Amount
- Refund Amount
- Due Date
- Paid Date
- Accepted Payment Methods (ach, ccd)
4. To clear your filters/start over from scratch, select Filters > Reset Filters with the blue button at the bottom.
One thing to note about filtering is that only the fields in the items listed below in "Items shown on the Excel export include" will be exported), other filters are only visually filtered in the user interface (UI).
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
Accepted Payment Methods:
- ACH, Credit Card
Description of Service:
- Type in or select a saved Description of Service (can type in the content of description or title to search)