How to bill stored materials on a pay application (without double-counting)

You bought $40,000 of switchgear in March; it installs in June. Waiting three months to bill it is a cash-flow hole, which is why pay applications have a materials presently stored column. Used correctly it’s free working capital; used sloppily it’s rejection bait.

What qualifies

Contracts vary, but the usual tests are:

Consumables and small stock generally don’t qualify; discrete, project-specific equipment and materials do.

The math rule: stored → installed, never both

This is where sheets go wrong. The lifecycle of that switchgear:

  1. March (delivered): bill it in the stored materials column. It joins “total completed and stored” and gets retained per your contract’s materials rate.
  2. June (installed): the value moves from stored materials into work completed. It does not appear in both columns, total completed and stored doesn’t jump; the composition changes.

If your spreadsheet adds this-period work AND keeps the stored balance, you just billed the gear twice, and the reviewer will find it.

What the GC wants attached

Send it unasked. Stored-material lines without backup are the single most-cut item in certification.

Track it like retainage: cumulatively

Keep a running stored-materials balance per line, added when delivered, drawn down when installed. Our free template carries a stored column with the transfer math built in, so the double-count mistake is structurally impossible.