6.4 Incomplete Records Techniques & Single Entry Conversion

6.4 Incomplete Records Techniques & Single Entry Conversion

In the real world—and frequently in ACCA exams—accountants do not always receive a perfect trial balance. Many small businesses (sole traders) do not keep a complete double-entry system (they use 'single entry'). Alternatively, records might be destroyed by fire, flood, or computer failure, or cash/inventory might be stolen.

The task of the accountant is to take the fragmentary information available and reconstruct the missing figures to produce complete financial statements. This is essentially accounting detective work.

1. The Net Assets Method (The Capital Equation)

If a business does not keep records of its income and expenses, it is impossible to draft a traditional Statement of Profit or Loss. However, we can deduce the net profit by looking at the change in the owner's wealth (net assets) over the year.

The fundamental accounting equation states: Assets - Liabilities = Capital (Net Assets)

The Capital Equation explains how capital changes over a period: Closing Capital = Opening Capital + Capital Introduced + Profit - Drawings

If we know the opening and closing net assets (by listing the assets and liabilities at the start and end of the year), and we know the owner's drawings and any capital they introduced, we can rearrange the equation to find the missing Profit figure.

Derived Profit Formula: Profit = Closing Net Assets - Opening Net Assets - Capital Introduced + Drawings (Note: If the result is negative, it indicates a Loss).

Worked Example: A sole trader provides the following:

• Net Assets at 1 Jan: $50,000
• Net Assets at 31 Dec: $65,000
• During the year, the trader paid $10,000 from personal funds into the business bank account (Capital Introduced).
• The trader took goods costing $4,000 and cash of $8,000 for personal use (Total Drawings = $12,000).

Calculate the Profit: Profit = $65,000 (Closing NA) - $50,000 (Opening NA) - $10,000 (Cap. Intro) + $12,000 (Drawings) Profit = $17,000.

2. Reconstructing Cash and Bank Summaries

If cash or bank transactions are not fully recorded, we can set up a T-account (a control account) for Cash or Bank to find the missing balancing figure.

Common missing figures we search for using this technique include:

• Cash sales (cash received from customers)
• Payments to suppliers (cash purchases or payables)
• Cash stolen by an employee
• Owner's cash drawings

Method:

1. Open a T-account for Cash/Bank.
2. Enter the Opening Balance on the debit side (if an asset).
3. Enter all known receipts on the debit side.
4. Enter all known payments on the credit side.
5. Enter the Closing Balance on the credit side (carried down).
6. The side that doesn't balance reveals the missing figure.

Example: Opening cash $500. Cash banked from till $15,000. Wages paid from till $2,000. Closing cash $800. What were the cash sales? Debit side: Opening ($500) + Missing Cash Sales (X) Credit side: Banked ($15,000) + Wages ($2,000) + Closing Bal ($800) = $17,800. Missing Cash Sales = $17,800 - $500 = $17,300.

3. Margin and Mark-up

Perhaps the most heavily tested technique in incomplete records is using margin and mark-up to find missing sales, cost of sales, or inventory figures. You must understand the mathematical difference between the two.

Both represent the Gross Profit, but they calculate it as a percentage of different bases:

• Mark-up: Gross profit expressed as a percentage of Cost of Sales.
• Margin (Gross Margin): Gross profit expressed as a percentage of Sales Revenue.

The Mathematical Relationship: Cost of Sales + Gross Profit = Sales Revenue

If Mark-up is 25%: Cost (100%) + Profit (25%) = Sales (125%)

If Margin is 20%: Cost (80%) + Profit (20%) = Sales (100%)

Conversion Formulas: If you are given a fraction, converting between them is simple:

• Margin = Mark-up / (1 + Mark-up)
• Mark-up = Margin / (1 - Margin)

Fraction Trick: If Mark-up is 1/4 (25%), then Margin is 1/5 (20%). If Mark-up is 1/3 (33.3%), then Margin is 1/4 (25%). (To go from Mark-up to Margin, add 1 to the denominator. To go from Margin to Mark-up, subtract 1 from the denominator).

4. Finding Missing Inventory (Stolen or Destroyed Goods)

When inventory is destroyed by fire or stolen, the business needs to calculate the value of the missing goods for an insurance claim. We use the standard Cost of Sales equation and our knowledge of margin/mark-up.

The Equation: Opening Inventory + Purchases - Closing Inventory (what's left) = Cost of Sales

We can expand this to isolate the missing inventory: Opening Inventory + Purchases - Stolen/Destroyed Inventory - Actual Closing Inventory = Cost of Sales

Step-by-Step Method:

1. Calculate the Sales Revenue for the period up to the fire/theft.
2. Use the standard margin or mark-up percentage to calculate the Cost of Sales.
3. Plug the Cost of Sales, Opening Inventory, and Purchases into the equation.
4. The balancing figure is the value of the inventory that should be there but isn't (the destroyed/stolen amount).

Worked Example: A fire on 31 October destroyed most of a company's inventory.

• Opening Inventory (1 Jan): $30,000
• Purchases to 31 Oct: $180,000
• Sales revenue to 31 Oct: $240,000
• Inventory salvaged after fire: $5,000
• The company applies a uniform mark-up of 20% on cost.

Step 1 & 2: Find Cost of Sales Mark-up is 20% (1/5). Therefore, Margin is 1/6 (16.67%). Alternatively, Cost = 100%, Profit = 20%, Sales = 120%. Cost of Sales = $240,000 x (100 / 120) = $200,000.

Step 3 & 4: Use the Cost of Sales equation Opening Inv ($30,000) + Purchases ($180,000) - Expected Closing Inv (X) = Cost of Sales ($200,000). $210,000 - X = $200,000. Expected Closing Inv = $10,000.

The inventory that should have been in the warehouse was $10,000. The inventory salvaged was $5,000. Therefore, the cost of the inventory destroyed by the fire = $10,000 - $5,000 = $5,000.

Mastering these equations—the capital equation, the cash T-account, and the cost of sales/margin equation—gives you the tools to solve any incomplete records puzzle in the exam.