Aplauso makes all tip and payout data available for export so you can use it in payroll systems, accounting software, or business intelligence tools.
What Data Can Be Exported
| Data Set | What Is Included |
|---|---|
| Tip Transactions | Date, time, employee, tip amount, service charge, payment method, environment |
| Dividend Payouts | Employee, amount, status (pending/paid), tip reference |
| Employee Earnings Summary | Per-employee totals for a period: tip count, gross tips, net tips |
| Ratings Report | Per-employee average ratings, count, date range |
| Full Analytics Report | Combined earnings + ratings + conversion funnel |
How to Export from Mission Control
-
Sign in to Mission Control (mission-control.aplauso.io) as a Property Admin or higher.
-
Go to Insights > Reports.
-
Select the report type, scope (employee / department / property / organization), and date range.
-
Choose your export format:
- PDF - formatted printable report with charts
- Excel - structured data with summary and raw data tabs
- CSV - flat file for import into payroll or accounting systems
- JSON - structured data for developer use
-
Use the export option displayed for your account. Confirm the generated file before distributing it.
Recurring reporting
If your account provides a recurring-report option, configure it in the reporting workspace and verify the first delivered report before using it in an operational process. If the option is not visible, use an on-demand export or contact Aplauso Support to confirm what is available for your account.
Using Tip Data in Payroll
The Employee Earnings Summary CSV is designed for payroll integration. Each row represents one employee for the selected period:
| Column | Description |
|---|---|
employee_id | Aplauso employee ID |
name | Employee full name |
department | Department name |
tip_count | Number of finalized tips |
gross_tips | Total tip amount (before any splits) |
net_tips | Amount credited to this employee's wallet |
withdrawals | Amount paid out during the period |
period_start | Start of reporting period |
period_end | End of reporting period |
Import this file into your payroll system to add allocated earnings to employee pay stubs. Withdrawal and payout records determine whether an allocation has already settled; the canonical tip record alone does not. Confirm the correct treatment with your payroll provider.
Personal Data Export (Employees)
Individual employees can download a copy of their own data from Settings > Account > Export My Data. This generates a JSON file with all their tip history, ratings, and profile data. The download link is emailed after processing (usually within 24 hours).
Enterprise Data Access
For large properties or organizations that need programmatic access to raw transaction data for custom BI or payroll pipelines, Aplauso offers:
- Scheduled CSV drops to cloud storage (GCS or S3)
- Read access to the BigQuery analytics dataset
- Custom data schemas on request
Contact your Aplauso account manager to discuss enterprise data export options.