Three reports in the Reports Inventory group are about film and job material cost. They're built from the rolls you receive and the film your team logs against jobs.
Inventory is on the Growth plan and up. To see these reports you need the View financial reports permission. Owners, Admins and Managers have it by default.
Open the reports
- In the sidebar, click Reports, then switch to Detail.
- Pick your date range across the top. Film Rolls On Hand ignores it and always shows today.
- Under Inventory, click Film Usage, Film Rolls On Hand or Material COGS per Job.
Film Usage
One row per film product used in the date range, with the most-used first. Columns are Product, Type, VLT, Feet, Installs and Cost.
Installs is how many film entries were logged, not how many cars. Cost is feet used times the cost per foot set on the film product. A product with no cost per foot shows $0.
Film Rolls On Hand
The tiles show Active Rolls, total Remaining in feet and Est. Value. The value scales each roll's cost by the share of the roll that's left.
The table lists every active roll, newest first: Roll, Product, VLT, Remaining in inches with a percentage, Width and Supplier.
Material COGS per Job
One row per appointment that had film or supplies logged against it in the date range, most expensive first. You see Date, Customer, Film, Supplies, Material COGS and Gross Profit.
Gross Profit is the money actually collected on that job's invoice, after refunds, minus material cost. A job whose invoice isn't paid yet shows a negative number until payment comes in.
Getting good numbers
These reports are only as good as your film logging. If installers skip logging film on a job, it won't appear here. See Tracking film usage per install for how film gets logged.
Frequently asked questions
Q: Why does Material COGS per Job show a negative gross profit?
A: Gross Profit only counts money collected on that job's invoice. If the invoice is unpaid, or the job has no invoice yet, the material cost is subtracted from $0.
Q: Why does Film Usage show $0 cost for a product?
A: Film Usage prices film by the cost per foot set on the film product. Add a cost per foot to that product and the cost will fill in.
Q: Does Installs mean the number of cars?
A: No. It's the number of film entries logged for that product. One car can have several entries if film was logged per window or per roll.