Notes · AccountingUK · A-Levels

Accounting for incomplete records

Many small businesses do not keep full double-entry records, so the accountant must reconstruct the missing figures to prepare financial statements. This chapter covers the net-assets (capital comparison) method of finding profit, the use of control accounts to derive credit sales and purchases, the use of mark-up and margin to find missing trading figures, and the construction of statements from incomplete information.

4 sections~18 min reading time3 competenciesLevel Standard 1 · Advanced 3

T·0777 / 18

Exam profile

AO1 · Understand the techniques for dealing with incomplete recordsAO2 · Reconstruct missing figures and prepare financial statements from incomplete recordsAO3 · Analyse and evaluate the reliability of statements built from incomplete records

Operators:calculatereconstructprepareexplainanalyseevaluate

basic level

AS-Level may introduce the net-assets method of finding profit.

higher level

The full A-Level expects the reconstruction of missing figures using control accounts and mark-up/margin and the preparation of full statements from incomplete records.

Depth

Text

Contents · 4 sections

Accounting for incomplete records

Incomplete records and the net-assets method#

StandardAQA 7127 3.14

The net-assets method of finding profit

Fig. 1Profit is deduced from the change in the owner's capital: the £15,000 increase in net assets plus the £12,000 of drawings, less any capital introduced, gives a profit of £27,000.

Incomplete records arise when a business - usually a small sole trader - does not keep a full double-entry system, so there is no ledger from which a trial balance and statements can simply be extracted. Instead there may be a cash book, some bank statements, files of invoices, and lists of assets and liabilities, but not the neat double entry the earlier chapters assumed. The accountant's task is to reconstruct the missing figures using the relationships that double entry guarantees - above all the accounting equation - so that a proper income statement and statement of financial position can be prepared. This is where a firm grasp of the accounting equation pays off, because it is the tool that fills the gaps.

The simplest situation is where the records are so sparse that even the sales and purchases cannot be found, and only profit is required. Here the net-assets method (also called capital comparison or the increase-in-net-assets method) is used. It rests on the expanded accounting equation: because profit increases the owner's capital and drawings reduce it, the profit for a period can be deduced from the change in the owner's capital (net assets) once drawings and any new capital are allowed for. In effect, if the owner is better off at the end of the year than at the start, after taking out drawings and putting in any new capital, the difference must be the profit the business made.

The method is applied in a clear sequence. First, calculate the opening capital as the opening net assets (opening assets minus opening liabilities) and the closing capital as the closing net assets. Then the profit is the closing capital minus the opening capital, plus the drawings taken during the year (added back because they reduced capital but were not a loss), minus any capital introduced during the year (deducted because it increased capital but was not profit). A worked example: opening net assets £30,000, closing net assets £45,000, drawings £12,000, no new capital. Profit = £45,000 - £30,000 + £12,000 - £0 = £27,000. The business's capital rose by £15,000 and the owner also took £12,000 out, so the profit that generated both must have been £27,000.

The net-assets method is quick and useful when detailed records are absent, but its limitation is precisely its lack of detail: it produces the profit figure but tells you nothing about how it was earned - no revenue, no cost of sales, no breakdown of expenses. It cannot produce a full income statement, so it cannot be used to calculate a gross margin or analyse performance. It also depends on accurate valuations of the opening and closing net assets, which may themselves be uncertain in a poorly-recorded business. So the method answers 'how much profit?' but not 'how was it made?', and where a full income statement is required the more detailed reconstruction techniques of the following sections must be used.

\text{Profit} = \text{Closing capital} - \text{Opening capital} + \text{Drawings} - \text{Capital introduced}

The net-assets method

Profit is the change in capital, adjusted for drawings (added back) and new capital (deducted). Capital = net assets = assets - liabilities.

Worked example

Finding profit from the change in net assets

A trader's net assets were £30,000 at the start of the year and £45,000 at the end. During the year she withdrew £12,000 and introduced no new capital. Calculate the profit for the year.

Find the change in capital
Capital = net assets. Increase in capital = closing £45,000 - opening £30,000 = £15,000.
Adjust for drawings and new capital
Add back drawings of £12,000 (they reduced capital but were not a loss); deduct capital introduced of £0 (none this year).
Calculate the profit
Profit = £15,000 + £12,000 - £0 = £27,000. The owner's capital rose £15,000 and she also took out £12,000, both funded by the £27,000 profit.

Result: The profit for the year is £27,000 - the £15,000 increase in net assets plus the £12,000 of drawings, with no new capital to deduct.

Typical mistakes

