Project Inventory template

Materials and products consumed by each project: a material catalogue with validated EAN-13 barcodes and HS codes, projects carrying a material allowance, and an issue log that prices every drawdown and rolls it up per project so spend can be read against budget while the job runs.

3 tables · 8 views · 1 form · 6 automations · sample rows included, so it opens looking like a working app

Use this template

Tables

Projects

Project code, Project, Status, Project manager, City, Material budget, Start, Planned completion, Material issues, Issues raised, Material spend, Budget used %, Notes

Materials

Material code, Material, Group, Unit, Unit cost, EAN-13, HS code, Central stock, Reorder level, Stock value, Stock status, Material issues, Quantity issued, Notes

Material issues

Issue reference, Project, Project record, Project manager, Material, Material record, Unit cost, Quantity, Issued on, Reason, Issued by, Issue value, Chargeable to, Notes

Views

Forms

Automations

It is a starting point, not a fixed product

Installing the template creates these tables in your own workspace. Rename a column, add a field, change a view or delete a table you do not need — it is an ordinary Appdor app from the first minute, and your existing spreadsheet can be imported into it.

More Construction & field templates

All templates