Setup & configuration · Guide 05 of 53
What RiQ found: suggestions and automation
RiQ reads your books every hour and whenever something changes, and lists what it found: things to know, things it has done for you, and changes that need your OK. You decide how much it does by itself.
RiQ keeps an eye on the books between your visits. When it spots something, such as a product running low, a bill that looks entered twice, or a credit note sitting unused, it says so in one place and, where it is safe, does the work for you. Nothing that posts to the ledger happens by itself unless you switch it on.
Where to find it
The RiQ found card on the dashboard shows how many suggestions are waiting. Click it to open the list: Needs your OK first, then To know about, with a chip for each part of the books (Sales, Purchases, Stock and so on) to narrow it to one. In the IQ Books phone app, the same list opens from the RiQ found row on Today.
RiQ’s suggestions also sit where you would act on them. Most screens (Customers, Sales invoices, Suppliers, Payments, Purchase orders, Products, Expenses, Banking, the Accounting tabs, Year-end close, the VAT return, Corporation tax, Aged debtors, Budgets, the Audit log) carry a RiQ found line above their content when RiQ has something there: how many, what kinds, and how many need your OK. Click it to open them on the spot. A customer, supplier, bank, expense claim, budget, invoice, bill, product or project shows what RiQ found about that one record, open.
Several of one kind
When RiQ finds the same kind of thing more than once (ten invoices to write off, four unused credit notes), they come as one card: the kind, how many, and the total, with a row each. Click a row to see its details. Each row has its own button and a menu (What it posts, Not now, Dismiss). To act on several at once, tick them and use the button at the foot of the card; anything that posts asks you to confirm the count and the total first. A card of notices has Got it, all, which only ever marks them seen.
What RiQ made
Anything RiQ made in the books carries a small plum star wherever it is listed, and a RiQ tag on its own screen: a draft purchase order, a draft invoice (from a project’s unbilled time, a repeat invoice, a late payment charge or a quote accepted online), a payment run, a bill filed from an email, an asset, a prepayment schedule, and the journals it posted. Hover the star to see what made it, whether RiQ did it by itself or someone accepted it, and when.
Three kinds of suggestion
Each card carries a label saying what accepting it would do.
- Notice: something worth your attention that changes nothing, such as two bills that look like the same document. Click Got it once you have looked.
- Posts nothing: a change to a record that posts nothing to the ledger, such as drafting a purchase order. RiQ can do these by itself; when it does, the Done for you tab says what was done and how to undo it.
- Changes the books: a change that posts a journal, such as capitalising a purchase, or that changes what someone owes, such as setting a credit note against an invoice (that posts no journal: the credit note posted its own when it was issued). It waits for your OK unless you have set it to act by itself in Settings, Automation. What it posts shows the journal first, or says that none posts; the button with the action’s name carries it out. A credit RiQ set against an invoice can be taken off again from the invoice, with Take off, and RiQ does not set that credit against the same invoice again.
Every suggestion can be dismissed, or put off with Not now until tomorrow, next week or next month. The list has three tabs: To review, Done for you and Dismissed. Check now runs the checks straight away instead of waiting for the next hour.
What RiQ looks for
- Reorder stock: when a product falls to its reorder level, RiQ works out how many to order and drafts a purchase order to the supplier you buy it from. Set the reorder level, the reorder quantity and Buy from on the product; without a supplier there, RiQ uses the one you last bought from. Nothing posts until the order becomes a bill.
- Duplicate bills: the same document entered twice, the same invoice number written another way, or the same amount from the same supplier within a week. RiQ shows the bills side by side and you decide.
- Allocate credit notes: an unused credit note while the same customer has an open invoice. RiQ proposes setting one against the other, starting with the invoice the credit note names.
- Allocate supplier credits: the same for a supplier credit note and a bill you still owe.
- Month-end bank reconciliation: for each bank with a feed that reports its balance, once the feed’s balance for the last day has settled (from the 5th, banks send some lines late): when it and the books agree and nothing is waiting in Review, the month is recorded as reconciled and that month’s lines ticked (it posts nothing, so RiQ does it by itself unless you set it to ask); when they do not, what stands between them, including a statement reconciled for that date with another closing balance or a feed figure that never settled. A month already reconciled whose books have since changed is said too.
- Lines coded unlike the rest: a bank line posted to an account your books have never otherwise used for that merchant, when the merchant has gone to one account at least five times in the year (four times in five or more). RiQ proposes moving it to the usual account (its posting is reversed and posted again, as recategorising it would), and says if its VAT code is not the usual one too. From your own books only; splits, transfers, invoice receipts, locked periods and filed VAT periods are left alone. It always asks; dismiss it when the difference was meant.
- Money counted twice: a bank line posted as income or spending while the same money is also a receipt, payment or refund recorded against that account, or the whole of a posted payment run (one bank debit for every supplier on it). RiQ proposes matching the line to it so the money counts once.
- File emailed bills as drafts: a bill emailed to your email-in address from a supplier already in your books, read cleanly (every line coded, nothing that looks like a duplicate), is filed as a draft bill with the document attached. Nothing posts. Undo with Put it back on the document under Documents, Filed.
- Issue bills that came by email: such a draft is offered for issuing, which posts it. RiQ asks first.
- Link bill lines to stock: a line on a draft bill that names one of your tracked products (its SKU, or its name on a bill from the supplier you buy it from) but is not linked to it. Linked, issuing the bill moves the stock.
- Link bills to purchase orders: a bill from a supplier you have an open order with gets its lines linked to the order lines they bill (same product, same description, or the amount and quantity left), so the order shows as partly or fully billed. It posts nothing, and a link you take off is never put back.
- Bills that do not match their order: a draft bill whose price is over the order’s (beyond the tolerance), or that bills more than was ordered or received, is pointed out before it is issued.
- Subcontractors to verify: CIS subcontractors with bills waiting to be paid who are not verified with HMRC, with a link to verify them together.
- Cash running low: from the 13-week cash calendar LedgerIQ works out from your books, when cash is forecast to go below zero in the next 13 weeks, RiQ says which week and what is due then.
- Targets off course: when a target saved in LedgerIQ’s scorecard that is measured from the books (debtor days, paid on time, days of stock, unbilled work) goes red, RiQ says by how much.
- Unusual in the books: from LedgerIQ’s anomaly checks over the last twelve months (cash posted at weekends or on bank holidays, round or just-under-a-threshold amounts, amounts far outside the usual for their account, large unusual entries, a month far busier than usual, entries that may be in the wrong account), one notice per kind of finding at medium risk and above, while one of its examples is from the last 60 days; and from what is usual for your books (over the months the books cover, so new books are not compared with months before they began): a cost more than twice its usual month (and up by at least £250), a first payment to a payee over £1,000 (one notice per payee, with all its payments; only once the books have three months of history; you can change the size, or set 0 for none), and a regular payee paid more than three times their usual (one notice per payee). Money moved between your own accounts is never a payment. Each lists the entries, which open the journal; Open the analysis shows the rest. It changes nothing, and there is often a good reason: it only says something is unusual for these books.
- Count stock for the year end: from a month before your financial year end to two weeks after it, while any product holding stock has not been counted by a count posted near the year end, a reminder to count it (or to finish the count you started, or to count the rest).
- Fixed assets from spend: equipment, vehicles, furniture or machinery of £1,000 or more net posted to an overhead expense (it proposes moving the cost to the asset account with a journal and adding it to the register), and spend already on an asset account with no register entry (it proposes the entry, after which depreciation catches up from the purchase). Repairs, hire, leases, running costs, cost of sales and materials, and a supplier you buy from six times or more a year on that account are never suggested. It asks first.
- Prepayments on bills: a bill line of £500 or more on a cost usually paid ahead (insurance, rent, rates, software, subscriptions, licences, memberships, advertising, hosting, maintenance contracts) that reads like months paid in advance: annual, renewal or a number of months in the wording, the same supplier billed a similar amount about a year before and nothing like it since, or at least three times their usual bill. A charge for a month (monthly rent, a monthly subscription) is never suggested. RiQ proposes spreading it: the cost moves to Prepayments on the bill date and a share is released to the expense each month end, over 12 months unless the bill says quarterly, six months or two years. It asks first. Undo: end the schedule under Prepayments & accruals, which releases the rest.
- Month-end accruals: from the 3rd of each month, a cost billed or paid on the same account in each of the three months before the month just ended, at a steady amount, with nothing in for that month, proposed as an accrual at the month end that reverses itself on the 1st (the usual amount, net of VAT). Never cost of sales, materials, subcontractors, payroll, tax, depreciation or interest. When the bill comes in dated in that month, RiQ offers to take the accrual out so nothing is counted twice. It asks first.
- Month-end FX revaluation: from the 2nd of each month, once the month-end rates are in, foreign bank balances and open foreign invoices and bills restated at that day’s closing rate, the unrealised gain or loss to exchange gains and losses, carried forward. It asks first; it can be set to post by itself. Undo: reverse its journal from View transactions.
- Year-end checklist: from 30 days before your financial year end until the year is closed, what is not finished (lines in Review, prepayments, accruals and depreciation not posted, the asset register, stock, draft invoices and bills, future-dated entries, VAT on purchases, the opening position, suspense, and for a company its corporation tax charge), each with a button to where you fix it. A notice: closing the year never waits on it.
- Corporation tax charge (limited companies): from the day after the financial year end until the year is closed, the year's corporation tax worked out from the books (see Corporation tax), to post as Corporation Tax Charge against Corporation Tax on the year end. It always asks first, says what to confirm on Reports, Corporation tax before you accept, and proposes nothing once anything is on the corporation tax charge for the year (by PrepIQ, by hand, or an adjustment for an earlier year). If the books change before you accept, it is refused and worked out again. s455 is never posted, and nothing is filed.
- Draft payment runs: with payment runs switched on, a couple of days before your pay day, the bills due by then (and overdue) gathered into a draft run, holding back suppliers without verified bank details, CIS bills that cannot be worked out yet, other currencies, and anything that would take cash below the amount you keep in the bank (checked against the cash forecast as the books stand, the most urgent bills first). Bills that fall due while the run is still a draft are added to it, not put on a second run. It asks first; accepting drafts the run (or adds to it) only, and you submit, approve, export and post it. Where cash could not be checked it always asks, even when set to automatic.
- Slow-moving stock: from LedgerIQ’s stock figures, products with no sale in 180 days, or holding more than 365 days of stock at the last twelve months’ rate of sale, with the money tied up in them. Both limits, and a value below which a product is ignored, are yours to set.
- Stock running out: products that, at the rate they sell, will run out before more could arrive (their lead time, or a default you set, plus a margin), counting what is already on order. Products at their reorder level are left to Reorder stock, which drafts the order.
- Margin dropping: from LedgerIQ’s sales figures, a product whose margin over the last 30 days is more than 10 points below its twelve-month average, or below cost, with what it sold for. The points and the number of sales needed are settable.
- Write stock down: stock held at more than it sells for (what it has actually sold for over the last 90 days, or its sales price when it has not sold lately) is proposed for a write-down to that, posting to Stock write-offs when you accept. You can also set a percentage to write down stock that has not sold for a long time (off unless you set it). It always asks first unless you choose otherwise.
- VAT return check: in the days before a VAT return is due (10 unless you change it), if its period has something worth checking first (bank lines still in Review, drafts or documents dated in it, a bank that does not reconcile, suspense, box figures no UK rate makes). The same list is on the VAT return under Before you file. Nothing stops the return being filed.
- Changes worth a second look: for owners, admins and bookkeepers, for a week after each one: a supplier’s payment details changed or a second account added for them, an employee’s reimbursement details changed (not the first ones they set for themselves, nor the same ones saved again; someone else setting a person’s first details is said; both also a phone notification to owners and admins who have joined, opening RiQ found, as that is the usual way a payment is rerouted: confirm a change by phone on a number you already had), the books unlocked back to an earlier date (by hand, by deleting the opening balances that set the lock, or by undoing a migration), someone invited, joining, leaving, removed or given another role, ReconcileIQ support given view-only access for a support ticket (and when it has ended), an invoice or bill voided, a receipt or payment deleted, a posted bank line taken back out of the ledger or deleted, and a manual adjustment over £10,000 (you can change the size). Removals are one notice per kind, person and day, with how many (a bulk void is one thing to look at). Only an owner or admin can mark one seen or dismiss it, in the app: not a bookkeeper, and not an assistant through the connector. A change to payment details, the lock or who has access is cleared by another owner or admin when there is one, not by the person who made it. Switching these alerts off, changing what they watch for, or turning all of RiQ’s checks off is done in the app, never through the connector. It changes nothing, and the audit log keeps the record. Not shown on demo companies.
- Draft invoices from customer orders: a customer’s purchase order emailed to your email-in address is drafted as a sales invoice with your own number, their order as its reference. It is never issued by itself. See Documents.
- Draft repeat invoices: a customer invoiced the same each month gets this month’s invoice drafted for you to check and issue. See recurring invoices.
- Quotes accepted online: when a customer accepts a quote on its page, the draft invoice it made is pointed out. See quotes.
- Who to chase: each week, the customers with overdue invoices and the next step for each. See credit control.
- Late payment interest (off unless you switch it on): statutory interest and compensation drafted for business customers who pay late. Late payment reference rate says when the Bank of England rate it needs is missing.
- Write off bad debts: invoices unpaid six months past due, suggested for writing off, with VAT bad debt relief where it is due. Claim VAT bad debt relief when it is due follows up a debt written off before its relief was due. Both only ever ask. See sales invoices.
- Unbilled time drafted into invoices: each month, a project’s unbilled time and costs drafted into an invoice. Project over budget warns at 80% of a project’s budget and again when it goes over; Task over its estimate when logged time passes a task’s estimate. See time and billing.
- Budget line overspent: a budget line spent past its budget, allowing for sales. See budgets.
- Expense claims to check: a submitted claim with something for the approver to look at (over a limit, a receipt also on another claim or a bill, the same spend claimed before). See employee expenses.
Choosing how much RiQ does
Settings → Automation sets this for the organisation. At the top, Off stops RiQ looking, Suggest only makes it ask about everything, and On lets each kind follow its own setting:
- Ask me first: every suggestion waits for you.
- Do it for me: for changes that post nothing, RiQ does them and lists them under Done for you.
- Do it when sure: for changes that post, RiQ acts by itself only when it is at least as sure as the level you choose (80% to 98%), and asks about the rest.
Reorder stock also takes how many days of sales an order should cover (7 to 180, 30 by default). Hover a kind’s name to see what it looks for. Beside it, open is what is waiting now (click it to see them) and done is what was done in the last 30 days. The chips at the top jump to each part of the books and show how many of its kinds are on. A kind’s own settings show while it is on. Only owners and admins can change these settings. Members with read-only access can see what RiQ found but not act on it.