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.