In this guide 6 sections
The three numbers differ because each is written at a different moment by a different person. The diary records the promise made at the counter, Tally records the voucher the accountant posts later, and the owner’s notes record the phone call. One shared ledger, written once, removes the gap.
Three records, three moments in time
A salesman in Dewas writes the diary entry while standing at the shop. It holds what the retailer said: ten crates of sev now, cheque on Thursday. Nobody has checked it against a bill. A memory, not a voucher.
Tally gets the figure only when the accountant posts the sales voucher and the receipt, often a day or two behind the road. The owner’s notes come from a phone call with a distributor in Ratlam who swears the last cheque was handed over. Each record is honest for its own moment. That is the catch.
None of them is wrong alone. The trouble starts when a collection call quotes one figure while the distributor, standing in a Ujjain wholesale lane, remembers another and the argument eats the whole afternoon.
- Diary: promises, part payments, verbal credit extensions
- Tally: posted invoices, receipts, journal entries
- Owner’s notes: calls, favours, festival concessions
- Bank statement: what actually cleared
Where the numbers drift apart
Most drift comes from a handful of repeat causes. A scheme credit note promised for Diwali is agreed on the phone and never posted. A post-dated cheque sits in the drawer, counted as paid in the diary and as due in Tally.
Returns of stale namkeen packs travel back on the same truck, and the debit note reaches the accountant a week late. Freight deducted by the distributor at payment time never reaches the diary. Small, silent, constant.
Rounding is the smallest cause. It is also the loudest. A distributor pays the nearest hundred, the salesman writes the full figure, and the ledger keeps a stubborn balance that nobody will chase.
- Cheques received but not yet deposited
- Cheques bounced after the diary entry
- Scheme and discount credit notes agreed verbally
- Returns and breakage not yet posted
- Freight or cash discount deducted at payment
Why the owner’s number never matches
The owner often carries the freshest news and the thinnest detail. A call on Sunday evening changes the picture. It leaves no voucher.
So the owner quotes a fair figure that nobody can trace. The accountant defends the Tally balance. The salesman defends the diary. Everyone loses an hour arguing about which is right instead of calling the distributor.
Ask one question in your next review: for one named distributor, can all three people show the invoice numbers behind their figure? If they cannot, you have found the problem.
One shared ledger under every call
The fix is not a better diary. Nor is it a stricter accountant. The fix is one ledger where the salesman enters the promise, the accountant matches the voucher and the owner sees the same line. Each distributor shows invoices, receipts, credit notes and promised payment dates in a single running statement.
Tally can stay as the books of record. The shared ledger feeds it, so nothing is typed twice. A collection call then starts from a statement that the salesman, the accountant and the owner all trust.
Add a dispute flag to each invoice. When a Malwa distributor questions a line, the flag holds the reason and the date. The figure stops drifting.
- Salesman enters order, promise date and part payment in the field
- Accountant matches each receipt to invoice numbers
- Owner sees ageing by distributor on a phone
- Disputed lines are tagged, not buried in the balance
A first step you can take this week
Pick your five slowest-paying distributors across Malwa and Nimar. Photograph the diary pages, export the Tally ledger and write down the owner’s figure for each.
Lay the three side by side. Mark every line that appears in only one. Group the gaps under the causes above. You will usually find that two or three causes explain most of the difference.
Bring the sheet to the next sales meeting. Agree who posts what, and by when. That agreement becomes the specification for any software you choose later, so write it down while the examples are fresh.
Distributor dues reconciliation sheet
One distributor takes each line of a single sheet, and six columns follow: diary figure, Tally figure, owner’s figure, difference, cause of difference and who closes it. A strip below lists the usual causes to tick: uncleared cheque, scheme credit note, return not posted, freight deduction, rounding. A last box records the agreed fix and date.
Open a blank worksheet to printQuestions owners ask
Why does Tally show a different balance from my salesman’s diary?
Tally holds only what the accountant has posted. The diary holds promises and part payments made on the road. Cheques in hand, verbal credits and unposted returns sit in one record and not the other.
Which of the three numbers should I trust?
None until you trace the invoice numbers behind each. The bank statement is the final check for money received. The rest are partial views that need matching.
Do I have to give up Tally to fix this?
No. Keep Tally for accounts and let a shared ledger feed it. The point is that entries are made once, close to where the event happened.
How often should dues be reconciled?
Weekly for your slowest payers and monthly for everyone else. A short weekly sheet catches drift while the distributor still remembers the cause.