Books check
The Books check answers one question: does your accounting package hold exactly what MechIQ invoiced?
It compares document by document -- each sales invoice, credit note, customer receipt, deposit and refund -- and tells you which ones match, which ones differ and why. It only reads. It changes nothing in MechIQ and nothing in your books.
Find it on Accounts → Books check. The garage owner runs a check. Front of house can read every result.
What it compares
MechIQ takes each invoice as it was given to the customer -- its lines, the VAT at each rate, its totals, and the account the customer is linked to -- and each payment as it was recorded. It compares that with what your package holds -- read from Sage Business Cloud through your connection, or from the export file you upload:
- Customer account -- is the document on the account this customer is linked to?
- Date
- Line net -- the net amount at each VAT rate
- VAT code, and the VAT amount at each rate
- Nominal -- is each line on the nominal your settings give it?
- Total
- Bank account -- for a receipt, deposit or refund
- Allocation -- which invoice the money is against
Amounts are compared to the cent. There is no rounding allowance: one cent is a difference.
Run a check
- Open Accounts → Books check.
- Choose the period: Last month, This month or Choose dates. A period can be up to one year.
- Choose what to check it against:
- A garage connected to Sage Business Cloud sees Check it against: Sage | An exported file. Leave Sage chosen and press Check against Sage. MechIQ reads what Sage holds for the period through your connection (Settings → Accounting). Nothing is uploaded, and nothing is written to Sage.
- Every garage can choose An exported file: under Upload the file, choose the file to check (see Which file to upload below) and press Check this file.
The check runs in the background. You can leave the page. The result is kept. One check runs at a time.
Checking against Sage Business Cloud
MechIQ reads from Sage, for the period: the sales invoices and credit notes with their lines (the ledger account and the tax rate of each line), the customer receipts and refunds with the documents they are allocated to and the bank account they went to, and Sage's own lists of tax rates and ledger accounts. Each invoice is found by the Sage id MechIQ stamped on it when it was sent, and by its number in the Sage Reference (a credit note is CN- followed by its number). What Sage shows as settled on an invoice is compared too: it must be what MechIQ has against it, allowing for receipts not sent yet and for credit notes.
Where a line belongs is read from your map in Settings → Accounting: the Sage ledger you chose for labour and for parts, and the Sage tax rate you chose for each VAT rate. A rate is read as its percentage, so an Irish 23% / 13.5% / 9% and a UK 20% / 5% are both compared by figure.
If Sage cannot be read in full, the check says Could not check Sage with the reason, and compares nothing:
- Your connection has expired or was revoked -- reconnect Sage in Settings → Accounting, then run the check again.
- Sage is busy or not answering -- nothing is saved as a finding; try again in a few minutes.
- Sage holds nothing for the period -- the check says so above the results. Check the period, and that the Sage business connected in Settings → Accounting is the one your books are kept in.
A garage whose Sage connection is the test connection, or a garage on Xero or QuickBooks, is told in one line that the check against its package is not available, and checks a file.
Which file to upload
MechIQ reads two files:
- The audit trail exported from Sage 50 -- the Transactions list, saved from Sage as
.xlsxor.csv. This is the file that shows what your books hold today. Keep the columns Type, Account, Nominal, Date, Ref, Net, Tax and T/C in the list when you export it. - The export file MechIQ made for your accounts (Accounts → Export), a
.csv. This shows every invoice that was changed, credited or re-allocated since that file went to your books.
The largest file is 5 MB. For a larger one, export a shorter period.
From a Sage 50 audit trail, the check reads sales invoices (SI), sales credit notes (SC), customer receipts (SA, SR) and customer refunds (SP). Supplier rows, journals, bank and cash rows and customer discounts are counted and named in the box above the list. They are not compared.
A receipt that MechIQ exported has its invoice number in the Sage Ref column, and the check compares it. A receipt or a refund that was entered in Sage with an empty Ref shows its allocation as not checked.
If MechIQ does not know the layout, it says "This file layout is not recognised". Nothing is compared.
A garage connected to Xero or QuickBooks
The check against Xero or QuickBooks is not available yet. The page says so in one line. You can still check an exported file.
Read the result
The tiles
| Tile | What it means | What to do |
|---|---|---|
| Matches | The file holds it exactly as invoiced. | Nothing. |
| Differs | The file holds it, but a figure or the account is different. | Open the document and read the reason. |
| Missing | MechIQ sent it. The file does not hold it. | It was deleted in the package, or it never arrived. Export it again, or restore it. |
| Unknown | The file holds it. MechIQ has no document with that number. | It was entered in the package by hand, or it belongs to another system. |
| Twice | The file holds it more than once. | Delete or void the extra one in the package. |
| Not sent yet | It is in MechIQ and has not gone to your books. | Export it from Accounts → Export. |
| Sent by file | A check against Sage: this document went to your books in an export file, not through the Sage connection. It is not looked for in Sage, and it is never counted as missing. | Nothing here. To check those documents, upload the export file's audit trail. |
| Not checked | This check could not tell for this document. | Read the note above the tiles. |
Press a tile to list only those documents.
What this check could not tell
A box above the list says, in words, anything the check could not read -- for example supplier rows and journals in the file, or rows that could not be read. A field that could not be read is never shown as a match.
MechIQ sent something different from the invoice
MechIQ also compares what it recorded as sent to your books with each invoice as issued. This needs nothing from your package. If MechIQ sent an invoice at another total, or recorded a payment as sent for more than it was, the document is listed under MechIQ sent something different from the invoice, with both amounts.
MechIQ will look at this -- you do not need to do anything. MechIQ is told about it at once.
Customers on more than one account
If one customer's documents sit on two accounts, a red box names the customer and the accounts. A customer has one account. Merge them in your package and put that account's reference on the customer in MechIQ (Customers → the customer → Edit → Accounting reference).
Control totals
Side by side, MechIQ and the file, for the whole period:
- Sales invoices -- net, VAT and total
- Sales net by nominal
- Net and VAT by rate -- invoices less credit notes, as on a VAT return
- Credit notes
- Receipts and refunds by bank account
A document not sent yet, or one MechIQ does not know, shows here as a difference: the tiles tell you which.
Tax codes in the file. The file's lines carry your package's tax codes (T1, T2 …). MechIQ turns each code into a VAT rate with your tax code map (Settings → Accounting). It does not take the map on trust: it also reads each code's rate from the file itself -- the code's VAT divided by its net, line by line -- and matches it to the VAT rates of your country (today's rates, past ones such as Ireland's 21%, and the rates on your own list in Settings → Tax).
A line is at a rate when its VAT is within one cent, or half a percentage point of its net, whichever is more. This allows for rounding to the cent, and for packages that work VAT out from a price with VAT in it. If a code's lines are at different rates, the code reads mixed.
A table lists the file by tax code: the code, the rate in your map, the rate in the file, net, VAT and the number of lines.
A box at the top of the control totals, What the file says about its tax codes, lists every finding in plain words, with the codes, the number of lines and the net:
- The map and the file disagree. For example: "T3 is mapped to 23% but its lines in the file are 21% (4 lines, €198.62 net)." Check the code in your package and your map. The comparison by rate still uses your map, so the VAT difference shows there.
- A code MechIQ sends that the file never uses. For example: "MechIQ sends 0% lines as T0; this file has no T0. Its 0% lines use T9 (1 line, €135.00 net)." Your books keep that rate under another code. Decide which code is right and change it in your package or in Settings → Accounting.
- A code with no rate in your map, at one rate in the file. It is compared at that rate anyway. Its row, and the row of the rate table it goes into, say rate read from the file, not your map. Add the code to your map in Settings → Accounting so the check does not have to guess.
- A code with no rate in your map, and no single rate in the file (mixed, not a rate of your country, or a line without its VAT amount). Its row is highlighted with its money, and its lines are not in the comparison by rate.
The check only gives advice. It never changes a setting. A check run before 15 November 2026 shows the older line above the tables instead ("1 tax code in the file has no rate: T9 …").
- The codes that have a rate in your map are always compared, whatever else the file holds.
- A rate MechIQ invoiced that no code in the file is at reads not in the file (on a check against Sage, not in Sage). A bank account MechIQ has money in and the books hold nothing in reads the same way.
- On a check against Sage, each bank account reads by its name and nominal code in Sage, for example Cash (1210).
- A line without its VAT amount makes only its own code's VAT read not read.
On a document, a code with no rate in your map that is at one rate in the file is checked at that rate. The document says so: "Tax code T9 is not in your tax code map. Every line under T9 in the file is at 0% (rate read from the file, not your map), so this document was checked at 0%. MechIQ sends 0% lines as T0."
Documents
Each document shows its result, kind, number, date, customer, and both totals. A document that needs attention opens by itself and lists every difference:
- What differs
- MechIQ has
- The file has
- What to do
Filter by Result, by Document, or search for a number or a customer. Download CSV gives the whole result, one row per difference -- send it to your bookkeeper.
When a check does not finish
If a check stops, it says The check did not finish and compares nothing. It never reports "everything is missing" and never reports "all correct". Run it again.
Past checks
Every check is kept under Past checks, with its period, what it read (Sage, or the file's name) and its result. Press one to see it again.
The dates it expects
The check expects each document on the date it has in your books: your garage's own day it was raised (your time zone, not UTC). A written-off invoice's write-off credit (INV-2026-0042-WO) is expected on the day it was written off, so a write-off in a later month is checked with that month.
Part of an invoice written off (the rest after a part payment, at checkout or in Take payment) is its own credit note, INV-2026-0042-WO, dated the day of the write-off and checked like any credit note. The invoice itself is expected at its full total, as it was issued: MechIQ never changes an issued invoice.
What is not checked
- Supplier invoices and supplier payments. This check covers sales and the money from customers.
- Invoices imported from your old system. MechIQ did not issue them.
- An invoice with no lines that carries VAT (Needs entering by hand). No export and no connected package carries it, so it is not looked for in your books.
- How a discount is shared between nominals. The invoice gives a discount per VAT rate, not per nominal. For an invoice with a discount, the check confirms the nominals used are the right ones, and checks the amounts per VAT rate.
Related: The Accounts page · Accounting settings · How MechIQ handles VAT and accounts