Back to Study material
CA2


UNIT 2


RECONCILIATION OF COST AND FINANCIAL ACCOUNTS


It is normally assumed that the profit of a business for a given period is given by the Profit & Loss account made out for that period.

 

Imagine your surprise, when Profit and Loss Account  prepared by the financial accountant of X Ltd. Shows a profit of Rs.4,56,000 for the year ended 31.03.2009. While the cost accountant has prepared a cost sheet for the same period and arrived at a profit of Rs. 5,12,000. You feel that one of the figures reported should be wrong, otherwise how could there be a difference.

 

However, there is a logical explanation for the difference in the profit figures and both may be right. This is because the fundamental assumptions made by the two accountants for preparing the profit and loss account vary. For example, Interest on loan will be debited in financial Profit & Loss Account but the cost accountant will ignore this item as he does not consider this interest expense as an item of cost. Naturally, in this case, the cost accountant will report a higher profit than the financial account.

 

In the following sections we shall see the types of differences and the items which give rise to these differences.

 


 

The need for reconciliation arises due to the following reasons:

 

  1. To ensure that no income or expenditure item has been omitted and that there is no under or over recovery of overheads.
  2. To check the arithmetical accuracy, as well as for the determination of reason for disagreement between the two results.
  3. To know the reason for variation of profit or loss as internal control.
  4. To take administrative decisions such as depreciation, stock valuation and direct expenses.
  5. To test the reliability of cost accounts.

 


 

It is very essential to know the causes, which generally give rise to disagreement between Cost and Financial Accounts. These are briefly summarized below:-

 

Expenses that are not taken into account. The under mentioned expenses are usually not included in overheads or, for that matter in cost.

 

  1. Expenses or income of purely financial nature like dividends received, rent received, cash discount allowed, etc.
  2. Expenses or profits of capital nature like profit or loss on sale of investments, plant and equipment, etc.
  3. Items not representing actual costs but dependent on arbitrary decisions of management e.g. An unreasonably high salary to the managing director, providing for depreciation at a rate exceeding the economic rate.
  4. Appropriation of profits for dividends, payment of income tax and transfer to reserves.

 

  1. Items recorded in financial books only and not in cost books:

 

  1. Interest received/ paid on Debentures,
  2. Interest received and paid on Investment and Bank loan or overdraft respectively.
  3. Interest charged/ paid to debtors /creditors
  4. Discount allowed/ received.
  5. Provision for discount on debtors/ creditors
  6. Bad Debts written off/ bad debts recovered.
  7. Discount on issue of shares and debentures.
  8. Income tax paid /refund
  9. Penalty and fines paid / received
  10. Rent received/ paid
  11. Loss by fire, natural calamities or theft /damage recovered.
  12. Loss/ profit on sale of fixed assets, investment
  13. Cost of share transfer/share transfer fees received.
  14. Donation given/received
  15. Deferred revenue expenses written off. Such as write off of :

-          Preliminary Expenses

-          Discount  on Shares/ Debentures

 

II.                   Items recorded in cost book only and not in financial books:

  1. Notional rent charges of owned premises
  2. Salary of proprietor
  3. Interest on proprietors fund

 

III.                   Items recorded in both books with different amounts:

 

In Cost book and Financial book some item of expenses and incomes which are treated differently such as:

 

  1. Method of charging depreciation:

In Financial Books depreciation may have been provided, on Straight Line Method or Written down Value Method whereas in Costing Book depreciation may have been charged on the basis of Machine Hour Rate Method. Amounts of depreciation charge in  both books are bound to be different.

 

b.           Under and Over recovered expenses:

The expenses in costing books are recorded on the basis of pre-determined rates but in financial books they are recorded on actual basis hence the amount recorded in these two set of books differ.

c.                  Method of Valuing Stocks:

It is well known that in Cost Book Stocks are only valued at cost. But in Financial Books stock are valued either at cost or market price, whichever is lower.

 


 

