Suppliers & purchases · Guide 19 of 53
Adding suppliers and recording bills
The purchase-side mirror of customers and invoices: the parties you owe and the documents they send you. Supplier bills are the foundation of accurate aged creditors and accurate cost reporting.
A supplier (sometimes “vendor”) is anyone who bills you. Their bills become purchase invoices in your ledger. Understanding the supplier-bill workflow is critical for accurate aged-creditors reports, cost categorisation, and VAT input claims.
Supplier list
Suppliers → Suppliers shows your suppliers with name, balance owed, last activity. Same shape as the customer list:
- Click New supplier to add. Required: name, currency. Recommended: VAT number (if they are VAT-registered), default expense category, payment terms.
- Click any row to open the supplier’s detail page: outstanding bills, attachments, contact details, payment history.
- Archive suppliers you no longer use; their historical bills remain on reports.
Recording a bill
Two routes:
- Manual entry:
Suppliers → Supplier invoices→ New bill. Use this when you have the supplier’s invoice in hand — PDF, email, paper. - Documents:
Suppliers → Documents. Drop, photograph or email the bill; RiQ reads every line, links the supplier, stock items, purchase order and project, and files it as a draft with the original attached. Covered in its own guide.
The bill form
Same shape as a sales invoice, mirrored:
- Supplier. Pick from the dropdown. Inline-create new suppliers without leaving the form.
- Bill date and due date. Bill date is when the supplier issued the document; due date defaults from supplier payment terms.
- Reference. Almost always the supplier’s invoice number. Critical for matching when you pay.
- Currency. Defaults to the supplier’s currency.
- Lines. Each: description, quantity, unit price, account category (where the expense posts), VAT code, line total.
- Attachments. Drag the supplier’s PDF into the form so it stays with the record.
Coding defaults
Open a supplier, click Edit, and the Coding defaults block saves their usual expense account and VAT treatment. Every new bill line for that supplier then starts pre-coded, and bills read in Documents pre-select the same account whenever RiQ has no stronger reason (a purchase order line, or the stock item's own account) — your software subscription supplier codes itself to Software every time. A wand hint under the line editor names the default in use; every line stays changeable, and where CIS domestic reverse charge applies it overrides the saved VAT code (statutory beats habit).
VAT codes on bills
Same five codes as sales: ST (20% input), RR (5% input), ZR (zero-rated input, reportable), EX (exempt input, not claimable), NV (no VAT). On bills, the VAT amount lands as a debit to VAT control (claimable input VAT), and the rest is the deductible expense.
If the supplier is not VAT-registered, use NV. If you cannot tell from the document, ask the supplier — misclassifying VAT is the most common single source of restated VAT returns.
Issuing the bill
Click Issue (or just save and issue in one step). The journal posts: debit expense categories, debit VAT control, credit AP. source_reference = purchase_invoice:N.
The bill enters “Issued” status, appears on aged creditors, and is available for matching against bank-transaction outflows.
Multi-line bills
Many real bills cover more than one expense category. A typical example: an Amazon invoice for office supplies (£60) and a refurbished tablet that’s a fixed asset (£140). Two lines on the bill, two account categories on the bill form, two journal lines on posting.
VAT can be the same on each line, or different (rare but possible — e.g. food and books on a single supermarket receipt where one is zero-rated and the other is standard).
Attachments
Every bill should have the supplier’s original document attached. The attachment lives in iq_books.attachments linked to the bill, accessible from:
- The bill detail page itself.
- The supplier’s detail page under their Attachments tab.
- Any audit-log entry referencing the bill.
Attachments are intended as the single source of truth for HMRC inspection if asked. IQ Books never deletes them; archived bills retain their attachments.
Editing and voiding
- Drafts: edit anything.
- Issued, with nothing paid or credited against it: editing it reverses and re-posts it, keeping its number.
- Paid or part paid: the date, supplier and lines cannot change. Release the payment or credit note first, or raise a supplier credit note.
- Void to undo: posts a reversal, leaves the original visible for audit.
- Cannot void a bill that has been partially paid — reverse the supplier-payment allocation first.
- A bill spread as a prepayment, or with a line on the fixed asset register, cannot be voided while that schedule or asset is live, and the line it came from keeps its account and amount. End the schedule (Accounting, Prepayments & accruals), or archive the asset and reverse its capitalisation journal, first. Other changes, such as the due date, are fine.
Related guides
Setting Up A Supplier Properly
The only thing a supplier really needs is a name, but the extras you set once here save you re-keying on every bill that follows.
- Name is the one required field. Everything else is optional, so you can add a supplier in seconds and fill in the rest later.
- Default payment terms. Enter the number of days you normally have to pay (30 by default). When you raise a bill and leave the due date blank, IQ Books fills it in as the invoice date plus these days, which is what drives the ageing buckets later.
- Default currency. If a supplier always bills you in euros or dollars, set it here and new bills open in that currency. Leave it blank to use your organisation’s base currency.
- VAT number and contact details. Optional, but worth recording for overseas suppliers and reverse-charge purchases.
The country defaults to GB. IQ Books also guards against accidental duplicates: if you try to add a name that already exists (ignoring capitalisation), it quietly hands you back the existing supplier rather than creating a second one — which protects you from double-clicks and from a receipt scan re-creating the same supplier.
When you stop dealing with a supplier, archive them rather than trying to delete them. An archived supplier disappears from the picker on new bills and payments but keeps every past document intact, so your history and reports never change. You can unarchive at any time if they come back.
Paying A Bill And Allocating The Money
Issuing a bill records what you owe; recording a payment records the money actually leaving your bank and clears the debt. These are two separate steps, so a bill can sit as outstanding for weeks before you pay it.
- Start the payment. Go to Purchases → Payments and click Record payment — or start it straight from the supplier, or from the bill itself.
- Choose the supplier and the bank account. Pick the account the money actually left from, so your bank balance moves correctly.
- Enter the date, amount and an optional reference. The reference is handy for matching against your statement later.
- Allocate across open bills. Tick the bills this money settles. You can spread one payment over several bills, and you can part-pay a single bill. Each allocation is capped at that bill’s outstanding amount, and the total you allocate can never exceed the payment.
- Save. IQ Books moves each bill you touched to Part paid or Paid on its own, and does all the underlying bookkeeping for you.
Allocating is optional. If you pay a supplier before their bill has arrived, or send a round-figure amount on account, just leave it unallocated — the money sits as a credit against the supplier and you can allocate it to bills whenever they come in.
- You can only allocate to a bill that has been issued. Draft and voided bills aren’t selectable, because they carry no balance to settle.
- A bill’s status (draft, issued, part paid, paid) is worked out from the payments and credit notes against it. It is never a field you set by hand.
- A supplier credit note can be allocated to open bills in the same way as a payment, reducing what you owe without any cash moving.
Reading Aged Creditors And Tying It Back To The Ledger
Aged Creditors is your at-a-glance list of who you owe and how overdue each amount is.
- Open the report. Go to Reports → Aged Creditors and set the ‘as at’ date, or leave it on today.
- Read the buckets. Each supplier’s outstanding balance is split across Current, 1–30, 31–60, 61–90 and 90+ days. The bucket is chosen by each bill’s due date, so a bill with no due date always counts as Current.
- Check the tie-out. The totals block shows the report total alongside the balance on your Accounts Payable control account. In a clean set of books, the two agree.
Only issued and part-paid bills with something still outstanding are included, net of any payments and credit notes and converted into your base currency. Fully paid, draft and void bills drop off the report entirely.
If the report shows an unallocated figure, that is the honest gap between your control-account balance and the individual bills sitting behind it. It usually means an opening balance was brought onto Accounts Payable when you migrated in, with no single bill behind it. IQ Books surfaces this residue rather than quietly absorbing it, so you can see exactly what to investigate.
Putting Stock Items On A Bill
If you buy goods to resell, attaching a stock item to a bill line keeps your inventory value moving automatically — you don’t post a separate stock journal.
- Attach the item on the line. On a bill line, pick a stock item in the item field and enter the quantity and unit cost.
- Issue the bill. IQ Books takes the goods into stock — on-hand quantity and value both rise — valued at the unit cost on your bill line.
- Sell it later. When you issue a sales invoice for the same item, the cost of those goods is taken out of stock at the current moving-average cost, not the price you sold them for.
- Handle returns. A supplier credit note against a stock line takes goods back out of stock; a sales credit note brings them back in, both at moving average.
Two things are worth knowing up front. IQ Books values stock on a moving-average basis — it does not track specific batches or use FIFO. And it will let a sale drive stock negative if you sell more than the system thinks you hold, so keep your purchase bills entered promptly. Stock only ever moves when a line has a stock item attached; ordinary expense lines never touch inventory. Voiding a bill or invoice that moved stock reverses that movement exactly.
Common Questions About Bills
Why is the VAT on my reverse-charge or import bill showing as zero? That is correct behaviour. Codes such as RC and RCS (overseas services), PVA (import VAT under postponed accounting) and DRC (the CIS domestic reverse charge) carry the net only — no VAT amount sits on the bill itself. IQ Books self-accounts for the VAT on both sides of your return, which is exactly how HMRC expects a reverse charge to appear, so a zero on the document is right, not a missing figure.
I put a VAT code on a line and it switched to No VAT — why? VAT only attaches to income, expense and asset accounts. If a bill line points at a liability, equity or control account, IQ Books clamps the code to Non-VATable with no VAT, because VAT on that kind of account would be meaningless.
Can I record CIS deductions on a subcontractor’s bill? Yes. Mark the supplier as a subcontractor and set their CIS rate, split the bill between labour and materials, and when you pay it IQ Books withholds the deduction on the labour portion (materials and VAT are excluded) and posts it to a CIS deductions account. Be clear on the limit, though: this is the deduction bookkeeping only — IQ Books does not file the monthly CIS300 return or produce subcontractor payment and deduction statements.
Can I pay a bill that’s in a foreign currency? Yes. Record the payment in the currency the cash left your bank in, allocate it to the bill, and supply the exchange difference between the bill date and the payment date. IQ Books books the realised gain or loss for you and keeps the ledger in your base currency throughout.
Why won’t IQ Books let me edit a bill after I’ve paid part of it? Once a bill has payments or credit notes against it, only the description and due date can change; the figures are locked so your allocations and VAT stay consistent. If the amounts are genuinely wrong, void and re-raise the bill, or ask the supplier for a credit note.