ஆபீஸ் தொகுப்புகளில் ஆட்டோ ரெகவர்

எம்..எஸ். ஆபீஸ் 2007 மற்றும் ஆபீஸ் 2010 ஆகிய தொகுப்புகளில், சிறந்த ஒரு குறிப்பிடத்தக்க வசதி, ஆட்டோ ரெகவர் வசதி ஆகும். இதன் மூலம் குறிப்பிட்ட கால இடைவெளியில், ஆபீஸ் அப்ளிகேஷனில் அமைக்கப்படும் டேட்டாவினைத் தானாக சேவ் செய்து வைக்கும்படி செய்திடலாம். இதனால், மின்சக்தி இல்லாமல், கம்ப்யூட்டர் முடங்கும் காலத்தில், அல்லது விண்டோஸ் கிராஷ் ஆகும்போது, நம் டேட்டா நமக்குக் கிடைக்கும். இந்த கால இடைவெளியை எப்படி அமைப்பது என்று பார்க்கலாம்.

அனைத்து ஆபீஸ் 2007 அப்ளிகேஷன் புரோகிராம்களிலும், இந்த கால இடைவெளி, மாறா நிலையில் 10 நிமிடங்களாக அமைக்கப்படுகிறது. இதனை நாம் எந்த அளவிலும் வைத்துக் கொள்லலாம். எடுத்துக்காட்டாக 5 நிமிடங்களாக இதனை செட் செய்தால், நீங்கள் எந்த அப்ளிகேஷன் புரோகிராமில் செயல்பட்டுக் கொண்டிருந்தாலும், ஒவ்வொரு 5 நிமிடத்திற்கு ஒரு முறை, நீங்கள் அமைத்த டேட்டா அனைத்தும் உள்ள பைலாக அது சேவ் செய்யப்பட்டுக் கொண்டே இருக்கும். இதனை எப்படி எக்ஸெல் புரோகிராமில் அமைப்பது என பார்க்கலாம்.
1. ஆபீஸ் பட்டனில் கிளிக் செய்திடவும்.
2. கிடைக்கும் மெனுவின் கீழாக "Excel Options” என்று உள்ள பட்டனில் கிளிக் செய்திடவும்.
3. இப்போது "Excel Options” டயலாக் பாக்ஸ் கிடைக்கும். இதில் உள்ள மெனுவின் இடது பக்கமாக உள்ள Save என்பதனைத் தேர்ந்தெடுக்கவும்.
4. இங்கு "Save AutoRecover information” என்று உள்ள இடத்தில் காட்டப்பட்டுள்ள செக் பாக்ஸில் டிக் அடையாளத்தை இடவும்.
5. எத்தனை நிமிட இடைவெளியில், எக்ஸெல் டேட்டாவினை சேவ் செய்திட வேண்டும் என்பதனை முடிவு செய்திடவும்.
6. அடுத்து ஓகே கிளிக் செய்து வெளியேறவும்.
இதனை ஆபீஸ் 2003 தொகுப்பிலும் மேற்கொள்ளலாம். எக்ஸெல் தொகுப்பினைத் திறந்து Tools> Options எனச் செல்லவும். கிடைக்கும் டயலாக் பாக்ஸில், Save டேப்பினைத் தேர்ந்தெடுக்கவும். இங்கு Settings என்ற தலைப்பின் கீழ், முதல் பிரிவாக Save Autorecover info every எனக் காட்டப்பட்டு, தொடர்ச்சியாக நிமிடத்தை செட் செய்திட சிறிய கட்டம் ஒன்று மேல், கீழ் அம்புக் குறிகளுடன் காட்டப்படும். இதனை இயக்கி, நீங்கள் விரும்பும் நிமிட இடைவெளியை செட் செய்திடலாம். இங்கு கால இடைவெளியை ஒரு நிமிடமாகக் கூட செட் செய்திடலாம். ஆனால், அது சரியல்ல. இதனால், பெரிய ஒர்க்ஷீட்களில் செயல்படுகையில், ஆட்டோ ரெகவர் செயல்பாட்டினால், செயல்படுவது தாம தமாகும்.

