PrepIQ VOL. IV · YEAR-END
Private beta · for accountants & practices Issued ISS. I · 2026

Working papers.
Prepared for you.

Hand over a client's records. RiQ prepares the full year-end working papers set, the extended trial balance, fixed asset schedule, capital allowances, finance reconciliations, VAT and the tax computation, every figure linked back to its source and ready for your review. Sole trader or limited company, corporation tax and all.

Part of The IQ Suite Reconcile · Code · Analyse · Prepare
1 set Complete working papers
Any ledger Xero · QB · Sage · Pandle · CSV
ST + Ltd Right template per entity
100% linked Every figure traceable
§ Watch · the demo

See a full year-end set prepared and reviewed

A real client's records in; a balanced, cell-linked working-papers set out — schedules, tax computation and queries, ready for your sign-off.

§ PrepIQ A real client · sole trader & limited company
§ 01 · How it works

Hand over the records. Get back the papers.

Four steps, and only the first and last are yours. You hand over what the client already has, RiQ does the preparation, and nothing is released until you have reviewed and signed it off.

Step 00 · Hand over
Give it the records
Upload the client's bookkeeping or GL export and any supporting documents. Choose sole trader or limited company. Add a note if there is anything RiQ should know.
InputsAny format
EntityST · Ltd
Step 01 · Prepare
RiQ prepares
It reconciles every source, builds the schedules, posts to the trial balance with every figure cell-linked, and runs its own tie-out checks until the set balances.
Linked100%
Tie-outChecked
Step 02 · Review
Review & ask
Open the workbook and the notes. Every judgement and query is flagged. Ask RiQ to change anything, or add documents you forgot, and it reworks the same set in context.
QueriesFlagged
RevisionsIn context
Step 03 · Sign off
Approve & download
When it is right, you sign it off and download the finished working papers in your firm's own template. Nothing is released until you approve it.
OutputYour template
ReleaseOn approval
§ 02 · What it builds

A complete
working papers set.

Not a summary and not a draft. The full set your firm files behind a return, populated and balanced in the conventions you already use.

Schedule · 01

Extended trial balance

The heart of the set. Opening balances, recorded, unrecorded, adjustment and accruals columns, all footing and balancing. Recorded postings link from the working sheets, profit carries through to the balance sheet.

ColumnsRecorded · unrecorded · adj
FootingSelf-balancing
ProfitCarried to BS
Schedule · 02 · Tax

Capital allowances

Kept separate from the accounts, feeding only the tax computation. AIA, FYA, main and special pools, balancing allowances and charges on disposal, and the sole trader private-use restriction applied.

AIA · pools
Schedule · 03

Fixed assets & depreciation

The schedule built or rolled forward. Additions, disposals, gains and losses, the year's charge by class posted via the unrecorded columns, net book value linked to the balance sheet.

Schedule · 04

Finance reconciliations

A dedicated, cell-linked sheet for each hire-purchase, loan, mortgage or completion statement. Capital and interest split each period, liability carried forward and tied to the TB. One sheet per agreement, never merged.

Schedule · 05

Records summary, VAT & the tax computation

The client's bookkeeping summarised into the rows your trial balance expects, each figure tracing back to source. VAT reconciled and the tax computation completed, depreciation added back, capital allowances deducted, disallowables handled, and corporation tax posted to the adjustment columns for a profitable company.

§ A real set · names redacted

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

This is a real limited-company set PrepIQ prepared from a client's records. Swipe through the working papers — every figure cell-linked, every schedule tied out, every query flagged for the accountant.

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

The whole set, on one sheet.

Opening balances, recorded, adjustments, unrecorded and accruals columns — footed, balanced, with a live check row that has to come to nil.

PrepIQ fixed asset schedule
02 · Fixed assets

Built or rolled forward.

Additions, disposals, depreciation and net book value — carried forward from last year's papers where you have them.

PrepIQ capital allowances schedule
03 · Capital allowances

A tax schedule, kept separate.

Main and special pools, AIA and FYA at 100% — feeding only the tax computation, never the accounts. Total links straight to the comp.

PrepIQ hire-purchase reconciliation
04 · Hire purchase

One sheet per agreement.

Each HP reconciled on its own cell-linked schedule, with the liability split between current and non-current.

PrepIQ loan and finance reconciliation
05 · Loans & finance

Tied to the paperwork.

Loan and completion statements reconciled to the penny, with interest and capital cleanly separated.

PrepIQ corporation tax computation
06 · Tax computation

Profit, adjusted to tax.

Depreciation and disallowables added back, capital allowances deducted, marginal relief applied — and the effective rate shown.

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

Every judgement, flagged.

