The Bulk Deposit Upload feature allows airline users to create multiple deposit transactions at once using a CSV file, avoiding the need to manually create deposits one by one.
This functionality supports:
- Customer deposits
- Agency deposits
- Positive and negative adjustments
Customers Sub-Module
The Upload Deposits option is available only for users with the following permission:
- Allow Deposit Top-Up
The following option will be available:
When opening the upload screen, users can download a CSV template containing the required format.
The template follows the same behavior used in the Fares bulk upload process.
The CSV file for customer deposits must contain the following columns:
| Column | Description |
|---|---|
| ID | Unique ID for each row (ascending) |
| Unique identifier for the customer | |
| Amount | Deposit amount (positive or negative) |
| Currency | Valid airline currency code (e.g: USD) |
| Payment Method | Existing payment method configured in the system (Cash,Bank Transfer, Cheque, Debitcard) |
| Additional Information | Optional free text |
Example
| ID | Amount | Currency | Payment Method | Additional Information | |
|---|---|---|---|---|---|
| 1 | john@email.com | 100 | USD | Cheque | Manual top-up |
| 2 | anna@email.com | -20 | USD | Cash | Deposit adjustment |
To upload a new file, simply drag and drop the CSV file into the upload window or click the window to browse and select the file directly from your computer. Once the file is selected, press the UPLOAD button to begin the process.
Deposit Sub-Module (Agency deposits)
The Upload Deposits option is available only for users with permission to create deposit records in the Deposit sub-module.
The CSV file for agency deposits uses the same format, replacing the customer identifier with Agency Name.
| Column | Description |
|---|---|
| ID | Unique ID for each row (ascending) |
| Agency Name | Unique identifier for the agency |
| Amount | Deposit amount (positive or negative) |
| Currency | Valid airline currency code (e.g: USD) |
| Payment Method | Existing payment method configured in the system (Cash,Bank Transfer, Cheque, Debitcard) |
| Additional Information | Optional free text |
Example
| ID | Agency Name | Amount | Currency | Payment Method | Additional Information |
|---|---|---|---|---|---|
| 1 | Travel World | 500 | USD | Bank Transfer | Initial top-up |
| 2 | Sky Agency | -100 | EUR | Cash | Balance correction |
The upload flow works the same way as the Customer deposit upload process.
Comments