PrepIQ VOL. IV · YEAR-END

Year-end working papers software · For accountants and practices

PrepIQ

Hand over the records. Get back the papers.

PrepIQ turns a client’s records into a complete, balanced, cell-linked year-end set, with every judgement flagged for your call.

Open PrepIQ ▶ Watch the demo Live on practice plans · Sole trader & limited company
8
Schedules in a finished set
0.00
Check row difference
100%
Cell-linked schedules
2
Entity types covered
§ Watch

A year-end set, taking shape.

§ PrepIQ The film · the whole year-end, in seven minutes
Unedited

Prefer the real thing?

The actual product, preparing an actual set.

or open on YouTube →
§ The short

The long winter, in two minutes.

A painted short about year-end: Hazel the accountant, a winter of client boxes, and RiQ preparing the working papers the way a good preparer would.

§ PrepIQ The Long Winter · a two-minute short, with narration
§ 01 · How it works

Four steps. Two are yours.

Hand over, RiQ prepares, you review, you sign off.

Step 00
Hand over
Ledger, paperwork, last year's file.
You · two minutes
Step 01
RiQ prepares
Reconciles, builds the schedules, posts the TB. No plugs.
RiQ · unattended
Step 02
You review
Every judgement flagged. Ask for changes; it reworks the set.
You · ask RiQ
Step 03
Sign off
Approve and download, in your firm's template.
You · final word
§ 02 · What it builds

The complete set.

Working-papers automation and accounts production in one pass — not a draft, but the set your firm files behind a return.

A finished PrepIQ set contains eight schedules; every posted figure is a live cell link back to its working sheet, and the set ties out to a 0.00 check row with no plugged figures.

Schedule · 01

Extended trial balance

Opening, recorded, unrecorded and adjustment columns — footing, self-balancing.

ColumnsRecorded · unrecorded · adj
FootingSelf-balancing
Check row0.00
Schedule · 02 · Tax

Capital allowances

AIA, FYA, pools, private-use restriction — tax-side only.

AIA
Schedule · 03

Fixed assets & depreciation

Built or rolled forward, NBV linked to the balance sheet.

Schedule · 04

Finance reconciliations

One cell-linked sheet per agreement, tied to the TB.

Schedule · 05

VAT & the tax computation

VAT reconciled; add-backs, allowances, corporation tax posted.

§ A real set · names redacted

Not a mock-up. An actual year-end set.

A real UK limited-company set, prepared by PrepIQ. Swipe through.

PrepIQ extended trial balance for a limited company
01 · Extended trial balance

The whole set, on one sheet.

Footed, balanced, check row nil.

PrepIQ fixed asset schedule
02 · Fixed assets

Built or rolled forward.

Additions, disposals, depreciation.

PrepIQ capital allowances schedule
03 · Capital allowances

Kept tax-side.

Pools, AIA, FYA — feeding only the comp.

PrepIQ hire-purchase reconciliation
04 · Hire purchase

One sheet per agreement.

Liability split current and non-current.

PrepIQ loan and finance reconciliation
05 · Loans & finance

Tied to the paperwork.

To the penny, interest and capital split.

PrepIQ corporation tax computation
06 · Tax computation

Profit to tax.

Add-backs, allowances, marginal relief.

PrepIQ notes and queries for accountant review
07 · Notes & queries

Every judgement, flagged.

Where records fall short, it says so.

PrepIQ completion statement reconciliation
08 · Completion statement

Reconciled line by line.

Broken out, posted, traceable to source.

Prepared by PrepIQ · reviewed and signed off by the accountant

§ 03 · Built for review

It flags like
your best senior.

01

Cross-checks the sources

Cashbook, agreements, correspondence — read together, clashes flagged.

02

Catches incompleteness

A recurring item appearing once means the records are short. It says so.

03

Refuses to fabricate

Posts only what is evidenced. Gaps shown, never plugged.

04

Drafts the client queries

