To view all of your revenue for a designated time period and categorize those payments by Plan Code, your best option is to use the Adjustments export. This export includes all invoiced charges and credits, as well as the plan they're associated with.
Here are the steps to follow after downloading the export for the timeframe you need:
-
Filter by Plan: Use the
adjustment_plan_codecolumn to filter for the specific plan you want to analyze. -
Filter for Invoiced Charges: Go to the
adjustment_typecolumn and filter to only showcharge. Then, filter theadjustment_statuscolumn to only showinvoiced. -
Filter by Payment Status: Finally, go to the
invoice_statecolumn and filter to only showPaid. This will ensure you are only viewing invoices that were actually paid and will exclude past due or failed invoices.
This process will leave you with a list of all paid charge invoices for the specific plan code you configured.
Comments
0 comments
Please sign in to leave a comment.