📚 Worksheets and Answers | 工作表与答案
In A-Level Business (Cambridge), mastering the accounting worksheet is crucial for accurately preparing financial statements. A worksheet is an internal document that helps accountants organise and adjust data before finalising the income statement and statement of financial position. This article explains the purpose, structure, and step-by-step process of creating a 10-column worksheet, and provides a worked example with full answers to reinforce your understanding.
在A-Level商务（剑桥）课程中，掌握会计工作表对于准确编制财务报表至关重要。工作表是一种内部文件，帮助会计师在最终确定利润表和资产负债表之前整理和调整数据。本文解释十栏式工作表的目的、结构和逐步编制过程，并提供一个完整示例及答案，以巩固理解。
1. Understanding the Accounting Worksheet | 理解会计工作表
An accounting worksheet is a multi-column sheet used to move from an unadjusted trial balance to final financial statements. It is not part of the formal accounting records but serves as a draft tool to check the accuracy of adjustments and to simplify the preparation of reports.
会计工作表是一种多栏式表格，用于从调整前试算平衡表过渡到最终财务报表。它不属于正式会计记录，而是作为一种草稿工具，用于检查调整的准确性并简化报告编制。
Typical worksheets contain columns for the trial balance, adjustments, adjusted trial balance, income statement, and statement of financial position. They are especially useful when a business has many year-end adjustments, such as accruals, prepayments, or depreciation.
典型的工作表包含试算平衡表、调整、调整后试算平衡表、利润表和资产负债表等栏。当企业有多项年末调整（如应计费用、预付款项或折旧）时，工作表尤其有用。
2. Purpose of a Worksheet in Financial Accounting | 财务会计中工作表的目的
The worksheet helps to minimise errors by showing all account balances and proposed adjustments in one place. It allows the accountant to verify that total debits still equal total credits after adjustments, and to calculate net profit or loss before drafting the formal statements.
工作表通过在一个地方显示所有账户余额和拟议调整，有助于最大限度地减少错误。它使会计师能够验证调整后借方总额与贷方总额是否仍然相等，并在起草正式报表之前计算出净利润或亏损。
Additionally, worksheets facilitate the identification of missing entries and enable quick production of draft financial statements for management review without altering the actual ledgers.
此外，工作表便于发现遗漏分录，并能在不更改实际分类账的情况下快速生成供管理层审阅的草拟财务报表。
3. The 10-Column Worksheet Structure | 十栏式工作表的结构
A typical 10-column worksheet is divided into five pairs of debit and credit columns: (1) Unadjusted Trial Balance, (2) Adjustments, (3) Adjusted Trial Balance, (4) Income Statement, and (5) Statement of Financial Position.
典型的十栏式工作表分为五对借方和贷方栏：（1）调整前试算平衡表，（2）调整，（3）调整后试算平衡表，（4）利润表，（5）资产负债表。
| Unadjusted Trial Balance | Adjustments | Adjusted Trial Balance | Income Statement | Statement of Financial Position | |||||
|---|---|---|---|---|---|---|---|---|---|
| Dr | Cr | Dr | Cr | Dr | Cr | Dr | Cr | Dr | Cr |
Only accounts that exist in the trial balance or are created by adjustments are listed in the first column. Revenue and expense items eventually flow to the income statement columns, while asset, liability, and capital balances move to the statement of financial position columns.
只有存在于试算平衡表或由调整产生的账户才会列在第一栏。收入和费用项目最终流入利润表栏，而资产、负债和资本余额则流向资产负债表栏。
4. Step 1: Entering the Unadjusted Trial Balance | 步骤一：输入调整前试算平衡表
Begin by listing all general ledger accounts and their balances at the end of the period. Enter debit balances in the first Dr column and credit balances in the first Cr column. The totals of these two columns must be equal, confirming the trial balance is balanced.
首先列出所有总分类账账户及其期末余额。将借方余额输入第一个借方栏，贷方余额输入第一个贷方栏。两栏合计必须相等，以确认试算平衡表是平衡的。
If the unadjusted trial balance does not balance, check for transposition errors, omitted postings, or incorrect ledger balances before proceeding to adjustments.
如果调整前试算平衡表不平衡，则在进入调整前检查换位错误、遗漏过账或不正确的分类账余额。
5. Step 2: Recording Adjustments | 步骤二：记录调整分录
Year-end adjustments are entered in the second pair of columns. Common adjustments include depreciation, accruals (e.g. accrued rent), prepayments (e.g. prepaid insurance), and closing inventory. For each adjustment, a debit and a credit are recorded, and a key or letter is often used to cross-reference.
年末调整输入第二对栏。常见调整包括折旧、应计费用（如应付租金）、预付款项（如预付保险费）和期末存货。每项调整都记录一个借方和一个贷方，通常用字母或编码交叉引用。
For example, if depreciation of £1,200 is charged on equipment, debit Depreciation Expense £1,200 and credit Accumulated Depreciation £1,200 in the adjustments columns. Ensure total adjustments Dr = total adjustments Cr.
例如，若设备折旧为1,200英镑，则在调整栏借记折旧费用1,200英镑，贷记累计折旧1,200英镑。确保调整栏借方总额等于贷方总额。
6. Step 3: Preparing the Adjusted Trial Balance | 步骤三：编制调整后试算平衡表
Combine the unadjusted trial balance figures with the adjustments to produce the adjusted trial balance. For each account line, add or subtract the adjustment to arrive at the adjusted balance. Transfer these to the third pair of Dr/Cr columns.
将调整前试算平衡表数字与调整分录合并，生成调整后试算平衡表。对每一行账户，加上或减去调整额，得出调整后余额。将其转入第三对借方/贷方栏。
Totals of the adjusted trial balance columns must once again be equal. If they are not, a mistake has occurred in extending the balances or in the arithmetic of adjustments.
调整后试算平衡表栏的合计必须再次相等。若不相等，则说明在扩展余额或调整算术中出现了错误。
7. Step 4: Extending Balances to Income Statement and Statement of Financial Position | 步骤四：将余额分别转入利润表与资产负债表栏
Take each line from the adjusted trial balance and decide whether it belongs to the income statement (revenues and expenses) or the statement of financial position (assets, liabilities, capital). Extend revenue and expense balances to the income statement columns: expenses go to the Dr column, revenues to the Cr column.
从调整后试算平衡表中取出每一行，判断它属于利润表（收入和费用）还是资产负债表（资产、负债、资本）。将收入和费用余额扩展至利润表栏：费用进借方栏，收入进贷方栏。
Asset, liability, and capital balances are extended to the statement of financial position columns: assets to Dr, liabilities and capital to Cr. Be careful with contra-asset accounts such as accumulated depreciation, which carry a credit balance and go to the Cr side of the statement of financial position.
资产、负债和资本余额扩展至资产负债表栏：资产进借方，负债和资本进贷方。注意累计折旧等抵销资产账户，它们有贷方余额，进入资产负债表贷方。
8. Step 5: Calculating Net Profit/Loss and Balancing | 步骤五：计算净利润/亏损并平衡工作表
Once all balances are extended, total the income statement Dr and Cr columns. The difference is the net profit (if Cr > Dr) or net loss (if Dr > Cr). Enter this balancing figure on the smaller side to make the columns equal, and carry it to the statement of financial position columns on the opposite side: net profit is added to the Cr side (increases capital), net loss to the Dr side.
所有余额扩展完毕后，合计利润表借方和贷方栏。差额即为净利润（若贷方大于借方）或净亏损（若借方大于贷方）。将这一平衡数字填入较小的一侧，使两栏相等，并将其转至资产负债表栏的对侧：净利润加至贷方（增加资本），净亏损加至借方。
Finally, total the statement of financial position columns. They should now balance. If they do not, re-check the extension of balances and the net profit figure.
最后，合计资产负债表栏。它们现在应该平衡。若不平衡，重新检查余额扩展和净利润数字。
9. Common Errors and How to Avoid Them | 常见错误及如何避免
One frequent mistake is placing an account in the wrong final column, e.g. extending a prepayment (asset) to the income statement instead of the statement of financial position. Always recall the nature of the account: prepaid rent is an asset, accrued revenue is an asset, accrued expense is a liability.
一个常见错误是将账户放入错误的最终栏，例如将预付款项（资产）扩展到利润表而非资产负债表。始终牢记账户性质：预付租金是资产，应收收入是资产，应计费用是负债。
Another error is forgetting to reverse the sign of a trial balance credit balance when it becomes an adjustment debit. Using a worksheet template and double-checking cross-references can dramatically reduce mistakes.
另一个错误是忘记在调整借贷时反转试算平衡表中贷方余额的符号。使用工作表模板并仔细核对交叉引用可显著减少错误。
Always ensure total debits = total credits at every pair of columns.
始终确保每对栏的借方总和等于贷方总和。
Label each adjustment clearly with a unique reference letter (a, b, c...).
用独特的参考字母（a, b, c……）清晰地标记每项调整。
10. Worksheet Practice Example with Answers | 工作表练习题与答案
The following information relates to Solo Trader for the year ended 31 December 2025. Unadjusted trial balance (extracts): Sales £98,000 Cr, Purchases £52,000 Dr, Rent £6,000 Dr, Insurance £3,000 Dr, Equipment £40,000 Dr, Accumulated Depreciation £4,000 Cr, Trade Receivables £14,000 Dr, Trade Payables £9,000 Cr, Cash at Bank £5,000 Dr, Capital £7,000 Cr. Adjustments needed: (a) Closing inventory £8,500; (b) Depreciation 10% straight-line on equipment; (c) Rent prepaid £500; (d) Insurance accrued £200.
以下信息与Solo Trader截至2025年12月31日的财年相关。调整前试算平衡表（摘录）：销售收入98,000英镑贷，采购52,000英镑借，租金6,000英镑借，保险费3,000英镑借，设备40,000英镑借，累计折旧4,000英镑贷，应收账款14,000英镑借，应付账款9,000英镑贷，银行存款5,000英镑借，资本7,000英镑贷。所需调整：(a) 期末存货8,500英镑；(b) 设备按10%直线法折旧；(c) 预付租金500英镑；(d) 应计保险费200英镑。
Partial worksheet solution (answer):
部分工作表解答（答案）：
| Account | Unadj. Dr | Unadj. Cr | Adj. Dr | Adj. Cr | Income St. Dr | Income St. Cr |
|---|---|---|---|---|---|---|
| Sales | 98,000 | 98,000 | ||||
| Purchases | 52,000 | 52,000 | ||||
| Rent | 6,000 | 500 (c) | 5,500 | |||
| Insurance | 3,000 | 200 (d) | 3,200 | |||
| Depreciation expense | 0 | 4,000 (b) | 4,000 | |||
| Closing inventory (IS Cr) | 8,500 (a) |
Depreciation charge: 10% x £40,000 = £ under current assets in the statement of financial position. The net profit calculated is £98,000 + £8,500 – £52,000 – £5,500 – £3,200 – £4,000 = £ atement Dr side to balance, then carried to the statement of financial position Cr column.
折旧费用：10% x 40,000英镑 = 4,000英镑。期末存货在利润表中作为贷方出现以降低销售成本，并在资产负债表中作为借方列在流动资产下。计算出的净利润为98,000 + 8,500 – 52,000 – 5,500 – 3,200 – 4,000 = 41,800英镑。净利润记入利润表借方以使平衡，然后转入资产负债表贷方栏。
11. Tips for Exam Success | 考试成功技巧
Practice drafting a 10-column worksheet using past paper questions. Focus on the logic of extending balances: all revenue and expense accounts go to the income statement; all asset, liability, and capital accounts go to the statement of financial position – but remember that drawings, although a capital account, is shown as a deduction from capital and appears in the statement of financial position Dr column.
利用历年真题练习编制十栏式工作表。重点关注余额扩展逻辑：所有收入和费用账户进入利润表；所有资产、负债和资本账户进入资产负债表——但请记住，提款虽然是资本账户，但作为资本减项列示在资产负债表借方栏。
Use a consistent layout and clearly label adjustments. Even if the question does not ask you to present a full worksheet, rough working in worksheet format can help you derive missing figures quickly and accurately.
使用一致的布局，并清晰地标注调整。即使题目不要求呈现完整的工作表，以工作表格式进行粗略运算也能帮助你快速、准确地推导出缺失数字。
Published by TutorHao | Business Revision Series | aleveler.com
更多咨询请联系16621398022（同微信）
或截图后用「扫一扫 → 相册」选择本图