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
  • Reconciling Direct Debits
  • Reconciling TL Pay
  • Parameters for Transactions Report

Was this helpful?

  1. Exporting Data & Reconciliation

Reconciliation Best Practice

A guide to reconciliation in the Travel Ledger Platform

PreviousExporting Data & ReconciliationNextExporting Data from Grid Displays

Last updated 1 year ago

Was this helpful?

The Travel Ledger platform provides support for reconciliation. By using our Task Scheduler (settings>Task Scheduler), you can set up reports to be delivered to you on a regular basis as per your reconciliation schedule.

Two key reports used for reconciliation are the 'Standard Seller Rec Report' (due to be sunset on 31/12/2023 alongside the standard seller upload) which is a txt format file, and the Transactions Report which is the most up to date report and is in CSV format.

Reconciling Direct Debits

For direct debit transactions on PE schemes, we recommend a two part reconciliation. Firstly, reconciling against what the Buyer has accepted and then secondly, when the actual payment has reached your bank. The transactions report can support in both these instances as it updates the transaction and settlement status throughout a cycle.

We suggest to complete final reconciliation on bank as this avoids problems with failed payments.

Reloading transactions may be two tier, you may find at first reconciliation you have Buyers that have either ignored or incorrectly rejected transactions which need to be reloaded for the following week, and then if you have any failed payments at time of bank payment then you would again need to reload any associated transactions.

Reconciling TL Pay

With the fast payment using TL Pay, you will find that a single reconciliation will suffice as the funds will hit your wallet very quickly without a Processing Entity handling and disbursing them in the middle. Again, the Transactions report will support this.

Parameters for Transactions Report

When setting up your Transactions report for reconciliation ( see ) you are able to tailor the report date parameters by 'Last Collection' which is very useful to configure to run on a regular basis after the collection is submitted. Last collection can be selected on the basis of the commit date or the collection start date.

For guidance on configuring your reconciliation reports, please see .

Scheduling Reports in Task Scheduler
Scheduling Reports in Task Scheduler
Click on slide to expand