Free Excel Business Expense Template

At Business Accounting Basics, we have created two free Excel business expense templates to download. They are both simple to use and will allow you to include the detail of your monthly expenses.

Free Excel business expense template

The first is for VAT registered businesses; it will calculate the VAT once the rate is entered. The second is for non VAT businesses. The expense sheet can be used in Microsoft Excel, Google Sheets or other spreadsheet apps.

We have a section on claiming business expenses, which is an excellent place to start if you are unsure what expenses to claim.

Most small business owners will have rules for claiming monthly expenses and typically have procedures for claiming the company’s expenses.

Excel is a powerful tool that can help businesses keep track of their expenses. For example, it can be used to track actual expenses, including mileage, general office supplies and travel expenses.

Our Excel Free template will allow employees to record their mileage, subsistence, and other general office expenses. There is a section for approval by a manager. Once the template is complete, payment can be authorised to the employee and recorded in the accounting software.

Alternatives to Excel Expense Template

Using our expenses report template is an easy option for small businesses needing to track expenses. It is worth investing in accounting software that includes a mobile app or expense management software.

Accounting Software

Although our small business Excel spreadsheet is easy to use, there are alternatives for tracking expenses. A good accounting software package like QuickBooks has an app to record mileage and photograph receipts. It keeps all your accounting in place. Below are some excellent accounting software packages that include expenses.

 

QuickBooks

Monthly Fee
Track Mileage in App
Catch Bills in App
Visit QuickBooks

FreshBooks

Monthly Fee
Track Mileage in App
Catch Bills in App
Visit FreshBooks

Expense Template

Free to use
Microsoft Excel
Business use

Free spreadsheet download below

Business Expense Management Software

Business software like PLEO or View the website of Breathe HR can be used to manage business expenses. Actual business expenses are easily tracked and recorded with this software, which helps business owners keep track of their finances.

Business expenses can be categorised for easy tracking, and business owners can set budget limits for employees. This software can also be used to generate reports on business spending, which can help make decisions about where to cut costs.

Overall, using business software like Pleo can help business owners save time and money by keeping track of their business expenses.

 

Instructions for Business Monthly Expense Template

Expenses Spreadsheet UK Example
Example Expenses Spreadsheet UK

To track business expenses download the correct template below, depending on if you are registered for VAT or not. The templates are created to calculate all the figures for you; this is especially useful for a VAT registered business.

Complete the section on the top right, including name, date and, if needed, authorisation signature. 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.

Excel Expenses Claim Form Template UK – VAT Mileage

As 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. It covers the cost of running your vehicle, including fuel, insurance, and maintenance.

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. You can then claim the allowance on your expenses report. Remember that you can only claim for business travel, not personal travel.

If you are VAT registered and claiming mileage at 45p per mile, you can only claim part of the amount as VAT. This amount varies depending on fuel type and engine size. HMRC regularly updates these figures, and you will need to check back if there is a new version of the template with new rates.

Our VAT spreadsheet has taken the different rates into account. Use the drop-down list to select fuel type and engine size to choose the correct rate.

Receipt Details

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. All this information is helpful if you need to refer back to a receipt. You will need to keep the receipt in case HMRC requires it.

Free Excel Business Expense Spreadsheet – Accounts Code

There is a drop-down list of different account codes that can be used. Click on the arrow and the list will appear, then click on the code required. It will automatically post the net figures to the correct column.

Total Mileage

Expense Spreadsheet mileage
Example of entering mileage

If you are claiming mileage, enter the total number of miles claimed; this is calculated at 45p per mile. If you claim for over 10,000 miles in the year, you will need to contact us for a different template. The mileage figure is calculated as a total at the bottom.

Total mileage with VAT calculated
Mileage showing VAT

There are special rules for claiming VAT on mileage as you can only claim the allowance’s petrol element. If this figure changes, you can adjust the VAT element figure in the Accounts tab of the spreadsheet.

Advisory Fuel rate figures

Current advisory fuel VAT rates are on the HMRC website. The template is updated for March 2022 rates.

We also have a separate mileage form available.

Gross Amount

Enter the total amount that you wish to claim against the account code.

VAT rate

If you are VAT registered, enter the VAT percentage as shown on the invoice. The current standard rate is 20 per cent. All the figures will then be calculated for you. If there is no VAT, either leave blank or enter 0.

Template Totals

Once all the expenses are entered, the bottom row on the expense template will give you the total, VAT amount and each expense type total. Enter these amounts into your accounts monthly and refund to the employee.

Changes to the Business Expense Report Template

Please email the details if you need any changes to the business expenses spreadsheet template UK. There would be a small fee, typically £5, for small changes.

 

Licence Agreement to Download Business Claim Expenses Template

By downloading the business expense spreadsheet, you agree to our licence agreement, allowing you to use the templates for your own personal or business use only. You may not share, distribute, or resell the templates to anyone else in any way.               

Conclusion for Expense Report Template

The Expense tracker template is a great way to keep track of your business expenses. The template allows you to enter in all the pertinent information, including who the receipt is from, the date, and the amount. You can also claim mileage at 45p per mile. The template will automatically calculate the totals for you.

The Expenses report template is an excellent resource for small businesses that are tracking business expenses.

Return from small business Free Excel business expense template to Excel Bookkeeping templates.

Related Resources and more Templates

Free Excel Bookkeeping Templates – Free download of 16 spreadsheets

Claiming Home office expenses

Mileage expense form

Business Budget Template