Upload Project Status Excel Report
Drag & drop or click — supports multiple .xlsx files
● Full refresh: replaces all data with the latest report (cumulative from Jan 2026)
Performance Overview
Total Invoiced
—
—
Total Collected
—
—
Net Position
—
—
Avg GP%
—
From uploaded data
Active Projects
—
—
Receipts
—
—
Credit Notes
—
—
Visual Analytics
Revenue by SalesmanINVOICED
Job Type BreakdownBY CATEGORY
Monthly Revenue TrendINVOICED vs COLLECTED
Salesman Performance
Upload Excel to see salesman cards
Invoice Register
All Invoices0 records
| Invoice No. | Date | Salesman | Project Code | Customer | Type | Gross AED | GP% |
|---|---|---|---|---|---|---|---|
| Upload Excel to view | |||||||
Receipt Register
All Receipts0 records
| Voucher No. | Date | Salesman | Project Code | Customer | Cheque/Ref | Amount AED |
|---|---|---|---|---|---|---|
| Upload Excel to view | ||||||
📝 New Invoice
Header Information
Invoice No.
Invoice Date
Invoice Type
Project Code
Project #
Salesman
Customer Details
Customer Name
Customer TRN
Customer ID
P.O. Box
City
Payment Terms
Contact Person
Project Details
Project Description
Ship To / Site
Reference / Agreement No.
Work Progress Period
Subcontract Description
Line Items
| Item | Description | Unit | Qty | Unit Price | Amount |
|---|
Financials
Retention %
Advance Recovery AED
Prev. Invoiced (Cumul.)
Prev. Inv. Reference
Gross AmountAED 0.00
Less RetentionAED 0.00
Less AdvanceAED 0.00
Sub TotalAED 0.00
VAT @ 5%AED 0.00
NET AMOUNT DUEAED 0.00
Invoice Preview
📄
Fill in the form and click Generate ▶ to preview the invoice
📋 Cumulative Invoice Generator
Track cumulative work done to date per project
💡 The Cumulative Invoice shows ALL work done at site to date, then deducts previously invoiced amounts to get the net new amount payable. Focus software cannot auto-generate this — that's what this tool is for.
Project Code
Invoice No.
Date
Project Ref #
Customer Name
Project Description / Site Location
Work Period
Subcontract Reference
Prev Invoice No. (deduct)
Previously Invoiced Total (AED)
Payment Terms
Cumulative Line Items (All Work Done to Date)
| Item | Description | Unit | Qty | Unit Price | Amount |
|---|
Total Amount (Cumulative)AED 0.00
Add: 5% VAT (Cumulative)AED 0.00
Previously Invoiced( AED 0.00 )
Net Amount to be PaidAED 0.00
📋
Fill in the details and click Generate Preview ▶
📊
Data loaded