Construction software or Excel?
Excel is enough for a contractor who runs a small project alone and knows the files well. Once several people edit the same file, certificates pile up month after month, and the consultant or owner asks for a documented approval, copy, formula and balance errors start. This page is a fair look at where Excel works well, where it breaks, and how to move to Ta3mir without losing your files.
Where Excel works well
Excel is an excellent tool in its place, and we do not ask you to drop it. It does the job without trouble here:
- Engineers and accountants know it, and you can shape any table the way you want.
- It needs no setup: open a file and start, which suits quick calculations.
- It suits a single item rate analysis, comparing two quotes, or a first draft of a bill of quantities.
- It is enough for a small project run by one person with a limited number of items.
- It is a common language for exchanging tables with the consultant, owner and suppliers, which is why Ta3mir imports from Excel and exports to it.
Where Excel breaks in contracting
The problem is not Excel itself but using it as the system that runs a company: separate files passed between people and linked to each other by hand.
Conflicting versions
The certificate file travels by e-mail and messaging apps, two people edit two different copies, files appear with names like "certificate 4 revised final", and nobody knows for sure which copy is the approved one.
Formula errors in cumulative certificates
Each new certificate is copied from the last one and its totals moved into the previous column. An inserted row shifts a cell reference, a formula is overwritten with a fixed number, or a quantity is corrected after the move, and the error rides through every later certificate unnoticed until the final account.
No approval trail
Who reviewed the certificate, who approved it, and when? Approval is a signature on a printout or a message separate from the file, and the file itself can still be edited after approval without anyone seeing it.
Nothing arrives from site directly
Worker attendance, the daily log and material requests come from site by phone or on paper, then are typed again in the office, late and with copying errors.
No link between BOQ, certificate and cash
The BOQ is in one file, certificates in one file per month, expenses and collections in a third. To know the profit on an item, what a subcontractor is still owed, or what is still uncollected, you combine the files by hand every time.
A stock balance you cannot trust
The stores sheet is updated when someone remembers, so you do not know the real balance on each site before you order more.
Signs you have outgrown Excel
If one or two of these apply to you, the time spent checking files is worth trying software:
- More than one person edits the same certificate file.
- You run several projects at once, each with its own files.
- The consultant or owner wants a clear approval path for every certificate.
- You want to know the profit on each certificate or item before the project ends, not after.
- The attendance sheet from site differs from what was actually paid.
The same task in Excel and in Ta3mir
Every row is a module that works in Ta3mir today, and each module has its own page.
| Task | In Excel | In Ta3mir |
|---|---|---|
| Bill of quantities | A file copied for each project with items edited by hand. | A BOQ per project with measurement sheets, imported from Excel with a review before saving, and exported to Excel, CSV or PDF. Details |
| Interim certificate | Copy the last certificate and move totals into the previous column with formulas. | Enter this period's quantities only; previous, current and cumulative are summed for you, and the next certificate starts from the last one in one click. Details |
| Linking certificate and BOQ | Cell references between two files that can break on any edit. | Certificate lines are linked to the BOQ items they certify, lines still unlinked are listed for you to link, and an imported Excel certificate is matched line by line to its items before saving. Details |
| Certificate approval | A signature on a printout or a message separate from the file. | An approval path that includes the consultant, where no one approves a certificate they prepared. Details |
| Subcontractors | A sheet per subcontractor with paid and outstanding worked out by hand. | Each subcontractor has a contract, certificates and an account statement with approved, paid and outstanding. Details |
| Collecting from the owner | A hand-kept list of what was paid and what was not. | A claim from the approved certificate with a due date, followed to collection. Details |
| Expenses and project cost | A separate expense book added up at month end. | Each expense on its project and cost code; approved certificates, payroll and purchases flow into project cost automatically, with budget against actual. Details |
| Attendance and payroll | A paper sheet or messages copied into a spreadsheet, then pay worked out by hand. | Check-in from the Ta3mir Field app inside the site area, or a fingerprint-device file import, then payroll from the attendance record. Details |
| Daily site log | A report typed in a file with photos sent separately. | A daily log per site with work done, labour and notes, and execution stages documented with photos. Details |
| Stores and purchasing | A balance sheet updated by hand, purchase requests in messages. | A balance for each item in each store with a reorder level, recorded receipts, issues and transfers, and purchase requests that go through approval. Details |
How to move from Excel to Ta3mir
You do not start from zero or leave your old files behind. Start from them in this order:
- Start with the BOQ: import the bill of quantities from Excel and review its items before saving.
- Move the running certificate: import it from an Excel file and match each line to a BOQ item, then create the following certificates inside Ta3mir.
- Turn the old stores sheet into ready stock movements with the smart Excel upload.
- Start recording worker attendance from the Ta3mir Field app, or import the fingerprint-device file if you have one.
- Export when you need to: the BOQ to Excel or PDF, and certificate items to CSV that Excel opens, so exchanging files with people who do not use Ta3mir stays easy.
If you are not ready to move yet, start with Ta3mir's free Excel templates: interim and final certificates, a subcontractor certificate, rate analysis and a daily report, with no sign-up.
Frequently asked questions
Do I have to give up Excel completely?
No. Ta3mir imports the BOQ and certificates from Excel files, and exports the BOQ to Excel and certificate items to CSV. Keep Excel for quick calculations, and leave to Ta3mir what needs one record and an approval.
Can I import my current BOQs and certificates?
Yes. Upload the BOQ file and review its items before saving, and upload the certificate file and match each line to a BOQ item, so no item enters that an engineer has not reviewed.
Does Ta3mir work out previous, current and cumulative like the certificate sheet?
Yes. Enter only this period's quantities and they are added to the previous ones to show each item's total and value, with retention and deductions at the foot of the certificate.
My project is small. Is Excel enough?
It may be. If you run one project yourself and nobody shares the file, Ta3mir's free Excel templates are a good start. When people and projects multiply, try the software.
Is the construction software free?
The engineering tools and Excel templates are fully free with no sign-up. The software itself is a paid subscription; the plans and their prices are on the pricing page.
Can I try it before subscribing?
Yes, when the demo is available. The demo page lists the account types you can try now with illustrative data.
Try certificates in Ta3mir instead of a spreadsheet
See the plans and their prices, or try the demo account with illustrative data before you subscribe.