Financial Platform

Complete Financial Control for Tour Operators

AR
Accounts Receivable
AP
Accounts Payable
GL
Accounting Integration
BI
Reporting & Analytics

Contents

A comprehensive overview of Kaptio's financial platform capabilities

01

Overview

Why financial clarity matters for tour operators

02

Financial Data Model

How financial objects connect to bookings

03

Accounts Receivable

Customer payments, schedules, and receipts

04

Accounts Payable

Supplier payments, agreements, and invoices

05

Automation

Invoice generation, payment files, and remittances

06

Reporting & BI

Standard reports, custom reports, and analytics

07

Reconciliation

Cost matching, variance analysis, and margins

08

Accounting Integration

GL export and system integration patterns

This showcase links to detailed outcome documentation for implementation guidance. See the Resources section for links to adoption guides and configuration details.

01 / Overview

Financial Clarity for Tour Operators

Tour operators face unique financial challenges—complex multi-currency bookings, supplier deposits and billbacks, payment schedules tied to travel dates, and the need to track margins across thousands of departures.

Common Challenges

  • Manual invoice processing creates errors and delays
  • Disconnected systems for booking and finance
  • Limited visibility into true booking margins
  • Complex supplier payment terms and timing
  • Multi-currency reconciliation headaches

Kaptio Solutions

  • Automatic invoice line generation from agreements
  • Single source of truth—finance linked to bookings
  • Real-time margin analysis by package and departure
  • Configurable payment rules and schedules
  • Multi-currency with FX tracking

Key Capabilities

Accounts Receivable

Payment schedules, gateway integration, customer receipts, and refund management

Accounts Payable

Supplier agreements, payment rules, automatic invoice lines, and AP exports

Automation

Invoice processing, payment files, supplier remittances, and workflow triggers

Reporting & BI

Standard reports, custom dashboards, and integration with BI tools

Reconciliation

Cost matching, variance analysis, margin tracking, and accrual management

Accounting Integration

GL exports for Sage, Dynamics, Oracle, QuickBooks, Xero, and custom systems

Single Source of Truth

Every financial transaction in Kaptio links directly to the booking. AR, AP, and reconciliation all trace back to itineraries, items, and services. No more reconciling between disconnected systems—your financial data lives where your operational data lives.

02 / Financial Data Model

How Financial Objects Connect

Every financial record traces back to the booking. This unified model enables accurate reporting, reconciliation, and margin analysis.

Central Object
Itinerary (Booking)
Payment Schedules
What customer owes and when
Transactions
Actual customer payments received
Supplier Invoice Lines
Expected costs from agreements
Supplier Invoices
Actual supplier bills received
Sales Invoices
What we invoice the customer
Sales Invoice Lines
Line items on customer invoices

Accounts Receivable Objects

KaptioTravel__PaymentSchedule__c
Payment rules defining deposit, progress, and balance amounts and due dates
KaptioTravel__Transaction__c
Actual payments received from customers via gateway or manual entry
KaptioTravel__SalesInvoice__c
Customer-facing invoices generated for bookings

Accounts Payable Objects

KaptioTravel__SupplierAgreement__c
Contracted rates and payment terms with suppliers
KaptioTravel__SupplierInvoiceLine__c
Expected costs auto-generated from agreements when bookings confirm
KaptioTravel__SupplierInvoice__c
Actual supplier invoices for matching against expected costs

Why This Matters

Because every financial record links to the booking, you can answer questions like "What's the margin on this departure?" or "Which packages have outstanding supplier balances?" instantly. No spreadsheet reconciliation required.

03 / Accounts Receivable

Customer Payments Made Simple

From initial deposit to final balance, Kaptio manages the complete customer payment lifecycle with configurable schedules, gateway integration, and self-service options.

Payment Flow

1
Booking Created
Schedule generated
2
Payment Link Sent
Email to customer
3
Customer Pays
Via gateway
4
Transaction Recorded
Auto-reconciled
5
Status Updated
Booking confirmed

Payment Schedules

  • Configurable deposit percentages (e.g., 20% on booking)
  • Progress payments at specified intervals
  • Balance due relative to travel date
  • Per-channel and per-package overrides
  • Pay-per-passenger option for groups

Gateway Integration

  • Kaptio Pay API, Stripe, and regional providers
  • Credit/debit cards, Apple Pay, Google Pay
  • Regional methods (BPAY, SEPA, ACH)
  • Branded payment pages
  • 3D Secure and PCI compliance

