Overview
tikento allows you to export payment data for accounting, bank reconciliation, and analytics. Manual export is available on all plans for free. Scheduled automatic export is available starting from Pro.
Manual Export
Where to Find It
- Open the event → "Attendees" section.
- Click the "Export" button in the upper right corner.
- Select "Payments" as the data type to export.
Or through the global section:
- Open "Finances" in the sidebar.
- Click "Export".
Formats
| Format | Purpose |
|---|---|
| CSV | Universal format, opens in Excel, Google Sheets, any text editor |
| XLSX | For Excel and 1C, with column formatting and headers |
| JSON | For automation and programmatic processing |
Filters
Before exporting, you can configure filters to download only the data you need:
| Filter | Description |
|---|---|
| Period | Start and end date (by payment date) |
| Status | All / Paid / Pending / Refunded / Failed / Expired |
| Payment method | Card / SBP / Telegram Stars / Manual payment |
| Event | Specific event or all |
| Ticket type | Specific ticket type or all |
Fields in the Export
Standard set of fields in the exported file:
| Field | Description |
|---|---|
payment_id | Unique payment identifier |
date | Payment date and time |
status | Status (paid, refunded, failed, expired, pending) |
amount | Amount in rubles |
method | Payment method |
gateway | Payment gateway (YooKassa, Tochka, etc.) |
event_name | Event name |
ticket_type | Ticket type |
participant_name | Attendee name |
participant_email | Attendee email |
promo_code | Promo code used (if any) |
discount | Discount amount |
commission_tikento | tikento commission |
commission_gateway | Gateway commission (if available) |
net_amount | Amount to receive (after commissions) |
refund_amount | Refund amount (if applicable) |
refund_date | Refund date (if applicable) |
idempotency_key | Idempotency key (for technical reconciliation) |
Scheduled Export
Available on Pro, Business, and Enterprise plans.
Setup
- Open Settings → Export → Schedule.
- Click "Create export rule".
- Configure the parameters:
- Frequency: daily, weekly (day of week), monthly (date)
- Format: CSV, XLSX, or JSON
- Filters: status, payment method, event
- Recipients: one or more email addresses
- Click "Save".
The file will be sent to the specified email addresses at the selected time. The email subject includes the period and organization name.
Example Scenarios
- Daily export — for an accountant who reconciles receipts every morning
- Weekly report — for a manager, weekly summary on Mondays
- Monthly export — for preparing financial statements and tax returns
Integration with Accounting Systems
1C
For integration with 1C:
- Export data in XLSX format.
- Open the file in Excel or directly in 1C via "Import from external file".
- Map columns to fields in 1C.
For automation, use scheduled export in JSON format and process it via a loading script.
Other Systems
The JSON format is suitable for integration with any accounting systems via an intermediary script or automation service (Albato, Make, n8n).
Availability by Plan
| Feature | Free | Pro | Business | Enterprise |
|---|---|---|---|---|
| Manual export CSV/XLSX/JSON | Yes | Yes | Yes | Yes |
| Scheduled export | No | Yes | Yes | Yes |
| Webhook payment notifications | No | Yes | Yes | Yes |
| BI live connector | No | No | Yes | Yes |
| SQL dump | No | No | No | Yes |