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.
Get your books in order this month
Tell us about your business and get a fixed monthly quote within one business day.