When there is a difference between the profit/loss shown by cost accounts and financial accounts the procedure for reconciliation is similar to that of Bank Reconciliation Statement. For reconciliation following steps should be considered.

 

  1. Prepare a cost sheet for a particular period and find out costing profit or loss if it is not given.
  2. If financial profit or loss is not given then find out the same by preparing Trading and Profit and loss account for a period which corresponds to the cost sheet.
  3. Ascertain items which are shown in financial account and not in cost account.
  4. Ascertain items which are shown in cost account only.
  5. Calculate difference between expenses recorded in financial books and the amount of expenses recorded in cost accounts.
  6. Reconciliation Statement is to be prepared as on a particular date. Hence one can start with the figure of profit / loss as per cost account and arrive at the figure of profit/ loss as per financial accounts or vice –versa.

 

[Entries which are at variance with each other will appear in Reconciliation Statement and also entries appearing in only one set of book (non - common items).

 


Starting with financial profit- Statement of Reconciliation between Financial Profit and Cost Profit for the Year ended

Particulars

Amount (Rs)

Amount (Rs)

Financial Profit (as per the financial books)

 

XX

Add:

Expenses, losses and appropriation debited in financial books only

Closing stock under valued in Financial Books

Opening Stock over valued in Financial books

Excess depreciation charged in Financial Books

Expenses under recovered in Cost Books Income credited only in Cost Books

 

Less:

Income credited only in Financial Books Closing stock over valued in Financial Books

Opening Stock under valued in Financial books

Short depreciation charged in Financial Books

Expenses over recovered in Cost Books

 

XX

XX

XX

XX

 

XX

 

XX

XX

XX

XX

 

XX

 

XX

Costing Profit (as per Costing books)

 

XX

 

Starting with financial profit- Statement of Reconciliation between Financial Profit and Cost Profit for the Year ended

Particulars

Amount (Rs)

Amount (Rs)

Costing Profit (as per Costing books)

 

XX

Add:

Income credited only in Financial Books Closing stock over valued in Financial Books

Opening Stock under valued in Financial books

Short depreciation charged in Financial Books

Expenses over recovered in Cost Books

 

Less:

Expenses, losses and appropriation debited in financial books only

Closing stock under valued in Financial Books

Opening Stock over valued in Financial books

Excess depreciation charged in Financial Books

Expenses under recovered in Cost Books Income credited only in Cost Books

 

 

XX

XX

XX

XX

 

XX

XX

XX

XX

 

XX

 

XX

 

XX

Financial Profit (as per the financial books)

 

XX

 


 

Q.1. From the following particulars reconciliation statement

Particulars

Rs.

Net Profit as per financial records

1,54,506

Net Profit as per costing records

2,06,880

Works overheads under recovered in costing

3,744

Administrative Overheads recovered in excess in costing

2,040

Deprecation charged in financial accounts

13,440

Depreciation recovered in Cost Accounts

15,000

Interest received but not included in Cost Accounting

9,600

Obsolescence loss charged in financial records

6,840

Income tax provided in financial books

48,360

Bank interest credited in financial books

900

Stores adjustment credited in financial books

570

Depreciation of stock charged in financial books

8,100

 

Solution:

 

RECONCILIATION STATEMENT

Particulars

Rs.

Rs.

Net Profit as per costing records

Add:

Administrative Overheads over absorbed

Depreciation excess charged

Income not credited in costing –

Interest received

Bank interest

Stores adjustment

 

15,000

     900

     570

 

2,06,880

 

2,040

1,560

 

 

16,470

 

 

Total

Less:

Works overheads under recovered

Expenses not charged in costing books 9,600

Income tax provided in Financial Book     48,360

Depreciation of Stock charged in

Financial Book                                                    8,100

Net Profit as per financial books

 

20,070

 

3,744

 

66,060

2,26,950

 

(69,804)

 

1,57,146

 

Q.2. Following is the Trading and Profit and loss account of a factory producing a particular unit of a product of which the actual output is 1,00,000 units.

Trading & Profit and Loss A/c for the year ended 31/12/09

 

Rs

 

Rs.

To Material

200000

By Sales

400000

To Wages

100000

 

 

To Works Exp.

60000

 

 

To Office rent

18000

 

 

To Selling & Dist. Exit

12000

 

 

To Net Profit

10000

 

 

 

400000

 

400000

 

The normal output of the factory is 1,50,000 units. Works expenses are fixed to the extent of Rs. 36,000. Office expenses for all practical purposes are constant, Selling and distribution expenses are variable to the extent of Rs.6000/- Prepare a cost sheet and reconciliation statement.

Solution:

Cost Sheet

Actual output 1,00,000 units Normal output 1,50,000 units

Particulars

Per Unit

Amount (Rs)

Material

2.00

2,00,000

Wages

1.00

1,00,000

PRIME COST

3.00

3,00,000

Add: Works expenses

 

 

Fixed (2/3 of 36000) = 24000

 

 

Variable = 24000

0.48

48,000

WORKS COST

3.48

3,48,000

Add: Office Expenses (2/3 * 36000) (Actual output/ Normal output = 2/3 Proportionate fixed cost are considered)

0.12

12,000

COST OF PRODUCTION

3.60

3,60,000

Add: Selling and Distribution Expenses

 

 

Fixed (2/3) = 4000

 

 

Variable = 6000

0.10

10,000

COST OF SALES

3.70

3,70,000

Add: Profit

0.30

30,000

SALES

4.00

4,00,000

 

Reconciliation statement

Particulars

Amount (Rs)

Amount (Rs)

Profit shown by Cost Accounts

 

30,000

Add:

 

 

Less:

 

 

Under recovery of Work Expenses

12,000

 

Under recovery of Office Expenses

6,000

 

Under recovery of Selling Expenses

2,000

(20,000)

Profits shown by Financial Accounts

 

10,000

 

Q.3. The Trading & Profit & Loss account of “A’ Ltd. Is as follows:-

To Purchases

25120

By Sales (50000 units

 

 

 

@ of Rs.1.50 each)

75000

Less : Closing Stock

4050

 

 

To Gross Profit

53870

 

 

 

------------

 

---------

To Net Profit

75000

 

75000

To Direct Wages

10500

 

 

To Works Expenses

12130

By Gross Profit

43870

To Selling Expenses

7100

By Discount received

260

To Administrative

5340

By Profit on sale of

 

Expenses

 

Land

2340

To Depreciation

1100

 

 

To Net Profit

20300

 

 

 

------------

 

---------

 

56470

 

56470

 

The profit as per cost accounts was only Rs.19,770. Reconcile the financial and costing profits using the following information:

a)        Cost accounts valued closing stock at Rs. 4280

