ACCA SBR Exam: How to Answer the Spreadsheet Question (Question 1 Technique)

Updated June 2, 2026 by Eduyush Team
ACCA SBR | Question 1

How to answer the ACCA SBR spreadsheet question: the 50-minute Q1 technique that protects your marks

Most SBR candidates do not lose Question 1 because they cannot consolidate. They lose it because they treat the spreadsheet like the whole answer, overrun on the numbers, and then rush the written analysis that usually decides whether Q1 becomes a pass-maker or a time trap.

This refreshed guide shows you how to approach the ACCA SBR spreadsheet question using a cleaner exam method: build a coherent spreadsheet fast, use the Own Figure Rule intelligently, and convert your workings into written marks that move you above 50%.

Quick answer

The right SBR Q1 technique is not spreadsheet perfection. Your real job is to produce a coherent, markable consolidation in about 50 minutes, then switch hard into explanation, implication analysis, and professional judgment.

  • Cap the spreadsheet at 50 minutes, not 90 to 110.
  • Treat the spreadsheet as evidence, not the whole answer.
  • Use the Own Figure Rule, so one doubtful working does not destroy the rest of Q1.
  • Protect Q3 and Q4, by hard-stopping Q1 at roughly 85 to 90 minutes total.

A 90% spreadsheet with complete narrative usually beats a near-perfect spreadsheet followed by thin discussion.

About Eduyush. Eduyush is an ACCA-focused learning platform with a strong SBR content cluster and related preparation resources across exam technique, resit recovery, paper selection, and structured coaching. This refresh builds on the live Q1 article, the attached spreadsheet-question draft, the wider SBR blog set, and the live SBR hub so the advice stays aligned with the rest of your internal content ecosystem. Current Q1 article · SBR article hub

Is this guide for you?

  • Yes, if you keep overrunning on Q1 and then panic on Q3 or Q4.
  • Yes, if you can do consolidation mechanics but your SBR mark is still stuck in the 40 to 49 range.
  • Yes, if you passed FR but now feel SBR Question 1 is much more judgment-heavy than expected.
  • No, if you still need to learn basic group accounting from scratch first.
  • No, if you want a pure consolidation theory article rather than an exam-technique article.
Section What you will learn
1. What Q1 is really testing Where the spreadsheet ends and the mark-rich narrative begins.
2. The 50-minute spreadsheet method How to build fast without losing control of the answer.
3. How to turn workings into narrative marks Why treatment, implications, and judgment often decide your score.
4. The 85 to 90 minute Q1 plan A clean timing model you can rehearse before exam day.
5. The mistakes that sink strong candidates Why technically good students still waste marks on Q1.
6. How to practise Q1 properly How to stop “studying” and start training for the paper.

Why does SBR Question 1 feel harder than it should?

Because many candidates misread what the question is actually rewarding. They see a spreadsheet, assume the marks must sit mainly in numerical precision, and then behave as if Q1 is an extended FR consolidation exercise rather than an SBR mixed-skill task.

But the live Eduyush Q1 article itself frames Question 1 as a combination of spreadsheet-based consolidation or correction work plus written explanation, implication analysis, and professional judgment. That means the spreadsheet matters, but it is not the whole scoring opportunity. 

Typical Q1 part What it really tests Where students go wrong
Part (a) spreadsheet Core consolidation logic, adjustments, presentation structure Over-invest Students chase perfection and consume the paper.
Part (b) treatment explanation Standard identification, reasoning, application Under-answer Students point at numbers instead of explaining the accounting.
Part (c) implications Stakeholder effect, performance meaning, covenant or reporting consequence Skip Candidates never reach the “so what?” layer.
Part (d) judgment Professional recommendation and balanced conclusion Rush They write one line when multiple marks were sitting there.
Later questions Recoverable, often easier marks elsewhere in the paper Sacrificed Q3 and Q4 get damaged by Q1 overruns.
Eduyush insight

The recurring resit pattern across the existing Eduyush drafts is not “I did not know the standard.” It is “I spent too long on the spreadsheet and left easier marks elsewhere.” That is exactly why Q1 needs to be treated as a timed process, not an open-ended accounting exercise.

Key takeaway

