Step by step
- Open Contacts > Date Wise Customer Due.
- Choose the shop (only for users who see all shops), Customer, Customer Group, From Date and To Date, then press Filter. Leave both dates empty to see every transaction.
- Each row is one customer: Total Sale, Sales Return, Purchase, Purchase Return, Received, Paid, Others and Due.
- Due = Total Sale - Sales Return - Purchase + Purchase Return - Received + Paid + Others, from the transactions of the period only.
- Print prints the whole report of the filters. Excel and Pdf export the rows shown on the screen.
Good to know
- A customer whose due of the period is 0 is not listed. A minus due is an advance (more was received than sold).
- Purchase, Purchase Return and Paid are there for a customer you also buy from or pay. Others are journals, exchanges and the other entries of the customer's ledger.
- The figures come from the customer's ledger, so they agree with the Customer Ledger of the same dates (without its opening balance).
- Enter both dates or neither. The shop is the shop where the transaction was made.
- Needs the permission Date Wise Customer Due Report.