Find the right report
If you’re not sure what report is the best match for your task, start here.
This article helps you choose between:
- The Period report (PDF), if you want a quick overview with key numbers and less detail.
- The Settlement report in xlsx format, if you want a file you can read, filter, sort, use for detailed investigation, sum values and work in.
- The Settlement report in csv format, if you want to upload the data to another system or process it with automated tools.
To choose between them, start with the task you need to do.
If you need a clear overview of the totals for a period
Use the Period report in PDF.
This is usually the easiest report to read when you want a compact summary for a selected period. Among other things, it shows total captures, refunds, fees and payouts for the selected period, and if you have categories configured, it also breaks the numbers down by those. In addition, it lists totals per day for each sales unit.
It works well when you want to:
- Share a report with an accountant
- Get a quick overview of totals for the period without working in a spreadsheet
If you see that you need more detail, for instance about individual transactions, download the Settlement report.
If you need transaction-level detail
Use the Settlement report in xlsx format. This is the best option if you want to investigate individual payments, refunds, fees, or other entries one by one. To see individual transactions, go to the Details sheet. Each row shows one entry that affected the balance, with columns you can filter, sort, and search in. This works well when you want to:
- Check a specific payment or refund
- Investigate an unexpected entry
- Look up a reference, amount, date, or message
- Work with the data directly in a spreadsheet
If you only need a quick overview first, start in the Summary sheet and then go to Details when you need to look closer.
If you need to identify a payout in your bank account
Start with the Period report if you only need a high-level overview. It can help you identify the payout using the payout reference and bank account.
If you need to understand the payout in more detail, use the Settlement report. Start with the Summary sheet in the xlsx file, as it will often have all the information you need.
Use the Details sheet if you need to dig deeper and see the exact activity that led to the payout.
If you need to see which transactions are in a payout
Use the Settlement report in xlxs format. Note that the new Settlement report does not have payouts “containing” transactions. Instead, it shows a balance that increases as payments come in, and payouts as entries drawn from that balance - a bit like a bank account. To understand the activity behind a payout, go to the Details sheet, find the Payout scheduled row you want, and then look at the rows between it and the previous payout. To quickly find the payout you’re looking for, search for e.g. the payout reference from your bank statement by clicking Edit → Find or Ctrl+F / ⌘+F.
If the payout amount was unexpected
Use the Settlement report in xlsx format. Start with the Summary sheet. It gives you a quick overview of captures, refunds, fees, and payouts for the period. See if the numbers add up and make sense. Look at previous days - there may be a balance carried over from the day before (either positive or negative) that affects the payout amount. Check the Details sheet if you need to look deeper. Find the correct Payout scheduled row, then review the rows above it to see exactly how the balance developed over time. Some common reasons that the payout amount may be different from what you expected are:
- A negative balance due to refunds
- Invoiced top-ups to cover a negative balance
- A change between fees being retained from the balance, and fees being invoiced separately
On that last point: As retained fees draw from the balance, they are represented in the settlement report as separate Fees retained rows, commonly right before a payout. There is no such entry for invoiced fees.
If you didn’t receive a payout
Use the Settlement report in xlsx format. Start with the Summary sheet and check whether there is a payout for the period at all. If you cannot see one, the most common reason is that the balance was negative, for example because refunds, fees, or other entries reduced it. If so, the Remaining balance column should show a negative value. Check the Details sheet to understand exactly what entries led to this balance. If you do see a payout, check the Scheduled payout date. This shows when the payout was expected to reach your account - this is an estimate, not a guarantee.
If you need to see who has paid, and how much
Use the Settlement report in xlsx format - or the portal’s Transactions page. That may be the quickest if you want to find a payment by customer name or amount. If you download a report, select the Personal information checkbox to get Customer name, Customer phone number, and Message columns included in the Details sheet. Note that we only provide this information for MobilePay number sales units. Click Edit → Find or Ctrl+F / ⌘+F to search for a name, message or last digits of a phone number. You can also filter or sort by clicking the little arrow in any column header. For customer privacy, phone numbers only show the country code and last few digits.
If you need to group transactions into categories or types
Use the Settlement report in xlsx format. This is the best option if you want to group transactions for sales insights or post them to different financial accounts. For Open amount sales units with categories enabled, this grouping is filled in automatically in the Category column. If you don’t have categories configured, you can still group transactions manually by using columns such as Booking date, Message and Amount, and adding your own labels in the Category column or in a new helper column. This can still work, but it is more manual and easier to get wrong. If you need to do this often, it is better to use proper Categories if possible. Once you have categorised the transactions in the Details sheet, use Pivot tables to easily compute the totals or statistics you need. Tips: You can use the same method of grouping by category, whether you want to group Amount, Net amount or Fee.
If you need to process the data automatically or import it into another system
Use the Settlement report in csv format. The content is equal to the Details sheet in the xlsx file version. It uses comma as the field separator and dot as the decimal sign. Although we aim to keep the format as consistent as possible, it is a good idea to make parsers and scripts robust to small changes where possible. For example, identify columns by name instead of relying on a fixed column order. If you load the file into an accounting system, check whether you can set up automatic data transfer instead.