Question 1 is a mixed-skill task. The spreadsheet gets you onto the mark grid, but the written explanation, implications, and judgment are what separate a low-40s script from a passing script.

What is the best way to answer the spreadsheet question in SBR?

The best method is to build a clean skeleton first, populate major balances second, and stop before perfectionism starts eating time. You are aiming for a coherent answer that the marker can follow, not a finance-team-quality model with every small working polished.

The 50-minute spreadsheet method

Minutes 0–10
Read and extract facts

Identify acquisition date, shareholding, fair value points, intra-group issues, goodwill inputs, and the exact adjustments the scenario is signalling.

Minutes 10–20
Build the skeleton

Lay out columns and rows first: draft figures, adjustments, workings logic, and final consolidated outputs. A visible structure reduces panic.

Minutes 20–45
Complete the major adjustments

Prioritise investment elimination, goodwill or gain, NCI, fair value effects, key intra-group corrections, and the main statement movements.

Minutes 45–50
Sanity-check and move on

Fix obvious issues, label incomplete points if needed, and leave. This is the discipline moment that protects the rest of Q1 and the rest of the exam.

What you are not doing here is writing out journal entries, over-formatting the sheet, or chasing tiny rounding issues that add very little to the score. In SBR, that is usually a poor use of scarce time.

The spreadsheet is your evidence. The written answer is your argument. Examiners do not reward silent logic; they reward visible, explainable logic.

What must be visible on the spreadsheet?

  • Clear row labels for the main statement lines.
  • Separate workings or adjustment logic the marker can follow.
  • Major consolidation adjustments shown rather than hidden.
  • A sensible flow from draft to adjusted to consolidated figure.
  • Enough coherence that your later narrative can refer back to it.
Key takeaway

Structure beats polish. A fast, readable spreadsheet with visible logic is worth more than a beautiful but incomplete answer that leaves no time for the written marks.

Why do candidates lose marks even after building a good spreadsheet?

Because they stop at the numbers. SBR is not only testing whether you can calculate the adjustment; it is testing whether you understand why the treatment applies, what the adjustment means, and how it affects users of the financial statements.

That is why many candidates who feel “good” about Q1 still come out with disappointing scores. They produced workings, but not enough usable explanation.

Written task What to include Simple structure
Explain the treatment Name the standard area, state the rule, apply it to the facts Principle → why it applies → accounting effect
Discuss implications Show what changes in profit, assets, liabilities, ratios, or interpretation Adjustment → financial effect → stakeholder meaning
Professional judgment Reach a recommendation and support it Assess facts → weigh view → conclude clearly

A simple narrative framework that works

Use a compact Point → Explain → Apply structure. First identify the accounting point. Then explain why it applies in this scenario. Finally, say why that matters to investors, creditors, management, or the integrity of the financial statements.

“I already showed the goodwill number in the sheet. Why do I need to write it again?”
What is happening

You are assuming the marker will award explanation marks for an implied answer.

Fix: State the treatment, the trigger, and the effect in words.
“I know the standard, but my written answer still looks thin.”
What is happening

You are writing definitions instead of applying the standard to the exhibit facts.

Fix: Anchor every paragraph to the scenario, not to textbook memory.
“I ran out of time, so I just wrote one line for the implications part.”
What is happening

Your spreadsheet absorbed the time that should have been reserved for higher-level marks.

Fix: Protect at least 25 minutes for the non-spreadsheet parts.
“My answer was technical, but not persuasive.”
What is happening

SBR expects professional communication, not just accurate mechanics.

Fix: Always include the “so what?” for users and decisions.
Eduyush insight

The biggest written weakness across the Q1 materials is not missing theory. It is missing application. Students often know the rule but fail to connect it to the exact scenario, the statement effect, and the stakeholder consequence.

Key takeaway

Do not let the spreadsheet speak for you. In SBR, explanation marks are earned by explicit writing: what the treatment is, why it applies, and why it matters.

How much time should you spend on Question 1 in SBR?

The safest working rule is about 85 to 90 minutes total. That is enough time to build a credible spreadsheet, answer the written components, and stop Q1 from damaging the rest of the exam.

The 85 to 90 minute Q1 plan

