We’ve upgraded the ‘Search Customer Payments’ report to make reconciling HolidayRentPayment (HRP) payments easier.
Within your SuperControl account head to Bookings> Charts & Reports> Search Customer payments.
This new report gives you the benefit of new filters including:
Batch and Transaction ID search, making it quicker to identify and match payments. The Batch ID & Transaction ID's are reference numbers allocated to each payment by HolidayRentPayment. You will find these references on your bank statement attached to pay-outs and also on HRP pay-out notifications that are e-mailed to you when they release funds.
New Settlement status filters, enabling you to easily identify cleared HRP pay-outs or pending pay-outs. A payment is classified as "Settled" as soon as HRP clear/release the funds to your bank. The time it takes to physically reach your bank can vary depending on your bank provider however its usually between 1-2 days.
We’ve also added new report columns including:
- Transaction ID - Transaction reference number for each singular guest payment
- HRP settlement date - The date that HRP clears/releases funds to your bank
- HRP Fee amount - The total monetary value of the payment processing fee charged by HRP per transaction
- HRP Batch ID - HRP Pay-out reference number. This can be the same for multiple payments if all sent within one batch pay-out.
- HRP settlement amount - The total monetary value per transaction that should match the the pay-out from HRP, this is excluding HRP payment processing fee's as HRP take their fee before sending you the money per transaction.
- Batch total - The total monetary value per pay-out. This can include multiple payments in one batch, if so then it adds all payments in the batch up and therefore gives you the total.
- Grouped batch reconciliation feature -If a batch is made up of more than one payment our reconciliation feature will capture all payments associated with that batch and enable you to reconcile them all in one click.
- Pending settlement Identifier - If a payment is pending settlement i.e waiting for HRP to release the funds to you, you will find our settlement icon identifier.
Xero and Sage exports now include net settlement values and optional HRP fee itemisation, ensuring your exports match your bank deposits perfectly, no more mismatched figures or manual adjustments.
To see these updates within your SuperControl account go to Integrations> Accountancy software export.
Select your accounting software:
We have added a new field, highlighted above, Default code for HRP fee's. This gives you the option to now itemise HRP fee's separately and export them into your accounting software.
Here is an example of what that looks like on the report export:
Each HRP processed payment made by the guest will show a new line on the report specifically itemising the Fee total. This is a minus figure that will export together with the payment it is associated with so the total equals the amount in your bank.
For example:
Guest balance payment = £500
HRP fee (1%) = -£5
Exported amount total = £495
You simply just dont enter a value into the field below when exporting to your account software:
What if I don't wish to itemise fee's I just want to export the Net Settlement amount?
If you leave this field empty and click "Export to Xero" or "Export to Sage" you will see a new toggle at the top of the report:
Switching the toggle "ON" will show the Net settlement amount per guest payment, which is the total the guest paid minus the HRP processing fee. Exporting this value will match the value in your bank/accounting software.