Site expenses and cheques: how a UAE contractor reconciles them without losing a week a month

Why does site cheque reconciliation take so long in the first place?

Because the receipts and the cheque never meet until someone forces them to. The office issues a cheque to a site. The site spends it over the following days or weeks on small purchases: a materials top-up, a taxi or fuel run, an extra day of labour, a permit fee. Every one of those produces a paper receipt or a hand-written invoice, and the pile comes back to the office days or weeks later, sometimes at the end of the project.

Someone then has to re-type every receipt into Excel, work out which cheque it belongs to, and add it up against what the bank shows. On a contracting business running several sites and several cheques at once, that is not a ten-minute job. It is the kind of work that eats a week a month, and it eats it precisely when the office also needs those numbers for a client report or a cost review.

We saw this directly with a contracting business in Abu Dhabi. The reconciliation was already being done, carefully, by hand. The problem was never the arithmetic. It was that nothing carried the cheque and the project with it until a person typed it in.

What actually goes wrong when it is done by hand?

A few patterns repeat, in our experience and in what the accounting side of the business told us.

• Receipts land against the wrong cheque. Two cheques open at once, one receipt, easy to file under the wrong one when nothing on the receipt says which cheque it belongs to.
• The running balance drifts from the bank. A missed entry, a duplicate entry, and the amount still in hand figure quietly stops matching reality.
• A cheque closes with money unaccounted for. The project moves on, the cheque is treated as spent, and nobody can say where the last few hundred dirhams went.
• The same receipt gets entered twice. Especially when more than one person touches the same pile of paper.
• What did this project actually cost us in site cash takes days to answer. Because the answer is scattered across receipts, not sitting in one place.

None of this is about anyone being careless. It is what happens when the record of a purchase and the record of the cheque that paid for it are two separate pieces of paper that only meet at month end.

What did we build, and how does it work?

We describe this as an approach, not a product, because the first version needs nothing more than a spreadsheet done right.

One Excel table holds every receipt as a row. Each row carries the cheque number and the project it belongs to, alongside the amount, the date and what it was for. Because the cheque number sits on the row itself, there is no separate step where someone has to remember or guess which cheque a receipt belongs to.

From that one table, three things fall out automatically:

• A running balance per cheque. Every time a receipt is added, the sheet shows what is left in hand against that cheque, so the site and the office are looking at the same number.
• A per-cheque summary. One line per cheque showing what was issued, what has been spent, and what remains, instead of scrolling through every receipt to work it out.
• A one-cheque statement that prints with the project name as the header. When a cheque closes, this is the single document the office and the site agree on, rather than a stack of loose receipts and a separate summary someone typed up.

This is the same fix we describe in the Excel sheet that quietly became the system: the sheet was never the problem, the missing structure inside it was.

What does the next step up look like?

Once the same table is doing its job, the next step is usually the same table feeding a small system rather than a shared file. Receipts get photographed on site and matched to the cheque as they happen, instead of arriving in a pile weeks later. The office sees the balance live, not at month end, and the question what did project X cost us in site cash has an answer the moment it is asked instead of a day or two later.

That step is worth taking once a business is running several sites and several cheques at once and the reconciliation lag starts costing real time every month. Before that point, the spreadsheet version does the job.

Is this a problem specific to cheques?

Not really. The same paper-to-Excel double entry shows up across UAE trades wherever a document has to be typed twice before anyone can use it. Our post on why UAE subcontractors lose money on paperwork covers the same pattern one level up, in the correspondence chain behind a single site instruction.

Site cheque reconciliation is often the smallest version of that same problem, and the cheapest one to fix first. Get one table with the right structure working, and the bigger document-control question in the post above gets easier to see clearly.

What about VAT records and the paper trail?

Most site purchases produce a simplified tax invoice rather than a full VAT invoice, since the supplier is usually selling to a buyer who is either unregistered or buying under AED 10,000 in that transaction. Whatever the invoice type, the FTA requires VAT records, including invoices received, to be kept for a minimum of five years from the end of the relevant tax period. A reconciliation table that keeps every receipt attached to its cheque and project also happens to be the retention record an audit would ask for. Confirm the specifics for your business with your accountant; we are not a tax adviser.

What if a site cheque bounces?

We keep this post to the bookkeeping side of cheques, not the legal side, but one change is worth knowing about if it comes up. Since amendments to the UAE Commercial Transactions Law took effect in January 2022, a bounced cheque no longer carries automatic criminal liability in most cases; that is now reserved for bad faith, with administrative penalties, such as losing chequebook privileges, applying otherwise. The paying bank is also required to pay what funds allow if a cheque cannot be honoured in full, unless the person presenting it refuses partial payment. Anything beyond bookkeeping on a bounced cheque is a conversation for a lawyer, not this post.