What Is the Payment Outstanding Report?
The Shopify Payment Outstanding Report brings together orders with payments still outstanding, helping merchants review open receivables without checking each order separately. It shows the amount outstanding alongside order identifiers and payment-term dates.
Finance and operations teams can use the report to prioritize collection follow-ups, identify approaching due dates, and share a consistent snapshot of unpaid amounts. Results reflect the selected report period and the data available when the report is generated; they are not a bank reconciliation or a confirmation of cash received.
Report Overview
- Report scope
- Orders with payment still outstanding, for the selected reporting period.
- Included data
- Order details, payment terms, issue and due dates, total sales, transaction amount, and total outstanding.
- Best for
- Accounts receivable reviews, due-date checks, and payment follow-up planning.
- Export
- Excel, CSV, TXT, and PDF.
- Delivery
- Scheduled email delivery daily, weekly, or monthly.
What Can You Learn from Outstanding Payments?
1. Which orders have the largest unpaid balances
Total Outstanding helps you prioritize orders with the highest open amounts rather than simply sorting by total sales.
Example: A hypothetical order shows 12,000 outstanding while another shows 800.
What you can do: Review the higher-balance order first and confirm its payment arrangements.
2. Which payment deadlines need attention
Due At and Due In Days help distinguish approaching deadlines from those already passed, depending on how days are represented in your report.
Example: A hypothetical order is due in two days.
What you can do: Schedule a reminder or check the agreed terms before contacting the customer.
3. Which payment terms appear on an order
Payment_Terms_Name, Issued At, and Due At provide context when checking whether a balance should be collected yet.
Example: A hypothetical order has terms issued last month and a due date next week.
What you can do: Review the agreed terms before escalating any follow-up.
4. How sales value differs from unpaid value
Total Sales, Transaction Amount, and Total Outstanding appear side by side, supporting a closer review without treating these figures as interchangeable.
Example: A hypothetical order displays a total sales value higher than its outstanding balance.
What you can do: Use the outstanding amount for receivable follow-up, and inspect the order for any discrepancy.
What Should You Check First in This Report?
Use these checks to make the first review practical and consistent.
- Total Outstanding: Sort to identify the largest open balances.
- Due At: Review the nearest due dates and any dates already passed.
- Due In Days: Check urgency, but verify how overdue values are displayed.
- Payment_Terms_Name and Issued At: Confirm the agreed timing before sending a follow-up.
When Should You Use This Report?
| When to Use It | How It Helps |
|---|---|
| Reviewing outstanding order balances each week | See which orders still carry outstanding amounts. |
| Preparing open-balance records at month end | Prepare an open-balance list for follow-up and reconciliation checks. |
| Planning collections follow-up by balance and due date | Focus outreach on balances and due dates. |
| Answering a billing question about an order | Locate an order and review its recorded terms before responding. |
| Sharing recurring outstanding payment summaries | Share a periodic snapshot of pending payments with the responsible team. |
How to Create This Report in Data Export
Start with the premade Payment Outstanding report, then review the fields and criteria before saving.
- Open Data Export and locate the premade Payment Outstanding report.
- Open the report and confirm the nine included columns, especially Total Outstanding and Due At.
- Choose the report period and review any filters so only the intended outstanding orders are included.
- Save the configured report; export to a format that fits your review workflow.
- If needed, set up scheduled email delivery for a daily, weekly, or monthly receivables check.
Make the Most of This Report
Small setup choices can make the exported list easier to act on.
01 / PRIORITIZE
Sort by balance: Put the largest Total Outstanding amounts first when deciding which orders need follow-up.
02 / VERIFY
Check dates: Compare Due At with Issued At and payment terms before treating an order as overdue.
03 / SHARE
Keep recipients focused: Email only the people responsible for payment follow-up because order-level details may be sensitive.
04 / COMPARE
Use consistent snapshots: Run the same period and filters for recurring reviews, and note when each export was generated.
Frequently Asked Questions
Does this report show which Shopify orders still have unpaid amounts?
It is designed to focus on orders with a Total Outstanding amount. Review the report filters to confirm which pending-payment orders are included.
Can I find overdue payments?
Due At and Due In Days help you identify orders whose payment deadlines have passed. Confirm how negative or overdue day counts appear in your configuration.
Is Total Sales the same as Total Outstanding?
No. Total Sales is a sales measure, while Total Outstanding is the balance remaining unpaid according to this report.
Can I customize the columns and export the results?
The supplied setup instructions describe editing fields, sorting or filtering, and exporting to Excel, CSV, TXT, or PDF.
Can I receive the report automatically?
Yes. You can schedule email delivery on daily, weekly, or monthly intervals after you save the report.
