please tell me the reconciliation format in excel

Answer Posted / rahul bhalekar

Bank reconciliation is:
Company's bank ledger balance
(-) unclear cheques or amount of instruments
(=) actual balance of bank account

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

While finalizing the current year’s profit, the company realized that there was an error in the valuation of closing stock of the previous year. In the previous year, closing stock was valued more by Rs.50,000. As a result (a) Previous year’s profit is overstated and current year’s profit is also overstated (b) Previous year’s profit is understated and current year’s profit is overstated (c) Previous year’s profit is understated and current year’s profit is also understated (d) Previous year’s profit is overstated and current year’s profit is understated

1903


Productive Investment is Working Capital. Is it correct?

1345


What are the advantages of computer accounting over paper accounting?

684


Do you know what qualities and skills make an account manager successful?

739


DHPL is a small sized firm manufacturing hand tools. It manufacturing plan is situated in haryana. The company's sales in the year ending on 31st march 2007 were Rs.1000 million(Rs.100 crore) on an asset base of Rs.650 million. The net profit of the company was Rs.76 million. The management of the company wants to improve profitability further. The required rate of the company is 14 percent.The company is currently considering an investment proposal. One is to expand its manufacturing capacity. The estimated cost of the new equipment is Rs.250 million. It is expected to have an economic life of 10 years. The accountant forecasts that net cash inflows would be Rs.45 million per annum for the first three years, Rs.68 million per annum from year four to year eight and for the remaining two years Rs.30 million per annum. The plant can be sold for Rs.200 million: (a) The company can borrow funds from a nationalized bank at the interest rate of 14 percent for 10 years. It will be required to pay equal annum installment of interest and repayment of principal. (b) A financial institution has offered to lend money to DHPL at 13.5 per annum but it needs to pay equated quarterly installment of interest and repayment of principal. Questions: (1) Should the company expand its capacity? show the computation of NPV. (2) What is the annual installment of bank loan? (3) calculate the quarterly installment of the financial institution loan. (4) should the company borrow from the bank of from the financial institution?

2700






what is share application money pending allotment?

3746


Can anybody tell me diference between provisions of Profit and Loss account prepared as per company act & Income Tax Act?

1524


X draws a bill on Y for Rs 20,000 for 3 months on 1.1.05. The bill is discounted with banker at a charge of Rs 100. At maturity the bill return dishonoured. In the books of X, for dishonour, the bank account will be credited by Rs. (a) 19,900 (b) 20,000 (c) 20,100 (d) 19,800

2973


What is project implementation?

721


Tell me what is the general classification of accounts that usually ledger account involve?

717


What is deferred account?

776


How is scrap value calculated?

736


RPC Ltd. follows the written down value method of depreciating machinery year after year due to (a) Comparability. (b) Convenience. (c) Consistency. (d) All of the above

1877


MEANING OF RED HERRITING

2172


What is Debit Note and Credit Note? Subsidory Books? Minority Interest? Stock recording in P&L? Outstanding Expenses, Prepaid Expenses and Examples?

3048