Trade, stock & production

Accounting for food and FMCG distributors in the UAE

Aqid ERP is cloud accounting for UAE distributors of dry food, drinks and household goods. It invoices groceries and supermarkets on account with their own price lists and credit limits, keeps stock right across warehouses, splits sales by emirate for the VAT 201, and runs WPS payroll. It does not track batches or expiry dates.

· How we check our guides

Start now for free No credit card needed — invoice in minutes

Starts set up for Trading and distribution

Sign up as this kind of business and the books start with the accounts it posts to, beyond the country's chart:

  • 4110 — Wholesale sales
  • 5110 — Freight and customs on purchases
  • 5610 — Sales commissions

It also sets the invoice terms, whether prices include VAT, and the setup steps that matter for it. You can change it later, and nothing you have is removed.

Start with this setup

In short

Aqid ERP is cloud accounting for UAE distributors of dry food, drinks and household goods. It invoices groceries and supermarkets on account with their own price lists and credit limits, keeps stock right across warehouses, splits sales by emirate for the VAT 201, and runs WPS payroll. It does not track batches or expiry dates. Aqid ERP lays out the FTA's VAT 201 from the books, generates every invoice as signed PINT AE XML for the 2027 e-invoicing mandate and runs payroll in dirhams with a WPS salary file and end-of-service gratuity. The Growth plan fits, at AED 109 a month, with a 60-day free trial. Not built yet: Aqid ERP does not track batches, lots or expiry dates, and it has no FIFO or FEFO picking.

At a glance

ForFood & FMCG distribution
E-invoicingPINT AE: signed UBL XML kept with each invoice; sending through an accredited service provider is not yet live (the mandate starts in 2027)
VAT5% standard rate; the VAT 201 is laid out from the books, sales by emirate
PayrollA WPS salary file, end-of-service gratuity, GPSSA pension for Emirati staff, payslips in Arabic and English
StockOn Growth and Premium, at weighted average cost
Recommended planGrowth (AED 109 a month before VAT): several warehouses and branches, payroll with no headcount limit, and up to 3 marketplace channels.
PriceAED 109 a month before VAT · 60-day free trial today, no card
Not built yetAqid ERP does not track batches, lots or expiry dates, and it has no FIFO or FEFO picking.

How it runs

Groceries on account

Sales order, delivery note, tax invoice. Each shop has its own price list, a credit limit checked when an order is issued, a statement and an ageing line, and automatic email reminders go out on overdue invoices.

Stock across warehouses

Main store, chiller room and each depot are separate warehouses, with transfers and counts. Cost of sales posts on every sale at weighted average cost, and reorder suggestions draft a purchase request when an item runs low.

Big bills wait for approval

Set an approval limit in AED, VAT included, and purchase orders or bills above it wait for a second person before they post. Freight and customs duty on imported lines are spread over the goods.

A branch for each emirate

If you deliver from a depot in another emirate, make it a branch with its emirate set. Its sales then reach the right line of the VAT 201's sales by emirate, and its P&L can be read on its own.

A month at a food distributor in Abu Dhabi (example)

  1. Say you supply 50 groceries from a Mussafah warehouse and a depot in Dubai, and your lines carry VAT at 5%. The Abu Dhabi branch invoices AED 220,000.00 plus AED 11,000.00 VAT and the Dubai branch AED 90,000.00 plus AED 4,500.00, so AED 325,500.00 in all, each invoice leaving with a delivery note.
  2. Your main brand supplier bills AED 180,000.00 plus AED 9,000.00 VAT, AED 189,000.00. Your approval limit is AED 52,500.00, so the bill waits for the finance manager before it posts.
  3. The ageing shows AED 48,000.00 past 60 days across five shops. Credit control is set to hold, so the next order for the largest of them stops until someone who may approve payments releases it.
  4. Payroll for 18 staff, drivers, salesmen and warehouse hands, runs with the payday set on the 1st and a WPS SIF salary file for your bank. One driver has no IBAN, and the run warns you before it closes.
  5. In the VAT 201, AED 220,000.00 and AED 11,000.00 sit against Abu Dhabi in box 1a and AED 90,000.00 and AED 4,500.00 against Dubai in box 1b. Less the AED 9,000.00 of input VAT, AED 6,500.00 is due by the 28th day after the period ends.

The parts you will use

Sales

Quotes, sales orders, delivery notes, tax invoices and credit notes for returns and damaged goods, with price lists, credit limits, statements and ageing per shop.

Inventory

Several warehouses, transfers, stock counts, weighted average cost and reorder suggestions. Growth or Premium.

Purchasing

Purchase requests, purchase orders, goods receipts and bills, approval limits, landed cost on imports, and supplier payments released in one batch with a bank payment file.

Marketplace settlements

Settlement files from Amazon.ae and noon matched line by line to sales, fees and refunds. Starter covers 1 channel, Growth up to 3.

Payroll

Drivers, salesmen and warehouse staff in AED with a WPS SIF file, end-of-service gratuity accrued monthly, and expiry alerts for residence visas, work permits and passports.

VAT and e-invoicing for distributors

The VAT 201 is laid out from your posted invoices and bills, with standard-rated sales split by emirate: a branch's emirate first, the company's otherwise. Imported goods brought in with your TRN on the customs declaration have their VAT declared in box 6 and, where the normal rules allow, recovered in box 10. If you are unsure how a product line is treated, settle it with your adviser before you set its tax code. You enter the figures on EmaraTax yourself.

Your invoices to groceries and supermarkets are invoices to businesses, so they come under e-invoicing: at revenue below AED 50 million, appoint an accredited service provider by 31 March 2027 and transmit from 1 July 2027. Aqid ERP keeps signed PINT AE XML with every invoice and credit note today, but it is not a provider and its connection to one is not yet live.

Plans for Food & FMCG distribution

Starter

For small businesses that need compliant invoicing

77 د.إ / month

  • Compliant tax invoices
  • Customers & quotes
  • Payroll and WPS file for up to 5 employees
Start now for free

Premium

For companies with branches, devices and volume

214 د.إ / month

  • Everything in Growth
  • Branches & devices
  • Your own versioned metrics, consolidation & API
Start now for free

Compare the plans in detail

Questions

Does Aqid ERP track batches or expiry dates?

No. There is no batch, lot or expiry tracking, and costing is weighted average only. It suits distributors who do not need to trace batches; if you do, keep that in a warehouse system and use Aqid ERP for the accounts, VAT and payroll.

We deliver to shops in several emirates. How does the VAT 201 split them?

Standard-rated sales are reported by emirate in boxes 1a to 1g. Aqid ERP takes the emirate from the branch that made the sale, or from the company when there is no branch, so set up each depot as a branch with its emirate. Check the split with your adviser before you file.

Can I give each shop its own prices and a credit limit?

Yes, on every plan. A price list sets a fixed price per item or a percentage on your selling price, and becomes the shop's default. A credit limit is checked when an order or invoice is issued, and can either warn or hold the sale until someone who may approve payments releases it.

Do my invoices to groceries have to be e-invoices?

Yes, once your phase starts. Groceries are businesses, so invoices to them travel through an accredited service provider from 1 July 2027 if your revenue is under AED 50 million, or from 1 January 2027 at AED 50 million or more. Aqid ERP keeps the signed PINT AE XML; its provider connection is still in progress.

Does payroll follow the WPS rules that started in June 2026?

It produces the WPS SIF salary file and, under Resolution 340 of 2026, warns you when the payday is after the 1st or an employee has no IBAN and would be paid outside WPS. No bank has yet accepted an Aqid ERP WPS file, so test the first one with yours.

Can I try it with my own data?

Yes. Start with a 60-day free trial, and during the offer to 31 December 2026 we help migrate your items, customers and opening balances free of charge.

Appoint your provider before 31 March 2027. Start the books today.

Start now for free No credit card needed — invoice in minutes