A post-dated cheque tracker for UAE rental managers

The columns to keep

Copy these headings into your existing sheet. Use real spreadsheet dates, not text, so you can sort them reliably. Add a receipt reference only after the payment is confirmed and your receipt is issued.

Owner, building and unit

Identify whose rent this cheque covers. Keep one consistent unit reference.

Tenant and rent period

Record the tenant and the period covered, not just the cheque date.

Cheque number and bank

Store cheque numbers as text so leading zeros stay intact.

Amount in AED

Keep amounts numeric. Apply AED formatting separately so totals still work.

Cheque date

Copy the date written on the cheque. Keep it separate from the rent due date.

Rent due date

Copy the agreed due date from the lease or existing rent schedule.

Deposit date

Enter the actual date you deposited the cheque. Leave it blank until then.

Bank outcome and date

Record pending, cleared or returned, based on the bank’s confirmation.

Evidence reference

Reference your secure folder for the deposit record or bank confirmation.

Sample: deposited does not mean cleared

These fictional rows illustrate tracking only. They are not customer records or a working rent schedule.

In this example, confirmed rent received is AED 5,000, not AED 9,500. The first cheque stays pending until you verify the bank outcome. Keep pending amounts out of the owner’s received-rent total.

A short daily check

1. Filter upcoming cheque dates. Check the physical cheques and the relevant lease before planning deposits.
2. Update deposits from your actual records. Never fill deposit dates automatically from cheque dates.
3. Check pending deposits against bank confirmations. Record returned cheques and the bank’s stated reason separately.
4. Contact the tenant courteously about an unresolved payment. Keep the original cheque row and record any replacement payment separately.
5. Before updating an owner, reconcile confirmed receipts and repair costs. Flag pending or returned cheques without counting them as received.

Emirates NBD explains that clearing time depends on cheque type and deposit channel. Its guidance also lists reasons a deposited cheque can be returned. Read the bank’s cheque deposit guidance and confirm arrangements with your own bank. This is an operational tracking guide, not legal advice or a guarantee of clearing time.