Where the records are incomplete or a treatment needs your call, it says so — and leaves the decision to you. Nothing plugged, nothing assumed.

PrepIQ completion statement reconciliation
08 · Completion statement

Reconciled line by line.

Property and finance completions broken out and posted into the accounts, each line traceable back to source.

Prepared by PrepIQ · reviewed and signed off by the accountant

§ 03 · Built for review

Every figure linked.
Every figure traceable.

Working papers are evidence. PrepIQ treats them that way. Nothing is a typed-in number you have to take on trust, and nothing is plugged to force a balance.

01 · Linked

Cell-linked, not hardcoded

Every posted figure on the trial balance is a live link to the working sheet it came from. Trace any number to its source in one click.

02 · Balanced

It has to balance

The recorded columns self-balance by double entry, profit ties through to capital, and the set will not finish with a difference left unexplained.

03 · Queried

Queries, not assumptions

Where a treatment needs your call or the client's confirmation, it is flagged as a cell note and a query, marked TBC, never silently decided.

04 · Reconciled

A reconciled status

Bank, fixed assets and every schedule-backed line carry a Rec mark referencing the sheet that supports them. Sparingly, so the signal means something.

05 · Clean

Zero formula errors

The set is recalculated and checked end to end before it reaches you. No broken references, no stale figures, no surprises in the print.

06 · Logged

A written log

Every posting, assumption, judgement and client query is recorded in a log alongside the workbook, so your review starts from a clear trail.

§ 04 · Why it is different

It reviews the records
the way your best senior would.

Most tools categorise a client's records and produce plausible numbers. PrepIQ interrogates them. It cross-references the cashbook against the client's emails and the loan, HP and completion statements, reasons about what a complete set of records should contain, and refuses to invent a figure to force a balance. Where the evidence falls short, it shows the gap and marks it unresolved rather than plugging it.

“We tried to catch it out. It corrected the client's errors, then it corrected ours.”

CROSS-REFERENCES

Reads the cashbook, the emails and the agreements together, and flags where they disagree.

REASONS ON COMPLETENESS

Recurring items that appear once are treated as a signal the records may be incomplete.

NEVER FABRICATES

Posts only what is evidenced, shows the gap, and leaves the judgement to you.

A reviewer's instinct, reliably present because it genuinely reasons over the inputs. It flags like a senior; it is not a guarantee that it catches every error, and your review is always the final word.

§ 05 · Entity coverage

Sole trader, or limited company.

The right template and the right rules per entity, chosen when you start the job. Not a generic set with the wrong equity treatment bolted on.

For · sole traders

Self-assessment, done right.

For unincorporated clients. Trade, property and savings income kept in their right places for the return, with the equity treatment a sole trader's accounts expect.

  • Trade, property (SA105) and savings split out
  • Capital introduced and drawings handled correctly
  • Equity consolidated into capital on carry-forward
  • Private-use restrictions on motor and use of home
  • Mileage versus actual costs, never both
For · limited companies

Corporation tax, posted.

For incorporated clients. Directors' loan accounts, dividends and reserves handled, and the corporation tax charge calculated and posted for a profitable company.

  • Separate directors' loan accounts, never merged
  • Corporation tax computed and posted as an adjustment
  • Dividends against reserves, with the queries raised
  • Overdrawn loan accounts flagged for your confirmation
  • Reserves and share capital carried forward cleanly
§ 06 · Inputs

Any records.
Any platform.

There is no special export to produce. Give PrepIQ what the client already has: a ledger from whatever software they use, plus the supporting paperwork, in whatever format it arrives. And give it last year's file, and it continues from there rather than starting blank.

01

GL exports

Xero, QuickBooks, Sage, Pandle, or any general ledger as CSV / Excel. Income and expenses mapped to nominals, reclassifications flagged not buried.

02

Bank statements

For the reconciliations and to evidence the recorded columns. PDFs, scans and CSV all read.

03

Finance agreements

Hire-purchase, loan and mortgage statements, plus completion statements. One cell-linked reconciliation per agreement.

04

Receipts & invoices

Scanned or photographed sales and purchase invoices, mortgage interest certificates and the rest of the supporting paperwork.

05

Prior-year papers

Last year's closing balance sheet becomes this year's opening balances, proven to tie. The schedules carry their brought-forward history.

06

Your template

Work from your prior file and your layout, labels and the way your firm presents a set are preserved year to year.

Reads ledgers from
XeroQuickBooksSagePandleFreeAgentAny GL (CSV / Excel)no special export to produce

Continuing clients keep their history; new clients start clean. Request early access.

§ 07 · Privacy

Private by default, yours to release.

Client financial records deserve care. PrepIQ is built so the data stays scoped to you and is cleared once the job is done.

Scoped

