Free bookkeeping Excel template for UAE small businesses
A simple small-business bookkeeping spreadsheet with UAE VAT built in: record sales and expenses, and see your monthly profit and VAT payable automatically.
What's in the spreadsheet
- Sales sheet: invoice, customer, net amount, 5% VAT and total
- Expenses sheet with 17 ready-made expense categories
- VAT rate per line, so zero-rated and exempt items are easy
- A "VAT recoverable?" column for blocked expenses
- Monthly summary: sales, expenses, profit and VAT payable
- Quarterly VAT totals for your return
Outgrown your bookkeeping spreadsheet?
Excel works when you're starting out. As your business grows, a spreadsheet gets harder to reconcile with your bank and riskier at VAT and Corporate Tax time. BooksGem can move your records into Zoho Books, Xero or QuickBooks and keep them up to date every month.
See our monthly bookkeeping service →Frequently asked questions
Is this bookkeeping Excel template really free?
Yes. Download it, use it and share it. It works in Microsoft Excel, Google Sheets, Numbers and LibreOffice.
Can I use it to file my VAT return?
The Summary sheet shows your output VAT, recoverable input VAT and the net amount for each month and quarter, which you can use to prepare your return. Check zero-rated, exempt and reverse-charge items carefully, or let us file it for you.
When should I move from Excel to accounting software?
Once you have more than a few dozen transactions a month, more than one bank account, or you're VAT-registered and holding stock, software like Zoho Books, Xero or QuickBooks saves time and reduces errors. We can set it up and migrate your spreadsheet.
Guides for UAE businesses
Bookkeeping for Small Business in UAE: Step-by-Step Guide
Eight simple steps to set up and keep bookkeeping for a UAE small business, with basic examples and the UAE-specific rules you need.
Read the guide →What Is Bookkeeping? A Guide for UAE Business Owners
The meaning of bookkeeping, what a bookkeeper actually does each month, and why UAE businesses can't skip it.
Read the guide →Double-Entry Bookkeeping Explained (With UAE Examples)
Debits, credits and the accounting equation explained simply, with worked journal entries for everyday UAE transactions.
Read the guide →Get your books in order this month
Tell us about your business and get a fixed monthly quote within one business day.