How To Prepare A Excel Annual Salary Table Of Multiple Employees

How banks are crediting the salaries to all the employees in a company? What is the process behind it?

Yes, I can help you with that. An organisation used to have tie up with specific banks that their employees will have an account in your bank as well as company's account as well. So, when a new employee joins, after 3 months or so, he asked to get a salaried account in those banks and representatives used to come to the organisation for registering these employees. After that, once the account activated, the employee submit a cancelled cheque to the Finance Dept.. to authorise the dept. to transfer his salary directly in his bank account. After that, the finance dept. maintain the separate list of the employees with their account numbers, employee id, on basis of bank.In the end of every month, when HR dept. transfer the calculated salary for each employee, the finance dept. prepare the list of all the employees alongwith account number and the amount of salary need to be credited. And, submit the same to the bank authorities. After that, the bank just debit and credit all the relevant accounts with the amount and all the holders get informed about the credit of the salary. Now, what's the necessity?# It reduces the paper work, time, efforts of all the parties. # And, minimize the process of salary transfer as well. Hope this helps. Thank you!

How do I transfer money (salary) to all employees in one go?

Hello there,This you can’t do in one go though you can do one by one which is time consuming. But this is possible if you use Banks’ services.….. there is already software avaialble in almost all the Banks for effecting transfers to various accounts from single account. For this you need to give the account number which is to be debited with authorisation along with the list of accounts numbers, names to which the money transfer is expected to be done in soft copy in Excel format. That’s it, the job is done by Batch postings by running a small programme which is already avaialable. We used to do it for one corporate hospital in Kolkata. This works when all the employees when they have accounts in the same bank/branch where the remitter has account. If it is various banks also it is possible to effect through NEFT…but in this case whether “batch postings” in one go are possible or not I am not sure…you may get in touch with the nearest bank. Logically it should happen when you add one more excel column for IFSC Number for Bank. Hope this clarifies.

What is the salary of an IAS officer at the present time?

Some factual corrections please in a few answers given above…Expenses on electricity/water bills, domestic helpers/security guards (in most cases except district postings where a Camp Office is attached with the residence) etc. are not paid for by the government. Security is not provided when an IAS officer moves to the Secretariat (except in risk prone postings). Any officer enjoying such ‘perks’ is flouting laid down norms. For some other things like telephone bill, there is a fixed monthly allowance in most cases. Dearness Allowance is 9% (and not 65%) with effect from July 1, 2018 on the Seventh Pay Commission Scales. Pay levels are given correctly only by some people (matrix}.So, at my rank of Secretary in the Government of India or Chief Secretary in the State, my salary is Rs 2.25 lakh + 9% per month or About Rs 29.43 lakh per annum after 34 years of service in IAS. A bright Computer Science Engineering student from an IIT or any other good institution may be nowadays offered higher salary on day one (if value of perks like house is excluded). So, even though salaries of IAS officers have become rather ok now, one shouldn't bother about that aspect so much. Just think about the immense scope of work and canvas of activities that one gets at policy and implementation level to serve the nation - particularly the poor and the underprivileged.

What is the best cap table template available online for startups with different types of shares, bonus pools, multiple rounds, etc.?

Update: Sharewave is now Gust Equity Management, the platform has grown since this original answer and you can find more detail at Gust Equity Management.Take a look at Sharewave. I'll point out a few things that make us a bit different than some of the other choices in this list.Let the software do the mathOver time your option pool and financing terms can make your cap table a nightmare, and spreadsheets only take you so far before you're living in the formula bar. On a platform like ours you'll save a lot of valuable time on the numbers alone.Quickly process seemingly complicated scenarios like debt conversions where interest rates, discounts or valuation caps can play a role in the math.No more version historyYour lawyer or larger shareholders may want to review your cap table in its entirety, but you may not want smaller investors to have that level of detail. Give your employees access to their real-time equity compensation, but nothing else. Instead of versioning, keep one record and control access for each person.Share class ledgersThe cap table is just one way to view your equity transactions, but not always the most useful view. Get instant ledgers for each class, and reflect on the metrics we provide for the entire class and across each person.Make better decisions about future scenariosWith just a few clicks, you can evaluate how a new financing will impact your cap table or easily model the sale of your business.Straight-through stock and option processingIn a few clicks, you can issue stock or options directly to their recipient including automatically generated paperwork and electronic certificates (if you're still into that). With built-in e-signature, your recipients can sign from directly within Sharewave.