Company

Daily Purchasing & Materials Report

01

Purchase requests & bank status

Purchase requests

Approver is set by amount. Sorted by job code.

02

Cheques delivered

Cheques delivered to suppliers

Documents must reach finance within 24 hours

03

Materials received / in transit

Materials

Late = expected date has passed and not in store

04

Supplier credit & outstanding balances

Who we owe

Opening + new credit − payments = closing. Next due and overdue are worked out oldest-first. Cheque given? shows whether we gave the supplier a cheque for the credit still open.

05

Cost variance & overrun alerts

Jobs: contract value vs purchase cost

Purchase cost comes from the Jobs sheet, or the sum of the job's purchase requests when left blank

06

Missing data / outstanding BOMs

Jobs without a complete BOM

Late = expected completion date has passed

07

Defective materials & supplier issues

Supplier issues

Open issues first

08

Cash requirements for tomorrow

Cash needed tomorrow

In priority order

09

Daily summary

10

Compliance checklist

✎

Data sheet

Type, paste or import your records here, like a spreadsheet. The report is calculated from this sheet.