Financial reports as data
Monthly income statement reports sync as rows by account, group, and section, ready to query in your warehouse.
Rillet
Polytomic connects Rillet to your data warehouse, databases, and SaaS tools for reliable ETL. Sync contracts, invoices, bills, and monthly income statement data out of Rillet, without writing code.
Full contract detail
Contract terms, line items, and usage based pricing sync alongside invoices, bills, and payments.
Sync only what changed
Most objects support incremental syncs, so ongoing runs only pull records updated since the last sync.
Example workflows
Report on monthly income statement trends without exporting from Rillet
What you can sync
Sync data out of Rillet into your data warehouse, databases, and other systems with full control over object and field mapping.
From Rillet
Chart of accounts, customers, and vendors
Contracts and draft contracts with usage based pricing
Invoices, credit memos, and customer payments
Bills, vendor credits, charges, and reimbursements
Journal entries and bank transactions
Monthly income statement reports by account
How it works
Connect Rillet with an API key. Choose which objects to sync into your data warehouse, databases, or other destinations. Polytomic reads Rillet's revenue, expense, and ledger records. Monthly income statement reports come through flattened into rows you can query directly.
Most objects sync incrementally using Rillet's updated-since filter. Each run pulls only records changed since the last sync. Contracts, draft contracts, and a few configuration objects have no updated-since filter in the Rillet API. Those objects, along with the monthly income statement report, sync in full on every run.
- Objects read with an API key scoped to one environment
- Most objects sync incrementally using Rillet's updated since filter
- Contracts read in full each run using monthly date windows
- Monthly income statement reports flattened into account level rows
- Customer payment methods and bill payments fetched per parent record
- Money amounts kept as exact decimal strings, not floats
How to set up
Rillet authenticates with an API key generated in your Rillet workspace. Each connection targets one environment, either Production or Test.
How to get connected
- 1In Rillet, generate an API key for the workspace you want to connect
- 2In Polytomic, go to Connections, click Add connection, and select Rillet
- 3Enter the API key, choose the Production or Test environment, and click Save
Frequently asked questions
Why teams choose Polytomic
No engineering required
Set up and manage syncs without writing code.
Flexible data modeling
Use SQL to define exactly what data gets synced.
Handles scale automatically
Supports large datasets with incremental syncs and bulk APIs.
Start syncing your data with Rillet in minutes
No credit card required. Free trial available.