b)       The work expenses in the cost accounts  were taken at  100% of direct wages.

c)        Selling & administration expenses were charged in the cost accounts at 10% of sales and 0.10 per unit respectively.

d)       Depreciation in the cost accounts was Rs.800.

Solution:

RECONCILIATION STATEMENT

Particulars

Rs.

Rs.

Profit as per Cost Accounts

 

19,770

Add: 1. Over absorption of selling expenses

400

 

2. Discount received

260

 

3. Profit on sale of land

2,340

3,000

 

 

22,770

Less 1. Difference in valuation of closing

200

 

2. Under absorption of Administrative

340

 

Exp.

 

 

3. Under absorption of Works Exps.

1,630

 

4. Depreciation under changed

300

(2,470)

Profit as per Financial Accounts

 

20,300

 

Q.4. From the following Profit & loss account draw up a Reconciliation statement showing the Profit as per Cost Accounts:-

To Office Salaries

11282

 By Gross Profit

54648

To Office Expenses

6514

 By Dividend received

400

To Salary to Salesmen

4922

 By Interest on Bank FD

150

To Sales Expenses

9304

 

 

To Distribution Exp.

2990

 

 

To Loss on Sale of Machinery

1950

 

 

To Fines

200

 

 

To Discount

100

 

 

To Net Profit c/d

17936

 

 

55198

 

55198

To Income Tax

To Transfer to Reserves

8000

 By Net Profit b/d

17936

To Dividend

1000

 

 

To Balance c/d

4800

 

 

 

4136

 

 

 

17936

 

17936

The cost accountant has ascertained a Profit of Rs. 19636 as  per his books.

Solution:

RECONCILIATION STATEMENT

Particulars

Rs.

Rs.

