Ledger & adjustments · Guide 35 of 53
Posting manual journals and corrections
Adjustments, accruals, prepayments, year-end reclassifications. The Adjustments workspace is where you bypass the pre-built workflows and post directly. Immutability rules dictate how you correct mistakes.
Most of your activity flows through the pre-built workflows: invoices, receipts, bills, payments. The Adjustments workspace is where you reach for raw double-entry — the cases where the regular flows don’t fit.
When to use a manual journal
Three categories of need:
- Period-end adjustments. Accruals (“recognise this expense in the period it was incurred, even though we haven’t been billed yet”), prepayments (“defer this expense to the period it relates to”), depreciation entries you’re posting yourself rather than via the fixed-assets module.
- Reclassifications. Moving an amount from one account to another — for example, when an item posted to General expenses turns out to be a fixed asset.
- Corrections. An automated workflow posted the wrong account or amount; the regular “edit” path is closed because the original is issued.
If you find yourself reaching for manual journals as a regular pattern, that’s usually a sign that you should configure the regular workflow (bank rule, recurring template, etc.) rather than fix it after the fact.
Where to find it
Accounting → Adjustments opens the workspace. The list shows every manual journal entered, with date, reference, total, and posted/draft status.
The journal form
- Enter the date and a description of why (it shows wherever the journal appears).
- Add lines: the account, an optional memo, the VAT code if you are VAT registered, and a debit or a credit. Three lines show to start with; Add line gives up to six. You need at least two.
- The form shows a live total of debits and credits, and the journal cannot post unless they balance.
- For an accrual or an estimate, tick Reverse it automatically and pick the date (see below).
- Post adjustment posts it to the ledger straight away. There is no draft stage.
Journals that reverse themselves
An accrual or an estimate belongs to one month and comes out again at the start of the next. Tick Reverse it automatically, for an accrual or estimate and IQ Books posts the mirror of the journal (every debit a credit and every credit a debit) on the Reverse on date. That date starts as the 1st of the month after the journal’s date and follows the date as you change it, until you pick one yourself.
- The reversal posts on its day, checked every hour, or straight away if the date has already come (a back-dated accrual); if it cannot post, neither does the journal. If that date is in a locked period it posts on the first open day, once that day has come (never dated in the future).
- Both journals count in your reports: the month the journal is in carries the charge, and the reversal takes it out from the 1st.
- The journal’s detail says Reverses itself on the date, with Change the date and Take it off while it is waiting. A journal you have already posted can be set to reverse from its detail too.
- Once it has reversed, the detail says so and opens the reversal. To put the journal back, reverse the reversal; the journal then says its reversal was undone and can be set to reverse again. The original itself can no longer be reversed or edited by hand while its reversal stands, and the reversal is never edited, only reversed.
- A journal that reverses itself carries no VAT, neither a VAT code nor a line on VAT Control. The VAT belongs to the invoice when it comes.
- The reversal is posted in the name of whoever set the date. An accountant’s correction can only be set to reverse by someone who may correct the ledger.
Accounting → Year-end closelists journals set to reverse in the year that have not, before you close.
RiQ and the connector can post one too: a journal with a Reverse on date. From the 3rd of each month RiQ found also proposes accruals for regular costs missing from the month just ended, as journals that reverse themselves (see Prepayments & accruals).
The dr/cr convention
If you’ve never posted a manual journal before: each line is either a debit OR a credit, not both. The convention is:
- Debits increase Asset and Expense accounts.
- Debits decrease Liability, Equity and Revenue accounts.
- Credits do the opposite.
Most journals are two lines (one debit, one credit) but multi-line journals are common — e.g. a year-end accrual that splits across multiple expense categories.
Accounts a journal should not be the first place you touch
Two things happen when a manual journal lands on an account IQ Books works out for you.
Bank accounts are refused outright. A general ledger line with no bank transaction behind it can never be reconciled against a statement, so the cashbook and the ledger would disagree permanently. Record the movement in Banking → Add transaction (or as a transfer) instead. On a foreign-currency bank it would also corrupt the FX revaluation, so the refusal there is stricter still.
Control accounts are allowed, but you are told what you have just changed. These accounts have a list behind them — invoices, bills, stock movements, the fixed asset register, pay runs, CIS deductions — and the report that explains the balance is built from that list, not from the account. A journal moves the account without moving the list, so from that moment the two disagree and nothing else in the app will point it out. After posting, IQ Books names each control account you hit and what to go and check:
- Accounts receivable / payable — the aged debtors and aged creditors reports, and every customer statement, stop agreeing with the balance sheet.
- VAT control — boxes 1 and 4 of the VAT return are read from this account, so a journal here changes what you will file. Check the return for the period before submitting.
- Stock — the stock valuation report is built from movements, so it and the balance sheet figure will differ by the journal.
- Accumulated depreciation — depreciation posted by hand is not recorded against any asset and never appears on the fixed asset register.
- CIS, payroll and employee expense control accounts — a journal here will not appear on a CIS return or match any pay run or claim.
- Retained earnings — the year-end close computes this from the profit for the year, so a journal here is overwritten or double-counted at the next close.
This is a warning, not a block, and deliberately so: opening balances, the migration wizard and genuine corrections — a bad debt written off, a VAT misposting found after the return went in — all have to land on these accounts. The point is that you know which report has just stopped reconciling, and that the difference is the one you meant to create.
The immutability rule
Once a journal is posted, you cannot edit it. Database triggers physically prevent updates to journal_entries and journal_lines after posting. The only ways to change a posted journal are:
- Void it. The void posts a balanced reversing journal with
source_reference = reversal_of:N. The original stays in place; the reversal cancels its effect. Both are visible on reports. - Re-post a corrected version. After voiding, post the corrected journal as a new entry. This new journal’s reference can include “correction of #N” for clarity.
This pattern is by design. The audit trail must show every state the ledger was ever in — not just the latest. A regulator or auditor inspecting your books should see the mistake AND the correction, not just the final answer.
Bringing in a pay run
IQ Books runs no payroll itself: your payroll software does, and its figures come in as one journal. With payroll accounts on (Settings → Organisation, Payroll accounts), Accounting → Adjustments shows Bring in a pay run:
- Pick the payroll software (BrightPay, Xero Payroll, Sage Payroll, Moneysoft, IRIS, QuickBooks Payroll, Staffology or other), the date the employees were paid and, if you like, the period.
- Choose the export, CSV or Excel, a row per employee (title rows above the headings are fine). IQ Books matches its columns to gross pay, PAYE tax, employee and employer NI, employee and employer pension, student and postgraduate loans, other deductions and net pay, and adds the rows up: a total row is left out, whether it says Total or not, minus signs count (a correction row), and a file written with decimal commas is read as one. Change any column that is wrong; the totals can also be typed straight in.
- Other deductions (a court order, union dues, payroll giving) are owed to whoever ordered them, not HMRC: pick the liability account they go to.
- Check it shows the journal: wages, employer NI and employer pension debited; PAYE and NIC (tax, both NIs and loans), pension liability (both pensions), the other deductions account and net wages credited. A refund in the run (negative tax, say) posts on the other side.
- Post the pay run. The columns are remembered for that payroll software, so next month is choose the file, check, post.
Net pay is needed, because it is the check: gross pay less the employees’ deductions has to come to it (a penny an employee of rounding is allowed, and goes on the wages line), so a column matched wrongly is caught before anything posts. The same run cannot be brought in twice; if one was wrong, reverse its journal and bring it in again. Paying the net wages and HMRC from the bank then clears the control accounts. RiQ and the connector can post a pay run from its totals too.
Common patterns
Month-end or year-end accrual
You receive a bill in January for services in December. The bill is dated January, so the regular bill workflow puts the expense in January. To recognise it in December, post a manual journal dated 31 December: debit the expense category, credit Accruals, and tick Reverse it automatically (1 January). In January the reversal takes the accrual out and the bill posts normally. Net effect: expense recognised in December, nothing counted twice. For a cost that recurs every month, an accrual schedule under Accounting → Prepayments & accruals does this each month by itself.
Prepayment
You pay an annual subscription in March covering March to February. The bill is dated March, so the regular flow expenses it all in March. Rather than posting twelve journals, add a prepayment schedule under Accounting → Prepayments & accruals: it moves the cost to Prepayments and releases a twelfth each month end. RiQ suggests one when a bill or bank payment looks paid ahead.
Reclassification
Three months ago, an Amazon expense for £500 was coded to General expenses but was actually a piece of equipment that should be on the balance sheet as a fixed asset. Post a manual journal: debit Equipment (fixed asset), credit General expenses, for £500. Net effect: General expenses goes down by £500, balance sheet goes up by £500. Going forward, depreciation on the fixed asset is then handled by the Fixed Assets module.
Year-end
Accounting → Year-end close checks the year is finished before you close it (depreciation, prepayments and accruals posted, nothing in Review or suspense, among others) and then posts the closing journal that moves the year’s profit or loss to retained earnings. Any final adjustment is a manual journal you post first. Covered in the Reports & closing guide.
Related guides
Why Your Journal Won’t Post
IQ Books checks a journal before it will let it reach the ledger, so if the Post button refuses you it is almost always one of a short list of reasons. Here is each one in plain English, and how to clear it.
- At least two lines. A journal needs a minimum of two lines — one account debited, another credited. A single line can never balance, so it is rejected.
- One column per line. Each line takes an amount in either the Debit or the Credit column, never both. If you have typed into both on the same line, clear one of them.
- Positive amounts only. Every amount must be greater than zero. To reduce or reverse a figure, put it in the opposite column rather than typing a minus sign.
- No empty lines. Every line needs a figure in one column. A line that has an account picked but no amount will block the post — either fill it in or delete the line.
- Debits must equal credits. Watch the running Debit and Credit totals at the foot of the form; they have to match to the penny before the journal will post.
- A live account on every line. Each account must belong to this organisation and must not be archived. Un-archive it first, or choose a different account, if it will not select.
- A date outside any closed period. If the entry date falls on or before a date you have locked with a year-end close, the post is refused. Move the date into the open period.
Which Entries You Can Correct Here (And Which You Can’t)
The Adjustments workspace lets you correct journals you posted here: when you open one and edit the lines, date or description, IQ Books reverses the original and posts a fresh corrected entry, with both kept on the record. What it deliberately will not do is let you rewrite an entry that came from somewhere else in the app. Those must be changed at their source, because that is the only place the surrounding paperwork stays consistent.
- Bank transactions. A journal created by confirming a bank line is fixed back in Banking, on that transaction.
- Customer receipts and supplier payments. Change these on the receipt or payment itself, where the allocation to invoices and bills lives.
- Sales invoices and purchase bills. Edit, void or credit-note the document; you cannot reshape its journal by hand.
- Transfers between two bank accounts. Because both legs share one journal, you edit the transfer rather than either side’s posting.
Two further limits apply even to journals you can edit here: only an entry currently showing as posted can be corrected (an entry that has already been reversed is closed), and you cannot edit an entry into or out of a closed period — both its old date and its new date must sit after your latest lock.
Putting VAT On A Journal Line
Most VAT is captured for you when you raise an invoice or bill, or when you categorise a bank line, so you will rarely need a code on a raw journal. When you do — say an adjustment to a VATable expense — the rules are simple.
- VAT only sticks to income, expense and asset lines. Put a code on one of those and your VAT return picks it up. A code typed onto a balance-sheet line — a liability, equity or control account — is treated as no-VAT and ignored.
- The codes and their rates. ST is standard-rated (20%), RR reduced-rate (5%), ZR zero-rated (0%) and EX exempt (0%). Leave a line as no-VAT (NV) when it carries none.
- Correcting a journal re-checks the VAT. If you later correct an entry, any code sitting on a balance-sheet line is dropped automatically, so never rely on a manual journal to shuffle VAT around your control accounts.
- Reverse charge belongs on a bill, not a journal. Reverse-charge services, imported-goods (PVA) and CIS domestic-reverse-charge VAT are self-accounted on the actual bill. A hand-typed journal will not work that treatment out for you.
Fixing ‘Set A Valid VAT Number Or National Insurance Number’ Errors
You will usually meet these when you go to connect to HMRC or file, rather than when you post a journal, but the fix is quick and lives in your organisation settings.
- VAT number. Enter the plain nine-digit number with no spaces and no ‘GB’ in front, for example 123456789. Set it under Settings → Organisation. Both the VAT return and the HMRC connection refuse to run without it.
- National Insurance number. For Self Assessment updates, give it in the standard shape — two letters, six digits and a final letter, such as QQ123456C.
- Tax year. Where a tax year is asked for, use the two-year form, for example 2025-26, matching the 6 April to 5 April year.
These identifiers only need to be right when you connect to HMRC or file a return. Everyday bookkeeping and manual journals do not need them, so an unset VAT or NI number never blocks you from posting an adjustment.
Common Questions
- Do manual journals use up my credits? No. Posting journals, like all of IQ Books’ own bookkeeping, is free. Credits are only drawn by the AI features — RiQ Vision scanning a document, or CodeIQ coding your bank lines — never by posting an adjustment yourself.
- Can I post an adjustment by speaking? Yes. Hold to talk and describe a balanced journal, such as ‘debit rent £1,000, credit accruals £1,000’. RiQ checks it has at least two lines and that debits equal credits, shows you a confirm card line by line, and posts it only once you approve.
- Can I backdate a journal into a year I have already closed? No. A year-end close locks every date up to and including the close date, so an adjustment dated inside that window is refused. Post it in the open period instead.
- My journal only moves two balance-sheet accounts and carries no VAT — is that allowed? Yes. A journal does not have to touch the profit and loss, and it does not have to carry VAT. It only has to balance.