How To Make A Template That You Can Duplicate By Entering A Number In Excel

six Min. Read

How to Create an Invoice in Excel: Invoicing Solutions for Small Business organization

March 28, 2019

Small businesses can create their own invoices in Microsoft Excel to start billing clients for their services. Yous tin either utilize a customizable Excel invoice template or create your own professional invoice from scratch.

Acquire how to create an invoice in Excel with these invoicing topics:

How to Make an Invoice from an Excel Template (Windows)

How to Make an Invoice from an Excel Template (Mac)

How to Create an Invoice in Excel from Scratch

Free Microsoft Excel Invoice Templates

How to Make an Invoice from an Excel Template (Windows)

Businesses tin use customizable Excel templates to invoice their customers. To create an invoice from an Excel template on a Windows PC, follow these steps:

1. Open up Microsoft Excel

To begin making an invoice from an Excel template, you'll first demand to launch Microsoft Excel on your PC.

ii. Search for an Invoice Template

Once Excel is open on your estimator, use the search bar that's located at the height of the window and enter "invoice" to discover invoice templates. Brand sure you're connected to the cyberspace to perform the search.

3. Choose Your Template

Scroll through the dissimilar invoice template options to find one that works for your business. Excel offers a range of invoice templates, from sales invoices to service invoices and shipping invoices. Choose a template that fits your needs and has a design that fits with your visitor branding.

4. Open the Invoice Template

In one case you've chosen a template that works for you, click on the template to preview it and so hit the "Create" button to open the Excel template in a new window.

5. Customize the Invoice

Once you've opened a new spreadsheet using your selected template, yous'll need to edit the invoice to reflect the details of your project. Exist sure to include the post-obit data:

Your logo, if you accept one
Your business contact information, including your proper noun, address, telephone number and email
Your client's contact details
The invoice date
A unique invoice number
The payment due date
An itemized list of your services with brief descriptions, the hours worked or quantity and the charge per unit
A subtotal for each service
The payment terms, including payment methods and late fee details
The total amount due for the invoice, including applicable taxes

Read this invoicing guide to larn all the data businesses should include on their invoices.

6. Save the Invoice

When you lot've added all the necessary information to your invoice, relieve the completed spreadsheet to your computer. Save it every bit a .xlxs format document then you can edit it after if needed. You should also save it as a PDF and send that version to your client, and then information technology can't exist contradistinct.

vii. Send the Invoice

Transport the completed invoice to your client, either by electronic mail or by mail. Include a short cover note that highlights the important details, like the invoice due date and the total amount owing.

How to Make an Invoice from an Excel Template (Mac)

To make an invoice using an Excel template on a Mac computer, follow these invoicing steps:

1. Open Microsoft Excel

First, open Microsoft Excel. Click File on the carte bar and then click New from Template. A page will launch with a pick of available templates.

2. Search for an Invoice Template

To filter the template results, click on the search bar in the upper right-hand corner of the page, blazon "invoice" and hit enter to search.

3. Cull Your Invoice Template

In that location are a variety of Excel invoice templates to choose from, including business organisation invoice templates and templates that use formulas to automatically calculate taxes. Select 1 that provides all the information you demand and features a design that works with your visitor branding.

4. Download the Template

Once you've plant an Excel template to adapt your business needs, click on the template to open a preview page. Then, click the "Create" button to open it as a new spreadsheet.

5. Customize Your Invoice

Edit the invoice template to include the specific project details. Remember to include the following information:

Your logo, if yous have ane
Your business contact details, including your name, address, phone number and email
Your client's contact data
A unique invoice number
The invoice date
An itemized list of the services you provided the customer, including the quantity or hours worked and the charge per unit of pay
A subtotal for each of your services
Your payment terms, including accepted payment methods and late fee terms
The payment due date
The total amount due, including any applicable tax

half dozen. Salvage the Invoice

When you've filled out all the project specifics on your invoice, save the spreadsheet to your computer in both .xlxs and PDF format. When sending the invoice to your customer, utilize the PDF version and so it can't be edited later on you transport information technology.

7. Send the Invoice

Ship the invoice to your client by email or postal service. Include a brief note that calls out the important invoice details, such as the deadline for payment and the full amount due.

How to Create an Invoice in Excel from Scratch

Learn how to create an invoice in Excel from scratch past post-obit these easy steps:

1. Open a Blank Excel Workbook

To begin creating a new invoice in Excel, open Microsoft Excel on your computer and and so click Open a Blank Workbook. A new bare spreadsheet volition open.

Add a header to your invoice. Include important billing details in the header, including:

Your logo
Your concern contact information
The invoice date
A unique invoice number

3. Add the Client's Information

Include your client'south contact data, including the relevant contact person's name, address, e-mail and telephone number.

iv. List the Payment Due Engagement

Include the payment due engagement on your invoice. Write out the full due date, i.e. "Payment Due Dec 31, 2018" instead of more vague terms, such equally "Payment Due in 30 Days" which can lead to confusion and missed payments.

5. Add an Itemized List of Services

Create an itemized listing of the services y'all provided. Create a column for a description of each service, a column for the quantity or hours worked and a cavalcade for your rate. And then include a final column with a subtotal for each service listed.

6. Add together the Full Corporeality Owing

One do good of creating invoices in Excel is that the spreadsheet tin can exercise the math for you. Use Excel's SUM function to calculate the total due and add it to the bottom of the invoice. For case, if you need to add up the subtotals in Column C from cell four through eight to calculate the full due, just enter the post-obit formula in cell C9:

=SUM(C4:C8)

7. Include Your Payment Terms

Add your payment terms to the lesser of the invoice, including the payment methods accepted and the details of your belatedly fee policy.

Free Microsoft Excel Invoice Templates

Yous can download a broad range of customizable Excel invoice templates online. FreshBooks offers a selection of complimentary invoice templates available to download in Excel, Word and PDF formats. The templates are tailored to different industries and business models.