What Is the Outstanding Customer Payments Report?
The Outstanding Customer Payments report in Data Export helps you review Shopify orders with pending or partially unpaid customer payments. It brings customer names, order references, financial status, order amounts, outstanding balances, refunded amounts, and email addresses into one view.
Use the order reference to investigate each balance and the customer details to prepare follow-up. The report includes order-level information, so review individual orders before combining amounts for a customer. An outstanding balance does not, by itself, establish that a payment is overdue; payment due dates are not among the included fields.
Report Overview
- Report period
- Choose a date range and check the date setting before generating the report.
- Data included
- Seven fields covering customer identity, order details, payment status, outstanding balances, and refunds.
- Best for
- Preparing payment follow-up lists and reviewing unpaid order balances.
- Export formats
- Excel, CSV, TXT, and PDF.
- Automation
- Schedule delivery by email daily, weekly, or monthly.
What Can You Learn from Outstanding Customer Payments?
1. Which balances need attention first
Compare Total Outstanding across orders to identify larger balances for review. Check Financial Status before deciding how to follow up.
Example: For example, an order with $900 outstanding goes ahead of a $40 balance in your review queue.
What you can do: Sort by Total Outstanding and investigate the largest balances first.
2. Which customers have several orders to review
Customer Name and Email help you recognize related orders while Order Name keeps each balance traceable. Check the records before grouping customers with similar names.
Example: For example, two order references share the same customer email address.
What you can do: Confirm the customer match and prepare one clear message listing the relevant orders.
3. Where refunds need a closer look
Total Refunded adds context to a balance review. Use it with Financial Status and Total Outstanding rather than assuming a refund means the order is fully settled.
Example: For example, an order shows both a refunded amount and a remaining outstanding balance.
What you can do: Check the order record and confirm the balance before contacting the customer.
What Should You Check First in This Report?
Review these details before preparing payment reminders:
- Total Outstanding: Start with positive balances and prioritize the amounts that need review.
- Financial Status: Read the status alongside the balance to understand the payment situation.
- Total Refunded: Investigate refunds before deciding what amount to discuss with the customer.
- Order Name and Email: Confirm the order reference and contact details so each follow-up is accurate.
When Should You Use This Report?
| When to Use It | How It Helps |
|---|---|
| Preparing payment reminders | Brings customer email addresses, order references, and outstanding balances together. |
| Prioritizing large unpaid balances | Helps you review orders with the highest Total Outstanding first. |
| Checking customers with multiple unpaid orders | Lets you identify related orders and verify each balance before consolidating follow-up. |
| Reviewing orders that include refunds | Places refunded amounts beside financial status and outstanding balances for investigation. |
| Sharing a regular payment review list | Provides an export you can send to the team member responsible for follow-up. |
How to Create This Report in Data Export
Start with the Outstanding Customer Payments premade report rather than selecting every field manually.
- Open Data Export in your Shopify admin and find the Outstanding Customer Payments premade report.
- Open the report and review the seven included fields, especially Total Outstanding and Financial Status.
- Choose your date range and check the date setting. Adjust available filters and sorting for the balances you want to review.
- Generate and review the results, then save the report and export it in your preferred format.
- If needed, schedule email delivery daily, weekly, or monthly for the people handling payment follow-up.
Make the Most of This Report
Use these practical checks to keep your payment review useful.
01 / PERIOD
Check the date scope: A narrow period may leave older unpaid orders outside the report. Widen the range when reviewing unresolved balances.
02 / COUNTING
Count orders carefully: Use Order Name to check for duplicate rows before summing balances in a spreadsheet.
03 / REFUNDS
Read amounts together: Review Total Refunded alongside Total Outstanding. Avoid subtracting refunds again without checking the order record.
04 / SHARING
Limit access: Customer emails and balances are sensitive. Send scheduled exports only to people who need them for payment review.
Frequently Asked Questions
Does outstanding mean overdue?
No. Outstanding identifies an unpaid balance; overdue depends on the payment due date and agreed terms. The included fields do not contain a due date.
Can I use this report to follow up on partially unpaid orders?
Yes. Review Total Outstanding and Financial Status to identify balances needing attention, then check the order before preparing a reminder.
Can I total outstanding payments by customer?
Export to Excel or CSV and group verified customer records. Check Order Name for duplicate entries and confirm customer identity before adding balances.
Can I export and schedule this report?
Yes. Export as Excel, CSV, TXT, or PDF, and schedule email delivery daily, weekly, or monthly. A scheduled report does not itself send payment reminders to customers.
Does this report explain why a payment is unpaid?
The financial status gives context, but the included fields do not explain every cause. Open the order record to investigate payment details before following up.