Tips for Account Professionals for Time Management

Time Management helps individuals assign correct time slots to activities as per their importance. The right allocation of time to the right task in order to make the best possible use of time refers to time management. Time is limited and one can’t afford to waste it. Time once lost never comes back, no matter how much efforts you put in.

An individual who wastes time at workplace is liked by none and finds it difficult to achieve targets within the stipulated time frame. His work is never finished on time and is often criticized by fellow workers and superiors.

Let us go through some Time Management Tips for Professionals:

Reach office on time.- Avoid taking frequent leaves from work. It is important to be punctual for effective time management. Do not roam here and there.

The first thing an employee should do in the morning is to prepare a Task Plan- Write down what all needs to be done in a single day against the time slots you wish to assign to particular tasks as per their importance. Urgent assignments must be completed first followed by low priority tasks. Once the task is complete, tick it off. You will feel relieved.

Do assign some time for your personal calls, catching up with old friends on Facebook, writing updates on Twitter or even booking movie tickets for weekends.

Manage yourself well - Keep your workstation clean and organized. The files and important documents must be kept at their proper places. Avoid keeping stacks of files and heaps of paper at the desk. Throw whatever you don’t need. Never write on loose papers as you would definitely loose them after some time. Keep all your personal belongings at one place.

Do not clutter your desktop - Create separate folders to organize your documents. Delete whatever files and folders you don’t need. Manage your emails well.

 Use a planner or organizer to plan your day well - A table top calendar never lets you forget important dates and meetings.

Leave a little early for meetings outside office. Do keep margin of time for traffic jams, diversions or other unavoidable conditions on road.

Set priorities for yourself - Do not accept any task which you yourself know is difficult for you to accomplish within the allotted time period. A firm “NO“ in the beginning will save your reputation later.

Be clear about your goals and objectives - The KRAs of an employee must be communicated to him clearly. Know your targets. If you feel your targets are unrealistic, speak to your reporting Boss immediately. Plan things well. Planning helps you complete tasks on time.

Avoid gossiping or loitering around at the workplace - Your office does not pay you for playing games on computer during office hours. Do not work only for salary and to please your Boss. Work for yourself. The dedication should come from within.

Avoid long personal calls during office hours -. Remember if you finish your work on time, you will have enough time for your friends and family after office hours. A balance between personal and professional life is essential to be successful in the long run. 

போன் திருடுபோனால்... கண்டுபிடிக்கும் ஆப்ஸ்கள் ! உபயோகமான தகவல்கள்!!

CPT Accounting Questions and Answers - Part 4

In the 4rd part of CA-CPT accounting questions and answers, we will cover questions from 31st to 35th and explain the reasons why we have written the correct answer. It will increase your understanding to choose correct answer fastly.

31. The following information pertains to X Ltd.: Equity share capital called up ` 5,00,000

Calls in arrear ` 40,000 Calls in advance ` 25,000 Proposed dividend 15% The amount of dividend payable will be (a) ` 75,000 (b) ` 72,750 (c) ` 71,250 (d) ` 69,000 

Correct Answer : (d)

Reason Behind This : Proposed dividend is calculated on paid up capital

Called up capital = {Rs. 5,00,000 - 40,000} X 15% = 69000

32 Goods purchased ` 1,00,000, sales ` 90,000 Margin 20% on sales. Closing stock is

(a) ` 10,000 (b) ` 25,000 (c) ` 28,000 (d) None of the above

Correct Answer : (C)

Reason Behind This : Gross profit = Sale - Cost of Goods Sold

Cost of Goods Sold = Sale - Gross profit

Opening stock + purchase + Direct expenses - Closing Stock = Sale - GP

Nil + 1,00,000 + Nil - Closing Stock = 90,000 - 18000

100000 - Closing Stock = 72000

100000 -72000 = Closing Stock

28000 = Closing Stock

