Loading…

Free once a day · Unlimited for Premium members

Accounts Receivable Tracker

The Accounts Receivable Tracker takes a list of unpaid invoices and sorts them by how late they are. It shows how much is overdue, which customers hold the most of it and drafts a polite reminder for each late account. Small UAE businesses use it every week to get cheques and transfers moving without damaging the relationship.

Format and what you get

  1. One invoice per line: customer, invoice number, amount, invoice date (YYYY-MM-DD), and payment terms in days. If you leave terms out, 30 days is used.
  2. Each invoice is placed in an ageing bucket by how many days it is past its due date.
  3. You get totals, a customer ranking and a reminder message for each customer with overdue invoices.
  4. Copy the reminders into email or WhatsApp. Nothing is sent from this page.

Paste unpaid invoices

Free members can run this once a day. Premium members have unlimited use.

A cleaning company with four customers

A cleaning company in Sharjah invoices on 30-day terms. Two customers are paying on time, one is a couple of weeks late and the largest account is now more than two months overdue.

What the tool gives back for these figures

AED 64,600 is outstanding and AED 46,200 of it (72%) is past due. Start with Al Safa Properties.

Outstanding
AED 64,600
Overdue
AED 46,200
More than 90 days late
AED 0

Most of the problem sits with one customer. That is where the first phone call should go, before any message.

A word on chasing

A reminder works best when it is early, specific and friendly. Quote the invoice number, the amount and the date it was due, and offer a way to pay. Save firmer wording for after a phone call has been tried. Leave legal steps, including bounced cheque procedures, to a lawyer.

Questions people usually ask

What is an ageing report?

It groups unpaid invoices by how overdue they are, usually in bands of 30 days. It shows quickly whether money is merely slow or properly stuck.

When should I start chasing?

The day after the due date is fine. A short, friendly note is not rude, and early contact gets paid faster than waiting for a month.

Is the data stored?

No. Names and amounts are used for the report and then discarded.

What if an invoice has partial payments?

Enter only the amount still owed on that line and keep the original invoice date, so the ageing stays accurate.

How does this help when buying a business?

Ask the seller for their ageing report. Large amounts older than 90 days often will not be collected, and you should not pay full price for them.

Results rely only on what you enter. Check the figures against the seller's accounts, the lease and the trade licence, and take professional advice before you commit money. This is not a formal valuation, legal or tax advice.

Layla AISell your business free AI valuation✕
Top