Transactions by Invoice Item Report

The Transactions by Invoice Item report provides invoice item-level details of a transaction.  

From this report, you can create views that show how much revenue and tax collected for each product, breakdowns of transactions by revenue category, the number of failed transactions, and more.  Transactions can also be viewed by various timeframes such as daily, weekly, monthly or custom time ranges.

IMPORTANT NOTE

It's important to note that transactions are made at the invoice level, not against individual invoice items.  To create the Transactions by Invoice Item report, we take each transaction made against an invoice and attribute a portion of that transaction to each item associated with the invoice.  This means that every time a transaction is made, it is associated with every invoice item in the invoice.

For example, consider an invoice has a $90 plan and a $10 signup fee for a total invoice amount of $100.  The plan makes up 90% of the invoice and the signup fee the remaining 10%.

A $50 transaction against this invoice will result in two rows in the Transactions by Invoice Item report, one for the plan and one for the signup fee.  The plan row will report a transaction amount of $45, or 90% of the total transaction.  The signup fee row will report $5 for the remaining 10%.

This same allocation scheme will be used for refunds and voids as well.

Quick Views

Transactions Today by Revenue Category - Summary of today's Transactions grouped by Revenue Category

Transactions Last Month by Product Name - Summary of Transactions lat month for each Pass, Plan and merchandise item.

Transactions Last Month by Product Type - Summary of Transactions last month grouped by Product Type (recurring, pass, retail, etc.)

Summary View

The Transactions by Invoice Item report provides three summary views: Transactions by Invoice Item Details, Payment Method, and Processing Method. Each view can be grouped by a set of provided transaction attributes.

The following metrics are computed for each group of transactions:

Transactions by Invoice Item Details

• Transactions - The count of unique transactions
• Autopay - The count of unique transactions created by automated billing
• Settled - The count of unique settled transactions
• Failed - The count of unique failed transactions
• Total Net Paid - Sum of all successful, non-refunded payments
• Total Net Paid Less Tax - The portion of Total Net Paid that is not allocated to tax
• Total Net Paid Tax - The portion of Total Net Paid that is allocated to tax
• Total Payment Amount - Sum of all successful payments
• Total Refund Amount - Sum of all successful refunds

Payment Method

• Total Net Paid - Sum of all successful, non-refunded payments
• Cash - Sum of all successful, non-refunded payments made in cash
• Check - Sum of all successful, non-refunded payments made by check
• ACH - Sum of all successful, non-refunded payments made by ACH
• Account Credit - Sum of all successful, non-refunded payments made by account credit
• American Express - Sum of all successful, non-refunded payments made by Amerian Express
• Discover - Sum of all successful, non-refunded payments made by Discover
• Mastercard - Sum of all successful, non-refunded payments made by Mastercard 
• Visa - Sum of all successful, non-refunded payments made by Visa
• Other Credit Card - Sum of all successful, non-refunded payments made by an other credit card
• External Payment - Sum of all successful, non-refunded payments made by an external payment method

Processing Method

• Total Net Paid - Sum of all successful, non-refunded payments
• GlobalPay - Sum of all successful, non-refunded payments processed by GlobalPay (for Visa, Mastercard, and Discover)
• American Express - Sum of all successful, non-refunded payments processed by American Express
• Other - Sum of all successful, non-refunded payments processed by an other processing method

 

Key dates

There are two key dates available for this report: Transaction Date and Failed Date.

Use Transaction Date to group transactions by the day that they were made.

Use Failed Date to group failed transactions by the day that they failed.

There are also corresponding options to group by Week, Month, Quarter, or Year.  Transaction Date and Failed Date can also be filtered in the Details view to narrow down the window of time for review.

 

Details View

In addition to the summary view, there is also a Details view that shows greater details on each invoice item's attributed transaction amounts.  This view can easily be filtered to a desired timeframe, specific transaction statuses (such as failed transactions), clients, and more. 

Available details in this view are:

• Invoice Number - Unique ID across all invoices for each business.  For a franchise report, this number would not be unique.  It is only unique at the business level.  This is different from Invoice ID in that Invoice ID is unique across all invoices, not just those for this business.
• Invoice Due Date - Date when the invoice is expected to be paid.  This is displayed in the timezone of the business.
• Invoice Status - Current state of the invoice.  Possible states include Cart, Open, Closed, Canceled, On Hold, or Purchase Request.
• Transaction Status - Current state of the transaction.  Possible states include Completed, Failed, Checkout, Processing, Voided, or Settled.
• Product Name - Current product name.  Note that product names can change over time.
• Revenue Category - Business-defined revenue category assigned to a service or product.  An invoice item will have at most one revenue cateogry.
• Product Type - Type of the product purchased.  Possible types include Retail, Recurring, Pass, Signup Fee, Hold Fee, and more.
• Membership? - Indicates whether the item purchased grants membership status.
• Transaction At - Date and time when the transaction was created.  This is displayed in the timezone of the business.
• Transaction Date - Date when the transaction was created.  This is displayed in the timezone of the business.
• Transaction Type - Type of the transaction.  Possible values include Payment or Refund.
• Transaction Amount - Amount of the transaction.
• Payer - Full name of the person who made the transaction.
• Payer Home Location - Current home location of the person who made the transaction.  This is the payer's primary location of use.
• Payer's Primary Staff Member - Full name of the payer's current primary staff member.
• Payment Method - Payment method used for the transaction.  Possible values include ACH, Cash, Check, Account Credit, Credit Card, External, Free, PayPal, or Other.
• Credit Card Name - Name of the credit card used for the transaction, if applicable.
• Processing Method - Processing method of the transaction.  Possible values include Global Pay, American Express, Other.
• External Payment Name - Name of the external payment type as defined by the business.
• External Transaction Id - ID associated with the payment method used for the transaction, if available.  For example, this could be the check number when purchased with a check or the processing ID from a merchant processor when a credit card is used.
• Net Paid - Amount of the successful transaction.  For payments, this is the paid amount.  For refunds, this is the refunded amount.
• Net Paid Less Tax - Portion of Net Paid that is not allocated to tax.
• Net Paid Tax - Portion of Net Paid that is allocated to tax.
• Payment Amount - Amount of the successful payment.
• Refund Amount - Amount of the successful refund.
• Autopay? - Indicates whether the transaction was created as part of automated billing.
• Sale Location - Name of the business location where the sale occurred.
• Invoice Created By - Full name of client or staff member who created the invoice.
• Void At - Date and time when the transaction was voided.  This is displayed in the timezone of the business.
• Failed At - Date and time when the transaction failed.  This is displayed in the timezone of the business.
• Error Message - Error message if the transaction failed.
• Transaction ID - Unique ID across all transactions.
• Invoice ID - Unique ID across all invoices.
• Invoice Item ID - Unique ID across all invoice items.
• Payer ID - Unique ID for the person paying the invoice.