Deducting drawings instead of adding them back (or adding capital introduced instead of deducting it).
Using assets rather than net assets (assets less liabilities) as the measure of capital.

Active revision

A sole trader's net assets were £30,000 at the start and £45,000 at the end of the year. She took £12,000 in drawings and introduced no new capital. Calculate the profit for the year.

Active recall

Recall the key points — then reveal.

Sources: AQA A-level Accounting 7127 specification (AQA)

Deriving figures from control accounts#

AdvancedAQA 7127 3.14

Deriving credit sales

Fig. 2Credit sales are the balancing figure in the total receivables account: closing £10,000 + receipts £50,000 + discounts £1,000 - opening £8,000 = £53,000.

Where a fuller income statement is required, the missing sales and purchases figures can often be reconstructed using the total receivables and total payables accounts - the same control accounts met in the verification chapter, now used in reverse to find a balancing figure. The logic is that these accounts must balance, so if all the entries but one are known, the unknown can be found as the balancing figure. This is one of the most powerful reconstruction techniques and a common exam task, because a poorly-recorded business often knows its opening and closing receivables and its cash received, but not its credit sales.

To find credit sales, a total receivables (sales ledger control) account is drawn up. The debit side has the opening receivables and the credit sales (the unknown); the credit side has the cash and cheques received from customers, discounts allowed, sales returns, any irrecoverable debts, and the closing receivables. Because the account must balance, credit sales is the figure that makes it do so: credit sales = closing receivables + receipts + discounts allowed + returns + irrecoverable debts - opening receivables. A worked example: opening receivables £8,000, receipts £50,000, discounts allowed £1,000, closing receivables £10,000 - credit sales = £10,000 + £50,000 + £1,000 - £8,000 = £53,000, the balancing figure.

Credit purchases are found in exactly the same way from a total payables (purchases ledger control) account. Its credit side has the opening payables and the credit purchases (the unknown); its debit side has the payments to suppliers, discounts received, purchases returns, and the closing payables. Credit purchases is the balancing figure: closing payables + payments + discounts received + returns - opening payables. Adding any cash purchases gives total purchases for the income statement. The same balancing-figure idea reconstructs many other unknowns - a missing expense from an expense account with opening and closing accruals, or the cash taken as drawings from a cash summary - wherever an account can be built with one gap.

The reliability of these reconstructions depends on the accuracy and completeness of the figures that are known, and this is the evaluative point. If the cash received from customers is understated (for instance because some takings were not banked or were taken as drawings before banking), the derived credit-sales figure will be wrong, and any profit built on it will be misstated. The technique itself is sound - it follows inexorably from double entry - but its output is only as good as its input, so the accountant must corroborate the known figures (reconciling cash, cross-checking with the bank) and be alert to the gaps and the temptation, in a cash business, to omit takings. This is why incomplete-records reconstructions must be handled with care and, ideally, with a bank reconciliation to anchor the cash figures.

\text{Credit sales} = \text{Closing receivables} + \text{Receipts} + \text{Discounts allowed} + \text{Returns} - \text{Opening receivables}

Credit sales (balancing figure)

The figure that makes the total receivables account balance. Credit purchases are found the same way from total payables.

Worked example

Deriving credit sales as a balancing figure

A business had opening receivables of £8,000 and closing receivables of £10,000. During the year it received £50,000 from customers and allowed £1,000 of discounts. Derive the credit sales for the year.

Build the total receivables account
Debit side: opening receivables £8,000 and credit sales (unknown). Credit side: receipts £50,000, discounts allowed £1,000 and closing receivables £10,000.
Find the balancing figure
The two sides must balance. Credit side total = £50,000 + £1,000 + £10,000 = £61,000. Debit side must also be £61,000, so credit sales = £61,000 - opening £8,000 = £53,000.
State the result
Credit sales = closing £10,000 + receipts £50,000 + discounts £1,000 - opening £8,000 = £53,000.

Result: Credit sales for the year are £53,000 - the balancing figure that makes the total receivables account agree.

Typical mistakes

Putting an item on the wrong side of the control account, so the balancing figure comes out wrong.
Forgetting to include discounts, returns or irrecoverable debts when deriving the balancing figure.

Active revision

Opening receivables £8,000, receipts from customers £50,000, discounts allowed £1,000 and closing receivables £10,000. Derive the credit sales for the year.

Active recall

Recall the key points — then reveal.

Sources: AQA A-level Accounting 7127 specification (AQA)

Using mark-up and margin#

AdvancedAQA 7127 3.14

Mark-up and margin

Fig. 3The same gross profit of £20,000 is a 25% mark-up on cost (£80,000) and a 20% margin on sales (£100,000) - two views of one relationship.

