Employee T.A Bill Reimbursement Format

Sample ms excel template for staff travelling allowance and reimbursable charges here’s a sample travel expense worksheet tailored specifically for reimbursable expenses account related to traveling expenses of employees in Excel. You can use this as a template in spreadsheet software like Microsoft Excel or Google Sheets. Download a travel expense report template. There are many free templates available online, or you can create your own. The template should have columns for the following information: Employee nameDate of travelPurpose of…

Read More

Startup Financial Plan Excel Template

This spreadsheet will help startups to arrange,manage and monitor their financial data. There are actually 3 steps in this worksheet. The very first step is in which  user has to  fill  data related to capital and funds. Sales and expenses projection related inputs can be filled in step 2 and 3. It will be better if you read instructions carefully before starting to use this excel sheet,  it would  be more easier for you to understand and edit it. If…

Read More

Law practice cash flow budget sample template

Cash flow management  spreadsheet Being a professional accountant, i could say that it is never easy to manage all activities related to my clients that includes some law firms. If you are practicing alone or starting things up, then here are some sample excel templates that can help you. First one includes multiple tabbed sheet. In the start-up costs you have to fill in details fixed costs like office furniture,IT hardware etc. as well as variable costs like website and…

Read More

How to convert any number series in date format ?

Converting year/month/date format in date/month/year or other format using excel formulas . Actually i was facing problem regarding the format of dates. The spreadsheet that i downloaded from my stock broker was having different format from what i wanted to have, for income tax filing purpose.  The data was in following manner and i had tried number format option multiple times and it was not working at all. BuyDate SellDate 20161125 20161125 20160708 20160708 20160627 20160627 20160704 20160704 20160630 20160630…

Read More

Law Firm Profitability Calculator

This time we are offering you a powerful tool to calculate profitability of your law firm.This template allows user to determine the projected revenues and compare those revenues to the costs. Analyze the cost linked with associate partner. You can understand it with an example provided within the sheet. This example is based for large sized Toronto law firm. We have already published a budget template in past.   There is a another worksheet available that can help you in…

Read More

8+ Monte Carlo Simulation Excel Example and Add ins

This sample sheet shows example of random number generation and  Monte Carlo simulation. This worksheet runs a macro to do this work that can be adjusted for 1000 repetitions or for 10000 repetitions. RANDOM() function is used as base. To simulate a Monte Carlo situation for cost risk one has to look on the factors or parameters that have uncertainty associated with them, then find the distributions  that are to be used for every one of them. Now create a…

Read More
evm chart in excel

EVM Earned Value Management Excel

Example sheets contains chart. Don’t forget to check them.       Very first worksheet consist 3 tabbed sheets. Earned value,actual cost along with a report.If you want to check how this worksheet is working in background of the sheet just press ctrl+` button and all the formula’s will be revealed.You have to keep in mind that while inserting data WBS,task name and tbc are identical. You have to enter the percentage for each task to determine the CEV. This…

Read More
vehicle checklist

Vehicle Inspection Checklist Form

These automobile inspection checklists are real handy. You can download any one of them. You can edit them in pdf  editor or you can try the MS word version by using any online pdf to word converter. If you want excel version you can put this demand in comments. These files are printable and free. We are also processing a list of around 10 checklist forms for pre-owned cars. These templates are quite useful, in case you are getting your car serviced or…

Read More

kh coder tutorial

This software is a text analysis and mining software that can be used for computational linguistics. It supports various languages and is available free of cost.There are already two manuals provided in English for different versions(2,3). Including a Wiki page. Here we have arranged some pdf’s that were basically in Japanese language. These tutorials will help you understand the functionality of the software. Quite good for beginners. KH coder is a free software, it can be used for text mining.…

Read More

Rental Property Analysis Excel

For a investor it is very necessary to keep an eye on his investment. Buying a property needs a lot of effort and return on this investment depends of various factors. If you are trying to analyze how much ROI is there. How profitable and stable returns would be. Then you should calculate it in advance and work accordingly. Though there plenty of calculators on internet, but having a spreadsheet has its own benefits. You can use it anywhere and…

Read More