33. Net salary paid to employees ` 45,000 in cash after deducting income tax ` 1,000, professional tax ` 200, employees provident fund ` 2,000, staff welfare fund ` 100 and recovery of loan ` 1,700. Salary A/c will be debited with

(a) ` 50,000 (b) ` 45,000 (c) ` 48,000 (d) None of the three

Correct Answer : (b)

Reason Behind This : Actually, it should be salary payable account which is paid to employee.

First entry will be

basic salary account Dr. 50,000

Income tax Cr.1000

professional tax Cr. 200

EPF Cr. 2000

SWF Cr.100

Recovery of Loan Cr. 1700

Salary payable account Cr. 45,000

Now when we pay the balance salary to employee

Salary payable account Dr. 45000

Bank account Cr. 45000

For more detail see payroll entries.

34. Dr. balance as per cash book is ` 3000. Cheque issued but not presented for payment `500, Interest collected by Bank ` 400, Deposit by a Customer direct into his bank ` 250. Bank reconciliation statement will show balance as per Pass Book (a) ` 4,150 (b) ` 4,000 (c) ` 4,500 (d) None of the above 

Correct Answer : (a)

Reason Behind This :

Debit balance as per cash book = 3000

+ Cheque issued but not presented for payment = 500

+ Interest collected by Bank = 400

+ Deposit by a Customer direct into his bank = 250

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

Balance as per pass book = 4150

35. Bills payable is

(a) Real A/c (b) Nominal A/c (c) Personal A/c (d) Both (a) and (b) 

Correct Answer : (a)

Reason Behind This : Real account represent the assets and liabilities accounts.

Journalize the Entries to Record the Transactions of Investment

These are journal entries of  2 years'  investments transactions. Rules of double entry system will apply on these investment transactions. See detail problem before getting its solution.

Date of Asking Question	3/2/2014
Name	Candy
Country	USA
Title of Question	help with a question
Detail of Question	In problem PR 15-1A I need help find out to work the part one and part 2 of the problem. In acct 2 text book warren reeve duchac accounting 23e. pages 697-698-- roman products, Inc. is a wholesaler of men hair products. the company began operations on Jan. 1, 2010. the following transactions relate to securities acquired by roman products inc. which has a fiscal year ending in Dec.31 2010. I am in need of how to work out the excel problems . Year 2010 jan.3 purchased 3000 shares of whalen inc. as an available for sale investment at $46 per share including the brokerage commission july 6 split whalen inc. stock 2 for 1 and received the regular cash dividend of $0.60 per share on the whalen inc. stock after the split. Oct. 14 sold 900 shares of whalen inc stock at $25 per share , less a brokerage commission of $50. Dec. 9 Received the regular cash dividend of $0.60 per share . Dec. 31  Whalen inc. is classified as an available for sale investment and is adjusted to fair value of $21 per share. Use the Valuation allowance for available for sale investment account in making the adjustment. Year 2011 Jan 5 Purchased an influential interest in Tasmania co. for $620,000 by purchasing 60,000 shares directly from the estate of the founder of Tasmania . there are 150,000 share of Tasmania Co. stock outstanding . July 8. received the regular cash divided of $0.70 per share on whalen inc. stock. Dec.8. received the regular cash dividend of $0.70 per share plus an extra dividend of $0.15 per share on whalen inc. stock. 31 received $18,000 of cash dividends on Tasmania Co. stock Tasmania Co. reported net income of $74,000 in 2011. Roman products uses the equity method of accounting for its investment in Tasmania Co. 31. Whalen Inc. is classified as an available for sale investment and is adjusted to fair value of $26 per share. use the valuation allowance for available for sale investments account in making the adjustment. You have to : 1. Journalize the entries to record the preceding transactions.

Solution 

Journal Entries 

Jan. 3,  2010

Shares Investments in Whalen Inc. Dr. 138000

Bank Account Cr. 138000

July 6, 2010

Now, when in 6 july 2010, shares' stock will be split 2 for every 1, it means number of shares will be double. So, dividend will increase as per this rule

