A supplier payment can be perfectly matched to a bank statement and still give a misleading picture of customer orders. When one delivery serves several jobs, the payment record needs two connected views: what left the account and where the purchased materials went. Recording the full invoice against the first finished job makes that job appear unusually costly while later jobs seem to use free supplies. Start with the purchase as a common source, then document each supported allocation.
Give the purchase a stable identity
Save the supplier invoice number, order date, payment reference and delivery reference together. If the supplier sends several invoices, keep their identities separate even when one transfer pays them all. Record the transfer once, with a breakdown showing the invoices it settles. A payment confirmation establishes money movement; the invoice explains the goods and the delivery note helps establish what arrived.
Do not treat a screenshot of a shopping basket as the completed purchase. Retain it only as the earlier quotation if it helps explain a difference. Where the payment remains pending, label that status instead of recording a final settlement that has not happened.
Record quantities before allocating money
List each material in the unit actually purchased, such as sheets, lengths or packets. Record received quantity separately from ordered quantity. Assign an internal job reference to quantities issued for each customer order, and leave unused quantities in a visible stock line. A simple issue note dated when material leaves storage is stronger evidence than a reconstruction made after several orders have shipped.
Distinguish a whole packet from its individual contents. If a packet is opened, document the conversion used. An allocation worksheet cannot reconcile reliably when the purchase uses packets but job notes use pieces without a stated relationship.
Reconcile a shared purchase
Consider a hypothetical purchase in unspecified currency units: 100 identical sheets cost 500, with no additional charges. Each sheet therefore carries 5 units of purchase cost. Job Cedar receives 40 sheets, Job Maple receives 35 and 25 remain unused. Allocate 200 to Cedar, 175 to Maple and 125 to stock. These allocations add to the original 500 payment.
The allocation does not imply that either customer has paid you. Customer receipts need their own references. Nor does the 125 of unused material represent a new cash balance: that money has already left the account and is represented by supplies on hand.
Deal with mixed invoices carefully
A delivery can contain different grades of material at different prices. Allocate each line using its own supported unit cost rather than applying one average across unlike items. Where a common delivery fee exists, write down a practical basis for distributing it, such as relative material value, and use that basis consistently for the affected jobs.
If a line cannot yet be assigned, retain it in a clearly named unallocated balance. This is more useful than forcing it into the job whose paperwork happens to be complete. Give the balance a next review date and identify the missing issue note or delivery detail.
Link later changes to the original
A return, supplier credit or replacement should point back to the purchase and the quantities affected. If unused sheets are returned, reduce the unused stock allocation; do not automatically reduce a completed job’s cost. If a job returns unused sheets to storage, record that internal movement without inventing another supplier payment.
Preserve the earlier allocation when correcting it. A dated note showing which quantity changed and why prevents later reviewers from interpreting the revised number as the original evidence. Keep proposed credits apart from credits actually issued or received.
Close both sides of the record
Before closing the purchase review, check that payments explain the supplier balance and that quantities explain the delivery. Purchased quantity should equal job issues, unused stock and separately documented returns or losses. Any difference needs its own explanation rather than a hidden adjustment to unit cost.
Save the completed worksheet beside the invoice, payment proof and issue notes. The resulting record should let someone trace a job’s material figure back to the common purchase while also seeing the amount still represented by unused supplies. That connection is what makes the payment record dependable.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

