Accounts receivable aging report for Shopify
Shopify shows you orders. It does not show you who owes what and for how long. Terms Due gives you a live aging report of every trade invoice.
Every open invoice, sorted by risk
The report groups unpaid invoices into the standard buckets: current, 1-30, 31-60, 61-90 and over 90 days past due. Each buyer gets a row, and the totals show how much of your trade book is late.
Click any figure to see the invoices behind it and the reminders already sent.
| Buyer | Current | 1-30 | 31-60 | 61-90 | 90+ |
|---|---|---|---|---|---|
| Harbour and Pine | $9,260 | $8,420 | $9,960 | $12,480 | |
| Northgate Deli Co | $3,150 | ||||
| Lune Street Salons | $1,880 | $2,240 | |||
| Copper Kettle Cafes | $4,610 | ||||
| Total | $14,290 | $10,660 | $9,960 | $12,480 | $4,610 |
What you can do with it
- Spot the buyers who pay slower every month before they become a problem.
- Decide who to call this week, starting with the largest late balances.
- Export to CSV for your accountant or your month-end close.
- Have it emailed to you, or to your finance team, every Monday morning (Growth and Pro).
Questions
What is an aging report?
A list of unpaid invoices grouped by how many days past due they are. It is the standard way to see how healthy your receivables are. Read more in our aging report guide.
Does it include orders paid by card at checkout?
No. Only orders placed on payment terms that still have an outstanding balance appear.
Does Shopify have an aging report?
Not for B2B receivables. You can filter orders by payment status, but there is no report grouping outstanding balances by days past due.
Related
Reading an aging report
What an accounts receivable aging report is, how the aging buckets work, how to read it and what to do about each bucket, with a worked example.
Read moreStatements and pay-now page
Send monthly statements to Shopify B2B buyers and give them one page to see and pay every open invoice. Payments are recorded back on the Shopify orders.
Read moreCredit limits
Set a credit limit for each Shopify B2B company. Terms Due checks open balance plus the new order before checkout, so no buyer runs up more than you agreed.
Read moreStop chasing wholesale invoices by hand
Install Terms Due, set a credit limit for each buyer and let the app hold, remind and collect.
Install on Shopify