Examples & Patterns
Open-source production apps demonstrating key integration patterns: property-driven tax bots, multi-book exchange rate sync, FIFO inventory tracking, subledger hierarchies, and Google Sheets add-ons.
These are production apps built on Bkper, each demonstrating a different integration pattern. All are open source and available on GitHub.
Tax Bot
Calculates VAT, GST, and other taxes automatically when transactions are posted. Demonstrates property-driven configuration — tax rates and rules are stored in account and group properties, making the bot configurable per-book without code changes.
What you’ll learn: Using account/group properties to drive behavior, creating related transactions automatically, working with transaction amounts.
Exchange Bot
Converts transaction amounts between Books based on updated exchange rates and calculates realized gains and losses. Demonstrates multi-book synchronization — when a transaction is checked in one book, the bot creates corresponding entries in connected books.
What you’ll learn: Mirroring transactions between books, working with exchange rates, gain/loss calculations, cross-book data flow.
Inventory Bot
Calculates COGS (Cost of Goods Sold) automatically using FIFO method when inventory items are sold. Demonstrates inventory management patterns — tracking purchase and sale quantities to compute accurate costs.
What you’ll learn: Inventory management patterns, purchase/sale quantity tracking, automatic COGS calculation.
Subledger Bot
Manages hierarchical relationships between parent and subsidiary books, mapping accounts and groups across ledger levels. Demonstrates hierarchical ledger relationships — keeping consolidated and detailed views in sync.
What you’ll learn: Parent-child book patterns, account/group mapping between books, consolidated reporting.
Bkper Sheets
The Google Sheets Add-on — extends Bkper with custom spreadsheet functions, data import/export, and formula-driven reporting. Demonstrates a full Google Workspace integration.
What you’ll learn: Sheets add-on architecture, custom functions, data synchronization between Bkper and Sheets.