How to track your fees with the Payment report export in Mews Operations

The Payment report export in Mews Operations shows the fees that Mews Payments charges for each card payment, including interchange, scheme fees and commission. The export is for property owners, managers and accountants who reconcile payment costs. You use the export after payments settle, because Stripe sends the actual fees three days after the payment is taken. You find the report in Mews Operations under the main menu > Finance > Payment report. Fee details are only available in the export, not on the report screen, and commission adjustments apply only to Stripe accounts and only to Visa and Mastercard payments. With the export you can see your exact processing cost per payment, understand what drives your network fees and reconcile commission adjustments with your accounting integration.

 

 

 

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 Operations 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 Single Euro Payments Area, or SEPA, Direct Debit, Mews Operations 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 Mews Operations, go to the main menu > Finance > Payment report.

  2. Select the date range you want to check your fees for.

  3. Click Export > Export. Note: Information about your fees is only available in the export of the Payment report.

The Payment report export displays the following columns:

Export columnDescription
Issuing country codeThe country issuing the payment card.
Issuing bankThe bank issuing the payment card.
Funding sourceThe type of card funding, for example credit, debit, or prepaid, that card schemes like Visa and Mastercard use to determine fees.
Scheme feeUnregulated fees that card schemes such as Visa and Mastercard define and charge.
InterchangeA 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.
CommissionThe commission agreed upon with Mews and outlined in your contract, per card type.
Commission adjustmentThe difference between the estimated and the real, that is, adjusted fee, visible in the Mews Payments balance report as Commission adjustment.
Adjusted total fee netThe total amount that was settled after Mews received new values from Stripe, that is, the sum of interchange, scheme, and commission.
Adjusted tax valueIf the account needs to pay taxes on payments, this column shows the value. Otherwise, this column shows a "0".
Adjusted total feeEqual 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 to send Mews 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, Mews Operations 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 the balance is positive.

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

  • Daily: The first commission adjustment, that is, 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 > Finance > Mews Payments balance. The main menu is the icon at the top left of the screen.

  2. Select 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 the amount is 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 cannot match the fees with the real charged fees presented in the Adjusted total fee net column. This is because:

  • Accounting integrations pull information the day after the payment, but

  • Mews updates that payment three days later, once Mews 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 in Mews Operations in The Payment report.

 

Was this article helpful?
01



Feedback