Open questions become a ready-to-send client email.

It flags like a senior — not a guarantee it catches every error. Your review is the final word.

RiQ Review notes · hartley-joinery-ye25 3 flags
Flagged

HP agreement missing the final payment schedule. Drafted a client query for the closing figure.

Records gap

Fuel recurs monthly; October is missing. Marked TBC — nothing posted.

Your call

£6,000 to the director — dividend or DLA? Left unposted; both treatments noted.

client-email.txt — query email drafted, awaiting your edit
In testing we fed it deliberately broken records. It flagged the client's errors, and the ones we planted.
§ From PrepIQ's own test programme
§ 04 · Entities

Sole trader, or limited company.

The right template and rules per entity.

For · sole traders

Self-assessment, right.

  • Trade, property and savings split
  • Capital and drawings handled
  • Private-use restrictions applied
  • Equity rolled into capital
For · limited companies

Corporation tax, posted.

  • Corporation tax computed and posted
  • Directors' loan accounts, never merged
  • Dividends against reserves, queries raised
  • Reserves carried forward cleanly
§ 05 · Inputs

Any records.
Any platform.

No special export to produce — give it what the client already has.

01

GL exports

Xero, QuickBooks, Sage, Pandle, any CSV / Excel.

02

Bank statements

PDFs, scans and CSV.

03

Finance agreements

HP, loan, completion — one rec each.

04

Receipts & invoices

Scanned or photographed.

05

Prior-year papers

Closing becomes opening, proven to tie.

06

Your template

Your layout, preserved year to year.

Reads ledgers from XeroQuickBooksSagePandleFreeAgentany GL · CSV / Excel

Open PrepIQ and run a year-end.

§ 06 · Privacy

Private by default, yours to release.

Scoped to you. Cleared when the job is done.

Scoped

Scoped to you

Jobs isolated. Nothing shared across accounts.

Reviewed

Review before release

A finished set waits for your approval.

Removed

Removed when finished

Close the job; the documents are cleared down.

§ 07 · Native in IQ Books

PrepIQ has three siblings. They're all native in IQ Books.

Each tool takes over at a different point. Start where your books are.

§ 08 · Common questions

Frequently asked.

Anything else, email [email protected].

