With the introduction of the Payment Directive PSD2 in October 2019, a small adjustment was made to your monthly detailed Excel invoice to help you match your bookings to your payouts.
1. General Information
1.1. Checking Your Payments During the Month
- Go to Statistics > Statistics Export
- Click Columns
- Tick the boxes Reseller Payout and Reseller Payout Date
You'll get information about the amount of the payment and when it was received.
1.2. Invoice Schedule
While payments are now received weekly, the written invoice is still issued once a month — on the 5th working day, and no later than the 7th day of each month.
1.3. Invoice Reference Date
Your monthly invoice groups bookings by the Booking Date. This is not shown on the invoice itself, but can be extracted from Dashboard > Statistics using the Booking Number as the reference, for example with the VLOOKUP formula.
This is the only basis that reproduces the invoice total, so grouping your own export by any other date will not match.
| Grouping basis | Result |
|---|---|
| Booking Date | Matches the invoice total. This is the period the commission applies to. |
| Payout Sent Date | Does not match the invoice total. Funds are released within a few days after a sale, so bookings near a month-end shift into the following period. |
| Effective Payout / Bank-Receipt | Does not match the invoice total. It groups by the date cash reached your bank rather than by booking, so it never reconciles. |
Note: To reconcile your invoice, always group your bookings by the Booking Date. Small timing differences between the Booking Date and the Payout Date are expected from one month to the next and even out across consecutive invoices.
2. Invoice Structure
Your Monthly Detailed Invoice is a single Excel file with two parts:
- Booking lines — one row per ticket for all bookings created in your account during the calendar month (still active or already cancelled), with the payout status shown for each. Bookings are grouped by source, transaction direction and transaction type.
- Payout overview — a summary block at the bottom of the file listing your payouts: transfers already made, payments scheduled for the near future, and any manually added payments.
2.1. Booking Source
| Source | Explanation |
|---|---|
| POS | Point of sale — bookings made via your Regiondo dashboard or Touch POS. |
| Ticketshop | Bookings made via the integrations on your website. |
| Distribution Channels | Bookings made via a channel, e.g., GetYourGuide, Viator, etc. |
2.2. Transaction Direction
| Direction | Explanation |
|---|---|
| Credit memos | All new ticket bookings that haven't been cancelled. Payout amount may be positive or negative depending on payment method. |
| Cancelled tickets | All cancelled ticket bookings. If the payment was processed by Regiondo, this usually means the ticket price is deducted to refund the customer directly. |
2.3. Transaction type
| Transaction type | Explanation |
|---|---|
| Bookings with online payment | New bookings paid via Regiondo. |
| Bookings with own online payment | New bookings paid via your own PayPal account. |
| Bookings with offline payment | New bookings paid via invoice, cash, or any other method used at your cash desk (e.g., EC, cheque). |
| Reimbursement method: Cash flow | Cancelled bookings with a money transaction. If the booking was already paid out to you, Regiondo deducts the amount and transfers it to the customer. |
| Refund method: Value voucher | Cancelled bookings refunded as a value voucher instead of a cash refund. |
Note:
- PayPal is treated as an offline payment method, as it isn't processed through Stripe — only a commission is taken. It should still appear as a payment method on your own sales invoices.
- In case of refunds, it may look like additional provisions are owed to Regiondo. This isn't the case — provisions are calculated at the time of booking, not cancellation. This can occur when the original booking and cancellation happen in the same month, in which case the original provisions appear under cancellations. The refund line itself carries no commission: the fees already charged on the original sale are simply kept, and nothing is recalculated on the cancellation.
3. Booking Line Columns
Each line in your detailed Excel invoice corresponds to one ticket. The columns are:
| Column | Explanation |
|---|---|
| Ticket | The name of the booked ticket/product |
| Ticket Code | The unique code identifying the ticket |
| Booking Number | The reference number of the booking the ticket belongs to |
| Quantity_Bill | The number of tickets billed on this line |
| Turnover (net) | The amount you keep from the sale, after all deductions |
| Turnover (gross) | The full selling price, before any deductions |
| Ticket fees EUR/GBP | The ticketing fee charged per ticket, as per your contract |
| System commission % | The commission rate applied to the booking, as per your contract |
| System commission EUR/GBP | The commission amount in Euros/Pounds |
| Payment fee % | The payment-handling rate, applied only where Regiondo processed the payment, as per your contract |
| Payment fee EUR/GBP | The payment-handling amount in Euros/Pounds |
| x % VAT of Commission EUR/GBP | VAT charged on the commission. Applies only to operators without a valid VAT number registered in VIES; the rate depends on the operator's country. |
| Creditmemo EUR/GBP | The total amount Regiondo retains on the ticket |
4. Payout
Two columns in your detailed monthly Excel invoice help you match your weekly payouts to incoming bookings: Payout status and Payout date.
4.1. Payout status
| Status | Explanation |
|---|---|
| Paid | The payment has already been paid out to you. |
| Scheduled for payout | The payment will be paid out with one of the upcoming transfers, and the date has already been set. |
| Pending | The payment was successfully captured from the customer and will be paid out later. |
| Reconciliation | In rare cases, a payment may be manually transferred to your account. |
4.2. Payout date
Shows the date the payment was, or will be, paid out to you. An empty field means the payment was made recently and hasn't yet been prepared for payout.
4.3. Payout overview
Your detailed Excel invoice also includes an overview of all your payouts — transfers already made, payments scheduled for the near future, and any manually added payments.
| Column | Explanation |
|---|---|
| Payout status | Same values as above: Paid, Scheduled for payout, Reconciliation. |
| Payout amount | The amount paid to you by bank transfer. |
| Amount in this bill | The amount from this invoice included in the corresponding disbursement. |
| Payout date | The date the amount was transferred to you. |
Note: Because Stripe payouts are made weekly while the Regiondo invoice is issued monthly, a month may start or end in the middle of a payout week, so the booking month and payout month may differ. If the Payout amount and Amount in this bill columns don't match, check the previous or following invoice for details.
5. Open Amount
5.1. Reading the Open Amount
The Open Amount refers to the amount recorded in Stripe but not yet scheduled for a payout.
| Value | Explanation |
|---|---|
| Zero | Everything has been paid out or already scheduled for payout. |
| Positive | An amount was recorded in Stripe but not yet scheduled for payout — it will be included in the next payout. |
| Negative | There is a negative balance on your Stripe account, and this amount is owed to us. |
Notes:
- The system is currently set to automatically deduct the negative amount from the next incoming payments, so no manual transfer is needed — unless you know there will be no future online payments. In that case, transfer the amount due to our bank account using the details in the footer, and include the invoice number.
- Negative monthly invoices are marked as paid internally by our Accounting team once processed. This status is not visible on your end, and the Stripe balance may not always be reconciled on the exact day the transfer is received, due to the payment flow and other internal accounting processes. All invoices can be found in your Dashboard > Settings > Bills. The status shown there will not change to reflect this internal accounting process.
- If you'd like to confirm whether we've received your transfer, contact our Support Team. They will create a ticket for our Accounting department, who will verify the payment and provide you with an update.
- You may occasionally see a difference of a few cents. This is because Regiondo rounds to 4 decimal places while Stripe rounds to 2. This calculation method will be unified in the future.
5.2. Fees on Payments You Collect Yourself
- When you collect the payment yourself (your own PayPal, or any offline method), Regiondo never receives the money, so the ticketing fee and commission are taken from your Stripe balance instead. In your export these appear as negative transfer lines.
- The minus sign means money leaving your balance — it is a fee you owe, not a reduction in commission. When reconciling, these amounts are added to your commission total, not subtracted.
Note: The most common reconciliation error is subtracting these lines instead of adding them, which doubles the apparent difference. Treat every negative transfer line as a fee owed and add it to the total.