Track your fees with the Payment report export



Transparent reporting is currently available for Stripe accounts that process:

  • AUD
  • CAD
  • CHF
  • CZK
  • DKK
  • EUR
  • GBP
  • HUF
  • NOK
  • PZL
  • SEK
  • USD

With transparent reporting, your interchange and scheme fees are now totally visible in your reports. You can view a breakdown of your fees per payment, with information about each payment card, so you can:

  • View your exact payment processing cost, by fee type.
  • Gain more insight into the cost drivers of your network fees.
  • Track how your fees accumulate.
  • View the exact fees associated with the processing of virtual credit cards.

Note:

  • Mews displays the associated invoice or bill number in both the Invoice payments tab and the Card payments tab of the report export.
  • If the customer pays by SEPA Direct Debit, Mews displays the associated invoice or bill number in the Alternative payments tab of the report export


In this article you can learn about:

 

Tracking your fees with the Payment report

To track your fees and see a breakdown:

  1. In the Mews Dashboard, click Payment report.
  2. Choose the date range you want to check your fees for.
  3. Click Export > ExportNote: Information about your fees is only available in the export of the Payment report.

The report displays the following columns:

Export column

Description

Issuing country code

The country issuing the payment card.

Issuing bank

The bank issuing the payment card.

Funding source

The type of card funding, for example credit, debit, or prepaid, that card schemes like Visa and Mastercard use to determine fees.

Scheme fee

Unregulated fees that card schemes such as Visa and Mastercard define and charge.

Interchange

A fee that card schemes, for example, Visa and Mastercard define, and are paid to issuing banks. Interchange fees vary depending on the country, and change a few times per year. Check out the current interchange fees for Visa and Mastercard.

Commission

The commission agreed upon with Mews and outlined in your contract, per card type.

Commission adjustment

The difference between the estimated and the real, i.e., adjusted fee, visible in the Mews Payments balance report as Commission adjustment.

Adjusted total fee net

The total amount that was settled after we received new values from Stripe, i.e., the sum of interchange, scheme, and commission.

Adjusted tax value

If the account needs to pay taxes on payments, the value is shown here. Otherwise, the display shows a "0".

Adjusted total fee

Equal to the sum of the adjusted total fee and the adjusted tax value.


The scheme fee, interchange and commission columns remain blank until three days after the payment is taken, this is how long it takes for Stripe send us the actual fees.

 

Real-time commission adjustments

Mews estimates the amount of commission you need to pay based on the previous month. Once Mews receives the actual fees from Stripe, the system automatically adds them to the Payment report export and they are adjusted in the Mews Payments balance report.

You can track these commission adjustments in the Mews Payments balance report. 

Note: Commission adjustments only apply for Stripe accounts, and only for Visa and MasterCard payments. If your property has a negative account balance, commission adjustments may not go through until it is positive.

Stripe can make a small end-of-month fee adjustment, along with the daily adjustments. Therefore,  

  • Daily: The first commission adjustment, i.e., the difference between the estimated cost of interchange and scheme fee is reported usually three days after the transaction day. These fees are assessed daily, and processed in daily batches.
  • End-of month: Stripe might also make an additional adjustment for the previous month, at the beginning of a month, most likely on the fourth day of the month.

 

Tracking commission adjustments

To view the adjustments Mews makes to your fees:

  1. In Mews Operations, go to the main menu Screenshot_2.png > Finance > Mews Payments balance.
  2. Choose the date range you want to see your commission adjustments for.
  3. Under Type, deselect all except Commission adjustment.
  4. Click View report.
  • If the amount the Mews Payments balance report lists next to Commission adjustment is negative, Mews has charged extra, because the Mews estimate was too low. 
  • If it's positive Mews has returned money to you, because the estimate was too high.

Commission adjustments are also visible on your Mews invoice.
  

Commission adjustments and accounting integrations

If you use an accounting integration, the fees match the ones in the Payment report but only with the Fee total net or Fee total column, as an accounting integration pulls estimated fees.

You probably won't be able to match it with the real charged fees presented in the Adjusted total fee net. This is because:

  • Accounting integrations pull information the day after the payment, but
  • Mews updates that payment three days later, once it actually receives the actual fees.
To check that the numbers match between the Payment report and your accounting software, schedule a daily export of the Payment report at the same time your accounting software pulls data. 

You can learn more about the Payment report here

 
Was this article helpful?
01



Feedback