A second powerful reconstruction tool exploits the fixed relationship between cost, gross profit and sales that a business's pricing policy implies. Mark-up is the gross profit expressed as a percentage of the cost of sales - it is the profit a business adds on to its cost when setting a price. Margin is the gross profit expressed as a percentage of the selling price (revenue). Because a business typically applies a consistent mark-up or margin, knowing one of the three trading figures (sales, cost of sales or gross profit) together with the mark-up or margin lets the accountant calculate the others - which is invaluable when one of them is missing.

Mark-up and margin are two views of the same gross profit, and converting between them is a frequently-tested skill. A mark-up of 25% means gross profit is 25% of cost; on a cost of £80,000 that is £20,000 of gross profit and sales of £100,000, so the margin (gross profit as a percentage of sales) is £20,000 / £100,000 = 20%. In general, a mark-up expressed as a fraction of cost converts to a margin by putting the same numerator over cost-plus-that-numerator: a mark-up of 1/4 (25%) is a margin of 1/(4+1) = 1/5 (20%). Conversely a margin of 1/5 is a mark-up of 1/(5-1) = 1/4. Being fluent in this conversion prevents a whole class of errors.

The technique is used to find a missing trading figure and then to reconstruct the trading account. If, for example, sales are known to be £100,000 and the business works on a 20% margin, gross profit is £20,000 and cost of sales is £80,000. The cost-of-sales relationship (opening inventory + purchases - closing inventory = cost of sales) can then be rearranged to find whichever of its components is missing: if opening inventory is £10,000 and closing inventory £12,000, purchases must be £80,000 - £10,000 + £12,000 = £82,000. In this way, a single known margin unlocks the whole trading account, even when purchases or inventory were never properly recorded.

The reliability of this method rests on the assumption that the mark-up or margin was actually applied consistently, and challenging that assumption is the evaluative dimension. In reality a business may vary its margin between product lines or over the year, may hold clearance sales at reduced margins, or may suffer theft or wastage that reduces the gross profit actually earned below what the standard margin would predict. A reconstructed figure that assumes a constant margin will then be wrong, and a discrepancy between the expected and actual gross profit can itself be a useful signal - of stock loss, theft, or a change in trading. So mark-up and margin are powerful reconstruction tools, but the accountant must be satisfied that the assumed relationship really held, and treat any unexplained gap as something to investigate rather than to smooth over.

\text{Mark-up} = \frac{\text{Gross profit}}{\text{Cost of sales}} \times 100\% \qquad \text{Margin} = \frac{\text{Gross profit}}{\text{Sales}} \times 100\%

Mark-up and margin

Two views of the same gross profit. A 25% mark-up (1/4) equals a 20% margin (1/5): margin = mark-up / (1 + mark-up).

Worked example

Reconstructing the trading account from the margin

A business achieves a gross margin of 20% on sales of £100,000. Its opening inventory was £10,000 and closing inventory £12,000. Calculate the gross profit, cost of sales and purchases.

Gross profit and cost of sales
Gross profit = 20% x £100,000 = £20,000. Cost of sales = sales - gross profit = £100,000 - £20,000 = £80,000.
Rearrange for purchases
Cost of sales = opening inventory + purchases - closing inventory, so purchases = cost of sales - opening + closing = £80,000 - £10,000 + £12,000 = £82,000.
State the results
Gross profit £20,000, cost of sales £80,000 and purchases £82,000 - all derived from the single known margin and the two inventory figures.

Result: Gross profit is £20,000, cost of sales £80,000 and purchases £82,000 - the 20% margin unlocks the whole trading account from the sales and inventory figures.

Typical mistakes

Confusing mark-up (on cost) with margin (on sales) and applying the wrong base.
Assuming a constant margin without questioning whether it truly held (theft, clearance sales, product mix).

Active revision

A business makes sales of £100,000 at a margin of 20%. Opening inventory was £10,000 and closing inventory £12,000. Calculate the gross profit, cost of sales and the purchases for the year.

Active recall

Recall the key points — then reveal.

Sources: AQA A-level Accounting 7127 specification (AQA)

Preparing statements from incomplete records#

AdvancedAQA 7127 3.14

Steps in reconstructing from incomplete records

Fig. 4The reconstruction sequence: from opening capital, through the cash summary and control accounts and mark-up/margin, to the adjusted financial statements.

