Skip to the guide
IQ Booksby ReconcileIQ

Suppliers & purchases · Guide 23 of 53

Paying suppliers and aged creditors

Recording the payment, allocating it against bills, and reading the aged-creditors report. Symmetrical with customer receipts but worth its own guide because the allocation table is where most accounting errors hide.

A supplier payment is the cash leg of a bill. Like customer receipts, payments need allocating — deciding which bills the cash settles — or your aged-creditors view will show what you owe in total but not how it splits across documents.

Two routes to record a payment

Manual payment: Suppliers → Payments → New payment. Used when you initiated the payment from your bank but the bank-transaction outflow has not yet been imported.

Confirm-invoice from a bank draft: when you import a bank CSV and a money-out draft matches an outstanding bill (same supplier, same amount, near date), the Drafts workspace offers Confirm as bill payment in one click.

The payment form

Mirrors the customer-receipt form:

  • Supplier. Required.
  • Payment date and bank account (the account the cash left from).
  • Currency and amount.
  • Reference. Bank transaction ID or your own internal reference.
  • Allocations. The table of outstanding bills for this supplier. Decide which bills this payment clears.

Allocating

The allocation table lists every outstanding bill for the supplier in date-ascending order. For each bill: bill number, date, total, outstanding amount. You allocate by entering an amount against each line:

  • Tick the “Pay all” checkbox to allocate the full outstanding amount on every bill until the payment is exhausted.
  • Allocate partial amounts where the payment doesn’t cover the full bill.
  • Leave bills alone (they remain outstanding).

Live totals at the bottom: payment amount, total allocated, unallocated remainder. As with receipts, you cannot save with a negative remainder; you can save with a positive remainder, which becomes a supplier credit available against future bills.

The journal it posts

Allocated payments produce: debit AP (reduces what you owe), credit Bank (cash leaves). source_reference = supplier_payment:N.

If the payment currency differs from your base, the journal includes an FX gain or loss for any difference between issue-rate and payment-rate of the bills being settled.

When the payment’s bank line arrives later, Review marks it Already recorded and offers to Match it to this payment, so the money leaves the books once. See confirming drafts.

A payment run usually leaves your bank as one debit for every supplier on it. Review recognises that too: a bank line for exactly the run’s total, on its bank account and within the same few days, is offered as Payment run PR-00012 (4 supplier payments), and matching it posts nothing new. While the line is matched, every payment in the run counts as matched: none is offered to another bank line, a payment’s amount or bank account cannot be edited, and changing how one payment is treated is refused until the bank line goes back to Review (which unmatches the whole run and leaves the payments as they are). From the bank feed or a statement import the match is made by itself when the run is the only thing that fits; a match you undo is never made again by itself. A payment moved to another bank account or re-dated since no longer counts as part of the debit. While the line is matched, none of the run’s payments can be deleted: the money left the bank with the run. If the bank sent one back, the returned money is its own line in Review; if one never left, send the bank line back to Review first.

Multi-bill payments

The classic case: a £4,200 monthly bank transfer to a key supplier covering three bills (£1,500 + £1,200 + £1,500). One payment, three allocations.

The result: each bill flips to Paid, the supplier’s aged-creditors balance drops by £4,200, your bank balance drops by £4,200, AP drops by £4,200. One balanced journal with three allocation rows.

Multi-supplier payment runs

