Learn how to build an auto-populating invoice template in Excel that automatically pulls in client details and item data in seconds. In this step-by-step tutorial, you’ll create a professional auto-filling invoice in Excel that uses XLOOKUP to instantly fill in customer information and product or service details when you select a name or description.

Once your template is set up, creating invoices becomes fast, accurate, and completely stress-free — no more typing the same information over and over.

Want the Template Used in This Tutorial?
If you’d like a ready-to-use version, you can grab it from my shop and customize it to fit your business needs: https://sharonsmithhr.etsy.com/listing/4462695852/excel-auto-filling-invoice-billing

This lesson is perfect for small business owners, freelancers, bookkeepers, and anyone who wants to automate invoice creation in Excel and save time.
You’ll Learn
How to use XLOOKUP to auto-populate client information
How to automatically pull item descriptions and pricing
How to create drop-down selections for faster invoice entry
How to auto populate Invoice Number and Due Date

Free Invoice Template Resources
Explore Microsoft’s free invoice templates here:
https://excel.cloud.microsoft/create/en/invoice-templates/

Watch Next
In my next video, I’ll show you how to mass create multiple billing statements and bulk email them out — perfect for saving hours each billing cycle.
Subscribe so you don’t miss it!

TIMESTAMPS
Jump to any section of the Excel invoice automation tutorial:
00:00 Auto-Populating Invoice Template Overview
01:32 Convert Client List & Items List to a Table
03:10 Create Invoice Template
03:43 Create Client Drop-Down List with Data Validation
04:34 Use XLOOKUP to Pull Client Information
10:50 Create Auto Invoice Number
12:42 Auto-Calculate Due Dates
14:53 Create Item Drop-Down and XLOOKUP Unit Price
17:45 Calculate Invoice Totals
19:17 Format Invoice for One-Page PDF Printing

#Excel #ExcelTutorial #InvoiceTemplate #SmallBusiness #ExcelAutomation

FREE COURSE - How to Create Fillable Forms in Microsoft Word - A Step-by-Step Guide
Create Fillable Forms, Surveys & Questionnaires in Microsoft Word like a Pro: https: https://youtu.be/438pCPCSuG4

CHANNEL LINK
https://www.youtube.com/@SharonSmith
Visit my Channel page on YouTube to see all my videos, playlists, community posts and more!

TEMPLATES
Check out my helpful list of templates available for purchase: https://creatoriq.cc/43c51cv
Thank you for supporting my channel!

FREE DOWNLOADS
Visit https://mailchi.mp/6a0859ea0844/sharonsmithhrformulasdownload to sign-up for my e-mail list and get FREE downloads of super helpful spreadsheet formulas, dashboards and Org Chart templates for HR professionals.

CONNECT WITH ME
Visit my website: https://www.sharonsmithhr.com for more information, tools and resources.
LinkedIn: https://www.linkedin.com/in/sharonsmithhr
Twitter: https://twitter.com/SharonSmithHR
Instagram: https://www.instagram.com/sharonsmithlearning/
Facebook: https://www.facebook.com/SharonSmithLearning

GEAR
Blue Yeti USB Microphone: https://amzn.to/2W4SbzV (Great for recording professional sounding audio for your videos!)
Silent Mouse: https://amzn.to/3pxpc25 (This is a really cool mouse!)
Screen Recording Software: https://techsmith.z6rjha.net/NZG5b
Green Screen: https://amzn.to/2DnHsY2
Camera: https://amzn.to/39KvpQA
Live Stream Tool: https://amzn.to/2VFJyID (Turns your DSLR into a top notch webcam)

RESOURCES
JotForm: https://www.jotform.com/pricing/?utm_source=sharon-smith&utm_campaign=jf1&utm_medium=blog
TechSmith Camtasia Screen Recording: https://techsmith.z6rjha.net/SharonSmithHR

Links included here are affiliate links. If you click on these links and make a purchase, I may earn a small commission at no additional cost to you. Thanks for supporting this channel!

SUPPORT THIS CHANNEL
- Hit the "$Thanks" button on any video, or
- Donate through my PayPal link: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=AJJ6SXERNDMYA&source=url

If you found this content helpful, please consider donating to my channel. Your donation, no matter what amount, is greatly appreciated and goes towards producing more content that enhances your productivity and elevates your skills.
You can also support my channel just by watching, liking, and sharing all my videos! Thank you so much!

PLAYLISTS
Jotform Tutorials: https://www.youtube.com/playlist?list=PLb80efKTbWuO84pPbnHdTdgurmxHgZcyD

Creating Fillable Forms: https://www.youtube.com/watch?v=YktZ3B-tyqs&list=PLb80efKTbWuOe1LfFMNExEabkRkB5ehcv

Excel Tutorials: https://www.youtube.com/playlist?list=PLb80efKTbWuNjHDGgNeuGrGwOvh4JQC90

Excel Tips & Tricks: https://www.youtube.com/playlist?list=PLb80efKTbWuPI7fEWtroXHvJHhx5FnVMW

Word Tutorials: https://www.youtube.com/playlist?list=PLb80efKTbWuMotoYEXBFMlB3PtsBlFn45