The reports and exports page is your centralized hub for downloading business data. It offers 18 report types organized into 9 categories, with support for CSV, Excel (.xlsx), and JSON output formats.
Global controls
Four controls at the top of the page apply to all exports:
| Control | Description |
|---|---|
| Start Date | Beginning of the date range for time-based reports (defaults to 30 days ago) |
| End Date | End of the date range (defaults to today) |
| Format | Output format -- CSV, Excel (.xlsx), or JSON |
| Location | Controlled by the location picker in the navigation bar |
Time-based reports require a valid date range. Reports marked as "All records" export everything regardless of dates.
Available reports
Financial Statements
| Report | Date Range | Description |
|---|---|---|
| Financial Summary | Yes | Revenue, refunds, taxes, and cash flow grouped by period |
| Journal Entries | Yes | Double-entry accounting journal with debits, credits, and GL codes |
| Trial Balance | Yes | All GL accounts with debit/credit totals and balance validation |
| GL Summary | Yes | General ledger account summary with transaction counts |
| Accounts Receivable Aging | No | Outstanding balances with current, 30, 60, and 90+ day aging buckets |
Revenue
| Report | Date Range | Description |
|---|---|---|
| Revenue by Channel | Yes | Transaction breakdown by channel (online, POS, walk-up, phone) |
| Ledger Analytics | Yes | Account breakdown, time series, and top accounts by volume |
Tax
| Report | Date Range | Description |
|---|---|---|
| Tax Report | Yes | Tax collected by type (GST, PST, HST) for government filing |
Customers
| Report | Date Range | Description |
|---|---|---|
| Customer List | No | All customer records and contact information |
Bookings
| Report | Date Range | Description |
|---|---|---|
| Bookings | Yes | Booking records with customer details, dates, pricing, and status |
Transactions
| Report | Date Range | Description |
|---|---|---|
| POS Transactions | Yes | Point-of-sale transaction history with payment details |
| Tips Report | Yes | Daily breakdown of tips from POS and booking payments |
| Payment Method Breakdown | Yes | Transaction totals by payment type (card, cash, account, gift card) |
Inventory
| Report | Date Range | Description |
|---|---|---|
| Fleet Inventory | No | Rental fleet items with capacity, configuration, and location assignment |
| POS Items | No | Point-of-sale product catalog with pricing and stock levels |
| Pricing | No | Duration-based pricing tables and seasonal rate schedules |
Slips & Moorage
| Report | Date Range | Description |
|---|---|---|
| Slip Ledger | Yes | Slip-related GL accounts (1136, 2112, 4160) with debit/credit totals |
| Moorage Revenue | Yes | Moorage revenue and deferred revenue summary |
Staff
| Report | Date Range | Description |
|---|---|---|
| Timesheets | Yes | Staff clock-in/out records with hours, breaks, and overtime flags |
Generating a report
- Set the date range using the date pickers (for time-based reports).
- Select the format -- CSV, Excel, or JSON.
- Choose the location from the navigation bar.
- Click Download on the report card.
A progress bar appears during download. The timestamp of the last download is displayed next to each report card.
Output formats
| Format | Extension | Best For |
|---|---|---|
| CSV | .csv | Spreadsheet import, accounting software, payroll systems |
| Excel | .xlsx | Formatted spreadsheets with proper column types |
| JSON | .json | Programmatic consumption, data warehousing, custom tools |
Excel format details
Excel exports are generated client-side using the downloaded data. For reports that return JSON from the server (Trial Balance, GL Summary, AR Aging, Revenue by Channel, Payment Method Breakdown, Ledger Analytics), the data is automatically converted into a formatted Excel worksheet. For CSV-based reports, the CSV is parsed into rows and written to an Excel sheet.
JSON format details
Some reports are natively JSON on the server (marked with a "JSON" badge on the card). These return structured data that includes nested objects and arrays. When downloading these as CSV, the system flattens the data into tabular format automatically.
Report details
Trial Balance
Shows all GL accounts with their debit and credit totals for the selected period. Use this to verify that your books balance (total debits should equal total credits). Includes account codes, account names, and net balances.
Accounts Receivable Aging
Displays outstanding customer balances organized into aging buckets:
| Bucket | Description |
|---|---|
| Current | Invoices not yet past due |
| 30 Days | 1-30 days past due |
| 60 Days | 31-60 days past due |
| 90+ Days | More than 90 days past due |
This report does not use the date range -- it shows the current state of all outstanding balances.
Revenue by Channel
Breaks down revenue by booking source: online widget, POS walk-up, phone reservations, and other channels. Useful for understanding which acquisition channels drive the most revenue.
Payment Method Breakdown
Shows transaction volume and dollar amounts by payment type: card, cash, terminal, account charges, and gift cards. Helps with cash management and reconciliation.
Ledger Analytics
Monthly time-series data with GL account breakdowns. Shows debit and credit flows over time and highlights the accounts with the highest transaction volume.
Location filtering
When a specific location is selected, exports include only data for that location. When All Locations is selected, exports default to the first location's data.
Use the Trial Balance report at month-end to verify your books balance before closing the period. The AR Aging report is essential for tracking overdue customer accounts. Match your export date ranges to your accounting periods for clean reconciliation. The Journal Entries format is designed for direct import into accounting software like Xero and QuickBooks. Excel format preserves numeric types, making it easier to work with financial data in spreadsheets.
Export downloads an empty file -- Widen the date range or verify the selected location has data for the chosen period.
Numbers differ from Stripe -- Pending or processing transactions may not appear until they settle. Compare using the same date range and account for processing delays.
Excel file has "No data" in the sheet -- The selected filters returned zero results. Adjust date range or location and try again.
CSV opens with garbled columns -- Use Excel's "Import from Text/CSV" feature rather than double-clicking. Select comma as the delimiter.
Download button is disabled -- For time-based reports, the date range must be valid (start date before end date). Fix the dates and the button will enable.