Private jet on tarmac with digital overlay
Back to Case Studies
Aviation Holdings
Aviation HoldingsAviationScale-up

Multi-Entity Aviation Billing Platform

Intelligent routing and automation for complex dual-entity aviation billing

Key Outcomes

01

Complex financial routing

Successfully automated the logic for different invoice types across two distinct legal entities.

02

Zero reconciliation errors

Achieved 100% accuracy in Federal Excise Tax (FET) and margin calculations, eliminating inter-entity balance discrepancies.

03

Process acceleration

Reduced invoice processing time by 95% and sped up month-end reconciliation by 80%.

The Challenge

The dual-entity billing nightmare

Aviation Holdings operated with a complex structure requiring distinct invoicing logic for their operating vs. membership divisions. Each entity had different tax treatments, margin calculations, and compliance requirements.

Manual reconciliation and synchronization took a full resource's time, and staff were constantly firefighting discrepancies between systems.

Inter-entity reimbursements caused significant reporting delays, and the finance team was drowning in spreadsheets trying to keep everything aligned.

>1 full-time resource spent on boring, manual reconciliation and synchronization each month.

Our Approach

Logic mapping and intelligent routing

The Kipanga Finance Automation Protocol

Kipanga mapped out the five distinct invoice flows and built an intelligent routing system using Pipedream. We documented every business rule, tax calculation, and entity-specific requirement.

The system integrates with QuickBooks to handle negative amount reimbursements and complex split invoices automatically.

Every edge case was accounted for - from canceled flights to partial refunds to cross-entity charges.

Phase 01

Discovery

Mapped different invoice types and all business rules

Phase 02

Logic Build

Built intelligent routing engine

Phase 03

Integration

Connected to QuickBooks for real-time sync

Phase 04

Validation

Parallel testing against manual calculations

The Solution

Intelligent multi-entity invoice automation system

A fully automated billing engine that determines the correct invoice type, calculates dynamic margins, handles cross-entity validations, and integrates directly with QuickBooks.

The system handles everything from standard flight invoices to complex AOG (Aircraft on Ground) claims with insurance calculations.

Finance staff now review and approve rather than create and calculate - a fundamental shift in their workflow.

Automated generation of different invoice types
Intelligent entity routing
Automatic FET calculations
Negative amount handling
Real-time QuickBooks integration
Cross-entity reconciliation

Results

Measurable Business Impact

Cost reduction
$100k+
Annual Savings
Finance team
120hrs+
Monthly Saved
Invoice time
95%
Faster Processing
FET calculations
100%
Accuracy

Technology

Built With

Backend

JavaScript
JavaScript
Node.js
Node.js

Database

Airtable
Airtable

Infrastructure

Pipedream
Pipedream
QuickBooks
QuickBooks

"Working with Kipanga has been an excellent way to expand our in-house capabilities. They deliver quickly and understand our business needs clearly, which makes for easy communication and real results. Our completed projects with them have kept down our staffing, increased the utility of our data, and reduced implementation costs significantly. I highly recommend them for process automation and data system design."

Peter Keckemet

Peter Keckemet

Chief Financial Officer, Aviation Holdings

Start Your Project

Ready to achieve similar results?

Let's discuss how we can help transform your business with technology.