Dividend Received

3000 X 2 X 0.60 = $ 3600

Bank Account Dr. 3600

Dividend Received Account Cr.3600

Oct. 14, 2010 

Sold 900 shares @ $ 25 per share less brokerage commission $ 50

If we want to calculate the profit on this sale, we have to calculate the real cost of these shares.

Cost of 900 shares

= 138000 X 900/ 6000 = $ 20700

Net sale value of 900 shares = (900 X $ 25 ) - $50 = $ 22450


Profit on sale of 900 shares = $ 1750


Bank Account Dr. 22450

Share investment in Whalen Inc. Cr. 20700

Profit on Sale of Share Investment in Whalen Inc. Cr. 1750

Dec. 9, 2010

Balance shares in hand = 6000 -900 = 5100

Dividend = 0.60 x 5100 =$ 3060


Bank Account Dr. 3060

Dividend Received Cr. 3060

Dec. 31, 2010


 Fair Value of Per share after sale

= ( 138000 - 20700 )/ 5100 =  $ 23 per share

New fair value = $ 21

Unrealized loss due to changing  fair value

= $ 23 -$ 21 = $ 2

5100 X 2 =  $ 10200

Unrealized loss of shares investment in Whalen Inc. Dr. 10200

Valuation Allowance for Available-for-Sale Investment Cr. 10200

Jan. 5, 2011

 Investments in Tasmania Co. Dr. 620000

Bank Account Cr. 620000

July 8, 2011

Balance shares in hand = 6000 -900 = 5100

Dividend = 0.70 x 5100 = $ 3570


Bank Account Dr. 3570

Dividend Received from Whalen Inc.  Cr. 3570

Dec. 8, 2011

Balance shares in hand = 6000 -900 = 5100

Dividend = (0.70+ 0.15) x 5100 = $ 4335


Bank Account Dr. 4335

Dividend Received from Whalen Inc.  Cr. 4335


Dec. 31, 2011 

Bank Account Dr. 18,000
Investment in Tasmania Inc.  Cr.18,000

Dec. 31, 2011

.Fair value increased from $ 21 per share to $ 26 per share

Unrealized gain due to changing  fair value

= $ 26 -$ 21 = $ 5

5100 X 5 =  $ 25500

Valuation Allowance for Available-for-Sale Investment Dr. 25500

Unrealized Gain of shares investment in Whalen Inc. Cr. 25500

Explain the Role of Education in National Development

I can say many things regarding the role of education in National Development but I do not want to explain because today what education we are getting and we are providing, is not education in real sense. It is just business. When we talk about the business, national development will go to dustbin.

So, before talking about the role of education in national development, we have to explain the education in true sense.

1. Is it education, teacher does not teach in classroom and say to come to evening tuition class for starting business without any ethics?

2. Is it education, students do not attend the classroom and say, it is bunk marna in their culture.

3. Is it education, to educate their own children in hi-fi convent school and demand we need govt. service, we need govt. subsidy, we need govt. service wife or husband and we want to educate their children, they forget govt. school because they have the govt. money.

4. Is it education, do not care the footpath children because they are not your own. You did not give the birth. But they live in your same nation, they live in your same state, they live in your same city. Is your education does not make you responsible to educate them.

5. Is it education, to read the newspaper in the classroom because you have more tension of stability of politics of your nation but do not care the worthy time of students?

6. Is it education, to take fees for providing education by giving birth of different projects without seeing the money in the pocket of their parents?

7. Is it education, to take the decision of students pass or fail on some selected questions which can tell a dead machine also without any mistakes.

Human being is super machine who has the limited time on this earth. Student life is its beginning. If teacher will provide him or her true education, only then, student can use his maximum potentiality. So, role of education is to identify the potentiality of each student and motivate each student to use his potentiality. For this, every teacher has to sacrifice. Every teacher has to become role model.

If all the teachers are ready to bring revolution in the Education for national development, I have big idea which I am starting to act upon from tomorrow. You can also use it.