Scoped to you

Your jobs are yours. Each job is isolated and a user only ever sees and works on their own. Nothing is shared across accounts.

Reviewed

Review before release

A finished set waits for your approval. It is never auto-finalised, and every judgement is surfaced for you to confirm before sign-off.

Removed

Removed when finished

When you close a job, the client documents are cleared down. Records are processed for the job in front of you, not kept indefinitely.

§ 08 · The suite

PrepIQ is one of four.

One login, one subscription. Reconcile the bank, code the books, analyse the ledger, prepare the year-end set. Fronted by the same RiQ throughout.

§ 09 · Common questions

Frequently asked.

Everything you need to know about PrepIQ. Anything missing, email [email protected].

What does PrepIQ actually produce?
A complete set of year-end working papers in your firm's template: a records summary, the extended trial balance with opening balances and the recorded, unrecorded and adjustment columns, a fixed asset schedule, capital allowances, a reconciliation sheet for each HP, loan or completion statement, VAT, and the tax computation. Every posted figure is a live cell link back to its working sheet, so the whole set ties out and is traceable.
Does it handle both sole traders and limited companies?
Yes. PrepIQ uses the correct template for the entity you choose. Sole trader sets carry the self-assessment splits and roll the equity accounts into capital; limited company sets handle directors' loan accounts, dividends, reserves and the corporation tax charge for profitable companies.
Can it carry forward last year's figures?
Yes. Provide last year's working papers and PrepIQ rolls them forward. The closing balance sheet becomes this year's opening balances, proven to tie, and the fixed asset, capital allowance and finance schedules carry their brought-forward history. Without a prior file it treats the client as new and opens at nil.
Do I still review the work?
Always, and that is the point. PrepIQ prepares the papers and flags every judgement and query, then hands them to you. Nothing is released until you approve it. You can send follow-up instructions and extra documents and it will revise the same set, keeping the full context of what it already did.
What records do I need to give it?
A general ledger or bookkeeping export from any platform (Xero, QuickBooks, Sage, Pandle and others), plus the supporting paperwork: bank statements, hire-purchase and loan agreements, completion statements, mortgage interest certificates, and scanned or photographed receipts and invoices. There is no special export format to produce.
How do I get access?
PrepIQ is in private beta for accountants and practices. Request early access and we will be in touch. It joins ReconcileIQ, CodeIQ and LedgerIQ in The IQ Suite, one login and one subscription across all four.
§ 10 · Early access

In private beta
for accountants & practices.

PrepIQ is being rolled out to practices in a private beta. Request early access and we will be in touch. It joins ReconcileIQ, CodeIQ and LedgerIQ in The IQ Suite, one login and one subscription across all four.

See it first
How the workflow looks
  • Hand over a client's records and supporting documents
  • RiQ reconciles, builds the schedules and ties out the set
  • Review the workbook and the flagged queries
  • Ask for changes; it reworks the same set in context
  • Approve and download the finished papers
Before the year-end set

Clean books first.
Then the papers.

PrepIQ is strongest when the bookkeeping is already clean. CodeIQ is the intelligent automated bookkeeper that gets it there: coding each transaction, classifying VAT, matching invoices and posting back to the platform, in a few minutes per client.

  • Codes transactions and classifies VAT across the whole ledger
  • Matches invoices, detects transfers, handles merchant payouts
  • Posts to QuickBooks, Xero, Sage and Pandle
  • Learns your chart of accounts and your corrections
  • Ten concurrent client sessions per practice
Explore CodeIQ · included in the suite →
SHELL → Motor Expenses 97%
ADOBE → Software 91%
STRIPE → Sales 94%
HMRC → PAYE 88%
clean books, ready to prepare
One subscription · four products · one RiQ
After the year-end set

Papers prepared.
Now advise.

With the year-end done, LedgerIQ turns the client's general ledger into board-ready analysis. Forty-plus modules, ratios, trends and anomaly flags, with RiQ writing the commentary. The advisory conversation, ready to have.

  • 40+ analysis modules: DuPont, Altman Z-Score, CVP, cash flow and more
  • Works with Xero, QuickBooks, Sage and any CSV / Excel GL export
  • Established financial formulae · no black-box guesswork
  • RiQ explains every metric in plain English
  • One-click PDF board packs and Excel data exports
Explore LedgerIQ · included in the suite →
2.4×Current
18.2%ROE
A+Z-Score
38dDSO
£412KQ1 rev
3 flagAnomaly
40+ modules

Give RiQ the records.
Get back the papers.

PrepIQ does the preparation so your time goes on the review and the advice. In private beta for practices now. One subscription unlocks the complete IQ Suite.
Request early access See the feature tour Private beta · your data cleared when the job is done