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
| Column | What it shows |
|---|---|
| Period | The day, month or year being added up |
| Number of Orders | The number of orders with transactions |
| Number of Order Invoices | The number of invoices on those orders. An order can have more than one invoice. |
| Total Invoiced | The total of those invoices |
| Total Paid | The amount paid, including partial payments and deposits |
| Total Surcharge | Payment surcharges added to those payments |
| Total Refunded | The amount refunded |
| Total Payment Remaining | The 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 transactionThese reports were built before transactions and leave out partial payments, deposits and payment refunds:
- Paid (Invoices paid in full only) counts only invoices paid in full.
- Refunds (Credit Memos only) counts only credit memo 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.
| Total | The total raw value of the transaction. |
| Total (Base) | Base totals are displayed in the Store's base currency. |
| Available | Total raw value of a payment minus any refunds against it.Available = Total - Refunded |
| Refunded | Total 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) |
| Applied | The amount that has been assigned to an Invoice. |
| Unapplied | The '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
Updated 1 day ago
