Table of Contents
Activating the AirPlus Integration
To begin using the AirPlus integration, follow these steps:
- Click on the AirPlus connector icon to open the menu.
- Select Activate AirPlus Integration to enable it.
Once activated, VAT4U allows you to upload, split, and import AirPlus statement data for VAT recovery.
Uploading Your Statements
The AirPlus statements consists of:
- One Excel file
- One PDF file (corresponding to the Excel data)
Important Requirements for Uploads:
- You can only upload one Excel file and one PDF file at a time.
- The Excel file must contain a sheet named "Rechnungsdaten".
- The sheet must include a column labeled "Ticket No". The Ticket No corresponds to invoices in the PDF file.
Once your files are ready, upload them to VAT4U to start processing your expense data.
Naming and Extracting Data
Each data extraction requires a name. Choose a meaningful name to help you track and manage your extractions easily.
After naming your extraction, start the process:

The system will create a corresponding table, and the status will update as follows:
- Queued – Your upload is waiting to be processed.
- Processing - the extraction is being processed.
- Failed - the extraction failed due to error/s.
- Finished – The data is successfully extracted.

You can refresh the table to see status updates.
Linking Previous Imports
After extraction, you can link previous imports to the current data upload:

This helps maintain a clear record of your data processing.
Downloading and Importing Data
Once the extraction is finished, click on the three dots next to your processed data to access the following options:
✅ Download CSV File
This file is similar to the original Excel file but includes an additional "Document URL" column in VAT4U.
✅ Download Split PDF Files
Instead of the summary PDF, you can download separate individual invoice PDFs.
✅ Import Data into VAT4U
Select Multiple rows forming a single invoice during the import process. Under Help us detect the same invoice with multiple lines, choose "Ticket No" as the identifier:

By following these steps, you can efficiently process and reclaim VAT from your AirPlus statements in VAT4U. You can also deactivate the connection at any time by clicking the “Deactivate” button.