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.
Excel Expenses Claim Form Template UK – VAT Mileage 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 VAT registered.Ĭomplete the section on the top right, including name, date and, if needed, authorisation signature.
This graph can also be used for your reports and presentations.Free spreadsheet download below Instructions for Business Monthly Expense Template Example Expenses Spreadsheet UKĭownload the correct template below, depending on if you are registered for VAT or not. There is a corresponding line chart that reflects the monthly expenses, also giving you an idea of the big picture of your expenses. There is also a Trends sparkline under each expense category to easily give you a visual of what the trends are for each expense category. This shows you how much you spent on each of the expense categories. This tab features a summary of expenses per expense category for each month, as well as the yearly total for each category.
Then, the overall total of all the expenses are also automatically calculated using built-in formula that comes with the template.Īll the monthly totals are reflected in the Year Trends worksheet tab. The subtotal for each expense category is automatically computed on each expense table. There are columns for the Date, Purchase Order Number, Supplier/Description, and Amount. Then, you can log your expenses to these corresponding categories. You can add as many categories as you need. Each of the monthly expense tabs show various expense categories, represented by Expense 1, Expense 2, and so on.
0 kommentar(er)
