Travel Ledger
  • Welcome to Travel Ledger Help
  • Registering on the Platform
    • Registering as a New Company
    • Two-Factor Authentication (2FA) Setup Guide
    • Registering as a User
    • Updating User Profile
  • Managing Transactions
    • Bookings Organisation and Management
    • Updating Bookings (Accept/Reject)
      • Updating Booking (Accept/Reject) Manually
      • Updating Booking (Accept/Reject) through Buyer Download & Upload File
      • Reviewing Completed Settlements and Remittance Advice
    • Duplication Checks
    • Reviewing Remittances
    • Payment History Page
    • Uploading Bookings
      • Upload Manually
      • Upload by Data Delivery Methods
        • FTP setup guide
      • Reviewing Data Delivery
    • File Formats for Upload
      • Extended File Format (Full Version)
      • Extend File Format (Lite Version)
    • Seller returns file (Rec)
    • Scheduling payments
  • Exporting Data & Reconciliation
    • Reconciliation Best Practice
    • Exporting Data from Grid Displays
    • Scheduling Reports in Task Scheduler
  • Notifications
    • Notifications Overview
    • Configuring Notifications
  • Managing your Partners
    • Company List
    • Invite Partners to the Platform
      • Sending Individual Partner Invites
      • Sending Bulk Partner Invites
    • Commercial Link Creation
      • Payments Overview
        • Payment Profiles
        • Business Terms
        • Settlement Schedules
    • Managing Commercial Links
  • TL Pay Account
    • Registration Process - Revolut Grow
    • Registration Process - Nium/Clearbank
      • UK Application (KYB/KYC)
      • EU Application (KYC/KYB)
      • Step-by-Step Guide: KYB/KYC Form Completion
    • Funding your TL Pay Account
    • Commercial Links required
    • Settling via your TL Pay Account
    • Viewing TL PAY Activity
    • Withdrawals
    • Suppliers not cutover to TL PAY
  • Billing
  • Managing your Companies and Users
    • Managing your Companies
    • Suspending and Archiving Head Office and Branches
    • User Creation
    • User Management
  • Processing Entity Schemes
    • Refunds on the ABTA Scheme
  • Help and Support
    • Public Holiday Schedules
    • FAQs
      • FAQs - General Platform Queries
      • FAQs - Registration and Initial Set Up
      • FAQs - Transactions Area
      • FAQs - Uploading Files
      • FAQs - Payments and Commercial Links
      • FAQs - Admin
    • Glossary of Terms
    • Glossary of Notifications
    • Testing with Travel Ledger
    • Release Notes
      • Release 1.26.0 (12/10/2023)
        • Release 1.26.1 (19/10/2023)
        • Release 1.26.2 (26/10/2023)
          • Release 1.26.3 (03/11/2023)
          • Release 1.26.4(18/11/2023)
      • Release 1.25.0 (31/08/2023)
      • Release 1.24.0 (27/07/2023)
      • Release 1.23.0 (06/07/2023)
      • Release 1.22.0 (28/06/2023)
      • Release 1.21.0 (08/06/2023)
      • Release 1.20.0 (25/05/2023)
      • Release 1.19.0 (11/05/2023)
      • Release 1.18.0 (13/04/2023)
      • Release 1.17.0 (23/03/2023)
      • Release 1.16.0 (09/03/2023)
      • Release 1.15.0 (23/02/2023)
      • Release 1.14.0 (09/02/2023)
      • Release 1.13.0 (16/11/2022)
      • Release 1.12.0 (07/09/2022)
      • Release 1.11.0 (25/07/2022)
      • Release 1.10.0 (02/05/2022)
      • Release 1.9.0 (17/03/2022)
      • Release 1.8.0 (02/03/2022)
      • Release 1.7.0 (27/01/2022)
      • Release 1.6.0 (09/12/2021)
      • Release 1.5.0 (29/10/2021)
      • Release 1.4.0 (07/10/2021)
      • Release 1.3.0 (04/10/2021)
      • Known Issues
    • Still Need Help?
Powered by GitBook
On this page
  • Locating the File Upload Area
  • Auto Commiting Files
  • Manual Submission of Bookings
  • Validating Errors
  • Columns Available in the Upload Grid

Was this helpful?

  1. Managing Transactions
  2. Uploading Bookings

Upload Manually

How to upload files manually.

PreviousUploading BookingsNextUpload by Data Delivery Methods

Last updated 1 year ago

Was this helpful?

Locating the File Upload Area

Files can be uploaded manually by navigating to Transactions>File Uploads and clicking on 'Upload File'. You can then drag and drop the file into the box area, or click inside it to select and upload from your computer:

Auto Commiting Files

There is an option to Auto commit uploaded invoices, by selecting this toggle in advance of loading a file, the bookings will be automatically submitted to the Buyer for review, provided there is no error in the file:

Manual Submission of Bookings

If Auto commit uploaded invoices has not been selected, once the transactions upload is complete they are displayed in the grid on the upload page. You can commit them to the Buyer by using the 'select all function' and then clicking the commit button on the bottom left:

Once you have selected 'commit' the transactions are then available in the bookings grid for review by both the Buyer and Seller.

Validating Errors

Transactions may be flagged in the Upload grid, requiring action before they can be committed. This is a validation step in which any missing or incorrect fields such as Partner name or Commercial link name can be manually updated before the transactions are submitted to the buyer.

You can apply a filter to view the transactions with warnings only.

Transactions with a 'Pending' Commercial Link Status

If a file is uploaded with records that have Commercial Links on 'pending' status, the Seller will be notified with a yellow warning tag with a hover over message detailing the CL status. The CL description field will also be highlighted. It is important to note that these records can be committed to the Buyer for review, however unless the CL is changed to 'Live' status by the CL owner prior to the end of the Buyer review period the transaction will be voided at cycle start. Sellers using automated file submission (FTP and email delivery methods) will receive email notification of the CL status.

Columns Available in the Upload Grid

Below is an overview of the Upload grid, with each column header, and a description of the content. As with other grids, you can use the 'columns' button to add and remove columns you find useful or not.

Column

Description

Checkbox selector

Gives the ability to select single or multiple records. Note - when the status is 'not Matched' the checkbox selector can be ticked, however a=items with this status cannot be committed.

Partner name

Buyer Name – pulled from Seller Invoice File through the ABTA number. Can be empty and edited by the user

Partner ID Type

The ID Type associated with the Buyer (ABTA, IATA, TIDS)

Partner ID

The ID associated with the Buyer

Booking Ref

Transaction Reference – pulled from the Seller Invoice file – non-editable

Lead Name

Lead passenger name – pulled from the Seller Invoice file – non-editable

Dep date

Booking departure date – pulled from the Seller Invoice file – non-editable

Due

Transaction payment due date – matches the transaction upload date.

Amount

Amount due for the transaction – pulled from the transaction amount field of the Seller Invoice file - non-editable

CL Description

This will be the commercial link between the seller and the buyer, based on ABTA IDs in the file

Status

Transaction status.

Matched – Partner Name and CL Description matching values in the database.

Not Matched (see Description column for details)

Description

Error description when the status is not matched.

Once you select 'upload' you will receive an on screen notification that your file upload is in progress. For smaller files, you may find that once you close the notification box that your transactions are ready to review. For larger files, you can view the progress of your file submission immediately in . An email notification summarising the upload is sent upon completion of the load. These are configurable under the page.

The status column will show whether transactions match, or not. If there is no match then details of the issue will be shown in the Description column and the fields with missing data will be underlined in red. A warning exclamation mark and underlining will be used to highlight a possible .

Settings>Data Delivery
Notifications Settings
duplicate booking