The Payout report

The Payout report in Mews Operations helps properties quickly identify payments that Mews collects from various parties via different channels that land in the property bank account as payouts during a specified period. The report elaborates on the existing Mews Payments balance report focusing more on the bank activity.

The report makes reconciliation more straightforward, focusing on the breakdown between gross, net, and commission and showing all transactions contained in a payout batch. 

Note: A payout batch can contain transactions from multiple days, because:

• preauthorization and charges can occur at different times,
• refunds and chargebacks come in much later; or
• the banks that carry out the collection and authorization can approve the payments at different times.

The Payout report can help a property maintain financial transparency and accountability, manage revenue and expenses accurately, and optimize its financial performance. 

Note: Mews pays out the settled funds as soon as it is possible on the partner banks end. Mews advises you to reconcile based on the amount that comes into the account rather than match the payout date with a specific reservation time and date. 

To view the Payout report in Mews Operations, 

• go to the main menu   Finance > Payout report. 

To print the report:

• Use your browser's built-in print functionality via the browser menu or type Ctrl+P for Windows or Cmd+P for Mac.
  
  

In this article you can learn about:

• Setting the filters in the report
• Exporting the payout report
• Understanding the fields in the report
• Payout overview
• Payouts
• The Payout detail screen

Setting the filters in the report  

To access the filters, click on the right of the screen.

Set the following filters to refine the report according to your needs:

• Start: Select a start date to restrict results to a specific time period.
• End: Select an end date to restrict results to a specific time period.

The default filter covers the past 30 days from the current date. Note: The report displays when the payment provider initiates the payout, not when the payout arrives at your bank.

 

 

Exporting the Payout report

To export the Payout report:

1. Click     to export, then:
   •   Export to Excel: To generate the report in a .XLS format. You can download your exports from the Exports screen.
   •  Schedule recurrent report: To schedule an export of your Payout report. This opens the scheduling side-window.
2. If you click Schedule recurrent report, fill in the following details:
   
   
   
   
   
   • Export name*: Enter the name of your report.
   • Interval*: Click to select the date and time span of data to include in your report.
   • Format*: Click to select the export file format of your report. Click to select Excel (.XLS), CSV, or JSON.
   • Include payout details in the report export: Check box to include payout details in the export.
     
     Note: To find payout details for a transaction in your export, locate the Payout Identifier of the payout you want to see the details for in the Payouts tab.
     
     
     
     Find the payout details matching the payout identifier in the Transactions tab of the export.
     
     
     
     
3. Click Next to continue.
4. In the Schedule tab, fill in the following details:
   • Frequency: Click to select how often you want your report to generate.
   • Start date and time: Enter the date and time you want to generate the first report.
   • Target: Click to select the export target. Note: You can learn more about export targets here.
   • Check the Activate schedule upon creating box to enable the schedule immediately. If you uncheck the box, the report schedule is not immediately enabled. You can enable it at a later time from the report configuration. Note: Learn more about report configuration here.
   • Check the Notify me when export is ready box to receive a notification in Mews Operations when a report is generated.
     
      
5. Click Go back to return to the Export configuration tab or click Export to confirm the creation of your recurring report.

Understanding the fields in the report  

Payout overview  

This section at the top of the screen includes a summary of your payouts for the specified Start and End dates.
 

 

The overview contains the following information:

• Net paid out: The total sum of all net payouts. Note: Mews defines Net as the amount of money remaining after deducting all applicable commissions and fees from the total payout.
• In progress: The total net amount where Mews initiated the payout.
• Paid: The total amount of payouts where Mews transferred the money to the property's account.

 

Payouts  

The Payouts section divides the payouts into the following columns:

• Identifier: The unique alphanumeric code assigned to each transaction.
• Status: The payout status.
• Paid: Mews transfers the money to the property's account.
• In progress: Mews initiates the payout.
• Failed: The payout fails. Note: If the payout fails for technical or financial reasons, Mews adds all contained financial transactions to the next payout batch.
• Net: The total, excluding all commissions for all transactions in the specific payout.
• Commission: The total of all fees applied to the transactions in the specific payout.
• Gross: The total before fee deductions for all transactions in the specific payout.
• Created: The date and time Mews created the payout.
• Estimated arrival: The date Mews estimates to transfer the money to the property's account. Note: Only available if the payment provider shares this.

The Payout detail screen

The Payout detail screen allows you to examine your payouts further. It provides a detailed breakdown of transactions included in each payout batch.

To access the Payout detail screen, click the identifier on the Payouts table.

 

You can learn more about the Payout detail screen here.

 
 

You can learn more about the Mews Payments balance report here.