I will create a uae vat invoice and stock tracker in excel for your small business
Resume Writer, Excel and Ecommerce Specialist
About this Gig
Running a small shop or trading business in the UAE and still writing invoices by hand? I will set up a simple Excel (or Google Sheets) system for you.
What you get:
1) A clean tax invoice with your logo, TRN, invoice number, date and 5% VAT on every line
2) Sales log and purchases log
3) Stock that updates automatically, with reorder alerts
4) Monthly sales and output VAT on one summary sheet
5) Formulas only (no macros), plus a short how-to guide
I set it up with your own products and details. After ordering, send me your business name, TRN and product list.
How I work: I use AI tools to speed up drafting and I check every formula myself. If you want no AI at all, message me before ordering.
Please note: this is a record-keeping tool, not tax advice. Your accountant should confirm your VAT filing. The UAE plans mandatory e-invoicing for business-to-business sales from 2027, so this file is best for B2C sales, quotes and internal records.
Platform:
Excel
•
Google Sheets
•
Microsoft Office
Development technology:
Google Apps Script
•
Power Query
•
Excel
Expertise:
Pivot tables
•
Formulas
•
Dashboard
•
Cleaning
FAQ
Do you work in both Excel and Google Sheets?
Yes. I can build your file in Microsoft Excel or Google Sheets, whichever you and your team use.
What should I send before ordering?
A sample of your data (dummy data is fine) and a short note on what you want the sheet to do. I will confirm the right package.
Can you fix my existing spreadsheet?
Yes. I can repair broken formulas, speed up slow files and clean up messy layouts without losing your data.
Will I be able to update the sheet myself?
Yes. I keep things simple and add short notes explaining how each part works, so you can use and update it easily.