Accounting for Provision for Loan Losses

If you have the business to provide loan to your customers, provision for loan losses will be helpful for you for growing your business without any tension. Here, you will learn, how can you do accounting for provision for loan losses.

Provision for loan losses means to keep a fund without any use by making it as our annual expense which will deduct from our annual profit. When any customer will not pay our loan, it will be become our bad loan. So, we will use our this fund for giving loan to good parties and suffering other expenses. 

Provision for loan losses will keep on some % on our total given loan and this % is calculated on the basis of our past experience. 

Now you are ready for doing the accounting treatment of provision for loan losses.

First of pass the journal entry of actual bad loan .

1. Entry for recording actual bad loan which did not record in books of business

 Bad Loan account Dr. xxxxx
To Loan to Our customer  Account xxxxxx

2. Entry for transferring bad loan to provision for bad loan  losses Account

 Provision for bad Loan Losses account Dr. xxxxxx
To Bad Loan account xxxxx

3. Transfer of provision for Bad Loan Losses account to profit and loss account

 Profit and loss account Dr. xxxxxx
To Provision for bad Loan Losses account xxxxx

It is not necessary that provision for bad  Loan losses account will go only to the debit side of this account but it may go to the credit side . It will decide after making provision for bad loan losses account which is very easy to make . I am showing you this account . After study of this account you can easily make this account and take the benefits of this provision. This account will be started with credit balance because this is liability account. Now, we will debit actual bad loan in this account. We will show the credit closing balance with new provision for bad loan losses. Now, we will calculate the difference which will be transferred to profit and loss account.

Reason for the Growth of ERP Market

Since 1970, ERP is growing every year which you can find ERP history report. Growing rate of ERP in the market is 30% every year. There are many reasons behind this whose list, I am given below.

1.Good Inventory Control

In any ERP package, you will find the inventory control system. With inventory control system, you can add and raw data of raw material, work in process and finished goods in the database from anywhere. On basis of this database you can find, you can track the information of inventory availability. It is possible because ERP records are directly link with the records of all purchasing, beginning and closing stock.

2. Produce the Products Fastly

In ERP, both production department and sales department are inter-connected. So, when production department tracks the demand from sale department, it can fastly produce the products without any delay. It will reduce the production cost because correct and fast information will help to keep small produced stock and less invests money in stock.

3. New Product Development

When developer sees all the information together, they get more idea to create new product development. For example, recently, I saw in YouTube analytics, comparison of one video in two countries. When this option will see the YouTube video maker, he can take the development of new video for specific location. YouTube analytics are also developing the developers. ERP is also online software when they will develop its update, it will be helpful for businessman and working team to develop new product which increase the profit and decrease the losses.

4. Support of Multiple Languages and Currencies

ERP systems support multiple languages and currencies. So, more and more employees in different branches can work together because they can understand database language through better translation support. Better multiple currencies support will be helpful to do international business. When ERP software has started to give the multiple currencies support, then it can be helpful to calculate net gain from all the branches which are working in different countries whose currency is different. For example, SBI has its branches in almost all the countries. It uses bank link for managing the business in different countries in different languages and different currencies.

5. Vertical Market Solution

Before understanding the usages of ERP in vertical market solution, we should understand what is vertical market? As per Wikipedia,

A vertical market is a market in which vendors offer goods and services specific to an industry, trade, profession, or other group of customers with specialized needs. It is distinguished from a horizontal market, in which vendors offer a broad range of goods and services to a large group of customers with wide range of needs, such as businesses as a whole, men, women, households, or, in the broadest horizontal market, everyone.

Now, you have understood what is vertical market? Software developer can develop as per the need of vendor. Bank Vendor Company’s requirement will be different from automotive vendor. Telecommunication vendor’s requirement for managing his business will be different from transportation Vendor Company’s requirement.

6. Client Server

SAP, Oracle and Microsoft are the top client server ERP. One of main benefit, all files will be stored same store. All files will have automatically back up. If there is any bug, we can restore the back up.