Invoice ageing and outstanding reports
You will know which screen answers each outstanding-money question, what Age Days and Balance Due mean, and how the aging reports and statements fit together.
Outstanding money is shown at three levels: on the invoice list row by row, in the aging reports grouped by how old each invoice is, and in balance statements per customer or supplier. Each one reads the same invoices and payments, so the totals agree.
On the invoice lists
Column or KPI | Meaning |
|---|---|
Amount to Receive / Amount to Pay | Invoice total including tax (excluding tax when RCM is on) |
Received Amount / Paid Amount | Payments allocated to this invoice so far |
Balance Due | Amount to Receive minus Received Amount |
Age Days | Days since the Invoice Date, counting until the invoice is Paid |
Payment Status | Unpaid, Partial or Paid |
Last Day of Payment (supplier) | The date you planned to pay by |
KPI Total Invoices | Count and value of invoices in the date range |
KPI Amount to Receive | Balance Due summed over the invoices shown |
Aging reports
Customer Invoice Aging Report and Supplier Invoice Aging Report are published reports under Reports. Each open invoice is placed in an age bucket from its Age Days, so you can see at a glance how much is current, how much is a month old and how much is older. Filter by date range and by customer or supplier, print, or export to Excel.
- Use the customer report for collection calls: sort by the oldest bucket and start at the top.
- Use the supplier report with Last Day of Payment to plan the week’s payments.
- An invoice leaves the report the day its Balance Due reaches zero.
Statements
Report | What it shows | Use it for |
|---|---|---|
Single Customer Statement | Every invoice and receipt for one customer in date order with a running balance | Sending a statement, reconciling with the customer |
Customers Balance Statement | One line per customer with the closing balance | Total receivables, spotting large debtors |
Single Supplier Statement | Every bill and payment for one supplier | Matching the supplier’s statement |
Suppliers Balance Statement | One line per supplier with the closing balance | Total payables |
Ledger Report | The Account Receivables or Account Payable ledger entries | Accountant’s view |
On the dashboard
- Total Invoices: count and amount for the selected financial year and date range.
- Customer Payments: Received vs Pending and Supplier Payments: Paid vs Not Paid: the split of billed value.
- Pending Payments: To Receive / To Pay: the open balances in one pair of numbers.
- Customers and Suppliers list KPIs Amount to Receive and Amount to Pay show the same balances per screen.
Reading the numbers together
- Balance Due on the list, the aging report total and Customers Balance Statement should match for the same date range. If they do not, look for a payment recorded as an Advance Payment that has not yet been allocated.
- An opening balance entered on the customer record appears in the statement but not as an invoice, so it is in the balance statement and not in the aging report.
- Overdue notifications (type customer_invoice_overdue in the Notification Delivery Log) are sent from the Due Date, not from Age Days.
Need Help?
Chat with the NShine ERP support team on WhatsApp at +91 79950 87755, or ask from inside the app. Last checked 9 November 2026 against app.nshineerp.com.