Skip to the guide
IQ Booksby ReconcileIQ

Setup & configuration · Guide 09 of 53

Importing customers, suppliers and invoices from a spreadsheet

Bring your customers, suppliers and past sales invoices and bills into IQ Books from a spreadsheet or another package's export, with a preview that checks every row before anything is saved.

If your customers, suppliers or invoices are in a spreadsheet, or in an export from Xero or QuickBooks, you don’t have to retype them. IQ Books reads the CSV, shows you exactly what it will do in a preview, and only writes once you say so.

Where To Find It

Open Settings → Import data, pick what you are importing (customers, suppliers, sales invoices or supplier bills) and drop in the CSV. The Template button downloads the columns with an example row.

This brings in lists and documents. To move a whole set of books from Xero, QuickBooks or Sage in one go (opening trial balance, outstanding invoices and bank accounts), use the Move my books migration instead. Bank statement lines are imported under Banking.

What The File Can Look Like

  • Exports as they are. Column names from Xero and QuickBooks exports are recognised (ContactName, InvoiceNumber, UnitAmount, TaxType and so on), as are plain names like Customer, Invoice number, Date and Unit price.
  • UK dates. 25/08/2025 is read as 25 August. 2025-08-25 and 25 Aug 2025 work too. A file that is plainly month first (US style) is read that way, and the preview says so.
  • Amounts as written. £1,200.00 is fine.
  • VAT. A VAT code column (ST, RR, ZR, EX, NV and the reverse charge codes) or a rate (20, 5 or 0). Xero and QuickBooks tax names are understood. EC tax codes are not, so those rows ask for a code.
  • One row per line. An invoice with three lines is three rows sharing the invoice number. If any line is wrong, none of that invoice comes in, so you never get a part invoice.

Read The Preview

  1. Check the dates. The ready rows show dates in words (3 Sep 2025), so a date read the wrong way round is easy to spot.
  2. Customers and suppliers. With Add customers that are not in the books yet ticked, names the file uses that aren’t in IQ Books are listed and created on import. “ACME LTD.” and “Acme Limited” count as the same name. An archived customer is never duplicated: restore it first.
  3. Accounts. An account can be given by our code or its exact name. Anything else (another package’s codes, such as Xero’s 200 for sales) is listed under Accounts to match, each with a suggestion; choose ours or click Use the suggestions. A sales line only ever goes to an income account and a bill line to an expense or an asset bought, never to a bank, VAT or control account.
  4. Rows with issues. Each says what is wrong: an unreadable date, a price that is not an amount, a voided invoice, a credit note, a foreign currency, a discount, or a total that doesn’t match the file’s own total. Fix them in the spreadsheet and preview again; the preview never writes anything.

Past Invoices: Issue Them And Their Payments

Imported invoices arrive as drafts unless you tick Issue them as well, which posts them to the ledger as documents already sent. Leave it unticked if your opening balances already include these invoices, or they would be counted twice.

When the file says what was paid (a Status of Paid, an amount paid or due, or a Paid yes/no column) and gives a payment date, choose the bank account the money went into (or out of). Each payment is then recorded on that date and matched to its invoice, and when the bank line arrives IQ Books finds the money already recorded. Payments with no date in the file are left for the bank line to match, so nothing is booked twice.

If Something Doesn’t Come In

After the import, a summary stays on screen: what was imported and issued, new customers added, payments recorded, and every row that did not come in, with the reason. The file stays loaded, so fix those rows and import the same file again. Anything already in the books is skipped (by name for contacts, by invoice number for invoices), so nothing is doubled.

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.