How to Create Tax Invoice Bills on Computer

Katherine Jul 11, 2026

Creating a tax invoice bill on your computer involves a few simple steps using software designed for accounting or invoicing. This guide will walk you through the process, ensuring you generate accurate and compliant invoices.

GST Invoice Format in Excel, Word, PDF and JPEG (Format No. 20)
GST Invoice Format in Excel, Word, PDF and JPEG (Format No. 20)

Before we dive in, ensure you have the necessary software installed. Popular options include Microsoft Excel, Google Sheets, or dedicated invoicing software like QuickBooks, Zoho Invoice, or FreshBooks. For this guide, we'll use Microsoft Excel as an example, as it's widely accessible and user-friendly.

an invoice form is shown with the name and number of each item on it
an invoice form is shown with the name and number of each item on it

Setting Up Your Invoice Template

To begin, open Microsoft Excel and create a new workbook. You'll use this as your invoice template. Start by labeling the columns with relevant headers such as 'Invoice Number', 'Date', 'Client Name', 'Address', 'Phone Number', 'Email', 'Description of Services', 'Quantity', 'Rate', 'Tax', and 'Total'.

Free Invoice Template  | Download for free
Free Invoice Template | Download for free

Next, format your invoice to include your business logo, name, address, and contact information at the top. You can use Excel's built-in features or insert images and text boxes for a more professional look.

Creating Invoice Numbers

Fully 🔥 Automatic Invoice in Excel | Create Invoice Bill in Excel | MS Excel
Fully 🔥 Automatic Invoice in Excel | Create Invoice Bill in Excel | MS Excel

To keep track of your invoices, you'll need a unique invoice number for each one. In Excel, you can use the AutoFill feature to generate sequential numbers. In cell A2 (assuming 'Invoice Number' is your first header), enter the first invoice number (e.g., INV001). Then, drag the small square in the bottom-right corner of the cell down to auto-generate subsequent numbers.

To make this process smoother, you can also use Excel's TEXT function to format your invoice numbers. For example, entering "INV" & TEXT(A2,"000") in cell A2 will display "INV001" for the first invoice, "INV002" for the second, and so on.

Calculating Tax and Total

Tally Invoice Customization TDL - (Company Name and GST No. Customize)
Tally Invoice Customization TDL - (Company Name and GST No. Customize)

To calculate tax, you can use Excel's built-in functions. Assuming your tax rate is 10% and your rate per service is in column F (e.g., $100), enter the formula =(F2*10%) in cell G2 for the tax amount. Then, enter =(F2*G2) in cell H2 for the total amount.

To apply this formula to all invoices, drag the small square in the bottom-right corner of cells G2 and H2 down to copy the formulas for subsequent rows.

Generating Individual Invoices

One Click Save & Print GST Invoice Software in MS-Excel full Automatic
One Click Save & Print GST Invoice Software in MS-Excel full Automatic

Once your template is set up, you can start generating individual invoices. To create a new invoice, simply fill in the relevant information in the corresponding columns. Excel will automatically calculate the tax and total amounts based on the formulas you've set up.

Before sending the invoice, review it to ensure all information is accurate and up-to-date. You can also customize the invoice's appearance by adding borders, shading, or changing fonts and colors.

Commercial Tax Invoice Template Excel
Commercial Tax Invoice Template Excel
How enter bill in excel | Billing in ms excel | How to prepare tax bill in excel in Tamil
How enter bill in excel | Billing in ms excel | How to prepare tax bill in excel in Tamil
Sample Of Proforma Invoice Template For 2023 Business - BestTemplatess
Sample Of Proforma Invoice Template For 2023 Business - BestTemplatess
Computer Bill Format Template in Excel, Apple Numbers, Pages, Word, Google Docs, Google Sheets - Download | Template.net
Computer Bill Format Template in Excel, Apple Numbers, Pages, Word, Google Docs, Google Sheets - Download | Template.net
Create Professional Invoices in 30 Seconds (Free Tool for Freelancers)
Create Professional Invoices in 30 Seconds (Free Tool for Freelancers)
Create a Custom Invoice Template in Word & Track Payments Effortlessly
Create a Custom Invoice Template in Word & Track Payments Effortlessly
Tax Invoice Templates | Quickly Create Free Tax Invoices
Tax Invoice Templates | Quickly Create Free Tax Invoices
Free Bill Kit Official Website | Every invoice & billinng document in one place.
Free Bill Kit Official Website | Every invoice & billinng document in one place.
an invoice form is shown with the name and number
an invoice form is shown with the name and number
Free Invoice Generator – No Login Required
Free Invoice Generator – No Login Required
GST Invoice Format in Excel, Word (Format No. 21) .xls, .doc file
GST Invoice Format in Excel, Word (Format No. 21) .xls, .doc file
16+ Useful Service Invoice Templates [EXCEL & WORD] - Word Excel Fomats
16+ Useful Service Invoice Templates [EXCEL & WORD] - Word Excel Fomats
an invoice form with the words invoice written on it
an invoice form with the words invoice written on it
Free Tax Invoice Generator – Instant PDF Download | GoSetle®
Free Tax Invoice Generator – Instant PDF Download | GoSetle®
Professional Business Invoice Template Excel | Editable Tax Invoice | A4 Print Ready
Professional Business Invoice Template Excel | Editable Tax Invoice | A4 Print Ready
GST Invoice Format in Excel, Word (Free Download) .xls, .doc file
GST Invoice Format in Excel, Word (Free Download) .xls, .doc file
the receipt for tax invoice is shown
the receipt for tax invoice is shown
a laptop computer sitting on top of a desk next to a mouse and keyboard with the words create professional invoices in seconds
a laptop computer sitting on top of a desk next to a mouse and keyboard with the words create professional invoices in seconds
an invoice form is shown with the name and number on it, as well as
an invoice form is shown with the name and number on it, as well as
an invoice is shown on top of a piece of paper
an invoice is shown on top of a piece of paper

Saving and Sending Invoices

After reviewing and customizing your invoice, save it as a PDF for easy sharing. You can use free online converters like Smallpdf or PDFmyURL to convert your Excel file to PDF. Alternatively, if you're using Microsoft Office, you can save your workbook as a PDF directly from Excel.

Once your invoice is saved as a PDF, you can send it to your client via email or upload it to your customer relationship management (CRM) system. Some invoicing software also allows you to send invoices directly from the platform.

As your business grows, you may find it helpful to upgrade to dedicated invoicing software. These platforms often offer additional features like recurring invoices, payment tracking, and integration with accounting software. However, for small businesses or freelancers just starting out, Microsoft Excel can be an effective and affordable solution for creating tax invoice bills.