Read a customer or supplier balance
You will be able to read any balance on the Customers or Suppliers list, know what moved it, and open the statement that proves it line by line to the customer or supplier.
The Current Balance column is the sum of everything posted to that record’s ledger: opening balance, invoices, receipts or payments, credit notes and journal entries. It changes the moment any of those is saved; there is no month-end step.
Where the figures appear
Screen | Figure | What it means |
|---|---|---|
Customers list | Current Balance (Dr/Cr) | Per customer; Dr = they owe you |
Customers list | Amount to Receive | Total of all customer Dr balances |
Suppliers list | Current Balance (Dr/Cr) | Per supplier; Cr = you owe them |
Suppliers list | Amount to Pay | Total of all supplier Cr balances |
Dashboard | Pending Payments: To Receive / To Pay | The same two totals, for the selected financial year |
Customer Invoice list | Balance Due, Age Days | Per invoice, not per customer |
What moves a customer balance
- Up (Dr): a customer invoice is saved, or an opening balance is entered.
- Down: a Customer Payment is recorded against the invoice (Against Voucher) or as an Advance Payment, a credit note is issued, or a journal voucher credits the ledger.
- An advance larger than the invoices turns the balance to Cr; it is auto-adjusted against future bills.
What moves a supplier balance
- Up (Cr): a Supplier Invoice for vehicle hire, a Purchase Invoice, a maintenance record with an unpaid Payment Type, or a fuel fill marked Not Paid.
- Down: a Supplier Payment, a debit note or a journal voucher.
- The Payment Status on the Supplier Invoice and Purchase Invoice lists (Paid / Partial / Unpaid) tells you which bills make up the balance.
The statements
Open Reports and pick from the Finance group. Each statement takes a Select Range (Current Month, This Financial Year or custom dates) and can be printed or exported to Excel.
Report | Shows | Use it to |
|---|---|---|
Single Customer Statement | Every invoice, receipt and adjustment for one customer, running balance | Send a statement of account to the customer |
Customers Balance Statement | One line per customer with the closing balance | See who owes you, in one list |
Single Supplier Statement | Every bill and payment for one supplier | Reconcile with the supplier’s own statement |
Suppliers Balance Statement | One line per supplier with the closing balance | Plan the week’s payments |
Customer Invoice Aging Report | Open invoices bucketed by Age Days | Chase the oldest first |
Supplier Invoice Aging Report | Open supplier bills by age | Pay before credit periods run out |
When the balance looks wrong
- Check the Opening Balance and Opening Date on the record first; a wrong sign there shifts every later figure.
- Open the Single Customer or Single Supplier Statement for the full financial year and look for a payment recorded as an advance when it should have been against an invoice.
- A supplier balance that is too high is often a fuel fill or a service saved as unpaid when it was paid in cash. Edit the entry’s payment status or type.
- The Ledger Report in Books shows the same ledger with the voucher numbers, which is the fastest way to find the entry to fix.
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.