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:
- To ensure that no income or expenditure item has been omitted and that there is no under or over recovery of overheads.
- To check the arithmetical accuracy, as well as for the determination of reason for disagreement between the two results.
- To know the reason for variation of profit or loss as internal control.
- To take administrative decisions such as depreciation, stock valuation and direct expenses.
- 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.
- Expenses or income of purely financial nature like dividends received, rent received, cash discount allowed, etc.
- Expenses or profits of capital nature like profit or loss on sale of investments, plant and equipment, etc.
- 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.
- Appropriation of profits for dividends, payment of income tax and transfer to reserves.
- Items recorded in financial books only and not in cost books:
- Interest received/ paid on Debentures,
- Interest received and paid on Investment and Bank loan or overdraft respectively.
- Interest charged/ paid to debtors /creditors
- Discount allowed/ received.
- Provision for discount on debtors/ creditors
- Bad Debts written off/ bad debts recovered.
- Discount on issue of shares and debentures.
- Income tax paid /refund
- Penalty and fines paid / received
- Rent received/ paid
- Loss by fire, natural calamities or theft /damage recovered.
- Loss/ profit on sale of fixed assets, investment
- Cost of share transfer/share transfer fees received.
- Donation given/received
- 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:
- Notional rent charges of owned premises
- Salary of proprietor
- 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:
- 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.
- Prepare a cost sheet for a particular period and find out costing profit or loss if it is not given.
- 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.
- Ascertain items which are shown in financial account and not in cost account.
- Ascertain items which are shown in cost account only.
- Calculate difference between expenses recorded in financial books and the amount of expenses recorded in cost accounts.
- 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:
- Financial Profit & Loss Account
- Costing Profit & Loss Account
- 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 |