This article describes the UK Receipt/Refund VAT Report, which exports a list of receipts and refunds with their associated VAT amounts for a selected date range.
Overview
The UK Receipt/Refund VAT Report is designed for UK properties to review VAT collected or refunded on guest transactions.
It exports directly to a CSV file and can be filtered by transaction date, arrival date, transaction type, and whether voided transactions are included.
✎ Please Note: RMS is highly configurable. Some Terminology, User Access & Permissions, Images, Labels, and Functions used in these articles may differ from your setup. CLICK HERE to find out more.
How to access
Go to Reports > Accounting > UK Receipt/Refund VAT Report.
Report options
★ Tip: Report build screens default to a common use configuration, and selections can be made as required.
| Option | Description | Default |
|---|---|---|
| Receipt/Refund Created Between | Filters results to receipts and refunds created within the selected date range. | Yesterday |
| Reservations Arrive Between | When selected, also filters results by the arrival date of the associated reservation. A date range selector becomes available. | Not selected |
| Property | Limits results to the selected property. Shown on multi-property databases only. | All properties |
| Transaction Type | Filters by transaction type. Options are Both, Receipts or Refunds. | Both |
| Show Voided Receipts/Refunds | When selected, includes voided transactions in the results. | Not selected |
Report Columns
This report exports directly to a CSV file. There is no on-screen preview. Select Export to CSV on the parameter form to download the file.
The exported file contains the following columns:
| Column | Description |
|---|---|
| Property | The property name. |
| Receipt/Refund Date | The date the receipt or refund was created. |
| Transaction Type | Whether the transaction is a receipt or refund. |
| Receipt/Refund No | The unique transaction number. |
| Income Source | The charge type the receipt or refund is applied to. |
| Account No | The guest account number associated with the transaction. |
| Res No | The reservation number. |
| Res Status | The status of the reservation at the time of the transaction. |
| Arrive | The arrival date of the reservation. |
| Last Changed Arrive Date | The date the reservation's arrival date was last modified. |
| Depart | The departure date of the reservation. |
| Area | The accommodation area allocated to the reservation. |
| Guest Name | The name of the guest. |
| Payment Type | The payment method used for the transaction. |
| Amount | The receipt or refund amount. |
| VAT % | The VAT percentage applied to the transaction. |
| VAT Amount | The VAT amount included in the transaction. |
Comments
0 comments
Please sign in to leave a comment.