Read 0–5
Read the full requirement

Do not start typing after the first exhibit. Understand every part so you know where the written marks sit.

Part A 5–55
Spreadsheet only

Work fast, show your logic, and do not cross the 50-minute line unless there is an obvious high-value fix.

Part B 55–65
Explain the treatment

Use a principle-and-application paragraph, not a theory dump.

Part C 65–75
Discuss implications

Translate the accounting effect into financial statement meaning and stakeholder consequence.

Part D 75–80
Professional judgment

Give a balanced recommendation and then actually conclude.

Finish 80–85+
Review and move

Clean obvious errors, then leave Q1. The rest of the paper still contains marks you can bank.

The uncomfortable truth: leaving Q1 while it still feels unfinished is often the correct exam decision.

Key takeaway

Time discipline is part of technique. You are not managing Q1 well if Q3 and Q4 become casualty zones.

What are the biggest mistakes candidates make in the spreadsheet question?

Most failures come from process errors, not intelligence gaps. Strong candidates often lose marks for the same predictable reasons because exam pressure pushes them toward overwork on the visible spreadsheet and underwork on the less visible narrative.

Mistake What it looks like in the exam How to fix it
Spreadsheet perfectionism 90 to 110 minutes spent on Part (a) Set a hard stop and rehearse it in mocks.
No visible workings flow Numbers appear with little explanation or progression Show a draft → adjustment → final logic path.
Definition-heavy narrative Textbook-style writing with weak scenario application Use scenario facts in every paragraph.
Skipping implications Answer stops after the accounting rule Always add “this means for users…”
Abandoning after one wrong figure Candidate freezes because goodwill or NCI seems wrong Use the Own Figure Rule and continue.
Writing journal entries nobody asked for Time drains into unnecessary mechanics Keep effort inside the spreadsheet and required narrative.

The Own Figure Rule: why it matters so much in Q1

If one early calculation goes wrong, that does not mean the rest of Q1 is dead. If your later workings and written comments use your own figure consistently and logically, you can still collect follow-through marks.

That is why panic is so expensive in SBR. The moment you stop writing because one number feels wrong, you turn a recoverable issue into a much bigger mark loss.

Eduyush insight

Perfectionists often underuse the Own Figure Rule because they psychologically treat one bad number as a collapsed answer. In reality, consistent follow-through is one of the best mark-protection habits you can build for Q1.

Key takeaway

Never blank the rest of Q1 because of one doubtful figure. A flawed but completed answer is usually much stronger than an accurate start followed by silence.

How should you practise SBR Question 1 before the exam?

You should practise Q1 as a timed performance, not as an open-book study exercise. Reading model answers and admiring them does not train the real skill, which is producing a good-enough spreadsheet and usable narrative under pressure.

A practical Q1 training routine

  1. Attempt a full Q1 in 85 to 90 minutes. Use the exact timing split you intend to use in the exam.
  2. Mark the attempt immediately. Identify whether the loss came from technical errors, poor time allocation, weak narrative, or missing implications.
  3. Rewrite only the weak section. If your implications answer was poor, rewrite that section rather than rebuilding the whole sheet.
  4. Repeat across 5 to 8 past Q1s. Pattern recognition improves quickly when the review is disciplined.
  5. Track your overrun points. If goodwill, NCI, or fair value adjustments always trap you, simplify your exam plan around those pain points.

What not to do in practice

  • Do not practise Q1 without a timer.
  • Do not keep restarting the spreadsheet to make it neater.
  • Do not read model answers before making your own attempt.
  • Do not ignore the written parts because “the spreadsheet is the main thing.”
  • Do not measure progress only by numerical accuracy; measure it by completion and time control too.
Key takeaway

Practise Q1 the way you must perform it. Timing, structure, and follow-through matter just as much as technical knowledge.

Questions students ask about the SBR spreadsheet question

These are the kinds of retrieval-style queries candidates increasingly type into Google, ChatGPT, Gemini, and Perplexity. Writing direct answers to them improves both reader usefulness and GEO discoverability.

Should I build a template spreadsheet for SBR Question 1?

No. Templates can help you understand structure during revision, but exam performance improves more when you build the framework from scratch. That trains recall, layout speed, and working memory under pressure. For the wider execution framework, read this SBR exam tips guide.

