How to Calculate the Total and Subtotal of VAT in Excel step by step


Today get basic knowledge of Excel they are essential for everyday life. We can associate it with the career you are doing, since technology advances every day. Over time, all programs help us to solve problems more easily.

This tool is currently the most widely used spreadsheet in the world. It has a market share of approximately 90%. It does not matter the company in which you develop or the work that you are going to perform, whether as a Professor, Entrepreneur, Student, Engineer, Accountant, among others, regardless of any of that there is a high probability that are you going to use the excel tool.

On the other hand, it is of total importance that we learn to use Excel online, as well as the other Microsoft Office programs and so on. have more opportunities in your future jobs. In the world where we live, all things must have an order and proper administration, therefore, this Excel tool is the most ideal to carry out all this.

You may also be interested in:

Take into account that this process requires time and dedication, so do not be discouraged, at first it will cost you a lot, as everything begins, so following the steps that we will take you will be able to achieve it.

In this way we will help you how to calculate VAT total and subtotal in Excel. This is very necessary due to the requirements of the law. Therefore, you must be at the forefront in the current administrative area because the mathematical calculations are always varying to the requirements of the law. For this reason it is imperative to handle a spreadsheet.

calculate balance sheet in excel

How to calculate VAT total and subtotal in Excel?

It is an easy and simple process to carry out. The first thing we have to do is create an Excel spreadsheet or electronic sheet in which we will enter the data of an invoice.

  1. The invoice and the products to be added must be displayed, which will generate the subtotal spanning cell C1 where prices are.
  2. Apply the SUM function To find the SUBTOTAL of the products, once located in cell C6 we write = SUM (C2: C4) where the values ​​are, it will generate a result.
  3. To obtain the VAT calculation we will apply a formula in cell C7, the tax value will be 16%, we select the SUBTOTAL amount and the mwe finalize for the tax as follows = + C6 * 16%.
  4. Once the VAT amount is found, we proceed to generate the TOTAL result of our invoice, locating ourselves in cell C8 and applying the SUM function again as follows = + C6 + C7.

Recommendation: You can transform or customize the spreadsheet style for greater appreciation or visualization when practicing it.

What is Excel?

Excel is a Microsoft application called in many cases as a spreadsheet or electronic sheet, it is located included in the Microsoft Office suite. This means, if you know Word, PowerPoint or Access, it will be easy and simple to use Excel.

use excel on computer

Similarly, a spreadsheet has many uses in different areas of the economic sector. Well, this program allows us use various formulas to perform different mathematical operations and thus obtain more accurate results. In addition, it has tools to graph data, which is very useful to appreciate results more easily.

On the other hand, this data can be used to be exported to other programs, such as databases and websites. You can even export the table created as a image in different formats.

Furthermore, this program is so versatile that even has its own programming language with which you can even make web pages.

What is VAT?

The Value Added Tax (VAT) is the amount that is added to products or services that are sold, this means that it is an indirect tax on consumption. For instance:

When a food store buys a product for XXX amount, it must add the VAT value corresponding to your country. That VAT is involved in the invoice from the store to the final consumer.

Therefore, it is necessary to know the importance of VAT, since it is about contributions. That is, payments that all citizens as taxpayers must make to the Nation or State so that it is returned in benefits for society or community where we live.

How useful did you find this content?

Click on a star to rate!

Average score 0 / 5. Counting of votes: 0

So far, no votes. Be the first to rate this content.

I'm sorry this content was not useful for you!

Let me improve this content!

Tell me, how can I improve this content?

You may also be interested in:

Deja un comentario