What Is the Payment Due on Report?
The Shopify Payment Due on Report brings together order payment terms, due dates, and outstanding amounts. It helps you identify which orders have a balance to collect and when payment is expected under their assigned terms.
Each row can be reviewed using the order name and the supplied payment-term and date fields. Compare the due date with the outstanding balance to prioritize follow-ups without treating recorded sales as money already received.
Use it to prepare payment reminders, review exposure across due dates, and share a consistent collection-focused export with your team.
Report Overview
- Report focus
- order-level payment due dates and amounts outstanding.
- Key fields
- payment terms, issued/due/completed dates, days until due, and sales figures.
- Best for
- reviewing upcoming dues, organizing follow-up, and evaluating unpaid exposure.
- Export options
- Excel, CSV, TXT, or PDF.
- Scheduling
- Email delivery daily, weekly, or monthly.
What Can You Learn from Payment Due Dates and Balances?
1. Which outstanding orders need attention
Compare Due At with Total Outstanding to locate balances due soon or past their recorded dates.
Example: An order due tomorrow still has an outstanding balance. (Hypothetical.)
What you can do: Put that order on your next reminder list.
2. How payment terms affect your follow-up schedule
Payment_Terms_Name and Payment Terms Type help separate orders with different agreed payment arrangements.
Example: Two orders have the same balance but different due dates. (Hypothetical.)
What you can do: Schedule contact around each order’s agreed date.
3. Which outstanding balances are most material
Use Total Outstanding alongside Order Name to identify larger unpaid amounts without confusing sales values with collections.
Example: One order shows a substantially larger outstanding balance than the others. (Hypothetical.)
What you can do: Review that order first when setting collection priorities.
4. How issued and due dates relate
Review Issued At and Due At together to understand the recorded timing of a payment obligation.
Example: An invoice was issued well before its due date. (Hypothetical.)
What you can do: Check whether the planned reminder falls within your agreed terms.
What Should You Check First in This Report?
Start with the fields that directly explain the timing and size of each outstanding payment.
- Due At: identify the orders whose payment deadlines deserve attention.
- Total Outstanding: determine the unpaid amount associated with each order.
- Payment_Terms_Name and Payment Terms Type: confirm the applicable payment arrangement before contacting a customer.
- Order Name, Issued At, and Completed At: check the order identity and date context before acting.
When Should You Use This Report?
| When to Use It | How It Helps |
|---|---|
| Preparing a weekly payment follow-up list | Sort due dates against Total Outstanding to decide which order balances to review. |
| Checking payments approaching their due date | Use Due At and Due In Days to focus on upcoming payment obligations. |
| Reviewing overdue outstanding amounts | Compare recorded due dates with the review date and examine Total Outstanding; the report does not provide a separate overdue-status field. |
| Checking an order’s payment agreement | Look at Payment_Terms_Name and Payment Terms Type alongside its dates. |
| Sharing a collections review with a teammate | Export Order Name, Due At, and Total Outstanding as a consistent working list. |
How to Create This Report in Data Export
Start with the premade Payment Due on report rather than building the field set from scratch.
- Open Data Export and find the premade Payment Due on report.
- Open it and review the order identifiers, payment-term fields, dates, and outstanding amounts.
- Choose the date range and apply relevant filters, if needed; keep Due At and Total Outstanding visible.
- Save the report and export the results in your preferred available format.
- Optionally schedule delivery by email daily, weekly, or monthly for recurring reviews.
Make the Most of This Report
These four checks help make a payment-due export more actionable.
01 / DUE DATES / Review timing: Sort by Due At so the nearest deadlines rise to the top.
02 / BALANCES / Keep amounts distinct: Total Outstanding is not interchangeable with Gross Sales or Net Sales.
03 / TERMS / Check agreements: Read the payment term before deciding that an amount is late.
04 / SHARING / Send a focused list: Include Order Name, Due At, and Total Outstanding when assigning follow-ups.
Frequently Asked Questions
What does Total Outstanding mean in this report?
It is the amount the report records as still outstanding for an order. Do not treat Gross Sales or Net Sales as a substitute for that balance.
Can I see when payment is due?
Yes. Due At provides the recorded due date, while Due In Days provides a related interval. Check how the interval is defined before using it for automated overdue labels.
Does this report show that an order was paid?
The listed fields include Total Outstanding and Completed At, but no explicit payment-status field. Verify an order’s payment status in the underlying system when necessary.
Can I group follow-ups by payment terms?
You can use Payment_Terms_Name and Payment Terms Type to distinguish arrangements, then organize the exported results for review.
Can I send this report on a schedule?
The supplied setup supports scheduled email delivery daily, weekly, or monthly. Choose a cadence that matches your collection workflow.
