📚 Year 11 SQA Accounting: Practical Assessment Key Points | SQA 会计实践考核要点
In the SQA National 5 Accounting course, the practical assessment—often carried out using spreadsheet software—tests your ability to apply double‑entry principles, process adjustments, and prepare final accounts for a sole trader. Success depends not just on knowing the theory but on working accurately, managing your time, and presenting information in a clear, professional layout. This guide walks you through the key areas examiners look for, from setting up your workbook to checking formulas and interpreting ratios.
在 SQA National 5 会计课程中，实践考核通常借助电子表格软件完成，考查你运用复式记账原则、处理调整事项以及为个体经营者编制最终报表的能力。成功不仅取决于掌握理论，更在于操作准确、时间管理得当，并以清晰专业的版式呈现信息。本指南将带你逐一了解考官关注的关键环节——从设置工作簿到检查公式、解读财务比率。
1. Understanding the Practical Assessment Structure | 理解实践考核结构
The assignment usually provides source documents, a trial balance and a list of adjustments. You will be asked to record transactions, complete ledger accounts, produce a corrected trial balance and draft an income statement and statement of financial position. Read every instruction twice before typing anything.
实践任务通常会提供原始凭证、一份试算平衡表以及一系列调整事项。你需要记录交易、完成分类账账户、编制更正后的试算平衡表，并草拟利润表和财务状况表。在输入任何内容之前，务必将每条指令阅读两遍。
Marks are awarded for correct use of spreadsheet features: formulas, cell referencing and formatting. A poorly laid out spreadsheet can lose marks even if the numbers are right. Always keep the end user—an examiner or a manager—in mind.
正确使用电子表格功能（公式、单元格引用和格式）可以获得分数。即使数字正确，排版凌乱的电子表格也可能失分。要始终考虑最终使用者——考官或管理者——的阅读体验。
2. Setting Up Your Spreadsheet Professionally | 专业地设置电子表格
Start with a clear name in cell A1, such as ‘Practical Assessment – Year 11’. Use separate sheets (tabs) for Journals, Ledgers, Trial Balance, Adjustments, Income Statement and Statement of Financial Position. Colour‑code the sheet tabs if that helps you switch quickly.
在单元格 A1 中输入清晰的名称，例如“Practical Assessment – Year 11”。将日记账、分类账、试算平衡表、调整事项、利润表和财务状况表分别放在不同的工作表（标签页）中。如果有助于快速切换，可以为工作表标签设置颜色。
Apply consistent formatting: bold headings, borders around data tables, and number formatting (e.g., accounting format with £ sign, zero decimals for whole pounds). Use the ‘Merge and Centre’ feature sparingly—only for main titles.
应用一致的格式：粗体标题、数据表格加边框，以及数字格式（例如，带 £ 符号的会计格式，整数不带小数）。谨慎使用“合并后居中”功能——仅用于主标题。
3. Using Formulas and Cell Referencing Correctly | 正确使用公式与单元格引用
Never type a calculated value where a formula can be used. The examiner needs to see that you understand how the number is derived. For example, use =SUM(B5:B10) instead of typing the total manually. For adjustments that appear in several places, link cells across sheets.
凡是可以用公式计算的值，绝不要手动输入。考官需要看到你理解数字是如何得出的。例如，使用 =SUM(B5:B10) 而不是手动输入合计数。对于在多处出现的调整项，要跨工作表链接单元格。
Learn the difference between relative, absolute and mixed cell references. Use $ signs to lock a reference when copying a formula (e.g., =B5*$C$2). This is essential for depreciation calculations or applying a standard VAT rate.
了解相对引用、绝对引用和混合引用的区别。复制公式时使用 $ 符号锁定引用（例如 =B5*$C$2）。这对于折旧计算或应用标准增值税税率至关重要。
4. Recording Transactions in the General Journal | 在普通日记账中记录交易
For any transaction not already entered in the ledger, you must show the double‑entry in the General Journal. Clearly state the date, details, debit account, credit account and amounts. Narratives (short explanations) are usually required and earn a mark.
对于尚未记入分类账的任何交易，你必须在普通日记账中列出复式分录。明确写出日期、摘要、借方账户、贷方账户和金额。通常需要撰写简要说明（叙事），这也会得分。
Common journal entries include corrections of errors, purchase of a non‑current asset, introduction of capital, drawings of goods and the creation of an allowance for doubtful debts. Make a check list of these standard entries and practise them.
常见的日记账分录包括更正错误、购买非流动资产、投入资本、提用商品以及计提坏账准备。将这些标准分录整理成清单并反复练习。
5. Posting to Ledger Accounts and Balancing | 过账到分类账账户并结平
Set up T‑accounts for every ledger item mentioned. Post the opening balances first—debit balances on the left, credit balances on the right. Then post the journal entries, cross‑referencing with a folio number or date. After all entries, calculate the balance carried down (c/d) and bring down the correct opening balance for the next period.
为每一个提到的分类账项目设置 T 型账户。首先过入期初余额——借方余额在左，贷方余额在右。然后过入日记账分录，用页码编号或日期进行交叉索引。所有入账完成后，计算结转余额（c/d），并准确转出下期期初余额。
Be careful with bank and cash accounts. If the bank column in the cash book shows a credit balance, it must be shown as an overdraft in the statement of financial position. Label the balancing figure clearly as ‘Balance c/d’ or ‘Balance b/d’.
处理银行和现金账户时要格外小心。如果现金簿中的银行栏显示贷方余额，在财务状况表中必须列为银行透支。清楚地标注结平数字为“Balance c/d”或“Balance b/d”。
6. Preparing an Accurate Trial Balance | 编制准确的试算平衡表
Once all ledger accounts are balanced, extract the closing balances to a new Trial Balance sheet. Use direct cell references (= ) to pull figures from the ledger sheet, so any later correction automatically updates the trial balance. The total of debit and credit columns must match.
所有分类账账户结平后，将期末余额提取到新的试算平衡表工作表中。使用直接单元格引用（= ）从分类账工作表取数，这样任何后续更正都会自动更新试算平衡表。借方和贷方栏的合计数必须相等。
If the trial balance does not balance, check for common errors: a one‑sided entry, transposition error (e.g., 96 instead of 69), or omission of an opening balance. Use the difference to help locate the error—if the difference is divisible by 9, a transposition error is likely.
如果试算平衡表不平，请检查常见错误：单边入账、数字颠倒错误（例如把 69 写成 96）或遗漏期初余额。利用差额帮助定位错误——如果差额能被 9 整除，很可能发生了数字颠倒。
7. Accruals and Prepayments Adjustments | 应计与预付调整
Adjustments for accruals and prepayments ensure expenses and income are matched to the correct period. For an accrued expense, the amount owing is added to the expense in the income statement and shown as a current liability. The double entry is Dr Expense, Cr Accrued expenses.
应计和预付调整确保费用和收入匹配到正确的会计期间。对于应计费用，应将欠款金额加计到利润表的费用中，并列为流动负债。会计分录为：借 费用，贷 应计费用。
For a prepayment, deduct the amount paid in advance from the expense in the income statement and show it as a current asset. Write the journal entries clearly and link the adjustment figures to both the income statement and statement of financial position cells.
对于预付费用，应从利润表的费用中扣减提前支付的金额，并将其列为流动资产。清楚地写出日记账分录，并将调整数字同时链接到利润表和财务状况表的相应单元格。
Adjusted Expense = Opening balance + Paid during year + Accrual closing – Prepayment closing – Opening accrual + Opening prepayment
8. Depreciation of Non‑Current Assets | 非流动资产折旧
You must be able to apply both the straight‑line and reducing balance methods. Straight‑line depreciation is calculated as (Cost − Residual value) ÷ Useful life. The reducing balance method multiplies the net book value by a fixed percentage. The SQA assignment will specify which method to use.
你必须能够运用直线法和余额递减法。直线法折旧计算公式为（成本 − 残值）÷ 使用年限。余额递减法以账面净值乘以固定百分比。SQA 任务会指定使用哪种方法。
Always show the depreciation journal entry: Dr Depreciation expense (Income Statement), Cr Accumulated depreciation (Statement of Financial Position). The net book value is Cost less accumulated depreciation. Link these cells so a change in rate or cost automatically recalculates.
始终列示折旧分录：借 折旧费用（利润表），贷 累计折旧（财务状况表）。账面净值等于成本减去累计折旧。链接这些单元格，以便更改折旧率或成本时自动重新计算。
9. Drafting the Income Statement | 编制利润表
Build the income statement using direct links to your trial balance and adjustments. The structure for a sole trader is: Revenue, less Cost of Sales (opening inventory + purchases – closing inventory) = Gross Profit, then add other income and deduct expenses to find Profit for the Year.
利用到试算平衡表和调整项的直接链接来构建利润表。个体经营者的利润表结构为：销售收入，减去销售成本（期初存货 + 购货 − 期末存货）= 毛利，然后加上其他收益并扣减各项费用，得出本年度利润。
Make sure you include every adjustment: accrued expenses increase the expense, prepayments decrease it, depreciation is an expense. An incorrect link or a hard‑typed number will break the model and lose marks. Use an IF statement to display a ‘Profit’ label if the result is positive and ‘Loss’ if negative.
确保涵盖每一项调整：应计费用会增加费用，预付费用会减少费用，折旧是一项费用。错误的链接或手动输入的数字会破坏模型并导致失分。使用 IF 语句，若结果为正则显示“利润”标签，为负则显示“亏损”标签。
10. Preparing the Statement of Financial Position | 编制财务状况表
The statement of financial position must show non‑current assets at net book value, current assets (including closing inventory, trade receivables, prepayments, bank/cash), current liabilities (trade payables, accruals, bank overdraft) and the capital section. Totals must balance: Net Assets = Capital + Non‑current Liabilities.
财务状况表必须按账面净值列示非流动资产，以及流动资产（包括期末存货、应收账款、预付费用、银行/现金）、流动负债（应付账款、应计费用、银行透支）和资本部分。合计数必须平衡：净资产 = 资本 + 非流动负债。
The capital section starts with the opening balance, adds profit for the year (brought in from the income statement) and deducts drawings. Use a formula to generate the balancing figure. Hard‑code only the opening capital and the drawings figure given in the question.
资本部分从期初余额开始，加计本年度利润（从利润表取数）并扣除提用。使用公式产生平衡数字。仅硬编码问题给出的期初资本和提用金额。
11. Calculating and Interpreting Ratios | 计算并解读财务比率
You will be asked to compute profitability and liquidity ratios. Key ratios include Gross Profit Percentage, Profit for the Year Percentage, Return on Capital Employed, Current Ratio, Acid Test Ratio and Rate of Inventory Turnover. Practise linking values directly from the final accounts.
你会被要求计算盈利能力和流动性比率。关键比率包括毛利率、年度利润率、资本回报率、流动比率、速动比率和存货周转率。练习直接从最终报表中链接数值。
Write a brief comment on what each ratio means. For example, a current ratio of 1.8:1 suggests acceptable short‑term liquidity. A falling gross profit percentage might indicate rising input costs or heavy discounting. Keep comments concise and evidence‑based.
就每个比率的含义撰写简短评论。例如，流动比率为 1.8:1 表明短期流动性可以接受。毛利率下降可能意味着投入成本上升或大幅折扣。评论应简洁且以证据为基础。
Gross Profit Percentage = (Gross Profit ÷ Revenue) × 100
Current Ratio = Current Assets ÷ Current Liabilities
12. Final Checks and Submission Tips | 最终检查与提交技巧
Before submitting, press Ctrl+` (show formulas) and scan the worksheet for broken references (#REF! or #VALUE!) or hard‑typed values where a formula is expected. Use the spell check tool—professional presentation includes correct spelling of account names. Ensure all sheet tabs are labelled and printer settings would fit on A4.
提交之前，按 Ctrl+`（显示公式）并扫描工作表中是否有断开的引用（#REF! 或 #VALUE!），或者在应使用公式之处存在手动输入的值。使用拼写检查工具——专业的呈现包括账户名称拼写正确。确保所有工作表标签均已命名，且打印设置适合 A4 纸张。
Save the file with a sensible name, such as ‘SQA_Accounting_Practical_YourName’. If required, print to PDF and check that all columns fit on the page, gridlines are visible and nothing is cut off. A well‑presented set of accounts reassures the examiner of your competence.
用合理的名称保存文件，例如“SQA_Accounting_Practical_YourName”。如果需要，打印为 PDF 并检查所有列是否适合页面、网格线可见且无内容被截断。一套版面整洁的账目会让考官对你的能力充满信心。
Published by TutorHao | Accounting Revision Series | aleveler.com
更多咨询请联系16621398022（同微信）
屏轩国际教育cambridge primary/secondary checkpoint, cat4, ukiset,ukcat,igcse,alevel,PAT,STEP,MAT, ibdp,ap,ssat,sat,sat2课程辅导，国外大学本科硕士研究生博士课程论文辅导