How detailed should my workings be?

Detailed enough that a marker can follow your logic, but not so detailed that each adjustment becomes a mini-essay. Think visible logic, not forensic modelling. If you are stuck in marginal-fail territory, pair this with our marginal fail recovery article.

What if my goodwill is wrong early in the question?

Keep going. The Own Figure Rule means consistent follow-through can still earn marks. What hurts more is stopping. That same resilience mindset is discussed in this failed ACCA exam recovery guide.

Is the spreadsheet the highest-value part of Q1?

It is high value, but not in the way most students think. It gets you core marks and gives you evidence for later parts, but Q1 becomes a pass-maker only when you also explain treatments and implications clearly. For the bigger paper-strategy picture, see our SBL vs SBR comparison.

Should I write journal entries in SBR Question 1?

Usually no, unless the requirement explicitly asks for them. In most cases, the spreadsheet already performs that function in a more exam-efficient format. Extra mechanics often become expensive time leakage.

How many Q1s should I practise before the exam?

Aim for at least 5 to 8 properly timed Question 1 attempts with review and selective rewriting. Fewer than that often leaves your timing untested; more than that is useful only if you are actively diagnosing recurring weaknesses.

📘

Need structured Q1 practice instead of random revision?

If your problem is not IFRS knowledge but exam execution, use materials that force timed practice, visible workings, and mark-scheme alignment rather than passive reading.

Explore SBR coaching See SBR books

Related SBR resources

The live SBR hub already clusters the spreadsheet article with adjacent topics including SBR vs FR, SBL vs SBR, difficulty comparison, and course-selection content. Use those contextual links inside the article body so both readers and search systems can understand how this page fits the broader SBR topic graph.

Resource Why read it next
ACCA SBR article hub Browse the wider SBR cluster and keep internal linking tight around the paper.
ACCA SBR exam tips Best companion piece if you need the wider technique framework beyond Question 1.
SBR marginal fail guide Useful if your score is stuck in the high-40s and Q1 overruns are part of the problem.
SBL vs SBR Helpful for candidates deciding paper order or trying to understand the judgment shift.
SBR vs FR: why passing FR is not enough Important if you are strong in FR mechanics but still surprised by SBR style and mark demands.
Is SBR the hardest ACCA paper? Useful for expectation-setting if you are comparing Strategic Professional papers.
Best ACCA SBR online course Good next step if you need structured coaching rather than more solo revision.
Failed ACCA exam recovery Helpful if this article found you after a difficult sitting and you need a reset plan.
🚀

Ready to stop losing marks on Q1?

The SBR spreadsheet question is not something you beat through brute force. You beat it through structure, time control, and the confidence to move from numbers into professional explanation before the paper moves on without you.

If your current revision is producing long hours but unstable marks, switch to a preparation system that trains Question 1 the way it appears in the real exam.

Join SBR coaching Get SBR books Read more SBR guides

Leave a comment

Please note, comments must be approved before they are published

This site is protected by hCaptcha and the hCaptcha Privacy Policy and Terms of Service apply.

Back to ACCA exam articles and tips

FAQs

Continue reading

More from this series

View all ACCA exam articles and tips articles →
Substantive Procedures vs Tests of Controls: Key Differences
ACCA AA

Substantive Procedures vs Tests of Controls: Key Differences

eTHE #1 EXAM CONFUSION Substantive Procedures vs. Tests of Controls: The Clearest Explanation You'll Find AA examiners repeatedly...

Updated Jun 12, 2026 Quick read
What Is the Three Lines Model? CIA & ACCA Guide
ACCA AA

What Is the Three Lines Model? CIA & ACCA Guide

FOUNDATION CONCEPT Three Lines Model: Why Internal Auditors (CIA) Are the 'Third Line' (And Why AA Auditors Need...

Updated Jun 03, 2026 Quick read
How to Identify Going Concern Risks in Audits
ACCA AA

How to Identify Going Concern Risks in Audits

FACULTY INSIGHT Going Concern Risks in Audits: When & How to Identify Them (With Red Flag Checklist) ACCA...

Updated Jun 03, 2026 Quick read