Suppliers → Payments includes a payment desk for paying several suppliers together. Select the issued bills you want to settle, choose the bank profile and payment date, then create a draft run. IQ Books groups every selected bill for the same supplier into one bank instruction while retaining the individual bill allocations underneath.

  1. Prepare. An owner, admin or bookkeeper selects the bills and creates a draft. Each selected bill shows a Pay amount pre-filled with its full outstanding balance — reduce it to make a part-payment; the remainder stays outstanding on the bill. Nothing posts to the ledger.
  2. Submit. IQ Books checks that every supplier has a verified default bank account, that every bill remains outstanding, and that no bill is reserved by another live run. Submission freezes the destination details into the run.
  3. Approve. An owner or admin reviews the supplier, masked destination, reference and total. Approval authorises that frozen instruction, not whatever happens to be on the supplier record later.
  4. Export. Download either a UK bank-upload CSV or an ISO 20022 pain.001 file, according to the secure bank profile. Upload it to your bank and complete the bank's own authorisation.
  5. Post. Once authorised, post the run. All supplier payments and bill allocations post in one transaction; if any item fails, none of the run reaches the ledger.
  6. Remittance advice. After posting, Email remittance advice sends each supplier a summary of the bills the payment covers, any CIS deducted, the cash amount, date and reference. Suppliers without an email address are skipped and reported, and re-sending never emails the same supplier twice for the same run.

Supplier bank details and verification

Open a supplier and use Supplier payment details. Full sort codes and account numbers are encrypted at rest and are returned to the screen only as masked values. Only an owner or admin can add, change or verify them.

Saving a bank account leaves it Unverified. Check the details against a trusted source outside the invoice or payment-change email, then mark them verified. Any edit resets verification automatically. A supplier cannot enter an approval run until its default account is verified.

Payment file profiles

A profile connects one IQ Books bank account to its originating sort code, account number, originator name and export format. Only owners and admins can create one. The credentials are encrypted and the Payments screen shows only the last four account digits.

The generic CSV contains payment date, payee, sort code, account number, amount and reference. ISO 20022 produces a pain.001 credit-transfer instruction. Banks vary in the exact upload formats they accept, so choose the format your bank documents for your service and review the bank's validation result before authorising.

Returning, cancelling and duplicate protection

An approver can return a submitted run with a required reason. Returned bills are released; reopening the draft re-reserves them, and if another run has taken a bill in the meantime IQ Books names the bill and refuses the reopen so you can resolve the clash deliberately. Draft, submitted, approved and exported runs can be cancelled without touching the ledger. A posted run is immutable and cannot be posted twice.

By default the same owner or admin may prepare and approve a run — practical for a one-person finance function. To enforce separation of duties, turn on Payment runs need a second approver under Settings → Features → Approval controls; whoever prepared the run, and whoever submitted it, are then blocked from approving it and from exporting its bank file. A run RiQ drafted by itself (the automation set to automatic) was prepared by whoever submits it, not by the person who switched the automation on.

RiQ drafts the run for pay day

With payment runs switched on, What RiQ found suggests a run a couple of days before your pay day (Friday unless you choose another in Settings → Automation): every bill due by then, and any overdue, from suppliers with verified bank details, on your default payment file profile, with any CIS deduction worked out. It says what it left out and why: no verified bank details (with a link to the supplier), a CIS bill that cannot be worked out yet (the subcontractor is not verified, or CIS is switched off), a bill in another currency, or a bill that would take cash below the amount you keep in the bank. If nothing can go and something you can fix is in the way, it says so as a notice; a pay day in a closed period is said too.

The cash check uses the 13-week cash forecast, worked out again from the books first if anything has changed since it was. The forecast already expects each unpaid bill to be paid on a particular week. Paying it on pay day instead moves it to that week, so the weeks in between go down (paid early) or up (paid late); CIS withheld stays in the forecast as a payment to HMRC by the 22nd after its tax month. Bills are taken most urgent first: the earliest due, then the largest. Each goes on the run if no week then ends below the cash you keep (set it under Cash to keep in the bank in Settings, Automation), or below where it already stood; one that would is held back, and smaller ones after it can still go. If the forecast could not be worked out, the suggestion says cash was not checked and waits for you, even when the automation is set to automatic.

Accepting the suggestion only drafts the run. You check it, submit it, approve it, export the bank file and post it, exactly as for a run you build yourself; cancel the draft to undo. Bills already on a run are not suggested again. Bills that fall due after the run was drafted, while it is still a draft, are suggested as Add them to PR-00012 rather than a second run for the same day; a supplier already on the run gets one payment for all their bills. A suggestion for a pay day that has passed can no longer be accepted.

