What this DSR evening settlement checklist is for
This free checklist helps distributors, dealers, wholesalers, supervisors, and field-sales teams close one DSR route consistently at the end of the day. It is software-neutral: print it, copy the fields into your own spreadsheet, or use the downloadable bilingual CSV. Complete one settlement record for each DSR, route, and date rather than combining several representatives or days into one total. The objective is to make the route explainable from morning responsibility to evening handover. Issued stock should reconcile with sales, returns, transfers, and remaining quantities. Shop transactions should explain sales and collections. Cash and digital payments should match the amounts actually received or handed over. Any difference that cannot be resolved should remain visible as an exception instead of disappearing into an adjustment.
1. Identify the DSR, route, and settlement date
Start by identifying exactly which route is being closed. Record the settlement date, DSR name or ID, route or territory, vehicle where applicable, morning issue reference, departure time, return time, and responsible supervisor. If your business uses shift, depot, warehouse, or route-code references, include those as well. Do not combine two DSRs, two routes, or two dates in one settlement simply because they returned at the same time. The route identity is what allows later stock, collection, and cash differences to be traced back to the correct person and period. If the morning issue document, route reference, or another required starting record is missing, mark that as an exception before continuing rather than creating an assumed reference.
2. Reconcile issued, sold, returned, and transferred stock
Reconcile stock product by product. Record the morning issued quantity, approved extra issue or incoming handover, quantity sold or delivered, good return, damaged return, transfer or handover out, and any unexplained shortage or excess. Use the same unit consistently. If your business works with cases and pieces, record the case-to-piece conversion clearly so that a full case is not accidentally compared with a single piece. A useful quantity check is: accountable quantity = sold or delivered quantity + good return + damaged return + approved transfer or handover + remaining or unresolved quantity, adjusted for approved extra issues where applicable. Physically count returned stock before the settlement is approved. If the calculated quantity and physical quantity do not agree, keep the difference visible until the issue, sale, return, damage, or transfer record explains it.
3. Match each shop's sales, dues, and collections
A route total is difficult to investigate without shop-level detail. For every visited shop, record the shop or customer reference, invoice or delivery reference, today's sale, cash sale, digital payment where applicable, due sale, collection against an older due, discount, sales return, and closing shop balance. Keep receipt, collection, or payment references beside the relevant shop entry. Today's new sale and collection against a previous due should remain separate because they answer different questions. A shop can pay an old balance without buying anything today, or it can buy on due without giving the DSR cash. When those events are mixed into one collection total, both route performance and customer balances become harder to verify.
4. Reconcile expected cash and non-cash handover
Calculate how much physical cash the DSR should hand over from the route. Start with cash received from today's sales and cash collected against older dues. Add other approved route cash receipts where applicable, then subtract only genuine approved cash-outs such as documented route expenses, customer cash refunds, or authorized cash handovers. Compare the expected amount with the physical cash actually received. Record digital or bank payments separately with their transaction or deposit references because they are not physical drawer cash. Where useful, count physical cash by denomination and identify the person receiving it. Record handover time as well. If expected cash and actual cash differ, write the variance and investigate it. Never silently carry a shortage or excess into the next day's route.
5. Calculate the closing shop and DSR balances
After stock and collections are reviewed, calculate the balances that remain open. For shop balances, start with the approved opening due, add today's due sales, and subtract verified collections, accepted return credits, and other approved adjustments according to your business process. If your organization also maintains a separate DSR accountability or due balance, use the documented company formula consistently. A simple structure may begin with approved opening DSR due, add today's accountable value, and subtract verified returns, collections, deposits, transfers, and other approved settlement adjustments. Record both the calculated closing amount and any balance acknowledged by the DSR. If the two amounts differ, keep the difference visible with the reason, evidence required, responsible person, and follow-up date.
6. Review settlement exceptions before sign-off
Do not treat a zero total as proof that the route is correct. Review exceptions before approving the settlement. Examples include missing shop visits, missing receipts, duplicate invoice or payment references, unauthorized price or discount overrides, damaged returns without physical goods, unexplained stock shortage or excess, cash shortage or overage, unconfirmed digital payments, disputed shop balances, missing route expenses, late settlement, and edits made after the DSR submitted the route. Also review unusual returns, repeated manual adjustments, and transfers without a confirmed receiving person. An unresolved exception with a clear owner and supporting notes is better than changing an unrelated transaction simply to force the route to balance.
7. Complete supporting documents and approvals
A useful settlement record should point to the documents that support its totals. Attach or reference the morning issue, invoices or delivery records, collection receipts, customer-return records, damaged-stock evidence, approved route expenses, bank or mobile-payment references, deposit proof, cash-receipt or handover record, stock-transfer references, and exception notes used by your business. The appropriate DSR, cash receiver or accounts person, stock verifier, and supervisor should sign or digitally approve according to the company's process, ideally with date and time. Preserve the original settlement and later corrections according to your record-retention policy so that a future review can distinguish the original submission from an approved correction.
8. Use three equations before supervisor sign-off
First reconcile quantity: Issued stock + extra stock received - shop deliveries - good returns - damaged returns - approved handovers = unexplained stock difference. Second reconcile physical cash: Cash sales + cash collections against old dues + other documented cash received - approved route expenses - cash refunds - cash deposited or handed over earlier = expected cash now. Third reconcile responsibility: Opening DSR due + new accountable value - verified collections - accepted returns - deposits - approved adjustments = expected closing DSR due. Use consistent units and keep digital payments outside physical cash. A zero in one equation does not prove the other two are correct.
9. Test the checklist with one controlled route
Before adopting the sheet across the team, run it for one DSR and one normal route day. Ask a different person to reproduce the closing figures from the attached issue, invoice, collection, return, expense, deposit, and handover references. Note every field that needed a phone call or an extra spreadsheet, then clarify that field and assign an owner. Test a second day containing at least one due sale, one old-due collection, one return, and one non-cash payment. The checklist is ready only when another reviewer can understand the route without relying on memory.
10. Adapt it to your business
Remove fields your route does not use and add controls required by your products, payment methods, return policy, or approval structure. Test the checklist on one route before rolling it out. This operational template is not accounting, tax, employment, or legal advice; ask the appropriate professional to review policies and statutory records.
