Excel Expenses Claim Form Template UK – VAT MileageĪs set by HMRC, the standard mileage allowance you can claim for business travel is 45p per mile for the first 10,000 miles and then 25p per mile after that. Each expense will need a separate line if you have a receipt to claim with several different expenses then you will need a line for each type. The expense claim form templates are created to calculate all the figures for you this is especially useful for a VAT-registered business.Ĭomplete the section on the top right, including name, date and, if needed, authorisation signature. Example Expenses Spreadsheet UKĭownload the correct template below to track business expenses, depending on whether you are registered for VAT. Instructions for Small Business Monthly Expense Templateįollow the basic steps below to complete the expense claim form spreadsheet. Once the template is complete, payment can be authorised to the employee and recorded in the accounting software. There is a section for approval by a manager. Our Free Excel Expense claim form template will allow employees to record their mileage, subsistence, and other general office expenses. For example, it can be used to track actual expenses, including mileage, general office supplies and travel expenses. These procedures might include getting expenses authorised by a line manager, submission dates, and payment dates.Įxcel is a powerful tool that can help businesses keep track of their expenses. Most small business owners will have rules for claiming monthly expenses and typically have procedures for claiming the company’s expenses. We have a section on claiming business expenses, which is an excellent place to start if you are unsure what expenses to claim. The expense sheet can be used in Microsoft Excel, Google Sheets or other spreadsheet apps.
Personal Budget Spreadsheet The 12-month version of the personal budget version.Personal Monthly Budget - Like the one above, but less detailed, and designed to fit on a single page.Family Budget Planner - This is the 12-month version of the household budget spreadsheet listed above.Money Management Template - Record transactions to automatically populate the budget vs.If you add or remove any categories, just make sure that the formulas used for the totals don't get messed up. If your Net is negative, that means you have overspent your monthly budget.Īdding or Removing categories: The household budget template contains a very detailed list of categories, which you may or may not need. The Monthly Budget Summary table totals up all your income and expenses and calculates the Net as Income minus Expenses. If you spend more than you budgeted, the Difference between the Projected and Actual values will be negative, and if your Actual income is less than your Projected income, the Difference will be a negative number. In this spreadsheet, the calculations are set up so that negative numbers are bad. The cells in the "Difference" column use conditional formatting to make negative numbers red. At the end of the month, you record in the "Actual" column how much you really spent during the month. This represents your goal - you're trying to keep from spending more than this amount. You record your desired budget for each category in the "Budget" column. The purpose of this worksheet is to help you compare your monthly budget with your actual income and expenses. You may also want to read the article " How to Budget". Our article " How to Make a Budget" explains how to use these spreadsheets to create your budget.
You'll want to replace the values in the Home Expenses category with your own. To use this template, fill in the cells highlighted with a light-blue background (the "Budget" and "Actual" columns). 42 Effective Ways to Save Money Budgeting Tips for the New Year Using the Household Budget Worksheet