Help Centre

Report filters - Bulk commission payments

Updated on

This article explains the options and filters found under Agency > Commisssion statement > tab Bulk Payments.

The dates selected here determine the payment entries that will be taken into account by the system when calculating the outstanding payment to the owner and the commission due.

A) After all filters have been selected / deselected as required, click Filter to update the figures shown.

B)  If you have a long list of owners, you can use this search box to look for a specific one.
You only need to type the surname and the system will filter the respective owner automatically from the list.
When you want to see all owners again, you need to delete any entries from the search box.

These are the filters available for the bulk payments. There are two distingued sections:
1. Filters for table
2. Filters for PDF

Bulk commission payments : SuperControl - Google Chrome
1. Filters for table

This section is used to change the (financial) information shown on the page directly.
The system will show entries for which any of filters are applicable.

Example:
When Show cancelled and Show provisional are selected, all cancelled, all provisional AND all cancelled provisional bookings are used to calculated the payments due

Without any of the filters selected the table looks as shown in the screenshot below.

1.1. Show cancelled

With the Show cancelled filter selected the previous amount of £2396.70 has increased to £3094.46.
It is therefore import to make sure the filters are ticked as applicable.
If you are not paying owners for cancelled bookings, this option can be used to check, if any payments entries are still live in any bookings.

1.2. Show provisional

Selecting both the below options, increases the amount due to £3895.46.
This means there is a number of bookings still resumed as being provisional in the system, which should be checked.

1.3. Include brought forward total

If there is any monies that have not yet been paid to the owner and show in the statement as Balance brought forward, you can include these payments in the amount shown due for the owner.

The amount due has increased to £4053.72, showing that there is an amount brought forward.

2. Filters for PDF
2.1. PDF Column settings

These column settings are not only influence what is showing in the generated PDF files, but also what the owner will see in the owner login when looking at the Payment & Statement tabs.

By default all the columns in the list are showing.
Any option that is being ticked is then being hidden from view.
It is possible to tick/untick any combination of boxes.

To preview the PDF that will be created before sending it to the owner click the cog to the right of the owner and then select Preview PDF.

Bulk commission payments : SuperControl - Google Chrome

When all the boxes are ticked the information showing is minimal.

When deselecting all boxes again the PDF is showing all the information you would expect to see (screenshot below).

If no payments are ticked in the individual owner statement, nothing will be showing in the PDF.

Regardless, if there are payment entries in the statement.

2.2. Hide brough forward total

Depending on the dates selected, there might be a balance showing as being brought forward.

When this option is ticked, the balance brought forward will not be showing in the PDF.

2.3. Don't show, if customer hasn't paid

Without this filter having been ticked, the owner is due £2992.72.

There are eight payment entries in the statement.

With the filter selected on the other hand, the owner is due only £1201.72, nearly £1800 less.

In the statement are now only six entries showing.

Please note:
Make sure, you do only pay your owner the money that the guests have actually paid.
Without this filter ticked you might include bookings that have any income against them. In which case you would be paying the owner money they are not due out of your own pocket.

2.4. Show date booking placed

Please note:
This option has been flagged to the developers as there seem to be an issue with it.
At the moment nothing will change in the PDF, when you select it.

2.5. Show running balance

The column Balance is showing, regardless, if this option has been selected.
Though with the option ticked, the column shows the relevant figures.

The running balance will be showing in the PDF, even when this filter has not been selected for the individual owner statement.

2.6. Separate expense column

Please note:
In order for expenses to the owner entries to show in a separate column, as well as the commission and VAT associated with expenses, in the PDF, it is necessary to have this option selected in the individual statement as well as under the PDF filter options in the bulk payment tab.

Option the needs to be selected in the owner's individual statement:

Screenshot below:
Expenses are not shown separately.

Screenshot below:
Expenses are shown separately.

2.7.

If you are working with the Held on account feature, you can show how much is being currently held by selecting this option.
A further column will be showing to the very right of the page, like it does in the individual statement.

Previous Article Reporting settings - Commission statement
Next Article How do I hold back some of the refundable deposit and pay this to the owner?