Transaction Reports

See every payment and refund recorded in a period, from the Transactions report or a custom export of the Transactions grid.

See the payments, deposits and refunds on your orders and invoices in two ways:

  • The Transactions (Payments / Refunds) report adds them up by day, month or year.
  • The Orders > Transactions grid lists each transaction. Choose your own filters and columns, then export it. See Transactions Grid Exports.

Transactions (Payments / Refunds) Report

Open the Report

Go to Reports, type "transactions" in Find a report, and click Open next to Transactions (Payments / Refunds). It's in the Payments & Tax category.

Set the Filters

See Running Reports with Zoey AI for what each filter does.

  • Date range: Date Range, From and To, Show by (Day, Month or Year) and Match Period To. Match Period To starts on Transaction Created Date, so each payment or refund counts in the period it was recorded.
  • Orders: Order Status
  • Display: Empty Rows

Click Show Report to run the report. To reuse these filters later, click Save view.

Report Columns

ColumnWhat it shows
PeriodThe day, month or year being added up
Number of OrdersThe number of orders with transactions
Number of Order InvoicesThe number of invoices on those orders. An order can have more than one invoice.
Total InvoicedThe total of those invoices
Total PaidThe amount paid, including partial payments and deposits
Total SurchargePayment surcharges added to those payments
Total RefundedThe amount refunded
Total Payment RemainingThe balance still owed on those invoices

Export the Report

In Results, choose a format next to Export to and click Export.

📘

Missing recent payments?

Click Refresh next to Statistics updated at the top of the report, or Refresh Statistics on the Reports page. See Refresh Report Statistics.

🚧

Older reports don't count every transaction

These reports were built before transactions and leave out partial payments, deposits and payment refunds:

Use this report to include every transaction.

Ask Zoey AI

Click Ask next to Transactions (Payments / Refunds) on the Reports page, or press Ctrl+J (Cmd+J on Mac), and try:

  • "How much did we collect in payments last month, and how much was refunded?"
  • "How much is still owed on invoices from last quarter?"

See Running Reports with Zoey AI.


Transactions Grid Exports

The Orders > Transactions grid will list every single Transaction and their details. You can add more columns to create custom views of the transactions grid which displays important information.

If you want to export Payments and the Invoices they are applied to then click the ⚙️gear icon and add the Invoice # column.

Transaction Amounts

There are even more columns you can add such as Unapplied Amount, Applied Amount, Available Amount, and Total.

TotalThe total raw value of the transaction.
Total (Base)Base totals are displayed in the Store's base currency.
AvailableTotal raw value of a payment minus any refunds against it.
Available = Total - Refunded
RefundedTotal raw value of the amount refunded against a payment.
(Refund transactions will always have $0.00 Refunded.
The 'Total' will show the amount refunded on a Refund)
AppliedThe amount that has been assigned to an Invoice.
UnappliedThe 'Available' amount minus the 'Applied' amount.
Unapplied = Available - Applied

📘

Payments can be associated with multiple Invoices!! All of the linked Invoice numbers will display as comma delimited data.

After configuring the grid with Filters and Columns, select the records and open the Bulk Actions menu to Export Current Grid. A CSV file will be downloaded with the columns and data shown in the grid.

👍

The Invoices grid can display Deposit Request info.

The following columns can be added to the Invoice Grid for Deposits.

  • Deposit Request Collected: Y/N
  • Deposit Requested: $ Amount Requested for Deposit

Did this page help you?