How to Create an Invoice Generator with Google Sheets & Apps Script | D17

A straightforward invoice generator for anyone who bills a few clients and does not need an accounting suite to do it. Fill the invoice, let it calculate, print it. Every invoice saves into Google Sheets so it can be found again later.

The arithmetic is not yours to do

Subtotal, tax and grand total calculate automatically as line items are added. That is the part of manual invoicing that produces the awkward call three weeks later, and removing it is most of the value here. Line items can be added and edited on the fly while you build the invoice.

Finding the invoice again

Invoices save directly into Google Sheets and can be searched and reloaded — so when a client asks about something you sent last quarter, you open it rather than reconstructing it. Reopened invoices can be updated and saved back.

Print and send

The print layout is clean and ready to hand over or attach, without the formatting fight that comes from printing a spreadsheet directly.

Who it suits

Freelancers and consultants, small shops and service businesses, and anyone who wants invoicing without a monthly subscription. If you also need stock deduction, login and a dashboard, the fuller build in this catalogue covers that — this one is deliberately the simpler tool.

Setup

Copy the sheet, deploy the script, start invoicing. No external software and no recurring fee — Google Sheets holds every record. The video covers the full build, and support is free if you get stuck.