Reversing a payment

If an individually recorded payment failed at the bank or was entered by mistake, remove it from View transactions. IQ Books removes its allocations, restores the bills’ outstanding balances and keeps a balanced reversal journal in the audit trail.

A posted payment run is a permanent approval record and is not edited or deleted as a batch. If the bank rejected the whole file, or one supplier’s payment in it, before any money left, delete the affected supplier payments from View transactions so each bill reopens with its own audit evidence (and match the smaller bank debit to the payments that did go). The run keeps the supplier’s line, marked Payment deleted, as the record of what it instructed, and remittance advice skips it. If the run has not yet posted, cancel it instead.

The aged-creditors report

Reports → Aged creditors shows what you owe each supplier broken into ageing buckets (Current, 1-30 days, 31-60, 61-90, 90+). Each bucket is computed live from outstanding-bill amounts: bill total minus all payment and credit-note allocations.

A supplier’s row totals across all buckets give you their total outstanding. The grand total at the bottom is your total trade payables — should match the AP balance on your trial balance.

If aged creditors and AP don’t reconcile, the most common causes are: payments saved with positive unallocated remainders (supplier credit), supplier credit notes not allocated against bills, manual journals to AP outside the standard workflow.

Statement reconciliation

Periodically, suppliers send you a statement of account — their record of what you owe them. Reconciling this against your aged-creditors view exposes any data drift in either direction. Discrepancies usually trace to a bill the supplier sent that you never entered, or a payment they have not yet recorded.

Related guides

Raising And Allocating A Supplier Credit Note

When a supplier refunds you, cancels part of a bill, or issues a credit for a return, record it as a credit note rather than editing the original bill. A credit note is the mirror image of a bill: it reduces what you owe and reverses the cost you originally recorded.

  1. Open the supplier. From the Purchases area, open the supplier’s page and choose to raise a credit note. It uses the same line-by-line form as a bill.
  2. Add the lines. Enter each line with the expense or cost account it relates to, the amount, and a VAT code — ideally matching how the original bill was coded so the reversal is clean.
  3. Issue it. Like a bill, a credit note sits as a draft and does nothing to your ledger until you issue it. Issuing posts the entry that lowers your creditor balance.
  4. Allocate it against open bills. Apply the credit note to one or more of that supplier’s outstanding bills to reduce each bill’s outstanding amount.

Allocating a credit note does not post a second journal — the accounting happened when you issued it. Allocation is simply the housekeeping that tells IQ Books which bills the credit cancels. A credit note can only be applied to bills belonging to the same supplier, and only up to the value of the credit; any credit you don’t use sits on the supplier’s account and can be applied to a future bill.

Credit note or refund? A credit note settles the debt on paper: it lowers what you owe without any money moving. If the supplier actually sends cash back to your bank, that is a refund — record the money arriving in the bank instead. Don’t use a credit note to represent cash you physically received.

Paying A Foreign-Currency Supplier Bill

Your organisation keeps its books in one base currency, but you can hold bills and bank accounts in other currencies. Because the exchange rate almost always moves between the day a foreign bill is raised and the day you pay it, settling it produces a small realised foreign-exchange gain or loss. IQ Books works this out for you.

  1. Record the payment in the cash currency. Start a supplier payment as usual, then set the currency of the money actually leaving your account — for example euros if you’re paying from a euro account.
  2. Enter the foreign amount and allocate. Type the amount in that currency and allocate it against the foreign-currency bill or bills it settles.
  3. Confirm the exchange difference. IQ Books calculates the difference between the rate on the bill date and the rate on the payment date and shows it. Save to post.

Every entry is still recorded in your base currency. The bank side is booked at the value of the cash on the day it moved, the bill is cleared at its original base value, and the gap between the two is posted to a foreign-exchange gain or loss account. A rate that moved against you shows as an FX loss; one that moved in your favour shows as a gain.

Paying a euro bill from a sterling account (a cross-currency payment) works the same way, except IQ Books treats it as settling that bill in full and books the exchange difference at that point. If you later correct the amount or date of a foreign-currency payment, you’ll be asked to confirm the exchange difference again, because changing either can move the rate that applies.

One thing to watch: a payment in your base currency against a bill in your base currency should never carry an exchange difference. If an FX figure appears on an all-sterling payment, check you haven’t set the wrong cash currency.

Withholding CIS When You Pay A Subcontractor

If you’re a contractor in the Construction Industry Scheme, IQ Books can withhold the CIS deduction automatically when you pay a subcontractor, so the right amount reaches them and the deduction is held ready to pay over to HMRC.

  1. Set the subcontractor up. On the supplier record, mark them as a subcontractor, record their verification number and date, and set their CIS status — gross (0%), net (20%) or higher rate (30%).
  2. Split the bill between labour and materials. Raise and issue the subcontractor’s bill as normal, putting labour and materials on separate lines. Post materials to a materials, purchases or cost-of-sales account (or mark the line as materials). CIS is only ever deducted from labour; materials and VAT are left out.
  3. Pay the bill. Record a supplier payment allocated to that bill. IQ Books withholds the deduction on the labour portion at this point: you pay the subcontractor the net figure, the full cost still clears against the bill, and the deduction is set aside in a CIS deductions account owed to HMRC.

A few details worth knowing:

  • The deduction is taken when you pay, not when you enter the bill, and it is scaled down for a partial payment — pay half the bill and only half the deduction is withheld.
  • If a supplier is flagged as a subcontractor but has no rate set yet (not verified), nothing is withheld until you set the rate.
  • Because IQ Books can’t always tell labour from materials, it treats a line as labour unless the line is clearly materials. Tag your material lines properly so you don’t over-deduct.
  • The CIS deductions account is created automatically the first time a deduction is taken.

What this doesn’t do: IQ Books records the CIS deduction accounting only. It does not file your monthly CIS return (CIS300) with HMRC, and it does not produce the payment and deduction statements you must give subcontractors. Handle those separately.

Common Questions And Troubleshooting

Can I pay a supplier without allocating to a bill? Yes. Leave the allocation blank and the payment sits on account — the money still leaves your bank and reduces what you owe the supplier overall, it just isn’t tied to a specific bill. You can allocate it against bills later.

Why can’t I allocate my payment to a particular bill? You can only allocate to a bill that has been issued and still has an outstanding balance. Draft bills and voided bills aren’t payable, so issue the bill first. Each allocation is also capped at that bill’s outstanding amount, and your allocations can’t add up to more than the payment itself.

I never changed the bill to ‘paid’ — why did it change? You never set a status by hand. IQ Books derives whether a bill is outstanding, partially paid or paid from the payments and credit notes applied to it. Allocate part of the balance and it becomes partially paid; clear the balance and it becomes paid, automatically.

Can I record a payment by voice? Yes — ask RiQ to, for example, ‘pay the Vector Labs bill from the current account’. RiQ finds the supplier, bank account and bill, then shows a confirmation card before anything happens. Note that a payment recorded this way posts straight away; there is no draft stage for receipts and payments.

Can I email a supplier statement? You can produce one — go to Reports, open the Supplier Statement, pick the supplier and a date range, and you’ll see the opening balance, each bill, payment and credit note with a running balance, and the closing balance. Emailing a statement directly from IQ Books is currently available for customer statements only; for a supplier, export or print the statement and send it yourself.

The aged-creditors total doesn’t match my list of bills. The report shows a small ‘unallocated’ figure when your creditor control account carries a balance with no bill behind it — almost always an opening balance brought over at migration. It’s reported honestly rather than hidden, and clears once every brought-forward balance is matched to a re-entered bill.

IQ Books by ReconcileIQ

Your books, kept by themselves.

IQ Books is the AI-native UK ledger that does the bookkeeping for you. Bank transactions arrive coded, receipts and bills file themselves from a photo or an email, and the books are reconciled to the statement. RiQ does it, you sign it off. The ledger is free.