Skip to main content

Accounting

Updated over 3 weeks ago

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:

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.

Did this answer your question?