Incomplete Records Incomplete Records For many small businesses
Incomplete Records
Incomplete Records For many small businesses, they do not maintain a full set of double-entry books. All they keep are just invoices and bank statement. The preparation of the profit and loss account and balance sheet in circumstances where the bookkeeping records are inadequate or incomplete.
Reason for incomplete record Lack of accounting experience to maintain records. Cash misappropriated by the assistant. Goods stolen or lost by fire.
Trading and profit and loss account
T. Lee Trading and Profit and Loss Account for the year ended $ Sales (1) $ x Less: COGS Opening stock x Add: Purchase(2) x Less: closing stock x x Gross Profit (3) x Add: Discount received (4) x x Less: Expenses (5) Rent x Light x x x
Working 1: Sales = Cash Sales + Credit Sale NEXT
Cash Sales may be found in cash book Cash book may be prepared to update the cash book and reconcile the cash book balance with the bank statement balance. to identify any missing figures e. g. : cash sales, sundry expenses, cash drawings and cash misappropriated. NEXT
Credit Sales to be found in Total Debtors Account to use accounting ratio BACK
Working 2: Purchases = Cash Purchases + Credit Purchases NEXT
Cash/Credit purchases Cash Purchases may be found in cash book. Credit Purchases Total Creditors Account to use accounting ratio BACK
Working 3: Gross Profit • • To use ratios such as mark-up and margin to find gross profit figures Then use gross profit figures to find missing figures. (e. g. : purchases, cost of good sold, closing stock, etc. ) NEXT
Introduction of accounting ratios Mark-up 2. Margin 1. NEXT
Mark-up: Refer to profit which expressed as a fraction or percentage of the cost price. Margin; Refer to profit which expressed as a fraction or percentage of the selling price. NEXT
Mark-up = Margin = Profit (P) Cost of Goods Sold (C) Profit (P) Sales (S) X 100% NEXT
Relationship of 2 ratios
Sales = Cost + Profit S = C + P Mark-up Margin P P ? C S P P => P C+P C S Margin Mark-up P P ? C S P P P => C+P C S NEXT
Example 1 Mark-up is 20%, what is margin? Mark-up: 20 Margin: 20 100+20 100 NEXT
Example 2 Margin is 25%, what is mark-up? Margin: 25 Mark-up: 25 100 75 BACK
Working 4: Income earned = Cash received + Prepaid last year – Accrued last year –Prepaid this year + Accrued this year BACK
Working 5: Expenses incurred = Cash paid + Prepaid last year – Accrued last year – Prepaid this year + Accrued this year BACK
Balance Sheets
Balance Sheet Net Profit = Closing capital – Opening capital + Drawings – Capital introduced Opening capital Balance = Opening assets – Opening liabilities Sometimes, statement of Affairs need to be prepared in order to find out the opening capital balance.
Example Balance Sheet at 31 June 19 -1 (extracts) Stock $2000 Debtors $2000 Creditors $ 1000 During this period: $ Receipts from debtors 6000 Cash Sales 1000 Payment to creditors 4000 Payment to Rent 500 At 30 June 19 -2: Debtors $1000 Creditors $1000 Mark-up 20% Accrued at 30 June 19 -2 $200 Prepare final accounts for the year ended 30 June 19 -2.
Trading and profit and loss account for the year ended 30 June 19 -2 $ $ Sales (Working 1) Less: COGS Opening stock Add: Purchase (Working 2) Less: closing stock Gross profit (Working 3) Less: Expenses Rent (500 + 200) Net Profit 6000 2000 4000 6000 1000 5000 1000 700 300
Working 1 Total Debtors Bal b/d Sales (bal. fig. ) 1000 5000 7000 Cash Bal c/d 6000 1000 7000 Sales = Cash Sales + Credit Sales = 1000 + 5000 = $6000 BACK
Working 2 Total Creditors Cash 4000 Bal b/d 1000 Bal c/d 1000 5000 Purchase (bal. fig. ) 4000 5000 Sales = Cash Purchases + Credit Purchases = 0 + 4000 = $4000 BACK
Working 3 Mark-up Margin 20 100+20 100 Sales = Cost + Profit 6000 = x + 6000 * 20/120 6000 = x + 1000 x = 5000 BACK
Further Example
Stock loss (e. g. $1000) without insurance claim l l Dr. Profit and loss $1000 Cr. Trading $1000 Stock loss (e. g. $1000) with insurance claim (e. g. $800) l l l Dr. Bank $800 Dr Profit and loss $200 (net loss) Cr Trading $1000
Balance Sheet at 31 June 19 -1 (extracts) Stock $23750 Debtors $16000 Creditors $11520 During this period: $ Receipts from debtors 61000 Cash Sales 17220 Payment to creditors 59630 Payment to expenses 4000 At 30 June 19 -2: Debtors $18780 Creditors $14210 The firm achieves a mark-up of 25% on all cost. The warehouse has burned down and all the stock was destroyed. The insurance company gives $15000 for compensation for stock loss.
Trading and Profit for the year ended 30 June 19 -2 $ Sales (17220+61000+18780 -16000) $ 81000 Less: COGS Opening stock 23750 Add: Purchase (59630+14210 -11520) 62320 86070 Less: Fire loss [3] (21270) 64800 [2] Gross profit (81000 * 25/125) 16200 [1] Less: Expenses 4000 Fire loss (21270 -15000) 6270 10270 Net Profit 5930
- Slides: 31