What Is the Payment Term Report?
The Shopify Payment Term Report organizes order payment conditions in one exportable view. It brings together the payment term name and type, issue date, due date, days until due, and outstanding amount for each reported order.
Use it to distinguish nearer-term payment deadlines from longer credit arrangements and prepare collection follow-ups. Order IDs and names make it easier to locate individual transactions, while sales and subtotal fields give additional order-value context.
This is a view of payment terms and recorded outstanding amounts, not a bank-reconciliation or cash-receipt report. The exact set of included orders depends on the report date range and configuration.
Report Overview
- Report period
- Choose the applicable date range when running or scheduling the report.
- Data included
- Due In Days; order identifiers; term name/type; issued, due and completed dates; outstanding and sales amounts.
- Best for
- Reviewing approaching due dates, comparing credit durations and identifying orders with balances to follow up.
- Output
- Download the report in an available export format, such as Excel or CSV.
- Automation
- Save and schedule delivery to the people responsible for reviewing payment terms.
What Can You Learn from Payment Terms and Outstanding Balances?
1. Which orders have the nearest due dates
Compare Due At and Due In Days to identify upcoming payment obligations. Pair those dates with Total Outstanding to decide where attention is needed first.
Example: An order due this week shows an outstanding balance.
What you can do: Prepare a follow-up list ordered by due date.
2. Where longer credit terms are concentrated
Payment_Terms_Name and Payment Terms Type help distinguish different agreed payment conditions. Review their Due In Days values to understand how much time customers have before payment is due.
Example: One order uses a shorter term while another has a longer due period.
What you can do: Group orders by term when reviewing credit exposure.
3. Which outstanding orders warrant review
Total Outstanding shows the recorded unpaid amount, while Order Name and Order ID identify the order to investigate. An outstanding balance alone does not establish whether an invoice is overdue.
Example: Two orders have balances, but only one has reached its due date.
What you can do: Review the due date before prioritizing a collection message.
4. How order values compare with balances due
Gross Sales, Subtotal and Net Sales provide sales context next to Total Outstanding. These are different measures and should not be treated as interchangeable cash received.
Example: A high-value order still shows an amount outstanding.
What you can do: Check the order details before drawing conclusions about payment progress.
What Should You Check First in This Report?
Start with the dates and the amount owed before reviewing broader sales figures.
- Due At: Find the earliest deadlines and compare them against the date of the review.
- Total Outstanding: Identify orders with meaningful balances that may need attention.
- Due In Days and Payment_Terms_Name: Check how the agreed payment window differs across orders.
- Issued At and Completed At: Review the recorded timeline, without assuming completion means a bank payment was received.
When Should You Use This Report?
| When to Use It | How It Helps |
|---|---|
| Preparing upcoming payment reminders | Uses Due At, Order Name and Total Outstanding to build a practical reminder list. |
| Reviewing overdue-looking balances | Helps compare due dates with outstanding amounts before checking individual orders. |
| Comparing short and extended credit terms | Shows Payment_Terms_Name, Payment Terms Type and Due In Days in one view. |
| Checking order-level payment timelines | Brings Issued At, Due At and Completed At together for date review. |
| Sharing a periodic receivables review | Creates a repeatable order reference and balance export for internal follow-up. |
How to Create This Report in Data Export
Start from the existing Payment Term premade report instead of rebuilding its columns manually.
- Open Data Export and locate the premade Payment Term report.
- Open the report and review its supplied fields, especially Due At, Due In Days, and Total Outstanding.
- Choose a relevant date range and apply any available filters to narrow the orders being reviewed.
- Save the report, adjusting its displayed columns if your team needs a simpler view.
- Download it or configure an email schedule (for example, daily or weekly) for recurring reviews.
Make the Most of This Report
A few simple checks make the exported payment-term list easier to act on.
01 / DUE DATES / Sort by Due At before reviewing the balance; not every outstanding order is past due.
02 / TERM TYPES / Keep the term name and type visible when comparing orders with different credit arrangements.
03 / AMOUNT CONTEXT / Do not add Gross Sales, Net Sales and Subtotal together; each represents a different sales measure.
04 / TEAM HANDOFF / Include Order Name and Order ID in scheduled exports so colleagues can find the source order quickly.
Frequently Asked Questions
What does Due In Days mean?
It is the days-to-due value recorded for an order’s payment terms. Check Due At to understand the actual due date.
Does Total Outstanding mean the order is overdue?
No. It is the outstanding amount; you need to compare the due date with the review date to assess whether the payment is late.
Can I see the type of payment terms on each order?
Yes. The premade field list includes Payment_Terms_Name and Payment Terms Type.
Does Completed At confirm that money reached my bank?
No. The report includes a recorded Completed At value, but it does not include bank-settlement or payout-reconciliation fields.
Can I receive this report automatically?
The supplied setup supports saving the report and scheduling email delivery, including daily, weekly or monthly options.