Payment Links & Portal

  • One-click payment links via email
  • Embedded in proposals and documents
  • Customer self-service portal
  • Agent/trade partner payment access
  • Mobile-friendly payment experience

Receipts & Refunds

  • Automatic payment receipts
  • Gateway refund processing
  • Manual refund logging
  • Cancellation policy integration
  • Complete transaction audit trail

Multi-Currency Support

Accept payments in customer's preferred currency while tracking in your base currency. Automatic FX rate capture, gain/loss tracking, and dual-currency reporting for international operations.

04 / Accounts Payable

Supplier Payments, Streamlined

Kaptio automates supplier cost tracking from agreement to payment. Expected costs generate automatically, making AP reconciliation straightforward.

How Supplier Costs Flow

Supplier Agreement
Define rates and payment terms
Booking Confirmed
Services added to itinerary
Invoice Lines Generated
Expected costs auto-created
Ready for Payment
AP knows what to pay

Supplier Agreements

  • Contracted rates by service and date range
  • Agreement types: net rate, commission, markup
  • Validity periods with versioning
  • Invoice basis: per item or per service
  • Tax handling configuration

Payment Rules

  • Deposit timing (e.g., on booking, 90 days prior)
  • Balance due before travel
  • Billback provisions (post-trip adjustments)
  • Cost bearer tracking (office vs tour leader)
  • Per-service and per-item rules

Automatic Invoice Lines

  • Generated automatically on booking confirmation
  • Based on supplier agreement rates
  • Due dates per payment rules
  • Linked to itinerary items
  • No manual cost entry required

AP Integration

  • Export expected costs to accounting
  • Integration with AP automation tools
  • Batch payment file generation
  • Variance tracking on reconciliation
  • Accrual management

AP Knows What to Pay

When supplier invoice lines generate automatically from agreements, your AP team knows exactly what's owed, when it's due, and to whom—before the supplier even sends their invoice. This enables proactive cash flow management and eliminates surprise costs.

05 / Automation

Let the System Do the Work

Kaptio automates the repetitive financial tasks that consume your team's time— from invoice generation to payment reminders to supplier remittances.

Invoice Processing Automation

Eliminate manual invoice line creation with agreement-driven automation

Supplier Invoice Lines

  • Auto-generated from supplier agreements
  • Created on booking confirmation
  • Due dates calculated from rules

Sales Invoices

  • Generated on status changes
  • Reflects booking pricing
  • Line items from itinerary

Payment Automation

Automate the customer payment lifecycle from schedule to collection

Schedule Generation

  • • Calculated on booking
  • • Rule-based timing
  • • Per-passenger splits

Payment Reminders

  • • Email at X days before due
  • • Overdue follow-ups
  • • Escalation workflows

Status Updates

  • • Auto-update on payment
  • • Confirmation triggers
  • • Receipt generation

Payment Files & Remittances

Generate bank-ready payment files and supplier communications

Payment Files

  • Batch AP payment file generation
  • Bank-ready formats (BACS, ACH, SEPA)
  • Scheduled or on-demand export
  • Multi-currency support

Supplier Remittances

  • Automatic remittance advice generation
  • Email distribution to suppliers
  • Payment reference linking
  • Audit trail maintenance

Automation Impact

Zero
Manual invoice line entry
Auto
Payment schedule calculation
Batch
Payment file generation
06 / Reporting & BI

Financial Visibility at Every Level

From standard financial reports to custom dashboards and BI integration, Kaptio provides the reporting flexibility your finance team needs.

Standard Reports

Out-of-box reports for common finance needs

  • • Payment Schedule Aging
  • • AR Aging Report
  • • Transaction Summary
  • • Supplier Invoice Summary
  • • Margin Analysis
  • • Refund Report

Custom Reports

Build any report using Salesforce capabilities

  • • Drag-and-drop report builder
  • • Cross-object relationships
  • • Filters and groupings
  • • Scheduled delivery
  • • Export to Excel/CSV
  • • Dashboard components

BI Integration

Connect to your enterprise analytics tools

  • • REST API access
  • • Scheduled data exports
  • • Direct database via KTAPI
  • • Tableau connector
  • • Power BI integration
  • • Custom data warehouse

Key Financial Reports

