

Multi-Entity Aviation Billing Platform
Intelligent routing and automation for complex dual-entity aviation billing
Key Outcomes
Complex financial routing
Successfully automated the logic for different invoice types across two distinct legal entities.
Zero reconciliation errors
Achieved 100% accuracy in Federal Excise Tax (FET) and margin calculations, eliminating inter-entity balance discrepancies.
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.
Discovery
Mapped different invoice types and all business rules
Logic Build
Built intelligent routing engine
Integration
Connected to QuickBooks for real-time sync
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.
Results
Measurable Business Impact
Technology
Built With
Backend
Database
Infrastructure
"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
Chief Financial Officer, Aviation Holdings
Related Work
More Case Studies


Better Together Platform

Intelligent Email Response System
Start Your Project
Ready to achieve similar results?
Let's discuss how we can help transform your business with technology.