prepare the trial balance

Question

ScanSolve AI Tutor · Accepted Answer

here is the adjusted Trial Balance for the enterprise as at 31 May 2015, incorporating all the additional information and corrections.

Analyze the initial Trial Balance and identify account types.
The provided initial trial balance lists various accounts with their balances. We will assume these are the unadjusted balances before considering the additional information. The total of K3,446 given in the problem is the sum of the debit column as presented, not necessarily a balanced total.
Apply additional information and corrections to the relevant accounts.
- Initial Balances (K'000):
  
  Debits: Land and buildings (800), Motor vehicles (500), Office equipment (400), Inventories (Opening) (240), Receivables (60), Cash and bank (45), Sales returns (40), Purchases (900), Carriage inwards (30), Carriage outwards (38), Salaries (210), Suspense a/c (12), Office rent (48), Discount allowed (23), Office expenses (139), Distribution expenses (72), Utility expenses (25), Bank charges (14), Interest expense (45).
  
  Credits: Capital (800), Acc. dep. L&B (50), Acc. dep. MV (120), Acc. dep. OE (70), Prov. for doubtful receivables (4), Payables (42), Bank loan (500), Sales (1,650), Purchase returns (34), Discount received (31).
- (1) Inventories as at 31 May 2015 were K60,000.
  
  Closing Inventory: K60 (Debit). The opening inventory of K240 is removed from the trial balance and will be used in the income statement.
- (2) Depreciation:
  
  Building 2% on cost (cost K500): Depreciation = $0.02 \times 500 = \text{K}10$ .
  
  Depreciation Expense (Dr) K10.
  
  Accumulated Depreciation - Land and Buildings (Cr) K10. (New balance: $50 + 10 = \text{K}60$ )
  
  Motor vehicle 20% on reducing balance: NBV = $500 - 120 = \text{K}380$ . Depreciation = $0.20 \times 380 = \text{K}76$ .
  
  Depreciation Expense (Dr) K76.
  
  Accumulated Depreciation - Motor Vehicles (Cr) K76. (New balance: $120 + 76 = \text{K}196$ )
  
  Equipment 25% on reducing balance: NBV = $400 - 70 = \text{K}330$ . Depreciation = $0.25 \times 330 = \text{K}82.5$ .
  
  Depreciation Expense (Dr) K82.5.
  
  Accumulated Depreciation - Office Equipment (Cr) K82.5. (New balance: $70 + 82.5 = \text{K}152.5$ )
  
  Total Depreciation Expense: $10 + 76 + 82.5 = \text{K}168.5$ (Debit).
- (3) Prepaid rent was K8,000.
  
  Prepaid Rent (Dr) K8.
  
  Office Rent (Cr) K8. (New balance: $48 - 8 = \text{K}40$ )
- (4) Provision for doubtful debts to be set at K10,000.
  
  Current provision: K4. Required: K10. Increase needed: $10 - 4 = \text{K}6$ .
  
  Provision for Doubtful Debts Expense (Dr) K6.
  
  Provision for Doubtful Debts (Cr) K6. (New balance: $4 + 6 = \text{K}10$ )
- (5) Errors:
  
  (1) Credit sales K20,000 not entered:
  
  Receivables (Dr) K20. (New balance: $60 + 20 = \text{K}80$ )
  
  Sales (Cr) K20. (New balance: $1,650 + 20 = \text{K}1,670$ )
  
  (2) Distribution costs K6,000 included under office expenses:
  
  Distribution Expenses (Dr) K6. (New balance: $72 + 6 = \text{K}78$ )
  
  Office Expenses (Cr) K6. (New balance: $139 - 6 = \text{K}133$ )
  
  (3) Interest on loan not fully accounted (recorded K45,000). Loan K500 at 15%:
  
  Total interest due: $0.15 \times 500 = \text{K}75$ .
  
  Under-recorded interest: $75 - 45 = \text{K}30$ .
  
  Interest Expense (Dr) K30. (New balance: $45 + 30 = \text{K}75$ )
  
  Accrued Interest (Cr) K30.
  
  (4) Cheque K12,000 paid to supplier recorded in cash book but not payables:
  
  Payables (Dr) K12. (New balance: $42 - 12 = \text{K}30$ )
  
  Suspense Account (Cr) K12. (New balance: $12 \text{ (Dr)} - 12 \text{ (Cr)} = \text{K}0$ )
Prepare the Adjusted Trial Balance.
$\textbf{Trial Balance} \\ \textbf{As at 31 May 2015} \\ \textbf{(All figures in K'000)}$ $\begin{array}{|l|r|r|} \hline \textbf{Account Name} & \textbf{Debit (K)} & \textbf{Credit (K)} \\ \hline \text{Land and buildings} & 800 & \\ \text{Accumulated depreciation - Land and buildings} & & 60 \\ \text{Motor vehicles} & 500 & \\ \text{Accumulated depreciation - Motor vehicles} & & 196 \\ \text{Office equipment} & 400 & \\ \text{Accumulated depreciation - Office equipment} & & 152.5 \\ \text{Inventories (Closing)} & 60 & \\ \text{Receivables} & 80 & \\ \text{Provision for doubtful receivables} & & 10 \\ \text{Payables} & & 30 \\ \text{Cash and bank} & 45 & \\ \text{Bank loan at 15\% per annum} & & 500 \\ \text{Capital} & & 800 \\ \text{Sales} & & 1,670 \\ \text{Sales returns} & 40 & \\ \text{Purchases} & 900 & \\ \text{Purchase returns} & & 34 \\ \text{Carriage inwards} & 30 & \\ \text{Carriage outwards} & 38 & \\ \text{Salaries} & 210 & \\ \text{Office rent} & 40 & \\ \text{Discount allowed} & 23 & \\ \text{Discount received} & & 31 \\ \text{Office expenses} & 133 & \\ \text{Distribution expenses} & 78 & \\ \text{Utility expenses} & 25 & \\ \text{Bank charges} & 14 & \\ \text{Interest expense} & 75 & \\ \text{Prepaid Rent} & 8 & \\ \text{Depreciation Expense} & 168.5 & \\ \text{Provision for Doubtful Debts Expense} & 6 & \\ \text{Accrued Interest} & & 30 \\ \hline \textbf{Total} & \textbf{3,773.5} & \textbf{3,623.5} \\ \hline \end{array}$
The trial balance does not balance. The difference is K150 (Debit total K3,773.5 - Credit total K3,623.5). This indicates that there might be an uncorrected error or an initial imbalance in the problem's provided figures beyond what the suspense account addressed. However, all adjustments have been applied as per the instructions.

Prepare the trial balance

Step-by-step solution

Analyze the initial Trial Balance and identify account types.

Apply additional information and corrections to the relevant accounts.

Prepare the Adjusted Trial Balance.

Still stuck on this one?

More Accounting Questions