PETTY CASH LOG 5% Excel
Home / Templates / Petty cash log
Free · no sign-upChecked 20 Nov 2026Expenses and cash

Petty cash log with VAT split

A float, a voucher per spend and a running balance. The Excel version adds up, splits VAT and tells you how much to top up.

CBUAE FX rateson foreign lines
Short answer

Keep a fixed float (say AED 2,000), log every spend with a voucher number, date, payee, purpose, net, VAT and total, and top the float back up by exactly what was spent. The format is practice, not law. The law bites on what you claim: input VAT only with a valid tax invoice, no VAT back on client entertainment (VAT Executive Regulation Article 53), only 50% of entertainment deductible and fines not deductible for corporate tax (Corporate Tax Decree-Law Articles 32 and 33).

01What goes on it

What does the law require, and what is just good practice?

Every line is marked. "Law" means a UAE law, decree or regulation says it, with the article. "Practice" means it is common and sensible, but no rule requires it.

ItemStatusWhere it comes from
Voucher number, date, payee, purpose, amountPracticeStandard imprest method; no prescribed format
Receipt kept for every spendLawRecords must support your returns: 5 years VAT (FTA guide), 7 years CT (CT Art. 56)
Input VAT claimed only with a valid tax invoiceLawVAT ER Art. 59; FTA tax obligations guide
No input VAT on entertainment for non-employeesLawVAT ER Art. 53
Client entertainment 50% deductible for corporate taxLawCT Decree-Law Art. 32
Fines and penalties not deductibleLawCT Decree-Law Art. 33(2)
Cash payments above a threshold may lose input VAT (threshold not yet set)LawCabinet Decision 149 of 2026, effective 1 Oct 2026; Ministerial Decision on the amount still awaited (Nov 2026)
Law stated in legislationPractice common, not required
02Preview and how to fill it

See it filled in, then make it yours

Switch between the worked example and the blank version you download. Example figures are illustrative.

Petty cash logNovember 2026
CompanyDune Studio LLC (example)
CustodianA. Rahman
Opening float (AED)2,000.00
DateVoucherPaid toWhat forNetVATTotalTax inv.Balance
02 NovPC-001ENOCFuel, delivery van142.867.14150.00Yes1,850.00
04 NovPC-002CarrefourOffice tea and water80.004.0084.00Yes1,766.00
09 NovPC-003RTAParking fine (not deductible)500.000.00500.00n/a1,266.00
12 NovPC-004AramexDocuments to client40.002.0042.00Yes1,224.00
15 NovPC-005RestaurantClient lunch (VAT blocked, 50% CT)190.489.52200.00Yes1,024.00
Total spent (AED)976.00
Top-up needed to restore float (AED)976.00
Custodian
Approved by

Example company and figures are made up. Replace every grey hint with your own details.

01

Fix the float

Pick an amount that lasts about a month. AED 1,000 to 3,000 suits most small offices.

02

Voucher for every spend

Number in sequence, staple or photograph the receipt, write what it was for.

03

Split VAT only where there is a tax invoice

A fuel receipt from ENOC with its TRN: yes. A taxi with no receipt: put the whole amount in Net and VAT 0.

04

Top up by what was spent

Cash in the box + vouchers = float. If not, find the gap before topping up.

03Common mistakes

What we see go wrong

Small slips that cost VAT, fines or an argument with a customer or employee.

!Claiming the VAT on a client lunch. Entertainment for non-employees is blocked for VAT.
!Booking traffic fines as "transport". They are not deductible for corporate tax.
!Paying suppliers large amounts in cash. From 1 October 2026 the VAT rules can deny input tax on cash payments above a threshold that is still to be announced.
!Topping up a round AED 1,000 instead of the actual spend, so the float drifts.

Or let the numbers fill themselves.

fylng reads your UAE bank exports and receipts, sorts every line under UAE rules and builds the VAT201 and a corporate tax estimate. Free to start. You still file on EmaraTax.

See how it works
FAQPetty cash log

Questions people ask

Is there a legal format for a petty cash book in the UAE?+

No. The format is up to you. What the law requires is that your records support your VAT and corporate tax returns and are kept for 5 and 7 years respectively.

Can I claim VAT on petty cash receipts?+

Yes, where the receipt is a valid tax invoice (a simplified tax invoice is fine for small amounts) and the expense is not blocked, such as client entertainment.

Are cash payments still OK for VAT?+

Cabinet Decision 149 of 2026, effective 1 October 2026, lets the rules deny input tax on supplies above a threshold paid in cash. As of November 2026 the threshold had not been published. Pay suppliers by card or transfer where you can.

How do I treat a traffic fine paid from petty cash?+

Record it, but not as a deductible expense: fines are not deductible for corporate tax (Article 33). There is no VAT on it.

Sources

Facts checked 20 Nov 2026. Official sources first; press and Big-4 summaries are marked. English texts of UAE laws are translations; the Arabic text prevails. This template is not legal or tax advice: rules change, so confirm with the FTA, MoHRE or your authority.

  1. VAT Executive Regulation, Cabinet Decision 52 of 2017 and amendments (FTA): Art. 53 blocked input tax, 59 tax invoice particulars, 60 credit notes, 61 rounding, 64 return deadline
  2. Federal Decree-Law No. 47 of 2022 on Corporate Tax (MoF English text): Art. 3 rates, 21 Small Business Relief, 32 entertainment, 33 non-deductible, 37 losses, 53 returns, 56 records
  3. MoF: Cabinet Decision 149 of 2026 amending the VAT Executive Regulation: effective 1 Oct 2026; cash-payment threshold still awaited
  4. FTA: Get to know your tax obligations: returns, 28th-day rule, record keeping

Upload statements,
receive a filed return.

ارفع كشوفك، واستلم أرقام إقرارك جاهزة.

Start free
دقةأمانشفافيةوفق أنظمة دولة الإمارات

fylng is UAE accounting software by DueDoor for VAT, corporate tax and bookkeeping, built for businesses in Abu Dhabi, Dubai, Sharjah, Ajman, Umm Al Quwain, Ras Al Khaimah and Fujairah. Privacy · Terms · llms.txt