Profit as per cost accounts

 

19,636

Add:

 

 

Income not credited in cost accounts

 

 

Dividend

400

 

Interest on Bank FD

150

550

 

 

20,186

Less:

 

 

Expenses not debited in cost accounts

 

 

Fines

200

 

Discount

100

 

Loss on sale of machinery

1,950

 

Income Tax

8,000

 

Trf to reserves

1,000

 

Dividend

4,800

(15,500)

Profit as per Financial Account(P&L A/c)

 

4,136

 

Q.5.

M/s ESVEE Ltd. Has furnished you the following information from the financial books for the year ended 31st December, 2009.

 

Particulars

Rs.

Materials consumed

260000

Wages

150000

Factory overheads

94750

Administration Overheads

106000

Selling and Distribution overheads

55000

Bad Debts

4000

Preliminary expenses

5000

Opening Stock (500 units at Rs.35/- each)

17500

Closing stock (250 units at Rs.50/- each)

12500

Sales (10250 units)

717500

Interest Received

250

Rent Received

10000

 

The cost sheet shows the following:

Cost of materials Rs. 26 per unit.

Labour cost Rs. 15 per unit

Factory overheads 60% of Labour cost

Administration overheads 20% of Factory cost

Selling expenses Rs. 6 per unit

Opening Stock Rs. 45 per unit

 

You are required to prepare:

  1. Financial Profit & Loss Account
  2. Costing Profit & Loss Account
  3. Statement of Reconciliation

Solution:

Financial Profit & Loss A/c

 

Rs

 

Rs.

To Opening Stock

17,500

By Sales (10250 units )

 

By Closing stock (250 units

 

At Rs.50 each)

 

By Gross Profit b/d By Interest received By Rent Provided

7,17,500

(500 Units at Rs.35 each)

 

 

To Materials consumed

2,60,000

 

(10000 units)

 

 

To Wages

1,50,000

 

To Gross Profit c/d

3,02,500

12,500

 

 

 

 

7,30,000

7,30,000

To Factory overheads

94,750

3,02,500

To Administration c/d

1,06,000

250

To Selling Expenses

55,000

10,000

To Bad Debts

4,000

 

To Preliminary Expenses

5,000

 

To Net Profit

48,000

 

 

 

 

 

3,12,750

3,12,750

 

Cost Sheet for the year ended 31.12.2009

(Production 10,000 units)

Particulars

Cost per

Unit

Rs.

Total Cost

 Rs.

Material Consumed

26

2,60,000

Labour

15

1,50,000

 

-------------

--------------

PRIME COST

41

4,10,000

Factory Overheads (60% of Labour cost)

9

90,000

 

------------

---------------

WORKS COST

50

5,00,000

Administration overheads

 

 

(20% of work cost)

10

1,00,000

COST OF PRODUCTION

60.

6,00,000

Add : Opening Stock of finished goods

 

 

(500 units at (Rs.45/- each)

 

22,500

 

 

---------------

 

 

6,22,500

Less : Closing stock of finished goods

 

 

(250 units)

 

15,000

 

-------------

---------------

 

 

6,07,500

Selling Expenses

6

61,500

 

------------

---------------

COST OF SALES

66

669000

PROFIT

4

48500

 

-------------

---------------

SALES

70

717500

 

Statement of Reconciliation

Particulars

Rs.

Rs.

Profit as per Cost Accounts

 

48,500

Add: Over recovery of overheads :

 

 

Selling expenses

6,500

 

Over valuation of stock :

 

 

Opening stock

5,000

 

Purely financial income:

 

 

Interest

250

 

Rent

10,000

31,750

 

-----------

------------

 

 

70,250

Less: Under recovery of overheads-

 

 

Factory overheads

4,750

 

Administrative overheads

6,000

 

Over valuation of stock :

2,500

 

Closing Stock

 

 

Purely financial expenses:

4,000

 

Bad Debts

 

 

Preliminary expenses

5,000

(22,250)

 

-----------

------------

Profit as per Financial Accounts

 

48,000

 


Index
Notes
Highlighted
Underlined
:
Browse by Topics
:
Notes
Highlighted
Underlined