Cash flow
How should distributors and manufacturers reconcile payments?
How should distributors and manufacturers reconcile payments and plan cash flow?
Match customer receipts to outstanding invoices, then reconcile the payment or settlement references against the bank statement. Explain fees, refunds, deductions and timing differences separately, and assign each unresolved item to a person. Use confirmed balances and realistic collection dates to build a weekly cash-flow forecast alongside supplier, payroll and other payment commitments. Sales, customer payments and cleared bank funds are different stages of the same process.
Key takeaways
- Match invoices, receipts and bank entries without counting a settlement as a second customer payment.
- Separate disputed deductions, unallocated receipts and settlement timing differences.
- Forecast using expected cash dates; invoice dates and profit do not determine available bank funds.
- Review overdue dealer balances and near-term supplier commitments together every week.
Why payment reconciliation deserves attention
Distributors may collect against several dealer invoices in a single transfer. Manufacturers may receive advances, part payments and final balances on different dates. A gateway can combine many payments into one settlement. Looking only at total sales or bank credits makes it hard to answer which invoices remain unpaid and which receipts are still awaiting settlement.
For background, the Reserve Bank of India's July 2024 chapter on digital payments describes India's payment ecosystem and adoption. It is historical context, not evidence of current search demand or an endorsement of this guide. The checklist below is an illustrative workflow you can test with a spreadsheet or your existing accounting system; adapt it to your records and provider's settlement statement.
Build a record that connects each stage
| Record | Fields to retain | Purpose |
|---|---|---|
| Invoice | Customer, company, invoice number, date, due date, balance | Establish what the customer owes |
| Receipt | Receipt ID, date, payer, amount, reference, invoice allocations | Explain which balances the payment clears |
| Settlement | Provider, settlement ID, gross payments, deductions, net amount | Bridge collected payments to bank funds |
| Bank entry | Account, date, amount, reference | Confirm money reached the relevant account |
| Exception | Difference, reason, owner, evidence, next review date | Keep unresolved items visible |
Keep original identifiers and source files. A bank narration can be shortened, and two customers can pay the same amount on the same day. Amount and date are useful matching hints, but do not establish identity alone. Ask for a remittance reference when needed. If a customer uses another entity's account, verify the payer relationship before clearing the customer balance.
Allocate dealer receipts before chasing balances
Consider an illustrative dealer with invoices of ₹40,000, ₹35,000 and ₹25,000. A ₹60,000 receipt can clear the first invoice and ₹20,000 of the second if that allocation agrees with the remittance advice or your documented policy. The remaining balances are ₹15,000 and ₹25,000. Record the allocation explicitly so that the collections team does not chase the fully paid invoice or describe the remaining ₹40,000 as a new sale.
A short payment needs its own explanation. The dealer may refer to a return, discount, tax deduction or quality claim. Obtain the supporting document and have the accounting team determine the correct treatment. Do not silently write off the difference to make reconciliation appear complete. Equally, an unallocated receipt should trigger an identification task before the team sends another overdue reminder.
Explain the difference between collections and settlements
Expected net settlement = gross payments in the settlement batch − refunds − charges − other supported deductions + supported adjustments
Use the provider's actual settlement statement. A deduction must have an explanation; this is a reconciliation relationship, not a fee or tax rule.
| Component | Amount |
|---|---|
| Gross customer payments | ₹1,00,000 |
| Refunds included in this batch | −₹5,000 |
| Documented charges, including any applicable tax | −₹2,360 |
| Expected bank settlement | ₹92,640 |
| Actual matching bank credit | ₹92,640 |
| Unexplained difference | ₹0 |
The lower bank credit in this example is explained by the settlement statement. It does not by itself mean the business lost a customer payment. Retain the gross receipt, refund and charge records so the accountant can post them appropriately. If the credit arrives in the next reporting period, track it as a timing item and clear it when the bank entry appears. Do not book the gross customer payment and its bank settlement as two separate collections from that customer.
Give each exception a next action
- Payment reported by the customer but absent from bank records: check the transaction reference and receiving account; a screenshot alone is not cleared funds.
- Bank credit without an identified invoice: record an unallocated receipt and investigate the payer and remittance details.
- Net amount differs from the settlement report: compare refunds, charges, holds and adjustment references before escalation.
- Dealer deduction or returned goods: obtain approved documentation and keep the dispute separate from an unexplained payment shortage.
- Repeated import or duplicate reference: compare the source transaction before creating, reversing or deleting a financial entry.
Use a daily review for high-volume collections and a weekly review for unresolved items. Choose the cadence according to transaction volume and risk. Record the date first seen, the amount, the person responsible and the next check. The owner's dashboard should show both the unresolved amount and the age of those items, because a stable total can conceal old issues being replaced by new ones.
Turn reconciled balances into a weekly cash plan
Begin with cleared, usable funds in the relevant accounts. Add expected collections by likely receipt week, distinguishing confirmed commitments from uncertain overdue invoices. Put supplier payments, salaries, freight, utilities, taxes, instalments and planned equipment payments into their expected cash weeks. Use the same scope throughout the forecast and avoid counting transfers between your own included accounts as fresh external cash.
Closing cash = opening usable cash + expected cash receipts − planned cash payments
Carry each closing balance into the next week's opening balance. This is a planning estimate, not a profit calculation or financing recommendation.
Suppose a manufacturer starts a week with ₹2,00,000, expects ₹3,00,000 of dealer collections and has ₹4,00,000 of payments planned. The expected closing balance is ₹1,00,000. If a dealer's ₹1,50,000 payment moves to the following week, the revised balance is negative ₹50,000. Model the delay before spending against the expected collection. Review the documentation, follow up on the commitment and discuss any changes to payment timing with the responsible people.
Connect inventory purchases to available cash
A large purchase discount can look attractive while creating a cash gap or expiry exposure. Review usable stock, existing purchase orders, realistic sales demand and payment dates before placing another order. Manufacturers should connect raw-material purchases to the production plan and the expected collection dates for finished goods. Distributors should look at slow-moving stock beside dealer outstanding balances, since both can hold up cash needed for replenishment.
Separate necessary production inputs from speculative purchases when reviewing a shortfall. This does not mean cancelling commitments or delaying suppliers without agreement. It means showing the owner which assumptions depend on collections arriving on time. The manufacturing owner dashboard guide and ERP budget guide help connect operational reports to measurable decisions.
Evaluate automation with a representative pilot
Choose a normal set of receipts that includes a split allocation, a partial payment, a refund, a duplicate import and a settlement crossing a period boundary. Compare invoice balances, receipt totals and bank reconciliation before and after the pilot. Measure unresolved items and correction time alongside the time saved. A high automatic-match rate is not useful if the matches clear the wrong dealer balances.
For a Naffo evaluation, bring this sample to a distributor workflow discussion or book a demo. Confirm the supported receipt, report and integration workflows for your setup. This guide does not promise a live bank feed, automatic gateway matching or invoice financing. Establish the review and reconciliation process even when imports or allocations require a manual step.
Frequently asked questions
Does a lower bank settlement mean a customer has underpaid?
Not necessarily. A settlement can include several payments and deduct documented refunds or charges. First compare it with the settlement report, then investigate any remaining difference before changing customer invoice balances.
Can I match a receipt using only the amount?
Use more than the amount when possible. Compare the customer, reference, date and remittance advice, especially where dealers pay identical invoice totals or use a single transfer to settle several invoices.
Why can profit increase while cash becomes tighter?
Profit and cash measure different things. Sales may remain unpaid while stock purchases, supplier commitments and other cash obligations fall due. A weekly forecast shows payment timing that a sales or profit total alone cannot explain.
This page also answers
- Why is a bank settlement lower than customer payments?
- How should one dealer payment be allocated across invoices?
- Why can a profitable manufacturer run short of cash?
References
Run this inside one system
naffo.tech is an all-in-one business management and manufacturing platform for Indian SMEs: versioned recipes and BOMs, batch-wise material issue under FEFO, yield, by-product and reason-coded wastage capture, in-process and finished-goods QC, batch traceability to dispatch, GST invoicing with e-invoice and e-way bill, and double-entry accounting that closes live.
Related answers
Business planning
Which business trends matter for distributors and manufacturers in 2026?
Which business topics should Indian distributors and manufacturers explore in 2026?
ERP selection
How to evaluate accounting and operations software for distributors
How should a distributor or wholesale trader in India evaluate accounting and operations software?
Business operations
The five-minute owner dashboard: run your business without doing everything yourself
How should a business owner manage a manufacturing business more efficiently?