ReportPurposeKey Metrics
Payment Schedule AgingTrack outstanding customer balancesAmount due, days overdue, aging buckets
Supplier Invoice SummaryMonitor expected supplier costsExpected cost, due date, supplier
Margin AnalysisUnderstand profitabilityRevenue, cost, margin %, by dimension
Transaction SummaryReview payment activityTotal collected, by method, by period
Variance ReportIdentify cost discrepanciesExpected vs actual, variance amount

Margin Visibility

Understand profitability at any level of granularity. Because costs and revenue link to bookings, you can slice margin data by:

Package
Departure
Channel
Agent
Supplier
Service Type
Time Period
Customer Segment

Example: Margin by Package

Italy Explorer
$125,000
28%
Japan Highlights
$98,000
24%
Peru Adventure
$67,000
31%

BI Integration Options

API Access

REST API for real-time or batch data extraction. Your BI team can query financial objects directly.

Scheduled Exports

Automated CSV/Excel exports delivered to email or SFTP. Configure frequency and data scope.

Data Warehouse

Via KTAPI, connect directly to a replicated database for enterprise analytics platforms.

07 / Reconciliation

Know Your True Margins

Match expected costs against actual supplier invoices, identify variances, and understand your real profitability on every booking.

Reconciliation Process

📋
1
Expected Costs
From supplier agreements
📄
2
Actual Invoices
Supplier bills received
🔗
3
Matching
Compare and link
🔍
4
Variance Review
Investigate differences
5
Resolution
Adjust or dispute

Cost Matching

  • Match expected supplier invoice lines to actual invoices
  • Identify exact matches, partial matches, and unmatched items
  • Link invoice lines to supplier invoice records
  • Track matching status and resolution

Variance Analysis

  • Flag variances above configurable thresholds
  • Categorize: overcharge, undercharge, rate change, FX
  • Route for review and approval
  • Track dispute and resolution status

Common Variance Types

Overcharge

Supplier billed more than agreed

Action: Dispute with supplier

Undercharge

Supplier billed less than expected

Action: Record accrual

Rate Change

Contract changed mid-booking

Action: Update agreement

FX Difference

Currency movement impact

Action: Recognize gain/loss

Margin Analysis

Gross Margin
Revenue - Costs
Net Margin
Gross - Operating
Margin %
Net / Revenue

Analyze margins at any dimension: by package, departure, channel, agent, supplier, or time period. Identify which products drive profitability and which need attention.

Accrual Management

Track accrued revenue and expenses for period-end accuracy. Generate accrual entries for unbilled services and unrecorded costs. Reverse accruals automatically when actual transactions post. Support for multi-currency accruals with FX handling.

08 / Accounting Integration

Connect to Your Accounting System

Kaptio's generic integration framework supports any accounting system. Export financial data in configurable formats with automated or manual triggers.

Supported Accounting Systems

Sage
Line, 50, 200, Intacct
Dynamics
365, NAV, GP
Oracle
NetSuite, Cloud
QuickBooks
Online, Desktop
Xero
Cloud
Custom ERP
API or File

The same integration patterns work across all systems—configuration determines the output format.

Integration Architecture

Kaptio Financial Data
Export Layer
GL Journals
Revenue, costs, accruals
AP Payments
Payment files for banks
AR Aging
Outstanding balances
API Sync
Real-time integration
Your Accounting System

GL Journal Entries

  • Revenue recognition entries
  • Cost accruals and adjustments
  • Variance journal entries
  • Multi-currency with FX entries
  • Configurable account mapping

AP Payment Files

  • Batch payment file generation
  • Bank formats: BACS, ACH, SEPA
  • Supplier bank details
  • Payment reference linking
  • Multi-currency payments

Configuration Options

Account Mapping

  • • Map Kaptio revenue types to GL accounts
  • • Configure cost account assignments
  • • Set up liability and asset accounts
  • • Define default and override mappings

Dimension Mapping

  • • Map to cost centers/departments
  • • Project and job tracking
  • • Channel and product segments
  • • Custom dimensions as needed

File-Based

Scheduled CSV/XML exports in your required format. Manual download or SFTP delivery.

API-Based

REST API for real-time or batch data extraction. Push or pull integration patterns.

Event-Driven

Trigger exports on booking confirmation, payment, or other events. Webhook support.

System-Agnostic Approach

Kaptio doesn't lock you into a specific accounting system. Our generic integration framework provides the flexibility to connect to Sage, Dynamics, Oracle, QuickBooks, Xero, or any custom ERP. As your business evolves, your integration can evolve with it.