A collection report lists the money a salesman or collection executive recovered from customers today, against which invoice, and how much is still due. The format below puts invoice number, amount collected, payment mode, balance outstanding and next follow-up in one sheet, so the owner can see cash in hand and pending payments together.
The columns a collection report needs
The key idea is that every collection is tied to an invoice. Money recorded against "the customer" in general is hard to reconcile; money recorded against INV-2033 is not.
| Column | Why it matters | Example |
|---|---|---|
| Date and collected by | When the money was received and who is accountable for it. | 30-09-2026, Rahul Shinde |
| Customer | Whom the payment came from. Same spelling as in your billing. | Kaveri Kirana |
| Invoice no. and date | Lets the accounts team match the payment to a bill and see how old that bill is. | INV-2033, 05-09-2026 |
| Invoice amount | The total on the bill, so the balance can be checked. | ₹38,000 |
| Collected | The amount received today, not the running total. | ₹20,000 |
| Mode | Cash, UPI, cheque or bank transfer. Each is deposited or verified differently. | Cheque |
| Cheque / reference no. | Needed to trace a bounced cheque or a missing UPI credit. | Cheque 004512 |
| Balance outstanding | What the customer still owes on this invoice after today. | ₹18,000 |
| Next follow-up | The date to call or visit again. Turns the report into a to-do list. | 07-10-2026 |
A filled-in example
Three customers visited on one round, with three different outcomes: paid in full, part payment and nothing.
| Customer | Invoice | Amount | Collected | Mode | Balance | Follow-up |
|---|---|---|---|---|---|---|
| Ambika General Store | INV-2041 | ₹24,500 | ₹24,500 | UPI | ₹0 | Closed |
| Kaveri Kirana | INV-2033 | ₹38,000 | ₹20,000 | Cheque | ₹18,000 | 07-10-2026 |
| Balaji Provision | INV-2028 | ₹15,600 | ₹0 | - | ₹15,600 | 02-10-2026 |
Collected today: ₹44,500. Still outstanding on these three invoices: ₹33,600. The third row is the one that matters most. A visit that collected nothing is still a row, with a reason and a date to try again.
Rules that keep the report honest
- Always quote the invoice number. Without it, two part-payments on different bills cannot be told apart.
- Balance = invoice amount minus all collected so far. If Kaveri Kirana pays another ₹10,000 next week, the new row shows a balance of ₹8,000, not ₹18,000.
- Record cheques with their number and date. A cheque is not cash until it clears; the reference is your only trace if it bounces.
- One row per payment. If a customer pays with ₹5,000 cash and ₹10,000 UPI, that is two rows, so each mode reconciles with the deposit or the bank statement.
- Log the promise. "Will pay Friday" in remarks, with a follow-up date, is what lets you say later that the customer missed their own date.
- Report the same day. Cash held overnight by a field person is a risk for them and for you, and a collection reported next week is rarely accurate.
Reconciling with the day's deposit
At the end of the day, filter the day's rows by mode and total each. Cash rows should equal the cash the person hands over or deposits. UPI rows should match the credits in the bank account. Cheque rows should match the cheques in the deposit slip, by number. In the example, the day's ₹44,500 splits into ₹24,500 UPI and ₹20,000 by cheque, with no cash to hand over. A gap at this step is much easier to trace on the same evening than at month-end.
Using the report to chase payments
Once a week, filter the sheet for rows where the balance outstanding is above zero and sort by invoice date. The oldest invoices come first, and those are the ones where the customer is most likely to stop answering calls. Then sort by next follow-up date, so each person starts the day with a list of who to call or visit. A collection report that is only filed and never filtered is just a diary; the follow-up column is what makes it a working tool.
Common mistakes
- Reporting only the total collected for the day, with no customer or invoice split.
- Skipping visits where nothing was collected, so no one knows which customers are avoiding payment.
- Writing "paid" without a mode, so the accounts team cannot tell what to expect in the bank.
- Adding the outstanding balance by hand in the field, which is where arithmetic slips creep in. Let the office calculate it.
Getting collections reported the same day
The format is easy. What breaks is timing: a collection executive who has been on the road all day types up the day at night, from memory, and half the cheque numbers are wrong. Capturing each payment at the counter, in seconds, is the better approach.
vBol does that over WhatsApp. After each payment the person sends a voice note to vBol's number, in their own language:
vBol transcribes it, reads the record back on WhatsApp in Kannada (or Hindi, Marathi, Tamil or whichever language was used) with buttons to confirm or fix a field, and writes nothing until it is confirmed. Confirmed records go into your Google Sheet, an Excel workbook on OneDrive or SharePoint, or Ekatm ERP, with a photo of the cheque and the GPS location attached if the sender adds them. The built-in sales visit record already carries the amount collected; a fuller collection record with invoice number, mode and balance is a record type Vritti sets up with you.
At 7 PM each evening owners and managers get one WhatsApp message: what was filed, by whom, and who sent nothing. No app, no login, no training for the field team. It is free for 30 days (up to 5 confirmed reports per person per day), then ₹199 per user per month for teams of up to 100 users; see pricing.
The free template on this page has these columns, dropdowns for payment mode, and three example rows. To record what was ordered in the first place, see the order booking format.
Frequently asked questions
What is a collection report?
A collection report records the money recovered from customers against their invoices: which invoice, how much was paid, by what mode, and how much is still outstanding. Field staff or collection executives send it daily.
What should a daily collection report include?
The date, who collected, customer, invoice number and amount, amount collected, payment mode, cheque or reference number, balance outstanding and the next follow-up date. A remarks column captures promises such as a payment date.
How do you calculate balance outstanding?
Balance outstanding equals the invoice amount minus everything collected against that invoice so far. If a customer pays in two parts, the second entry must subtract both payments.
Why record collections separately from sales?
A sale on credit and cash actually received are different for cash flow. Recording collections against invoice numbers shows which bills are old and who needs a follow-up.