NoteThe Sales Report displayed in the merchant panel are limited to 20 thousand rows for both displaying and downloading. If you need display more rows or columns in the report, contact your sales representative.
To have access to this module, you need to have a profile with the Reports > Sales Report permission enabled.
Refer to Profiles and Permissions for more information.
Consult the report
Log into your PayU account. In the left menu, expand the Transactions menu and select Sales Report.
In the report, you can see a filter box, and the list of your latest sales. By default, the report shows the sales information* of the last seven days, from the most recent to the oldest.
*Limited to top 20 thousand records.
The report has the following columns:
|Order||This column shows the identifier of the order along with the date of the sale.|
|Reference||This column shows the sale reference and the name of the product or service offered.|
|Buyer||This column shows the name and the e-mail address of the person who preform the buy.|
|Amount||Amount of the sale.|
|Payment method||Information of the payment method used by the buyer.|
|Status||Current status of the order.|
NoteIf you need to display more information, contact your sales representative.
Refer to Order details to know all the transaction detail of the sale.
Filter the report
You can use the search bar above the graph or the calendar to set filters. You can filter by Reference, Order, Buyer, Amount, status, or Payment method.
To set a filter, click the Filter my sales field at the top of the report table.
Configure the values for the filters and click Search. Once you click it, the filter table shows the sales that meet the selected criteria.
Along with these filters, you can also set a time frame when the buyer performed the purchase using the dates filter at the top right corner.
The date range of this filter is one (1) month before the end date. If you exceed this range, The report displays the information of one (1) month after the start date.
To see the information of a given date, set it for both start and end date.
You can review the transaction detail online. To do this, click the order you want to consult in the report table. The transaction details appears in the right panel.
The Transaction details panel has the following sections:
|1||Order info||This section shows the Order Id, its latest update date, its status along with the status description, and the sale reference.|
|2||Product or service||Description of the product or service you provided in the sale.|
|3||Payment method||Information of the Payment method used in the purchase. The information displayed in this section varies according to the payment method.
For pending cash payments, this section lets you see the payment receipt generated to the buyer.
|4||Values||This section shows the values involved in this transaction such as the Value to charge (or charged), Pending value, Refunded value (for refunds), Expired value (for cash payments).|
|5||Buyer info||Information of the person who performed the purchase.|
|6||Delivery info||Information of the delivery options.|
|7||This purchase had||Transactions associated to this purchase. Click the ▾ symbol to find the transaction history.
|8||Actions||Actions available over the order.|
When you expand the This purchase had section, you can see the details of each transaction associated to an order.
The information available includes the values debited from your account, the payment method, the payer information and more.
Download the report
To download the report, click the Download button located at the top or at the bottom of the report table.
A pop up window appear where you can select the options to generate the report:
- Report: lets you generate a report with the status of the orders and the final status of the last transaction or attempted purchase related to that order.
- Balance from previous secure: lets you generate a report with all the transactions and shows the information of the buyer and payer (e-mail, name, document number)*.
Note* If the file format does not meet the your needs, contact your sales executive to know more about the option to send files through SFTP and the templates that we have for this report.
The report is automatically downloaded in an Excel (.csv) format. The name of the report uses the following formats:
- Report option: [DownloadDateInMillis]_orders_[AccountId].csv
- Balance from previous secure option: [AccountId]_[DownloadDate]_transactions.csv*
* Download date in format dd-mm-yy-hh-mm-ss