Data Exports
Export your Alguna data for analysis, compliance, accounting, and backup purposes.Available Exports
| Export Type | Contains | Formats |
|---|---|---|
| Invoices | All invoice data with line items | CSV, PDF (bulk) |
| Customers | Account information and contacts | CSV |
| Subscriptions | Active and historical subscriptions | CSV |
| Payments | Payment transactions and status | CSV |
| Revenue | Revenue recognition schedules | CSV |
| Usage | Usage events and aggregations | CSV |
| Credits | Credit grants and consumption | CSV |
Exporting Data
Via Dashboard
- Navigate to Settings → Data Exports
- Select export type
- Set date range and filters
- Choose format (CSV or PDF for invoices)
- Click Export
- Download when ready
Export Filters
| Filter | Description |
|---|---|
| Date Range | Start and end date for the export |
| Status | Filter by status (e.g., paid invoices only) |
| Customer | Export for specific customers |
| Product | Filter by product or plan |
Export Formats
CSV
Standard CSV format with headers. Can be opened in Excel, Google Sheets, or imported into other systems. Invoice CSV Example:| invoice_id | account_name | status | total | currency | issued_at | paid_at |
|---|---|---|---|---|---|---|
| INV-001 | Acme Corp | paid | 99.00 | USD | 2024-01-01 | 2024-01-05 |
| INV-002 | Globex Inc | paid | 199.00 | USD | 2024-01-01 | 2024-01-03 |
PDF (Invoices Only)
Export invoices as a ZIP file containing individual PDFs:- Navigate to Settings → Data Exports
- Select Invoices
- Choose format: PDF
- Set date range
- Click Export
- Download ZIP file with all invoice PDFs
Export Types
Invoices Export
| Field | Description |
|---|---|
| invoice_id | Unique invoice identifier |
| account_id | Customer account ID |
| account_name | Customer name |
| status | paid, issued, draft, void |
| subtotal | Amount before tax |
| tax | Tax amount |
| total | Total amount |
| currency | Invoice currency |
| issued_at | Date invoice was issued |
| due_date | Payment due date |
| paid_at | Date payment received |
Customers Export
| Field | Description |
|---|---|
| account_id | Unique account identifier |
| name | Company or customer name |
| Billing email | |
| currency | Customer’s currency |
| country | Billing country |
| subscription_status | active, canceled, none |
| mrr | Monthly recurring revenue |
| created_at | Account creation date |
Subscriptions Export
| Field | Description |
|---|---|
| subscription_id | Unique subscription ID |
| account_id | Customer account ID |
| account_name | Customer name |
| plan_name | Plan name |
| status | active, canceled, paused |
| mrr | Monthly recurring revenue |
| start_date | Subscription start date |
| end_date | Subscription end date (if applicable) |
Revenue Export
| Field | Description |
|---|---|
| period | Recognition period (YYYY-MM) |
| subscription_id | Subscription ID |
| account_name | Customer name |
| product_name | Product name |
| recognized_amount | Amount recognized |
| deferred_amount | Amount still deferred |
| currency | Currency |
Usage Export
| Field | Description |
|---|---|
| account_id | Customer account ID |
| account_name | Customer name |
| metric_code | Billable metric code |
| period | Billing period |
| usage_value | Total usage |
| cost | Calculated cost |
| currency | Currency |
Credits Export
| Field | Description |
|---|---|
| account_id | Customer account ID |
| account_name | Customer name |
| grant_id | Credit grant ID |
| type | monetary or units |
| amount | Credit amount |
| remaining | Remaining balance |
| expires_at | Expiration date |
Compliance Exports
Audit Trail
Export all changes for compliance purposes:- Navigate to Settings → Data Exports
- Select Audit Trail
- Set date range
- Choose entity types (invoices, subscriptions, etc.)
- Export
GDPR Data Export
Export all data for a specific customer (data subject request):- Navigate to Customers → [Customer]
- Click Export All Data
- Download complete customer data package
Using Exported Data
Excel / Google Sheets
- Download CSV export
- Open in Excel or import to Google Sheets
- Use pivot tables for analysis
Accounting Systems
- Export invoices or revenue data
- Import into QuickBooks, Xero, or your accounting system
- Match to your chart of accounts
Data Warehouse
- Export data via API (see API Reference)
- Load into your data warehouse
- Use for business intelligence
Best Practices
Regular Backups
Export data periodically for backup purposes.
Use Filters
Export only what you need to keep file sizes manageable.
Secure Storage
Store exports securely—they contain billing data.
Audit Retention
Keep audit exports for compliance requirements.