How to track the cash your sales team and technicians collect

To track the cash your team collects, give every collector their own running balance, record each collection against an invoice with a receipt, hand it over the same day, and reconcile daily. Above all, treat cash as "collected, awaiting deposit" until it's in the bank, not as paid.

In the UAE a lot of money still changes hands in person: a technician paid on site, a driver collecting on delivery, a salesperson handed cash at a customer's office. This is how to stop it getting lost between the customer and the bank.

Why field cash goes missing

It's rarely theft. More often it's one of these:

• The cash is collected but never recorded, because the rep meant to log it later.
• It's recorded against the wrong invoice, so one customer looks paid and another looks overdue.
• It sits in a rep's car for a week, and the invoice shows "paid" the whole time.
• Three people keep their own copy of the cash sheet, and no copy is complete.

All four have the same fix: one record, written at the moment of collection, that says where the cash is right now.

A simple system that works

1. One collector, one balance. Every person who collects cash has their own running balance: what they've collected and not yet handed over.
2. Every collection against an invoice. Record the customer, the invoice number and the amount at the moment of collection, from the phone, not later from memory.
3. A receipt every time. The customer gets a receipt and the record keeps its number. No receipt, no collection.
4. Hand over the same day. Cash goes to one named person (the office, or accounts), and the handover is recorded with the time.
5. Two statuses, not one. "Collected, awaiting deposit" when the rep takes it; "banked" only when the deposit is confirmed.
6. Reconcile daily. Cash on hand plus deposits should equal collections. A difference today is a five-minute question; a difference at month end is an investigation.
7. Keep the records. Collections, receipts and deposit slips are part of your accounting records; ask your accountant how long UAE tax law requires you to keep them.

Doing it in a spreadsheet

You can run this in Excel or Google Sheets with one row per collection and these columns: date, collector, customer, invoice number, amount (AED), payment method, receipt number, handed over to, handover time, deposit date, and status (awaiting deposit or banked).

It works while one person maintains the sheet. It breaks when reps keep their own copies, when someone forgets to log a collection, or when the sheet and the invoices live in different places, because then "paid" means different things in each.

Doing it in a system

In SARZ Command, a rep or technician records a payment from their phone against the job's invoice, as cash, bank transfer, card or cheque, in full or in part. Cash is marked awaiting deposit until it's banked, so the owner's screen shows cash collected but not yet in the bank, per person, and the invoice, the payment and the job stay in one place. Full or partial payments, receivables aging and one-click WhatsApp payment reminders are on the same screen.

If cash collection is a daily headache in your business, book a 20-minute demo and we'll show you how it would work for your team.