small business spreadsheet for income and expenses free

All this information is helpful if you need to refer back to a receipt. When you spend money from the receipt for the expenses incurred, enter the date, who the receipt is from, the receipt or invoice number and a brief expense description. Use the drop-down list to choose the correct rate for fuel type and engine size. Our VAT spreadsheet has taken the different rates into account. HMRC regularly updates these figures, and you will need to check back if there is a new version of the template with new rates. This amount varies depending on fuel type and engine size. If you are VAT registered and claiming mileage at 45p per mile, you can only claim part of the amount as VAT. Remember that you can only claim for business travel, not personal travel. You can then claim the allowance on your expenses report. To claim the mileage allowance, you will need to keep a log of your business travel, including the dates, distances travelled, and purpose of the journey. It covers the cost of running your vehicle, including fuel, insurance, and maintenance. 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 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. To track business expenses download the correct template below, depending on if you are registered for VAT or not.

Once the template is complete, payment can be authorised to the employee and recorded in the accounting software.Įxpense Management Software Instructions for Small Business Monthly Expense Templateįollow the basic steps below to complete the expense sheet. There is a section for approval by a manager. Our Excel Free 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. The first is for VAT-registered businesses it will calculate the VAT once the rate is entered.

Small business spreadsheet for income and expenses free