What does PrepIQ actually produce?
A complete year-end working papers set in your firm's template: the extended trial balance and its lead schedules, the fixed asset register and capital allowances, debtors, creditors, accruals and prepayments, bank, loans and HP, VAT, payroll, dividends and the director's loan account (drawings and capital for a sole trader) and the tax computation. Every figure is a live cell link.
What are year-end working papers?
Accounting working papers are the schedules behind a set of accounts: the extended trial balance and a lead schedule for each area, fixed assets, debtors, creditors, accruals and prepayments, bank, loans, VAT, payroll and tax, each showing how the year-end figure was reached and the evidence for it. They are what a reviewer checks before the accounts are signed off. PrepIQ prepares them from the client's records.
What is a working paper in an audit?
Audit working papers record the auditor's work: the tests performed, the evidence obtained and the conclusions reached, so another auditor could follow them. Accounts preparation working papers, the kind PrepIQ produces, record how the accounts were prepared: the extended trial balance, a lead schedule for each area and the adjustments, each with its evidence. Most small companies are exempt from audit, so for them the preparation file is the one that matters, and a well-built one makes any later review or tax enquiry far simpler.
Does PrepIQ do year-end accounts for sole traders and limited companies?
Yes. Year-end accounts work for both: self-assessment splits and drawings for sole traders; the director's loan account, dividends, reserves and corporation tax for limited companies.
Does it roll last year forward?
Yes. Last year's closing balances become this year's openings, proven to tie. No prior file, the client starts at nil.
Do I still review the work?
Always. Every judgement is flagged and nothing releases until you approve it. Send follow-ups and it revises the same set.
What records does it need?
A ledger export from any platform, plus the paperwork: bank statements, agreements, receipts. No special format.
How do I get access?
PrepIQ is live on the ReconcileIQ practice plans (Practice Essential and above). Open PrepIQ, upload a client's records and run a year-end; each job draws 5,000 credits (RiQ default) or 10,000 (RiQ maximum) from your allocation. One ReconcileIQ subscription covers all five products.
What is PrepIQ?
Year-end working papers and accounts production software for accountants in the UK and Ireland. Give it a client's ledger and paperwork and RiQ prepares the full set: extended trial balance, fixed assets, capital allowances, finance recs, VAT and the tax computation, every figure cell-linked and tied out, ready for your review.
Does it do Irish year ends?
Yes. Your practice picks its tax jurisdiction, United Kingdom or Ireland, and the set comes back on that rulebook and in that currency. Irish sets are written to Revenue and CRO conventions throughout: 12.5% on trading and 25% on non-trading income, the close company surcharge, wear and tear over eight years, section 438 on an overdrawn director's loan. A mixed practice can switch it for a single client, and Northern Ireland uses the United Kingdom setting. More on Irish year ends.
Does PrepIQ produce statutory accounts?
Not the accounts themselves. PrepIQ prepares the year-end working papers that statutory accounts are built from: the balanced extended trial balance, the lead schedules, the year-end adjustments and the corporation tax computation, for small companies under FRS 102 Section 1A and micro-entities under FRS 105. Your accounts production software takes the signed-off trial balance on to statutory accounts preparation and filing.
Does PrepIQ do the corporation tax computation?
Yes. For a limited company the tax computation schedule works out corporation tax at the banded rates, with marginal relief and associated companies, apportioned across financial years, and posts the charge as a year-end journal unless your firm profile says memo only. PrepIQ does not file the CT600; the computation feeds your tax software. To check a figure quickly, use our free corporation tax calculator.
How is PrepIQ different from accounts production software like Iris, TaxCalc or Capium?
Traditional accounts production software gives you templates to fill in. PrepIQ prepares the working papers themselves from raw records, then hands the finished set to you to review. It works from any platform's records.
What is the best accounts production software in the UK?
It depends where the time goes in your practice. Traditional accounts production software is strongest at statutory accounts and filing from a finished trial balance, but the hours usually go earlier, in building the working papers that get you to that trial balance. PrepIQ does that part: RiQ prepares the full year-end set from the client's records, cell-linked and tied out, and you review it before taking the signed-off trial balance into your accounts production software. It is built to sit alongside that software, not replace it.
§ 09 · Get started

Live now
on the practice plans.

Practice Essential and above. One subscription, the whole ReconcileIQ suite.

  • 5,000creditsA year-end job on RiQ's default engine
  • 10,000creditsThe same job on RiQ maximum
  • 1,250/ 2,500An Ask RiQ revision, default or maximum
Open PrepIQ Practice plans · UK and Irish practices

What you get

  • The full set, your template
  • Sole trader and limited company
  • UK or Irish tax rulebook, set per firm
  • Every figure cell-linked, tied out
  • Released only on your sign-off

See the full feature tour →

Give RiQ the records.
Get back the papers.

The preparation, done. Your time goes on the review and the advice. All four IQ tools are native in IQ Books — or standalone on the software you run now.

Year-end set

An example job · ready for review

  1. Extended trial balancetied ✓
  2. Fixed assets✓
  3. Capital allowances✓
  4. Finance reconciliations✓
  5. VAT and tax computation✓
  6. Judgements flaggedfor you
Open PrepIQ See the feature tour Live · data cleared when the job is done

The platform behind PrepIQ

Year-end is easier when the books keep themselves.

PrepIQ builds year-end working papers from a client's ledger. Inside IQ Books that ledger is already coded, reconciled and current all year — so year-end starts from clean books, not a scramble.

Keep clients in IQ Books and PrepIQ works from a ledger that was ready the whole time — bring the back-history over in one connection.

Prepare the records behind the year end