Preparing a full set of statements from incomplete records combines the techniques into a systematic reconstruction. The usual approach is: first, establish the opening capital by listing the opening assets and liabilities (opening net assets); second, reconstruct the cash and bank position, using a cash and bank summary to find missing figures such as cash drawings or cash sales; third, use the total receivables and payables accounts to derive credit sales and credit purchases; fourth, apply mark-up or margin where a trading figure is still missing; and finally, adjust for accruals, prepayments, depreciation and irrecoverable debts exactly as for any sole trader, before drawing up the income statement and statement of financial position.

The cash and bank summary is often the linchpin, because in a cash business the takings and the drawings frequently pass through cash before banking. A common task is to find cash sales or cash drawings as a balancing figure in a cash account: opening cash plus receipts (cash sales, cash from receivables) less payments (banked, cash expenses, cash purchases, drawings) equals closing cash. If every figure but drawings is known, drawings is the balancing figure - a technique that also, uncomfortably, exposes whether the owner has taken more than was recorded. Reconciling the cash and bank positions anchors the whole reconstruction and reduces the risk that an error in the takings distorts the profit.

The statement of financial position then falls into place from the reconstructed figures: the non-current assets (at cost less accumulated depreciation), the closing inventory, the closing receivables and payables derived from the control accounts, the cash and bank balances, and the capital section built from the opening capital plus the reconstructed profit less drawings. Because the whole exercise rests on double entry, the statement of financial position should balance - net assets equal to closing capital - and if it does not, a figure has been reconstructed incorrectly. That final check is a valuable confirmation that the reconstruction hangs together.

Throughout, the accountant must remember that a reconstruction is a set of reasoned estimates built on incomplete data, and the professional judgement lies in corroborating the figures and flagging their uncertainty. The techniques are mechanically sound - they follow from double entry - but they depend on the reliability of the records that do exist and on assumptions (a constant margin, complete takings) that may not hold. So statements prepared from incomplete records are inherently less reliable than those from a full ledger, and this is the key evaluative point: they are the best that can be done with the information available, they are good enough for a tax return or a rough view of performance, but they should be treated with appropriate caution, and the real remedy is to persuade the business to keep proper double-entry records in future.

\text{Cash drawings} = \text{Opening cash} + \text{Receipts} - \text{Payments and banking} - \text{Closing cash}

Drawings as a balancing figure

Where drawings are the only unknown in the cash account, they are the balancing figure - which also reveals whether more was taken than recorded.

Worked example

Planning a reconstruction

A sole trader keeps only a cash book, bank statements and files of unpaid invoices. Set out the sequence you would use to prepare her financial statements, and identify the key check and the main limitation.

Establish opening capital and reconstruct cash
List the opening assets and liabilities to find opening capital (net assets), then draw up a cash and bank summary to find any missing cash figure (such as drawings or cash sales) as a balancing figure.
Derive sales, purchases and trading figures
Use total receivables and payables accounts to derive credit sales and credit purchases; apply the known mark-up or margin to find any remaining trading figure such as closing inventory or cost of sales.
Adjust, prepare and check
Adjust for accruals, prepayments, depreciation and irrecoverable debts, then prepare the income statement and statement of financial position. The key check is that net assets equal closing capital; the main limitation is that the figures are estimates resting on incomplete records and on the assumption that the margin held.

Result: The sequence is opening capital, cash summary, control accounts, mark-up/margin, adjustments, then the statements - checked by the statement of financial position balancing; the limitation is that the whole reconstruction is only as reliable as the incomplete records and assumptions behind it.

Typical mistakes

Skipping the opening-capital calculation, so the profit and the statement of financial position are wrong.
Failing to reconcile the cash and bank figures, letting an error in takings distort the whole reconstruction.

Active revision

Explain, in order, the steps you would follow to prepare an income statement and statement of financial position for a sole trader who keeps only a cash book and files of invoices, and state one limitation of the result.

Active recall

Recall the key points — then reveal.

Sources: AQA A-level Accounting 7127 specification (AQA) · Ofqual - GCE AS and A level qualifications (Ofqual)

References & sources

Sources

AQA

AQA A-level Accounting 7127 specification

Ofqual

Ofqual - GCE AS and A level qualifications

Accounting for incomplete records

4 sections~18 min reading time3 competenciesLevel Standard 1 · Advanced 3

Accounting for incomplete records

Key points

Finding profit from the change in net assets

Key points

Deriving credit sales as a balancing figure

Key points

Reconstructing the trading account from the margin

Key points

Planning a reconstruction

Sources

Accounting for incomplete records

Key points

Finding profit from the change in net assets

Key points

Deriving credit sales as a balancing figure

Key points

Reconstructing the trading account from the margin

Key points

Planning a reconstruction

Sources