Skip to content
Training manualBuying and stock

Suppliers and purchase invoices

Record what you bought, at what cost — and let the system work out what your stock is really worth.

The purchase invoice is where cost enters the system. Each line updates the item's stock and recalculates its weighted-average cost the moment you save, so a margin report is never based on a price someone typed in months ago. Whether the invoice was paid on the spot or is owed, it posts to the ledger accordingly — no separate accounting step. Saving a backdated invoice or editing a past one (or backdating a count, wastage, return or transfer) re-costs the later sales and documents it affects and re-posts their cost lines on their own dates; if one of them is in a locked month, the change is refused and the month is named. Goods sold while stock was at zero are costed at the last known average until stock arrives, then at the cost of the stock that covers them.

Suppliers and purchase invoices
  1. Open Purchasing → Suppliers → New and create the supplier with their name, phone and any opening balance you already owe them. An opening balance also posts a journal entry against Opening Balance Equity (3400), so Accounts Payable (2000) matches the supplier balances; the same applies to a customer's opening balance and Accounts Receivable (1100). A locked month refuses it.

    Suppliers and purchase invoices — 1
  2. Open Purchasing → Purchases → New. Choose the supplier, the receiving warehouse, and enter the supplier's invoice number and date so it can be matched later.

    Suppliers and purchase invoices — 2
  3. Add each item with the quantity and unit cost as invoiced. Buy by the carton if that is how it arrived — the unit conversion handles the pieces.

  4. Mark whether it was paid now — cash or bank — or is owed. Paid invoices post straight to cash or bank; owed ones post to the supplier's account for settlement later.

  5. Save. Stock rises, cost recalculates, and the ledger updates. If you later correct a quantity or cost on a posted line, the item's cost history replays forward so every sale since keeps an accurate cost of goods sold.

Good practice

  • To bring in many invoices at once, use Import from Excel on the Purchases list (download the template first: one row per line, rows with the same Invoice ref form one invoice). The list also exports to Excel and prints with totals.
  • A wrong invoice can be cancelled from its page (Cancel invoice): its stock and ledger entries are reversed and costs are recalculated from its date. It is refused if the invoice has returns, its month is locked, or its goods were already used so the quantity would go negative.
  • Enter purchases the day goods arrive, before they are sold. A sale made before its purchase is recorded carries the old cost.
  • A supplier with any purchase or payment history cannot be deleted, so old invoices always resolve to a real name.