How to find out the number of vouchers sold in one calendar year
After logging in to your Partner Interface, go to the Billing section and open the Overview of promotion payments. In the Summary of payments section, select the option to mark all events, select the period from 1 January to 31 December of the year and click Export.
Once downloaded, an excel spreadsheet will open with a summary of vouchers sold for the selected calendar year.
!The overview also includes sold vouchers that were subsequently cancelled (red colour)!
Use the filter to see the total number of sold (not cancelled) vouchers for each event. In the column (Promotion) set the filter by cell colour – white/no fill and select the desired promotion ID.
Then, in the (Variant) column, you can also select the number of vouchers sold based on each variant of the promotion.
How to find the financial value of vouchers sold in one calendar year
To find the total value of vouchers sold, use the filter to select only uncancelled vouchers (e.g. Total Price column – filter by cell colour – white/no fill) and then add them up. The resulting total represents the value of all vouchers sold in the selected calendar year before deducting our commission.
How to find out the total sales as of 31. 12.
In the excel spreadsheet, use the filter to re-select Uncancelled vouchers and in the column (Date of voucher redemption) select only the cells Without space/text. Then add up all the values in the column (Total price). You will get the sales value for all redeemed vouchers in the year before deducting our commission.
To check the amount of sales received as of 31 December for a given year, open the Billing section in the partner interface and follow the steps below:
Step 1.
In the Billing – Promotion Billing section, add up the amount for all commissions (note the final commission invoices with the provider's special remuneration) and the revenue sent dated from January 11 to December 21 of the calendar year.
Step 2
In the excel spreadsheet, filter out the Vouchers redeemed between 2 January and 20 December of the year and add up their financial value. If the resulting financial value matches the sum of all commissions and sales sent from Step 1, then you have been paid appropriately for all vouchers redeemed in that period.
Step 3
In the excel spreadsheet, see if you have any Vouchers redeemed as of 1 January in the selected calendar year. If not, please skip this step.
If so, download the Billing Statement for the period December 21 – January 1 of that year. If the total matches the resulting financial value for the vouchers redeemed on 1/1 in the excel spreadsheet, then you were paid the correct amount of revenue here as well.
!Here you must only select the amounts for vouchers redeemed on 1. 1.!
The sum of the sales from steps 1 and 3 represents the sales paid for all vouchers redeemed from 1 January to 21 December of the year.
Step 4
Repeat the procedure from the previous step, but download the Statement of Accounts for the period 21 December – 1 January of the following year (e.g. in the case of the 2022 claims survey, download the Statement of Accounts 21 December 2022 – 1 January 2023).
In the excel spreadsheet, select the Redeemed Vouchers from 12/21 to 12/31 and compare the amount obtained again with the sum of the sales sent and the commission credited. Here, be careful not to include vouchers that are redeemed on 1/1 of the following year in the sales and commission.
The resulting amount will be missing from your bank account on 31 December of the selected calendar year due to our billing period settings. This amount will be paid to your bank account on 2 January (or the next working day) of the following year.
In case you register unreceived payments for the calendar year after receiving the sales sent on the 2nd of January in the following year, please do not hesitate to contact us at partneri@slevomat.cz