Skip to main content

How to Generate a Transactions Report

Generate a Transactions Report to see every payment, refund and gift card sale, understand the fees deducted, and reconcile against the payouts landing in your bank account.

How to Generate a Transactions Report

  1. Click Marketing in the navigation bar — the Marketing menu expands

  2. Select Insights — opens the Insights dashboard

  3. Click Reports (top right) — you see a list of past reports

  4. Click + Report — the report generator window appears

  5. Select Type and choose Transactions — type is set to Transactions

  6. Pick your Start date and End date — dates are filled in

  7. Click Generate report — the report is generated

  8. Wait until the report status shows Ready — the report is ready to download

  9. Click the download icon next to your report — the report downloads to your computer

Which columns does the report contain?

Each row represents a single transaction — a purchase, a refund or a gift card sale.

Column

What it means

totalValue

The total amount paid by the customer, including VAT.

netPayout

The amount you receive after deductions such as fees and VAT.

type

Whether the row is a booking, refund or giftcard transaction.

paymentFee

The full cost of processing the payment. This already includes the acquiring cost from our payment provider, Adyen. There is no separate provider fee added on top.

transfer

A single payout from your Understory Pay balance to your bank account. One transfer entry corresponds to exactly one line on your bank statement.

currency

The currency the transaction was made in.

There is no separate VAT column in the Transactions Report. VAT is contained in the difference between totalValue and netPayout, together with the fees. If you need VAT broken out per sale for your bookkeeping, use the Bookings Report instead.

If you use Stripe rather than Understory Pay, processing fees are charged by Stripe directly and payouts follow your Stripe payout schedule. The paymentFee and transfer columns above apply to Understory Pay.

Transactions Report vs. payout overview

These two views answer different questions, and mixing them up is the most common source of confusion.

View

Shows

Use it when

Transactions Report
Marketing → Insights → Reports

Every individual payment, refund and gift card sale, with the fees deducted from each

You need to see what a specific booking earned, or you need a line-by-line export for your accountant

Payout overview
Company Settings → Payment

The money actually transferred to your bank account

You are matching Understory against your bank statement

If a payout amount does not match what you expected, start with the payout overview and work backwards to the transactions it covers.

Is there a separate payout report?

No. Understory does not generate a standalone payout report file.

To reconcile a month against your bank account, use the payout overview under Company Settings → Payment and cross-reference the transfer rows in your Transactions Report for the same period. Each transfer row matches one line on your bank statement.

See also Managing payments in Understory Pay and When will I receive my payout with Understory Pay?

Did this answer your question? If not, please reach out to us in the chat window at the bottom right, and we'll be happy to help 🤗

Did this answer your question?