Building an Excel automated invoice system. Begin the process by making an invoice template that includes pre-formatted fields for item descriptions, quantities, unit prices, and customer information.