Hopoti provides flexible, exportable data to make accounting easier, regardless of which tools you use. All reports are accessible in the Archive, where you can choose your preferred time period and export format.
In this article, we'll go through all of the options and how to use them:
🧾 Overview – What exports are available?
We offer three types of accounting exports:
1. Accounting Reports & Commission Receipts (PDFs)
These reports are perfect for basic bookkeeping and tax reporting, and are often sufficient for accountants – especially if you're using a cash-based accounting model.
The Accounting Report PDF includes a summary of all sales, taxes (like VAT, GST, Sales Tax, or other), Hopoti fees, and a full list of the payments.
The Commission Receipt PDF shows Hopoti’s service fees for the selected date range.
👉 For many small-to-mid-sized businesses, this is all that's needed. Still, we recommend checking with your accountant to confirm – it's quick and easy to print an entire month or quarter into one clear PDF.
2. Hopoti Payment, Taxes & Invoices Exports (CSV/XLS)
Use these if your accounting process requires line-by-line detail or if you’re importing data into accounting tools like Xero or QuickBooks.
While the PDFs include transaction listings, only the CSV or XLS files can be imported into most accounting systems or spreadsheet tools.
The Payments export is the main report, including all payment details.
The Taxes export simplifies reporting by summarising sales by tax rate.
The Invoices export may be needed in advanced accounting scenarios.
📌 All major accounting software accepts CSV imports, and Hopoti’s structure is designed to work with any kinds of software. Check the details from this article's Integrations section.
3. Stripe Exports (CSV)
These reports offer additional detail not found in Hopoti’s own reports:
Net payouts after Hopoti fees and possible client refunds.
Payment-level data with fees and refunds shown on the same row.
Annual tax documents like 1099-K in the US.
They’re best for payout reconciliation, refund tracking, or when you need Stripe-level detail for accounting. These complement Hopoti’s own reports – they don’t replace them.
📊 Comparison – Which export should I use?
If you need... | Use this export | Includes |
A summary of sales and tax for your accountant | Reports > Accounting Report (PDF) | Total sales, fees, tax rates, net/gross sales, booking and client statistics |
A receipt of Hopoti’s service commission | Reports > Commission Receipt (PDF) | Hopoti fee summary, tax %, net and gross |
A list of all client payments | Payments (CSV) | Amounts, commission, tax %, client, event, bookings |
A tax breakdown per rate (VAT, GST, etc.) | Taxes (CSV) | Tax rate, tax amount, total excl./incl. tax |
Issued invoices via Hopoti | Invoices (CSV) | Invoice ID, amount, client, due date, payment status |
Combined payment, refund and fee rows | Stripe > Payments and Disputes (CSV) | Charge, refund, method, fee, currency, status |
Match Stripe payouts to your bank account | Stripe > Balance and Payouts (CSV) | Payout ID, amount, date, destination, method, status |
Downloadable tax forms (e.g. 1099-K) | Stripe > Documents (PDF) | Annual tax forms from Hopoti and Stripe (US only) |
🗓️ Keep in mind: Every export can be downloaded for your preferred time period – whether it's a single day, full month, or custom date range. Just select your dates in the Archive before exporting.
🔗 Integrations – How to import files to my software?
Hopoti’s CSV and XLS exports can be opened in spreadsheet tools or imported into most accounting software. Below are help guides for the most-used apps:
Application | Guide |
Microsoft Excel Spreadsheet tool | |
Google Sheets | |
QuickBooks | |
Xero | |
Zoho Books | |
FreshBooks | |
Sage |
✅ Want to test compatibility with your system? Contact our support team and we can provide you with sample datasets of the exports that you need.
💸 Payment Flow – How money moves through Hopoti?
Here’s exactly what happens behind the scenes when a client makes a payment:
💼 Hopoti’s service fee is deducted instantly
The fee is taken at the time of payment and is non-refundable, even if you later refund the client – as the payment costs are still on us.
You’ll find a full breakdown of fees in your Commission Receipt (PDF) export.
🏦 The remaining amount is sent to your bank
By default, payouts are made weekly, with funds typically arriving every Monday to your business bank account.
You can request Daily Payouts (Monday–Friday) for a small additional fee – contact support to check your eligibility.
Full payout options and timing are explained in article: Pricing and Bank Payouts.
↩️ Refunds reduce your next payout
If you refund a payment from January in May, the refund is deducted from your next available payout – not from the original one.
There’s no backward adjustment – only future payouts are affected.
Learn more in the article: Refund Payments.
📊 You can track everything under Archive > Stripe > Balance and Payouts:
Your current balance
The next estimated payout (amount and date)
Full details of all past payouts
🗂️ Hopoti Exports
In addition to accounting data, Hopoti also offers other PDF and CSV/XLS reports for clients, events, horses, and more. Here are the main exports used for accounting:
Accounting report (PDF)
Summary of your business activity for any selected period. Ideal for monthly or quarterly reporting.
Overview includes:
Sales graphs
Gross and net sales
Tax totals by rate (e.g. 10%)
Number of payments, bookings, and clients
Average sales per payment
Also includes transaction-level details:
Order number
Date
Amount incl. tax
Commission
Tax rate
Client
Event
Commission receipts (PDF)
One-page document showing Hopoti’s service fees for the selected period.
Includes:
Seller and Hopoti information
Total fee (net, tax, and gross)
Applied tax rate
Not an invoice — this is for accounting documentation only
Payments (CSV/XLS)
Detailed list of all payments made via Hopoti.
Fields include:
Order ID
Reference number
Date
Amount (incl. tax)
Hopoti commission
Tax rate
Payment method
Client
Event name
Event date
Bookings
Taxes (CSV/XLS)
Summary of collected taxes by rate.
Fields include:
Tax rate (e.g. 10%)
Tax amount
Total excl. tax
Total incl. tax
This export may be referred to as VAT, GST or Sales Tax depending on your region.
Invoices (CSV/XLS)
Includes issued invoices from Hopoti, if invoicing is used.
Fields include:
Invoice number
Client
Amount
Tax rate
Date issued
Due date
Status (e.g. Paid, Expired)
💳 Stripe Exports
All Stripe exports are available in the Archive > Stripe tab. These provide additional Stripe-specific views not available in Hopoti’s own reporting tools.
Transactions – payments and refunds (CSV)
All transactions via Stripe, including refunds, fees, and method details – shown in one row. Found under: Archive > Stripe > Payments and Dispute.s.
Fields include:
ID (Stripe payment ID)
Created date (UTC)
Amount
Amount Refunded
Currency
Payment Source Type (e.g. card, Stripe Link)
Status (succeeded, refunded, partially refunded)
Application Fee (Hopoti fee)
Payouts – transfers to your bank (CSV)
List of Stripe payouts to your bank, including fees and destination details. Found under: Archive > Stripe > Balance and Payout.s.
Fields include:
ID (Payout reference)
Amount
Created (UTC)
Arrival Date (UTC)
Currency
Source Type
Destination Name / Country / Last 4
Status (paid, in_transit, failed)
Method (standard or instant)
Description
Trace ID and Status
Statement Descriptor
Failure Message and Code (if failed)
Documents – such as 1099-K forms in the US (PDF)
Includes Stripe-issued documents like the 1099-K (US businesses only).
These are generated annually for reporting income to tax authorities.
For most non-US businesses, this section may be empty.
💬 Still unsure of something?
Let us know in the chat or via email at support@hopoti.com what you're trying to achieve – our team is happy to guide you to the best export for your needs.