Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. As a store manager, if you want to check which payment method is popular in your store during the checkout, or which payment the customer often uses to refund, this report is for you

  2. To access the Sale by Time-frame report: Omni-channel Reports > Report Dashboard > All reports > Sales reports > Sales by Payment Type or Omni-channel Reports > Sales → Sales by Payment Type

The Sales by Time-frame Payment Type Report page is displayed with the default view as below:

...

Columns that are shown by default

Payment Type

  • Name of the payment type

Total Paid

  • The total paid by the payment type

  • Value= the amount that the user uses the payment to invoice the order

  • The currency will follow the Base Currency of the magento site.

% Total Paid

  • The contributions as % of this payment type over the total paid

  • Value= Total paid of the payments/ Total paid of all payment types

  • The currency will follow the Base Currency of the magento site

Number of Selling Transactions

  • The number of selling transaction of each payment type

  • Recorded when the order having that payment is invoiced.

Average Transaction Value

  • The average transaction value of each payment type

  • Value= Total paid of each payment type/ Number of Selling Transactions of each payment type

  • The currency will follow the Base Currency of the magento site

Columns that are hidden by default

Payment Type

  • Name of the payment type

Total Paid

  • The total paid by the payment type

  • Value= the amount that the user uses the payment to invoice the order

  • The currency will follow the Base Currency of the magento site.

% Total Paid

  • The contributions as % of this payment type over the total paid

  • Value= Total paid of the payments/ Total paid of all payment types

  • The currency will follow the Base Currency of the magento site

Number of Selling Transactions

  • The number of selling transaction of each payment type

  • Recorded when the order having that payment is invoiced.

Average Transaction Value

  • The average transaction value of each payment type

  • Value= Total paid of each payment type/ Number of Selling Transactions of each payment type

  • The currency will follow the Base Currency of the magento site

Refunded

  • The refunded amount of each payment type

  • The currency will follow the Base Currency of the magento site

  • This column is hidden by default.

Number of Refunding Transactions

  • The number of refunding transaction of each payment type

  • This column is hidden by default.

Discount

  • The total Discounts of all orders that paid by the payment type during the selected report period.

  • The currency will follow the Base Currency of the magento site.

  • This column is hidden by default.

Tax

  • The total tax of all orders that paid by the payment type during the selected report period.

  • The currency will follow the Base Currency of the magento site.

  • This column is hidden by default.

Shipping (excl. Tax)

  • The total shipping cost of all orders that paid by the payment type during the selected report period.

  • The currency will follow the Base Currency of the magento site.

  • This column is hidden by default.

Grand Total

  • The total Grand Total of all orders that paid by the payment type during the selected report period.

  • Grand Total = Subtotal + Tax - Discount + Shipping.

  • The currency will follow the Base Currency of the magento site.

  • This column is hidden by default.

Subtotal

  • The total Subtotal of all orders that paid by the payment type during the selected report period.

  • The currency will follow the Base Currency of the magento site.

  • This column is hidden by default.

II/ Filter Report Data

On this report, you can filter by the Payment Type (dropdown), Total Paid (from-to), Number of Selling Transactions (from-to), Average Transaction Value (from-to)

...