Create Tally Bill Format in Excel From Scratch: 7 Methods

Method 1 – Create a Bill Header with Company Details

Enter company details such as Company Logo, Name, Address, Contact Details, GSTIN No. etc.

Create a Bill Header with Company Details


Method 2 – Add Bill/Invoice Details to Tally Bill Format

Each company follows a specific type of bill/invoice No. Usually, Bill No. is a unique number. In this section of the format, you have to enter the Date of Issuance of the bill, the Due Date of the payment, etc.

Add Bill/Invoice Details to Tally Bill Format


Method 3 – Add Customer’s Details to Tally Bill Format

Input the details of the customer. For example, Customer Name, Contact details, GSTIN No. Besides you have to add a unique customer ID in this section.

Add Customer’s Details to Tally Bill Format


Method 4 – Description of the Items Provided to the Customer

In this section, companies describe the services and goods they are providing to the customer. All the names, prices, quantities of the provided services are provided in this section.

Description of the Items Provided to the Customer


Method 5 – Add the Subtotal and Total Amount

We can add a subtotal of the goods/services in this section. Besides, if any taxes are applied to the provided goods/services, then we have to list that amount too.

Add the Subtotal and Total Amount

In this section, we can use Excel formulas and functions to calculate the payable amount. Even simple multiplication formulas in Excel make the calculation process of bills easier. For example, in my bill format, we used the SUM function along with the ROUND function to calculate the total payable amount.

We entered the formula below:

=ROUND(SUM(F25:F27),0)

The above formula returns the total payable amount in Excel.

How Does the Formula Work?

SUM(F25:F27)

The SUM function adds all the amounts in the range F25:F27.

ROUND(SUM(F25:F27),0)

The ROUND function rounds the total amount to zero decimal places.


Method 6 – Include Comments/Notes/Payment Terms in the Tally Bill Format

If you want to add any payment terms or any instructions about the payment, then you can add those in this section. For example, you may have a late fee policy or conditions for the provided service warranty. In that case, add those things here.

Include Comments/Notes/Payment Terms in the Tally Bill Format


Method 7 – Additional Features

  • Most of the time companies add the signature of the authorized person in bills.

Additional Features

  • Companies include concluding messages and brief contact details of the company. You can add that, too, in your tally bill format.


Download Practice Workbook

You can download the practice workbook that we have used to prepare this article.


Related Articles

Get FREE Advanced Excel Exercises with Solutions!
Hosne Ara
Hosne Ara

Hosne Ara is a materials and metallurgical engineer who loves exploring Excel and VBA programming. To her, programming is like a time-saving superhero for dealing with data, files, and the internet. She's skilled in Rhino3D, Maxsurf C++, MS Office, AutoCAD, and Excel & VBA, going beyond the basics. With a B. Sc. in Materials and Metallurgical Engineering from Bangladesh University of Engineering and Technology, she's shifted gears and now works as a content developer. In this role, she... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo