Skip to the guide
IQ Booksby ReconcileIQ

Customers & sales · Guide 14 of 53

Managing your customers

A customer is more than a name on an invoice: they carry default payment terms, currency, statement-email cadence, and a complete history of every document and payment. This is where you set them up and keep them tidy.

Customers are the parties you raise sales invoices and quotes against. The customer record is also the home for everything you have ever sent or received from that party — opening and unpaid balances, sent statements, attached documents.

Where to start

Customers → Customers shows the list of customers, with name, balance, last activity date, and an archived flag. Filters across the top let you narrow by tag, by activity window, or by outstanding-balance status.

Click any customer to open their detail page, which is the workspace for everything to do with that party: sales invoices, quotes, credit notes, receipts, statements, attachments.

Adding a customer

  1. Click New customer in the top-right of the list. The form opens in a side panel.
  2. Enter at minimum: customer display name, primary email (used for invoice and statement emails), and currency. If they pay in your base currency, that is the default.
  3. Optionally fill in: legal name, billing address, secondary contacts, VAT number, default payment terms (e.g. 30 days), default account code, internal notes.
  4. Save. The new customer appears in the list immediately and is available in the customer dropdown on every invoice form.

Default payment terms

Set default payment terms once on the customer and every invoice you raise to them inherits the due date automatically. IQ Books offers preset terms (Due on receipt, Net 7, Net 14, Net 30, Net 60, Net 90) and a custom-day option. The default cascades to invoices but you can override on any individual invoice.

Coding defaults

Open a customer, click Edit, and the Coding defaults block lets you save their usual income account and VAT treatment. From then on, every new invoice line for that customer starts pre-coded — the third invoice codes itself the way the first two did — and sales invoices read in Documents pre-select the same account when RiQ has no stronger reason. A small wand hint under the line editor shows exactly which default is being applied, and every line stays changeable. Set it once for your regulars and invoicing becomes two fields: description and price.

Default currency

If the customer’s currency differs from your base, every new invoice for them defaults to that currency. Statements are in your base currency: a foreign invoice appears at the rate it was booked at.

Archiving

If a customer has gone away, archive them with the Archive button at the top of their detail page. Archived customers:

  • Don’t appear in customer dropdowns when raising new invoices.
  • Still appear on historical reports and lists with an “Archived” tag.
  • Can be unarchived from the archived-customers filter on the main list.

The customer detail page

Tabs across the top of any customer give you:

  • Overview — outstanding balance, recent activity, contact details.
  • Invoices — every sales invoice you have raised, status, paid/unpaid, with quick filters.
  • Quotes — open and accepted quotes; convert any quote to an invoice with one click.
  • Credit notes — all credit notes issued, including their allocations.
  • Receipts — every payment received from this customer, with allocation lines visible inline.
  • Attachments — contracts, signed orders, anything you want to keep on file.
  • Activity — a chronological audit of every change made to this customer’s record.

Sending statements

From the customer’s detail page, click Send statement in the top-right. Choose the period and the recipient (their email by default). The statement leads with what is unpaid now (as it stands the day it is sent), invoice by invoice with how overdue each is and an ageing line (not yet due, 1-30, 31-60, 61-90 and over 90 days), then the account activity: opening balance, every invoice, credit note and receipt, and the closing balance. It is in the email and attached as a PDF. Invoices written off as bad debts are not listed as unpaid.

Statements are sent as your business (replies go to your contact email). An address that bounces is not emailed again.

Monthly statements

Under Settings → Payment reminders, tick Send a statement each month (off unless you switch it on). On the first working day of each month (not a weekend or bank holiday), every customer with an overdue balance and an email gets their statement, from the first of last month to yesterday, PDF attached; one a month each, and if the day’s email allowance runs out the rest go on the next working day. Customers marked Don’t chase or No monthly statements (Edit customer, Credit control) are left out, and each statement has a link the customer can use to stop them (shown on the customer, and you can lift it).

Credit control

Edit a customer to set Credit control: a credit limit (how much they may owe), On stop (with a reason), Don’t chase (no payment reminders) and whether to charge them late payment interest. Issuing an invoice to a customer on stop, or one that would take them over their limit, asks first, and so does editing an issued invoice up; RiQ and connected assistants are refused unless you tell them to issue anyway. What they owe is their open invoices less credit notes and money on account not yet set against anything, in pounds (a foreign invoice at its rate). Credit notes are never held. A recurring invoice for such a customer is held (the template shows Held) until that changes, or until you run it yourself and say so; when the hold lifts it invoices the latest period and carries on from there, and the periods missed while it was held are noted on the template rather than raised one after another.

The customer page shows a Credit control strip: what is overdue and how late the oldest is, when they were last reminded and last paid, and the next step (reminders are chasing, call them, consider putting them on stop, or consider writing it off). What RiQ found lists who needs chasing each week.

Invoice design

Edit a customer and choose their Invoice design to have every invoice, quote and credit note for them print in it (a design is made under Settings → Invoice design). Default design follows your default. A single document can still be given another design from its form or print view.

Payment reminders

Turn reminders on under Settings → Payment reminders and choose when they go: before, on, or up to 120 days after the due date. A reminder that could not go on its day still goes within three days. Each reminder links to the invoice’s own page and carries a link for the customer to stop reminders (shown on the customer, where you can lift it). Copy me sends you a copy. Customers who are archived, marked Don’t chase, or who stopped reminders are not chased, nor is an invoice with a payment for it waiting in Review.

Late payment interest

For business customers, the Late Payment of Commercial Debts (Interest) Act 1998 lets you charge interest at 8% over the Bank of England reference rate for each day an invoice is late, plus fixed compensation of £40, £70 or £100 depending on the size of the debt. Neither carries VAT. Switch Late payment interest on under Settings → Automation and RiQ drafts the charge as an invoice once an invoice is paid late or is still unpaid 30 days after it fell due; nothing is sent until you issue it. The reference rate is fetched from the Bank of England for each half-year. The Act is for business customers only, so RiQ drafts it for a customer set to Charge it, or for one left on the business’s setting that has a VAT number; set a consumer never to be charged it. The charge goes to Interest Received (or Other Income), never to Sales.

Related guides

Recording A Customer Receipt And Allocating It

Sending a statement tells a customer what they owe; recording a receipt is how you mark it paid. When money lands, record it against the customer and allocate it to the invoices it clears so their balance — and your aged debtors — stay accurate.

  1. Open the customer, or go to the receipts list. From the customer’s detail page (or Sales → Receipts) choose Record receipt.
  2. Choose who paid and where the money landed. Select the customer and the bank account the funds arrived in.
  3. Enter the date, amount and an optional reference. The date is the day the money actually cleared, not the invoice date.
  4. Allocate the receipt across their open invoices. Tick the invoices this payment settles; you can spread one receipt over several, and part-pay an invoice rather than clear it in full.
  5. Save. IQ Books records the money into the bank and clears the same amount off what the customer owes. A receipt posts the moment you save — there’s no separate draft stage — and each invoice you allocated moves to partially paid or paid on its own. You never set those statuses by hand.

If the payment first arrives as an imported bank line, you don’t need to key it twice. On that bank draft, let CodeIQ match it to the outstanding invoice automatically or use Match to invoice to pick it yourself, then confirm. Money coming in is only ever matched to a sales invoice (money going out matches a supplier bill), so the direction has to agree before IQ Books will let you confirm. An invoice that is already fully paid can’t be matched again.

Partial Payments, Overpayments And Money On Account

Real payments rarely line up neatly with single invoices. IQ Books handles the awkward cases without you having to force the numbers.

  • Part payment. Allocate less than an invoice’s outstanding total and it moves to partially paid; the remaining balance keeps showing in aged debtors until the rest arrives.
  • One receipt, several invoices. A single lump sum can be split across as many open invoices as you like. Each allocation is capped at that invoice’s outstanding amount, and the total you allocate can never exceed the receipt.
  • Overpayment or payment up front. Anything you don’t allocate stays with the customer as money on account — a credit you can apply to a future invoice whenever you’re ready. You don’t have to allocate a receipt the moment you record it.
  • Nothing to allocate to yet. Record the receipt with no allocation and it simply sits on account until the invoice it relates to exists.
  • You can’t allocate to a draft or a void invoice. Only an issued invoice carries a real balance, so issue the invoice first.
  • Foreign-currency receipts. A payment in the same currency as the invoice can settle it in part; a receipt in a different currency is treated as settling the invoice in full, with any exchange difference booked automatically as an FX gain or loss.

Attaching Files To A Customer Or Their Documents

You can keep the paperwork with the record it belongs to — a signed contract on the customer, a remittance advice on a receipt, the customer’s copy of an invoice on the invoice itself.

  1. Open the record. Attaching works on a customer, a sales invoice, a receipt, a journal or a bank transaction.
  2. Click Attach and choose your file. Files up to 50MB are accepted.
  3. Find it in the record’s attachment list. Every file you add is listed on the record and can be downloaded again whenever you need it.
  4. Remove one you added by mistake. Deleting an attachment takes it off the list; your files are held securely and stored encrypted throughout.

Common Questions

IQ Books warned me I already have this customer. To stop your ledger filling up with “Acme”, “Acme Ltd” and “ACME” as three separate accounts, IQ Books flags it when a new customer’s name matches one you already have. If it really is a different business, confirm and carry on; if not, cancel and use the existing record so all their history stays in one place.

Is a customer the same record as a supplier? No. Customers and suppliers are set up the same way — name, default payment terms, default currency — but they’re kept as separate lists. A supplier record additionally holds their VAT number and, for a subcontractor, their CIS deduction settings. If a business both buys from you and sells to you, you create it once as a customer and once as a supplier.

I changed a customer’s default payment terms — why didn’t my old invoices update? The default is copied onto each invoice at the moment you raise it, so it only steers new documents. Invoices already issued keep the terms they were raised with; if one of those needs a different due date, adjust it on that invoice.

Why won’t IQ Books let me edit the journal behind a receipt? Anything that came from a document — a receipt, a payment, an invoice, a bill or a bank transfer — is corrected at its source, not on the journal it produced. Posted entries are never rewritten in place: IQ Books reverses the original and posts a fresh corrected one, and both stay on the record as an honest audit trail. So to fix a receipt, go back to the receipt (or the invoice it was allocated to), not the ledger.

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.