Skip to the guide
IQ Booksby ReconcileIQ

Ledger & adjustments · Guide 37 of 53

Prepayments & accruals: schedules that keep the books right monthly

Spread an annual cost over the months it covers, defer income you have invoiced ahead of earning, and post month-end accruals that reverse themselves. Set the schedule once; the engine posts every month end.

Cash rarely lands in the month it belongs to. Insurance is paid a year up front; a retainer is invoiced before the work; the electricity bill for June arrives in July. Prepayments & accruals is the workspace that puts those timing differences right — automatically, every month, so the P&L is honest between year-ends rather than only at them.

Where to find it

Accounting → Prepayments & accruals shows every schedule with its balance, what has been released so far, and when the next posting is due. It is available on every plan, the free plan included.

The three kinds of schedule

  • Prepayment. A cost paid up front sits on the Prepayments asset account and is released to expense evenly each month — £1,200 annual insurance becomes twelve £100 charges in the months the cover actually spans.
  • Deferred income. The mirror image for money you invoice ahead of earning it: the amount sits on Deferred Income (a liability — you still owe the work) and releases to revenue month by month.
  • Accrual (auto-reversing). An estimated cost charged at each month end — Dr expense, Cr Accruals — and reversed the next morning. The estimate keeps every month honest; when the real bill arrives and is recorded normally, you simply end the schedule. Nothing double-counts, because each month’s accrual has already reversed before the next.

Adding a schedule

  1. Pick the kind, name it (“Annual insurance 2026-27”), and enter the amount — the total to spread for prepayments and deferred income, the monthly estimate for an accrual.
  2. Set the months to spread over and the start date. The first posting lands at the end of the start month.
  3. Choose the P&L account (the expense being spread, or the revenue being deferred). The balance-sheet side is automatic — IQ Books uses your Prepayments, Accruals or Deferred Income account, and creates it if the chart doesn’t have one.
  4. Optionally link the supplier bill or sales invoice the schedule came from, for the audit trail.
  5. For prepayments and deferred income: if the amount currently sits on the P&L account (the bill was coded straight to expense), tick post the opening move and IQ Books reclasses it onto the balance sheet first. If the bill was coded to Prepayments already, leave it off.

Prepayments IQ Books finds for you

Two places spot a cost paid ahead, so you rarely set one up from scratch. Both look at amounts of £500 or more on costs usually paid ahead: insurance, rent, rates, software, subscriptions, licences, memberships, advertising, hosting and maintenance contracts.

  • A bank payment in Review. One that looks like months paid ahead shows Spread over with a choice of 3, 6, 12 or 24 months (3, 6 or 24 picked already when it says quarterly, six months or two years). It looks paid ahead when the same merchant was paid a similar amount about a year before and nothing like it since, when it is about three times what they usually cost, or when it says annual, yearly, renewal, per annum, p.a. or a number of months or years (36 months, 3 years). One click posts it to Prepayments and starts the schedule. Money received with subscription wording is offered the mirror, income received in advance, on the same evidence; where it carries VAT, the line posts to the income account with its VAT (due when the money comes in) and the net moves to Deferred Income.
  • A bill. A bill line that looks the same way (a similar bill from that supplier about a year before and none in between, three times their usual, or the wording) appears in RiQ found as Spread … over 12 months (3, 6 or 24 when the bill says quarterly, six months or two years). It shows the bill, the monthly amount and why RiQ thinks it covers months ahead. Accepting moves the cost to Prepayments on the bill date and starts the schedule here, linked to the bill. If it covers a different number of months, decline it and add the schedule yourself. A bill already spread (by RiQ, by hand, by PrepIQ, or with a schedule since ended and archived) is not suggested again, even after the bill is edited. While its schedule runs, the bill cannot be voided and the spread line keeps its account and amount.

Accruals RiQ proposes

From the 3rd of each month, RiQ found looks at the month just ended for a regular cost that is missing: a supplier billed (or a merchant paid) on the same expense account in each of the three months before, at a steady amount (no month more than half as much again as another), with nothing of about that size on the account for that month, not even a draft bill or a line still in Review. It proposes an accrual at the month end for the usual amount (the middle of the three, net of VAT, £100 or more unless you change it under Settings → Automation) that reverses itself on the 1st. Cost of sales, materials and subcontractors, payroll, tax, depreciation, interest and spending that varies by nature (motor, travel, entertaining, supplies, postage, marketing) are never accrued. A supplier already accrued for that month by RiQ, an account accrued by hand at that month end, or one with an accrual schedule running, is left alone. If a bill then comes in dated in an accrued month (any of the last twelve, while the month is open), the month would carry the cost twice, so RiQ offers to take the accrual out (it reverses the accrual and its reversal, leaving the bill). It asks first.

Neither prepayment route is offered for a charge for a month: monthly rent, a monthly subscription or a line that says monthly or per month. “Subscription” or “licence” on its own does not count as paid ahead, since most are paid monthly.

What posts, and when

The engine runs hourly and posts anything due: releases dated the last day of each month, accrual charges the same, and each accrual’s reversal dated the first of the following month. Every journal is balanced, carries no VAT (VAT was dealt with on the source document), and shows in Accounting → View transactions like any other posting. Rounding is handled at the end: the final release of a spread carries whatever pennies remain, so the schedule always releases the total exactly.

Ending a schedule

  • Prepayment / deferred income: ending early offers to release the whole remaining balance in one journal — the clean way to close off a policy you cancelled — or to just stop, leaving the balance for a manual journal.
  • Accrual: ending stops the monthly charge; the last posted month still reverses on the first, so the books stay clean. End it when the real bill has been recorded.

Year-end and PrepIQ

When PrepIQ prepares your working papers, the adjusting journals it derives can be brought straight into the ledger from Accounting → Year-end close. Journals tagged as prepayments or deferred income offer to create the matching schedule for the new year at the same time — PrepIQ seeds it at year-end, and this engine runs it monthly from then on. Locked periods are handled the same way as fixed assets: months that fall inside a locked period collapse into one catch-up journal dated the first open day.

Each journal arrives with its lines already set to your ledger accounts: the captions the papers use (Trade debtors, Accruals, Corporation tax creditor) are matched to the accounts in your books. A line that could not be matched says Pick account; choose one and it posts with the rest. A journal marked Papers only moves a balance between two captions that are one account in your ledger (a loan split into due within one year and after, say). It changes how the accounts are presented, not the ledger, so there is nothing to post and it does not hold up the close.

Why this matters

Without schedules, the ledger is only right once a year, after the year-end adjustments. With them, the P&L you look at in July is already on an accruals basis — which is the whole point of accrual accounting, and what makes the monthly reports (and everything LedgerIQ builds on them) worth reading.

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.