Excel workbookOfficial Zeyto

WPS Payroll Workbook for UAE Companies

An Excel workbook for owners, office managers and accountants at UAE companies who prepare payroll themselves.

Run monthly payroll you can check.

At a glance

  • FormatExcel workbook
  • DeliveryInstant download
  • In the box4 files, 105 KB
  • Works withMicrosoft Excel 2016 or later, or Google Sheets
  • Made forUAE businesses

How it works

  1. BuyPay on Stripe’s secure page.
  2. DownloadYour order page opens at once with a secure link.
  3. Open and useOpen the workbook in Excel and start from the example.

What you get

  • 8 sheets with about 2,700 formulas, 60 employees
  • Salary register, payslip and bank upload layout
  • Check column that flags negative net pay and missing bank details
  • Filled example workbook with a live worked example
  • Overtime and leave rates are settings you confirm, not built-in law
Files and sizes (4)
  • wps-payroll-workbook.xlsx50 KB
  • wps-payroll-workbook-worked-example.xlsx51 KB
  • bank-upload-layout-sample.csv379 B
  • README.txt3.7 KB

4 files, 105 KB in total. You download them from your order page after payment.

What it does not do

  • The bank layout is illustrative, so test it with your bank.
  • Confirm rates with MOHRE, your PRO or a lawyer.
  • It does not connect to MOHRE, the Wage Protection System or any bank.

After you buy

  • Instant downloadYour order page opens right after payment with a secure link for each file. The link is emailed to you too.
  • A fresh link any timeLinks last 48 hours. Enter your order reference and the email you paid with and we will send a new one.
  • Help is one email awayWrite to support@zeyto.app with your order reference. The team answers every enquiry.
  • Fix, replace or refundIf a file is damaged, will not open, or is materially different from its listing, tell us within 7 days of the sale and we will fix it, replace it or refund you.

Find my purchasesContact the Zeyto teamMarketplace terms

Full refund wording

Digital downloads (files, templates, skill packs, guides) are delivered straight away, so they are not refunded once downloaded. If a file is damaged, will not open, or is materially different from its listing, tell us within 7 days of the sale and we will fix it, replace it or refund you.

Applies to products sold by Zeyto itself. None of this takes away rights you have under UAE law.

About this product

WPS Payroll Workbook is an Excel workbook for UAE employers who run payroll themselves or prepare it for the accountant and the bank.

Read the full description

WPS Payroll Workbook is an Excel workbook for UAE employers who run payroll themselves or prepare it for the accountant and the bank. You enter each month's variable items (unpaid days, overtime hours, bonuses, deductions) and it works out net pay for every employee, a salary register for signatures, a payslip for anyone you choose, and a bank upload layout in the WPS style.

What is inside:

  • Eight sheets: Instructions, Settings, Employees (up to 60), Payroll, Salary Register, Payslip, Bank File and Worked Example
  • Settings for the pay month, the days basis for the daily rate, the hours per day, the overtime base and three overtime multipliers. All of them are yours to set
  • A Check column on every payroll row: negative net pay, deductions above a level you choose, and missing bank details
  • A salary register ready to print, and a payslip you can print or save as a PDF for any employee
  • A bank file layout of employee lines (ID, routing code, account, pay dates, days, fixed and variable income) with a clear warning that it is illustrative
  • A second, filled workbook with a live walk through one fictional employee, and a four-record sample CSV of the layout

Who it is for: owners, office managers and accountants at small and mid-size UAE companies who want payroll to be repeatable and checkable without buying payroll software.

What it does not do: it does not connect to MOHRE, the Wage Protection System or any bank, and it does not submit or guarantee acceptance of any file. The bank upload sheet is NOT an official file: your bank or exchange house decides the exact columns, order, header and totals, so test with a small file first. The overtime multipliers, the 30-day basis and the leave pay base are settings you must confirm with MOHRE, your PRO or a lawyer; the workbook does not state them as law. It does not calculate gratuity (see the End-of-Service Final Settlement Workbook), social security for UAE and GCC nationals, or tax.

Verified by recalculating the formulas with an independent spreadsheet engine and comparing results with a separate calculation. Not opened in Microsoft Excel itself, so open it once and check the dropdowns.

Requirements: Microsoft Excel 2016 or later, or Google Sheets (check dropdowns and shading after upload).

Questions

Who is it for?
Owners, office managers and accountants at UAE companies who prepare payroll themselves.
What do I need to use it?
Microsoft Excel 2016 or later, or Google Sheets.
How do I get it?
Pay on Stripe, then download from your order page at once. Links last 48 hours: ask for a fresh one with your order reference and email.
What if the file is wrong?
If a file is damaged, will not open, or is materially different from its listing, tell us within 7 days of the sale and we will fix it, replace it or refund you. Read the terms.

WPS Payroll Workbook for UAE Companies: AED 149

Pay once, download at once.

Damaged, will not open or not as listed? Tell us within 7 days and we fix it, replace it or refund you.

Questions before you buy? Contact the Zeyto team. This is sold by Zeyto (Emeron Infospace FZE) itself, not by an independent seller. See the marketplace terms.

Not sure it is the right one?

Works well with

Other official products that cover the same ground or finish the job.