Excel workbookOfficial Zeyto

Subcontractor Payment and Retention Tracker

An Excel workbook for main contractors and fit-out companies with several subcontract packages running at once.

Know what each subcontractor is owed and what you hold.

At a glance

  • FormatExcel workbook
  • DeliveryInstant download
  • In the box3 files, 261 KB
  • Works withMicrosoft Excel 2016 or later
  • 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

  • Excel workbook with 9 sheets
  • Packages, variations and certificates from cumulative values
  • Retention held and release due flags
  • Advance recovery and overdue payment status
  • Licence and insurance expiry warnings
  • Blank file plus a filled-in example
Files and sizes (3)
  • subcontractor-payment-and-retention-tracker.xlsx129 KB
  • subcontractor-tracker-WORKED-EXAMPLE-filled.xlsx129 KB
  • README.txt2.9 KB

3 files, 261 KB in total. You download them from your order page after payment.

What it does not do

  • Take terms from your subcontracts and ask your accountant how VAT applies to retention and advances.
  • Not legal advice and not a contract reader.

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

A main contractor can lose track of what each subcontractor has been certified, how much retention is held and when it falls due.

Read the full description

A main contractor can lose track of what each subcontractor has been certified, how much retention is held and when it falls due. This tracker follows the usual flow from package to variation to certificate to payment to retention release.

What is inside:

  • Subcontractors: 60 with trade licence and insurance expiry dates, flagged when expired or expiring soon, and what you owe each one
  • Packages: 100 packages with original and revised value after approved variations, retention, advance, payment terms, completion and defects period, retention held and a status (OVER-CERTIFIED, PAYMENT OVERDUE, RETENTION RELEASE DUE, In progress and others)
  • Variations: 200 lines; only approved ones change the package value
  • Certificates: 400 lines where you type the cumulative gross value; the sheet works out this period, retention, advance recovery, net, VAT, amount payable, due date and overdue days, with checks for missing or lower valuations
  • Retention Releases: 100 lines
  • Payment Summary: commitment, certified, retention held, advance still to recover, what you owe, overdue and falling due in 30 days
  • Blank and filled-in workbooks, a Worked Example sheet and a README

Who it is for: contractors and fit-out companies with several subcontract packages running at once.

What it is not: not legal advice and not a contract reader. Retention, advance and payment terms must come from your subcontracts. VAT on certificates is a simplification that you choose in Setup; ask your accountant how it applies to retention and advances. Licence checks only compare the dates you type. They are working tools and templates, not tax, accounting, legal or regulatory advice, and UAE rules change: check with your accountant, lawyer or the relevant authority for your case.

Requirements: Microsoft Excel 2016 or later (not tested in Google Sheets or LibreOffice Calc).

Questions

Who is it for?
Main contractors and fit-out companies with several subcontract packages running at once.
What do I need to use it?
Microsoft Excel 2016 or later (not tested in Google Sheets or LibreOffice Calc).
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.

Subcontractor Payment and Retention Tracker: 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.