Use the Spain Invoice Export report to total the tax invoices you issued to each guest, Company and Travel Agent by quarter, with their address and tax number, so you can prepare your Model 347 return in Spain.
Overview
The Spain Invoice Export report lists the tax invoices created on one property in a date range, by the guest, Company or Travel Agent each tax invoice is billed to. For each one it shows the total, the part of the total in each of four quarters, the address and the tax number from the profile. RMS built the report for properties in Spain that prepare the Model 347 return, and it is available to every property.
The Spain Invoice Export report is for accounts staff. Before you start, make sure that:
- Your Security Profile allows Spain Invoice Export under Report Screens > Accounting Reports.
- Each Company and Travel Agent you invoice has a Trading As name, which the report shows as its name (see Which name, address and ID Number appear?).
- Each guest, Company and Travel Agent you invoice has its tax number, such as the Spanish tax identification number (NIF), in the ABN field of its profile.
Please Note! RMS is highly configurable. Some Terminology, User Access & Permissions, Images, Labels, and Functions used in these articles may differ from your setup. For more information, see Understanding RMS Help Centre Articles.
When to use the Spain Invoice Export report
The Spain Invoice Export report suits properties that report their sales to each customer by quarter. Run it for the invoice dates you need to report, for example last calendar year.
- Preparing the Model 347 return - at the start of the year, the accounts team runs the Summary layout for Last Calendar Year and exports it to a spreadsheet.
- Checking a customer's total - the accounts team runs the Detailed layout to see the tax invoices behind one customer's total.
- Completing profiles before filing - the accounts team looks for rows with no name, address or ID Number and completes those profiles before building the report again.
How to access the Spain Invoice Export report
In the side menu of RMS, go to Reports > Accounting > Spain Invoice Export.
Choose the Spain Invoice Export report options
The Spain Invoice Export report options below set the invoice dates and the property the report covers, and choose the Summary or Detailed layout. The Report Options panel has no More Options section.
| Report Option | Type | Default | Description |
|---|---|---|---|
| Invoice Between | Date range | Last Financial Year |
Sets the range of dates the tax invoices were created in. Options:
|
| Property | Dropdown | The first property in the list | Selects the one property whose tax invoices the report lists. Only shown on databases with more than one property. |
| Report By | Dropdown | Summary |
Sets the layout. Options:
|
Please Note! Choose an Invoice Between range of 12 months or less that starts on the first day of a month, such as Last Calendar Year. The report counts its four quarters from that month, and a tax invoice created after the first 12 months counts in Total only. See How Total and the quarters are worked out.
Select Build to run the report. To send the report automatically as a PDF or comma-separated values (CSV) file, select Schedule (see Scheduled Reports).
Tip! Select the star beside Add Report to Favourites Menu to add the Spain Invoice Export report to your Favourites.
What the Spain Invoice Export column headers show
The Spain Invoice Export report shows the property name and the date range at the top, then its rows and a Total row that adds up each amount column. The table below lists the columns from left to right; Account No and Invoice No appear on the Detailed layout only.
| Column | Description | Source / Calculation |
|---|---|---|
| Guest Name/Profile Name | The guest, Company or Travel Agent the tax invoice is billed to. The word Guest follows your property's label for guests. | The Trading As of a Company or Travel Agent, or the guest's name. See Which name, address and ID Number appear? |
| Account No | Detailed only. The account the tax invoice was created on. | The account number. |
| Invoice No | Detailed only. The tax invoice number. | The tax invoice. |
| Total | The amount of the tax invoice (Detailed), or of all the tax invoices billed to the name (Summary). | Charges less credit notes on the tax invoice. See How Total and the quarters are worked out. |
| Quarter1 to Quarter4 | The part of Total from tax invoices created in each three-month block of the date range. | Counted from the first day of the month the date range starts in. See How Total and the quarters are worked out. |
| Address | The first line of the address. | Address on a Company or Travel Agent profile, or Address Line 1 on a guest profile. |
| Zip Code | The postcode. | Post Code on the profile. |
| City | The town or city. | Town on the profile. |
| Country | The country of the address. | The country on the profile. |
| ID Number | The tax number. | ABN on the profile. |
Tip! To work with the Spain Invoice Export report in a spreadsheet, select the download icon above the report and choose CSV (comma delimited). The file has a header row and one line for each row of the report, without the report heading or the Total row.
How the Spain Invoice Export report calculates its figures
The Spain Invoice Export report chooses its tax invoices by the date they were created, names each one by the profile it is billed to, and splits each total into quarters.
Which tax invoices appear on the report?
A tax invoice appears on the Spain Invoice Export report when all of these are true:
- It was created within the Invoice Between dates. The report uses the date the tax invoice was created, not the stay dates: a stay that departed in August 2025 and was invoiced on 21 January 2026 counts in January 2026.
- It is on an account of the selected property.
- It was not cancelled by the last date of the range. A tax invoice cancelled later still appears, so a past period shows its tax invoices as they stood at its end.
- Its total is not zero.
Charges that are not on a tax invoice do not appear. On the Detailed layout, a tax invoice that covers several accounts, such as a grouped invoice on a master reservation, shows one row for each account. If no tax invoice matches, the report shows the column headers and a Total row of 0.00.
Which name, address and ID Number appear?
Each tax invoice records who it is billed to when it is created: the account's Bill To. The Spain Invoice Export report reads that record:
- When the Bill To is a Travel Agent or Wholesaler, the row shows the Travel Agent's Trading As name.
- When the Bill To is a Company, the row shows the Company's Trading As name.
- Otherwise the row shows the guest's name: the surname in capitals, then the given name, for example EXAMPLE Guest.
If a Company or Travel Agent has Send all Accounts Receivable to Head Office ticked on its Accounts Receivable tab, its tax invoices are billed to the head office, so the head office appears on the report (see Company Branches). The report does not use the account's Invoice To.
The name, address and ID Number come from the profile as it is when you build the report, so completing a profile also updates its past tax invoices on the report.
Please Note! A Company or Travel Agent with no Trading As appears on the Spain Invoice Export report with no name, although its address and ID Number still show. Enter a Trading As name on the Company Details tab of the Company, or the Travel Agent tab of the Travel Agent, then build the report again.
How Total and the quarters are worked out
Total on the Spain Invoice Export report is the amount of the tax invoice: the charges on it, less any credit notes. Payments and balance transfers to Accounts Receivable are not counted. On the Summary layout, Total adds up every tax invoice billed to the same guest, Company or Travel Agent, across all their accounts.
The report splits each total into four quarters of three months, counted from the first day of the month the date range starts in, and puts each tax invoice in the quarter it was created in:
- For Last Calendar Year, Quarter1 is January to March and Quarter4 is October to December.
- For a range that starts on 1 October 2025, Quarter1 is October to December 2025 and Quarter2 is January to March 2026.
The four quarters cover 12 months. In a longer date range, a tax invoice created after the first 12 months counts in Total but in none of the quarters, so the quarters no longer add up to Total.
How the rows are sorted
The Detailed layout of the Spain Invoice Export report sorts tax invoices by quarter, then by Account No and Invoice No. The Summary layout lists each name in the order of its first tax invoice, not alphabetically.
Related Reports
Related reports in the Reports > Accounting menu are:
- Invoice List Report - lists tax invoices, including cancelled ones.
- Invoice Audit Report / Credit Note
- Overdue Invoice List Report
- Spain VAT Invoice (Reports > Accounting > Spain VAT Invoice)
Related Articles
- Tax Invoices in RMS
- Fiscalisation module - Fiskaly (Spain Verifactu)
- Fiscal and E-Invoice Compliance by Country
- Travel Agents in RMS
- Configure a Security Profile
Comments
0 comments
Please sign in to leave a comment.