Reports

Partners accounting

This report will explain you all about the partner bookings, their commission and the payment flow.

Last update [Mar 29, 2023]


Overview

If your business partner also uses a TrekkSoft account to share his activities or resell your activities you can settle your balance through partner accounting.

The Partners accounting shows you how many bookings you made for partners, how much commission you earned and how much money you owe to a partner and the same for the partner as well.

 

SOME IMPORTANT POINTS TO NOTE!

  • The commission is automatically calculated if there is a percentage commission set and if the activities were sold on a net price base then there is no commission but the net price is owed to one another.
  • The difference to the Agent reporting is that in this case, both partners can sell each other activities as with an agent he only can sell your activities, so partner accounting has more data.

 

________________________________________________________________________

Partners Overview

The overview shows all active partners of this year. If a partner didn’t make any bookings or you didn’t sell any of the shared activities the partner will not appear.

 

________________________________________________________________________

Generate Report

By clicking on the Generate report, you'll see a popup window that will allow you to generate a report for a whole month, by selecting a year and a month, a PDF or xlxs with all the receipts for that month will be generated.

 

________________________________________________________________________

Partners Detail View

A click on a partner (Details button) shows you the detail view of that partner where you see the balances for each month. Remember that all commissions or turnovers are shown based on the value date (trip departure date) that is different than on the agent accounting where you only see the commission based on the value date, sales are always based on the booking date.

 

________________________________________________________________________

Partners Monthly View

On the actual monthly view, you can see the summary in the first tab of who sold how much, how much commission is earned and how much money is owed for the guests sold of the partner's activity. Just click on the Details button of the month you want to analyze in detail.

  1.  Summary: On the different tabs you can see the detail information for each sum on the summary page. The main tabs are for the guests and add-ons that you sold for a partner or the partner sold for you (see the screenshot above).
  2. Items by You & Items by Partner (Guests): These 2 tabs group the guests by the ones that have been sold by you and by our partner. All guests that were sold by this partner show up in the second list. The system always assumes that the selling merchant took the payment for this guest so it will sum up the price for all guests and that’s the owed balance for this partner.

  3. Customer Payments to You & Customer Payments to Partner: There are cases where the partner makes the reservation on their account but then the customer pays the partner account directly. As our system doesn’t connect actual guests directly to a payment we cannot settle this easily. That’s why our system shows those payments and links to the basket based on the booking/payment date and not on the booking date. So our system always thinks that the merchant who sold the activity will pay out the partner at the departure date and those direct payments would need to be paid back first. Example: Your partner sells an activity of yours in April to a guest that will depart in May. The customer directly pays the partner and not you. So in the partner accounting, this guest would show up in May including the price and the commission but in the April accounting the customer payment would show up that you would need to pay back to the partner so he can pay you back in May. As our system is built this way that we don’t link payments and guests directly there is no other way for us to show.
  4. Invoicing: The invoice feature on the partner accounting allows each merchant to keep the balance for that partner. Each merchant only can add the invoices for money owed to him and confirm those payments. Example: If Merchant X operated an activity that was sold by Merchant Y then the system would show that Merchant Y owes money to X. So then it’s Merchant X’s responsibility to get that money and send invoices to Y. Our system mimics this in the same way so Merchant X should add the invoiced amount and once the payment was done and arrived on their bank account then they can confirm the payment. TrekkSoft itself does not send out any invoices and checks no balances.

 

________________________________________________________________________

Update March 2023: Some new fields are now added to the report.

  • Net rate: The net rate price the partner will receive (no matter for what is was sold).
  • Commission Rate: To see whether a net rate or a commission (if yes, which one) was used.
  • Commission: Calculation of Sales price - Net rate = What you earned.