Reports
Reports provide ShopWired Pay activity data for balances, payments, payouts, refunds, disputes, subscriptions, customers, and accounting exports.
Use the latest information shown in ShopWired Pay before taking action. Financial information, account status, and customer-facing actions are confirmed by ShopWired Pay.
Common report controls and columns
Common report controls and columns
Most reports include a Date range setting and an Export option. When an export is requested, ShopWired Pay emails the report to the account email address.
Common exported columns can include:
| Column | Description |
|---|---|
Report type |
The name of the report |
From |
The first date included in the report |
To |
The last date included in the report |
Generated at |
The date and time the report was prepared |
Currency |
The currency used for the row or summary |
Status |
The current status of the payment, payout, refund, dispute, subscription, schedule, or export row |
Scheduled reports
Scheduled reports
Scheduled reports send selected reports by email on a recurring schedule.
Use this section to create, edit, pause, resume, delete, and send scheduled report emails.
| Column | Description |
|---|---|
Report |
The report that will be sent |
Email address |
The email address that receives the report |
How often |
The schedule frequency, such as daily, weekly, monthly, quarterly, or yearly |
Data range |
The date range used each time the scheduled report runs |
Run time |
The time of day the report should run |
Timezone |
The timezone used for the run time |
Active |
Whether the schedule is active |
Next run |
The next time the schedule is expected to run |
Last run |
The most recent time the schedule ran |
Run history |
Previous scheduled report runs |
Job |
The internal report job reference shown for a scheduled run |
Balance summary
Balance summary
The Balance summary report shows how the account balance changed over a selected date range using the balance change date.
Use this report to understand the opening balance, balance activity, fees, payouts, and ending balance for each currency.
| Column | Description |
|---|---|
Starting balance |
The account balance at the start of the report period |
Account activity before fees |
The total balance activity before fees are deducted |
Fees |
Fees deducted from the balance activity or payout activity |
Net balance change from activity |
The balance movement after fees |
Payouts to bank |
Amounts paid out to the bank account |
Payout fees |
Fees charged for payout activity |
Total payouts |
The total payout movement after payout fees |
Ending balance |
The account balance at the end of the report period |
Balance change from activity |
Activity rows grouped by category |
Count |
The number of rows in the category |
Gross |
The amount before fees |
Net |
The amount after fees |
Payouts |
Payout rows grouped by category |
Amount |
The payout amount before fees where the row applies |
Total paid out |
The total paid out for the selected period |
Activity summary
Activity summary
The Activity summary report shows how the balance changed over a selected date range based on the originating event date.
Use this report to review payment, refund, dispute, payout, adjustment, and fee activity by reporting category.
| Column | Description |
|---|---|
Reporting category |
The activity category used for reporting |
Count |
The number of activity rows in the category |
Currency |
The currency for the category |
Gross |
The total amount before fees |
Fee |
The fee amount for the category |
Net |
The total amount after fees |
Total |
The total activity for the currency |
Statement
Statement
The Statement report shows money going in and coming out of the account, including fee breakdowns.
Use this report to review row-level balance movements and the running balance for each day.
| Column | Description |
|---|---|
Date |
The date assigned to the statement row |
Created at |
The date and time the row was created |
Reference |
The payment, payout, refund, dispute, or balance reference |
Title |
The statement row title |
Description |
Additional row context |
Reporting category |
The reporting category for the row |
Type |
The underlying row type |
Status |
The row status |
Currency |
The row currency |
Gross |
The amount before fees |
Fees |
The fees for the row |
Net |
The amount after fees |
Running balance |
The balance after the row is applied |
Daily closing balance |
The balance at the end of the day section |
Fees
Fees
The Fees report shows a breakdown of fees incurred on the account.
Use this report to review total fees by fee category and itemised fee rows.
| Column | Description |
|---|---|
Fees summary |
The fee category summary section |
Count |
The number of fee rows in the category |
Currency |
The fee currency |
Fees |
The total fee amount |
Date |
The date assigned to the itemised fee row |
Reference |
The payment, payout, refund, dispute, or balance reference |
Reporting category |
The fee category |
Description |
Additional fee context |
Gross |
The amount before the fee |
Fee |
The individual fee amount |
Net |
The amount after the fee |
Total fees |
The total fees for the currency |
Payout reconciliation
Payout reconciliation
The Payout reconciliation report shows payouts and the payment transactions included in each payout.
Use this report to compare a bank deposit with the payments, fees, and transactions that make up the payout.
| Column | Description |
|---|---|
Payout ID |
The payout reference |
Payout created at |
The date and time the payout was created |
Arrival date |
The expected or recorded date the payout arrives in the bank account |
Payout status |
The payout status |
Payout amount |
The payout amount |
Payout currency |
The payout currency |
Row type |
The type of row included in the payout |
Description |
Additional row context |
Transaction ID |
The transaction reference included in the payout |
Transaction occurred at |
The date and time the transaction occurred |
Transaction amount |
The transaction amount |
Transaction currency |
The transaction currency |
Payment intent ID |
The payment intent reference where available |
Card |
The card description where available |
Refunds
Refunds
The Refunds report shows refunds for the selected date range.
Use this report to review refunded payments, refund fees, net movement, and refund status.
| Column | Description |
|---|---|
Date |
The refund date |
Payment intent ID |
The payment intent reference |
Stripe transaction ID |
The provider transaction reference shown in the export |
Reporting category |
The refund reporting category |
Description |
Additional refund context |
Currency |
The refund currency |
Gross |
The refunded amount before fees |
Fees |
The fees associated with the refund row |
Net |
The net balance movement |
Status |
The refund status |
Disputes and chargebacks
Disputes and chargebacks
The Disputes and chargebacks report shows disputes, chargebacks, dispute fees, and dispute countered fees for the selected date range.
Use this report to review disputed balance movements and support dispute reconciliation.
| Column | Description |
|---|---|
Date |
The dispute row date |
Reference |
The dispute or payment reference |
Reporting category |
The dispute reporting category |
Type |
The underlying dispute row type |
Description |
Additional dispute context |
Currency |
The dispute currency |
Amount |
The dispute amount |
Status |
The dispute status |
Cash availability
Cash availability
The Cash availability report shows current available and pending balances, plus funds expected to become available during the selected date range.
Use this report to check when pending money is expected to move into the available balance.
| Column | Description |
|---|---|
Current balances |
The current balance summary section |
Available |
The balance currently available for payout |
Pending |
The balance that is not yet available |
Instant available |
The balance available for instant payout where supported |
Funds becoming available |
Rows showing pending funds expected to become available |
Available on |
The date funds are expected to become available |
Status |
The availability status |
Currency |
The currency for the row |
Count |
The number of rows included |
Gross |
The amount before fees |
Fees |
The fees included in the row |
Net |
The amount expected to become available after fees |
Adjustments and exceptions
Adjustments and exceptions
The Adjustments and exceptions report shows balance adjustments, reserves, corrections, and unusual balance movements for the selected date range.
Use this report to investigate balance movements that do not fit normal payment, refund, dispute, or payout activity.
| Column | Description |
|---|---|
Date |
The adjustment or exception date |
Reference |
The balance movement reference |
Reporting category |
The reporting category |
Type |
The underlying movement type |
Description |
Additional row context |
Currency |
The currency for the row |
Amount |
The movement amount |
Fees |
The fee amount where available |
Net |
The net balance movement |
Status |
The row status |
Customer lifetime value
Customer lifetime value
The Customer lifetime value report ranks customers by ShopWired Pay lifetime net value, payment history, and recent activity.
Use this report to identify repeat customers, active customers, and customers with refund or dispute activity.
| Column | Description |
|---|---|
Partial |
Whether the report is limited by the current report limits |
Currency |
The currency for the summary or customer row |
Customers |
The number of customers with payments |
Repeat customers |
Customers with repeat payment activity |
Active last 30 days |
Customers with payment activity in the last 30 days |
Customer ID |
The customer record identifier |
Customer |
The customer name shown in the report |
Email |
The customer email address where available |
Identity |
Whether the customer is identified or anonymous |
Trade customer |
Whether the row relates to a trade customer |
First payment |
The date of the first recorded payment |
Last payment |
The date of the latest recorded payment |
Lifetime days |
The number of days between the first and latest payment |
Payment count |
The number of payments |
Payments last 30 days |
Payments made in the last 30 days |
Refund count |
The number of refunds |
Dispute count |
The number of disputes |
Gross |
Total payment value before refunds |
Refunded |
Total refunded value |
Net |
Total payment value after refunds |
Average payment |
The average payment value |
Largest payment |
The largest payment value |
Largest payment date |
The date of the largest payment |
Customer risk and refunds
Customer risk and refunds
The Customer risk and refunds report reviews refund, dispute, early fraud warning, and unusual refund value context.
Use this report for support and dispute-prevention context. It is not a customer blacklist.
| Column | Description |
|---|---|
Partial |
Whether the report is limited by the current report limits |
Currency |
The currency for the summary or row |
Customers reviewed |
The number of customers reviewed |
Customers with context |
Customers with refund, dispute, early fraud, or other review context |
Customers with refunds |
Customers with refund activity |
Customers with disputes |
Customers with dispute activity |
Customers with early fraud warnings |
Customers with early fraud warning activity |
Payment methods with context |
Payment methods with refund, dispute, or fraud-warning context |
Customer ID |
The customer record identifier |
Customer |
The customer name shown in the report |
Email |
The customer email address where available |
Identity |
Whether the customer is identified or anonymous |
Trade customer |
Whether the row relates to a trade customer |
Payment method |
The card or payment method label |
Brand |
The card brand |
Last 4 |
The last four digits of the card |
Country |
The card country |
Context level |
The level of review context |
Context reasons |
The reasons the customer or payment method appears |
Payments |
The number of payments |
Refunded payments |
The number of payments that were refunded |
Refund rate |
The percentage of payments refunded |
Refund value rate |
The refunded value as a percentage of gross payment value |
Refund count |
The number of refunds |
Dispute count |
The number of disputes |
Early fraud warning count |
The number of early fraud warnings |
Gross |
Total payment value before refunds |
Refunded |
Total refunded value |
Net |
Total payment value after refunds |
First payment |
The first recorded payment date |
Last payment |
The latest recorded payment date |
Last refund |
The latest refund date |
Last dispute |
The latest dispute date |
Last early fraud warning |
The latest early fraud warning date |
Subscription summary
Subscription summary
The Subscription summary report reviews active, trialing, past due, unpaid, and cancelled subscriptions.
Use this report to monitor the current subscription base and recurring value.
| Column | Description |
|---|---|
Metric |
The subscription metric name |
Count |
The number for the metric |
Currency |
The currency for amount-based metrics |
Amount |
The money value for the metric |
Active |
Active subscriptions |
Trialing |
Subscriptions in trialing status |
Past due |
Subscriptions with past due payment status |
Unpaid |
Subscriptions with unpaid status |
Recurring amount |
The recurring amount for the currency |
Date |
The row date where applicable |
Customer |
The customer name or row title |
Email |
The customer email address |
Product |
The subscription product |
Status |
The subscription status |
Interval |
The subscription interval |
Subscription ID |
The subscription reference |
Invoice ID |
The invoice reference where available |
Payment intent ID |
The payment intent reference where available |
Next date |
The next renewal or payment date |
Reason |
The reason shown for the row where available |
Subscription payments
Subscription payments
The Subscription payments report reviews successful subscription invoice payments for the selected date range.
Use this report to reconcile paid subscription invoices and payment references.
This report uses the subscription report columns described in Subscription summary. Rows focus on successful subscription payment activity.
Failed subscription payments
Failed subscription payments
The Failed subscription payments report reviews failed subscription invoice payment attempts for the selected date range.
Use this report to identify subscriptions that need follow-up because a recurring payment attempt failed.
This report uses the subscription report columns described in Subscription summary. Rows focus on failed payment attempts and include payment attempt details where available.
Subscription cancellations
Subscription cancellations
The Subscription cancellations report reviews subscriptions cancelled during the selected date range.
Use this report to monitor cancellation activity and understand cancellation timing.
This report uses the subscription report columns described in Subscription summary. Rows focus on cancelled subscriptions and cancellation reasons where available.
Subscription renewals
Subscription renewals
The Subscription renewals report reviews upcoming subscription renewals due in the selected date range.
Use this report to prepare for future recurring payments and identify subscriptions due to renew.
This report uses the subscription report columns described in Subscription summary. Rows focus on upcoming renewal dates.
Invoices
Invoices
The Invoices entry is used to view and download invoices from ShopWired Pay for fees paid.
Use this entry where invoice downloads are available for the account.
No in-app report table or export column set is currently shown for this entry in the Reports list.
Xero bank export
Xero bank export
The Xero bank export creates a CSV file containing balance-affecting transactions for Xero.
Use this report to export bank account activity in the Xero format.
| Column | Description |
|---|---|
Date |
The transaction date |
Amount |
The transaction amount |
Payee |
The payee used in the export |
Description |
The export row description |
Reference |
The transaction or payout reference |
Account code |
The Xero account code applied to the row |
Tax Rate (Display Name) |
The Xero VAT rate display name |
Enter a Xero account code for payments into the bank account (numbers only) |
The account code used for payment rows |
Select a VAT rate for payment into the bank account |
The VAT rate used for payment rows |
Enter a Xero account code for ShopWiredPay fees (numbers only) |
The account code used for ShopWired Pay fee rows |
Quickbooks bank export
Quickbooks bank export
The Quickbooks bank export creates a CSV file containing balance-affecting transactions for Quickbooks.
Use this report to export bank account activity in a three-column accounting format.
| Column | Description |
|---|---|
Date |
The transaction date |
Description |
The export row description |
Amount |
The transaction amount |
Sage Accounting bank export
Sage Accounting bank export
The Sage Accounting bank export creates a CSV file containing balance-affecting transactions for Sage Accounting.
Use this report to export bank account activity in a three-column accounting format.
| Column | Description |
|---|---|
Date |
The transaction date |
Description |
The export row description |
Amount |
The transaction amount |
Clearbooks bank export
Clearbooks bank export
The Clearbooks bank export creates a CSV file containing balance-affecting transactions for Clearbooks.
Use this report to export bank account activity in a three-column accounting format.
| Column | Description |
|---|---|
Date |
The transaction date |
Description |
The export row description |
Amount |
The transaction amount |
Kashflow bank export
Kashflow bank export
The Kashflow bank export creates a CSV file containing balance-affecting transactions for Kashflow.
Use this report to export bank account activity in the Kashflow format.
| Column | Description |
|---|---|
Date |
The transaction date |
Description |
The export row description |
Value |
The transaction value |
Reference |
The transaction or payout reference |
FreeAgent bank export
FreeAgent bank export
The FreeAgent bank export creates a CSV file containing balance-affecting transactions for FreeAgent.
Use this report to export bank account activity in the FreeAgent format.
| Column | Description |
|---|---|
Date |
The transaction date |
Amount |
The transaction amount |
Description |
The export row description |
Zoho Books bank export
Zoho Books bank export
The Zoho Books bank export creates a CSV file containing balance-affecting transactions for Zoho Books.
Use this report to export bank account activity in a three-column accounting format.
| Column | Description |
|---|---|
Date |
The transaction date |
Description |
The export row description |
Amount |
The transaction amount |
FreshBooks bank export
FreshBooks bank export
The FreshBooks bank export creates a CSV file containing balance-affecting transactions for FreshBooks.
Use this report to export bank account activity in the FreshBooks format.
| Column | Description |
|---|---|
Date |
The transaction date |
Amount |
The transaction amount |
Description |
The export row description |