Settlement Reports on Dashboard

Merchants can view and download Settlement Reports using P4B, UMP, Email and schedule the reports using SFTP.

Highlights:

• Availability on same day / real-time 
• Customization 
• Standardized channel support - SFTP, Email, Dashboard 
• Aggregation of Reports
• Historical Reports
• Auto-scheduling reports to Email and SFTP

View Reports

1. Log in to the Paytm Merchant Dashboard.
2. Click on Settlements.
3. The Settlements Overview section provides a summary of all completed settlements with details of Settlement Amount, Total payments, along with Total Deductions for the selected date range. You can even download the Daily / Weekly / Monthly / Yearly payment and settlement reports.

    

   

4. You can view the detailed settlement records. The Settlement Records section displays the vital elements such as Date, UTR number, Payment Amount, Commission, GST, Net Settled Amount, Settlement Status, etc. 

Download Reports

1. Login to the Paytm Merchant Dashboard.
2. Go to Report & Invoices on the left side and click on Reports.

    

   

3. Choose the report that you want to download:- 
   • Payments Report for transaction-level data
   • Settlement Report for transaction-wise settlement 
   • Historical settlement report for up to 24 Months (1 year tenure at a time) 
   • Refund report for transaction-level refund data 
   • Balance statement for Business wallet merchant's settlement data 
   • Ledger Report for day level settlement summary 

Report Customization

Settlement Reports can be customized as per the specific needs and preferences of the merchant. The reports provide detailed information about the selected columns only. For example, settlement details of transactions, fees, and other financial aspects of their business. 

Here's what a customized merchant settlement report typically includes:-

• Renaming of columns 
• Reordering of columns
• Selecting / deselecting of columns 

Steps to customize the report :

1. Login UMP Dashboard panel. 
2. Go to Report & invoice (Left side of page).
3. Click on Reports > Settlement Report. 

    

   
4. Click on the Select Download Fields tab on the right side.
5. Choose the columns that you want to populate in the MSR report and click on Continue.

    

   

6. You can rename and reorder column names if required.

    

   

 Note:

1. The customization configuration created using this process will impact the reports being automated to the merchant's SFTP and email as well since the configuration is applied to all reports. If a merchant wants to avail a customized report on his SFTP and Email, they can be directed towards this flow to get their reports customized.
2. The list for customization of columns is mapped at UMP and will need separate development effort from the UMP end to get it added to the Customisation screen post addition to the Settlement Report. 

Report Scheduling 

Paytm has DIY support on the UMP Dashboard Panel that allows you to update additional email ID and SFTP details to schedule an automated report.

Steps to schedule reports:

1. Under the Settlements tab, go to the Reports section and select SFTP Details (of the admin user).

    

   

2. Upload the SFTP details on the right pop-up window, and select Apply for each MID individually.

    

   

     Note: Reports should be scheduled to the SFTP Details entered by the merchant, post whitelisting of the Paytm IPs.

    

   

Steps to add additional Email ID:

1. Login UMP Dashboard panel.
2. Go to Report & invoice on the left side.
3. Click on Reports> Settlement Report. 

    

   
4. Click on Send to Email section. 
5. Fill in the email IDs. Choose to save for the future.
6. Click on Share Report. 

    

   

Seamless Reconciliation

Reconciliation is the process of matching the amount received for successful transactions vs. total amount received by banks posts deductions. The total success transactions of merchants are checked and the corresponding amount is settled. (After factoring adjustment for MDR, Refunds, Repayments, subscriptions, and Chargeback).

Reconciliation and reporting-based product details are available in the UMP Reporting Section. 

Deep diving in MSR

A typical Merchant Settlement Report will look like below, with each transaction listed in order.

Column Details:

 
Order/ Transaction Type Details: