Create an invoice automatically in a few seconds using this Google Sheets template and email it as a PDF with just a few clicks of a button. 
 
This is a fully automated setup which allows you to generate an invoice from a template and then email it as a PDF attachment in a fully automated process without leaving Google Sheets. In addition, as invoices are generated and processed, they are added to a statement sheet in a seamless process.
 
You can create an invoice, add up to 10 items, email this as a PDF and update the statement in under a minute thanks to the power of this automatic Google Apps Script setup. 
 
Every invoice you create will have its own sheet created for historical purposes, and you can keep track of outstanding payments via the statement to keep on top of your finances.
 
Choose your own currency and date format in just a few steps. 
 
A full 16-page instruction PDF is included with this template to get everything set up and ready to go.
 
Please note: This Google Sheet is not compatible with Microsoft Excel since it uses Google Apps Script to run the automation.