Home » Free Invoice Templates » Google Sheets Invoice Template

Free invoice templates for Google Sheets

Sending clear and professional invoices is necessary for small businesses to get paid on time by clients.

Try downloading and customizing one of our free invoice templates for Google Sheets to make your first invoice.

Use Bookipi invoice app for the most efficient way to make and send invoices in minutes.

AUD - Australian Dollar USD - US Dollar GBP - British Pound Sterling AED - United Arab Emirates Dirham AFN - Afghan Afghani ALL - Albanian Lek AOA - Angolan kwanza AMD - Armenian Dram ANG - Dutch Guilder ARS - Argentine Peso AZN - Azerbaijani Manat BAM - Bosnia-Herzegovina Convertible Mark BBD - Barbadian Dollar BDT - Bangladeshi Taka BGN - Bulgarian Lev BHD - Bahraini Dinar BIF - Burundian Franc BND - Brunei Dollar BOB - Bolivian Boliviano BRL - Brazilian Real BWP - Botswanan Pula BYR - Belarusian Ruble BZD - Belize Dollar CAD - Canadian Dollar CDF - Congolese Franc CHF - Swiss Franc CLP - Chilean Peso CNY - Chinese Yuan COP - Colombian Peso CRC - Costa Rican Colón CVE - Cape Verdean Escudo CZK - Czech Republic Koruna DJF - Djiboutian Franc DKK - Danish Krone DOP - Dominican Peso DZD - Algerian Dinar EEK - Estonian Kroon EGP - Egyptian Pound ERN - Eritrean Nakfa ETB - Ethiopian Birr EUR - Euro GEL - Georgian Lari GHS - Ghanaian Cedi GNF - Guinean Franc GTQ - Guatemalan Quetzal HKD - Hong Kong Dollar HNL - Honduran Lempira HRK - Croatian Kuna HTG - Haitian gourde HUF - Hungarian Forint IDR - Indonesian Rupiah ILS - Israeli New Sheqel INR - Indian Rupee IQD - Iraqi Dinar IRR - Iranian Rial ISK - Icelandic Króna JMD - Jamaican Dollar JOD - Jordanian Dinar JPY - Japanese Yen KES - Kenyan Shilling KHR - Cambodian Riel KMF - Comorian Franc KRW - Korean Won(₩) KRW2 - Korean Won(원) KWD - Kuwaiti Dinar KZT - Kazakhstani Tenge LBP - Lebanese Pound LKR - Sri Lankan Rupee LTL - Lithuanian Litas LVL - Latvian Lats LYD - Libyan Dinar MAD - Moroccan Dirham MDL - Moldovan Leu MGA - Malagasy Ariary MKD - Macedonian Denar MMK - Myanma Kyat MOP - Macanese Pataca MUR - Mauritian Rupee MXN - Mexican Peso MVR - Maldivian rufiyaa MYR - Malaysian Ringgit MZN - Mozambican Metical NAD - Namibian Dollar NGN - Nigerian Naira NIO - Nicaraguan Córdoba NOK - Norwegian Krone NPR - Nepalese Rupee NZD - New Zealand Dollar OMR - Omani Rial PAB - Panamanian Balboa PEN - Peruvian Nuevo Sol PGK - Papua New Guinea Kina PHP - Philippine Peso PKR - Pakistani Rupee PLN - Polish Zloty PYG - Paraguayan Guarani QAR - Qatari Rial RON - Romanian Leu RSD - Serbian Dinar RUB - Russian Ruble RWF - Rwandan Franc SAR - Saudi Riyal SDG - Sudanese Pound SEK - Swedish Krona SGD - Singapore Dollar SLL - Sierra Leonean Leone SOS - Somali Shilling SRD - Surinamese dollar SYP - Syrian Pound THB - Thai Baht TND - Tunisian Dinar TOP - Tongan Paʻanga TRY - Turkish Lira TTD - Trinidad and Tobago Dollar TWD - New Taiwan Dollar TZS - Tanzanian Shilling UAH - Ukrainian Hryvnia UGX - Ugandan Shilling UYU - Uruguayan Peso UZS - Uzbekistan Som VEF - Venezuelan Bolívar VES - Bolívar Soberano VND - Vietnamese Dong XAF - CFA Franc BEAC XCD - East Caribbean Dollar XOF - CFA Franc BCEAO XPF - Central Pacific Franc YER - Yemeni Rial ZAR - South African Rand ZMK - Zambian Kwacha

Art, Photography & Creative Services Construction & Trades Cleaning & Property Maintenance Consulting & Professional Services Education, Non-profits & Associations Farming & Agriculture Hair, Spa & Beauty Retailers, Sales & Food Transport, Travel & Recreation Web, Tech & Media Other

Download free invoice templates for Google Sheets

Google Sheets is one of the most popular data entry software. Our free Google Sheets invoice templates have pre-populated formulas. Simply enter your items and calculations of totals are automated.

Our free invoice templates for Google Sheets are professional but are completely customisable to suit your business needs.

Browse our full invoice template collection for different business needs and formats including:

Alternatively, use Bookipi’s invoice app for pre-designed invoices with a few taps and clicks.

Download free invoice templates by Job or Business Types

Downloadable free Accounting invoice templates

Downloadable free Auto Repair invoice templates

Downloadable free Car Rental invoice templates

Downloadable free Catering invoice templates

Downloadable free Cleaning invoice templates

Downloadable free Construction invoice templates

Downloadable free Dentist invoice templates

Downloadable free Design invoice templates

Downloadable free Handyman invoice templates

Downloadable free Hotel invoice templates

Downloadable free Lawn Care invoice templates

Downloadable free Legal invoice templates

Downloadable free Marketing invoice templates

Downloadable free Moving Company invoice templates

Downloadable free Musician invoice templates

Downloadable free Photography invoice templates

Downloadable free Rental invoice templates

Downloadable free Roofing invoice templates

Downloadable free Small Business invoice templates

Downloadable free Therapy invoice templates

Downloadable free Trucking invoice templates

An alternative to using invoice templates

With Bookipi Invoice, you can easily generate invoices and save your customer and invoice details for future use.

Frequently Asked Questions (FAQs)

When should I use a Google Sheets invoice template?

Using one of our free Google Sheets invoice templates suits anyone who might have many line items with different pricing that require some formula work to calculate totals. Our invoice templates for Google Sheets are pre-designed to prompt you with what you need to enter on an invoice.

Select ‘Make a Copy’ after you download one of our Google Sheets invoice templates. This will create an editable copy for you to modify as you please. Our Sheets invoice templates are pre-formatted with the formulae required to calculate your invoice’s totals. Simply enter the invoice items and their costs. Total calculations can be automated. Our invoice templates for Google Sheets are professional but you can change formatting to suit your needs. Invoice templates in other formats (like Word, Excel/XLS, Google Docs and PDF) are also available for you to download.

If you want to learn more about invoicing, read up on what is an invoice and how to make an invoice.

What are invoice alternatives to Google Sheets invoice templates?

Google Sheets is great data entry software but it is not designed for invoicing. Google Sheets can handle calculations but not design. On the other hand, you can better make design changes in Google Docs but it isn’t built for calculations.

Ultimately, using standard document processing and data entry software like Microsoft Office and Google Docs isn’t ideal for small businesses who regularly invoice.

An invoice app like Bookipi Invoice is the best invoice generator and organizer software for small business. Make and send invoices from anywhere and on any device including mobile app and web. You can save items and customers to add to your invoices in one click. You also won’t need to worry about design as the app does it for you. You can also accept credit card and PayPal payments so your clients pay straight from your invoice. The Bookipi invoice maker and organizer automatically sorts invoices based on invoice number or invoice issue date.

How do I format an invoice in Google Sheets?

To format an invoice in Google Sheets, you can follow these steps:

Open Google Sheets: Go to Google Sheets and open a new spreadsheet.
Create Headers: Set up your invoice layout by adding headers for essential details such as “Invoice Number,” “Date,” “Client Information,” “Description,” “Quantity,” “Rate,” “Amount,” etc.
Enter Information: Input your company details and the recipient’s information.
Enter Invoice Items: Enter the items you are invoicing for, including a description, quantity, rate, and calculate the amount for each item.
Calculate Totals: Calculate the total amount due, including any applicable taxes or discounts.
Format Cells: Customize the appearance of your invoice by formatting cells, adjusting fonts, adding borders, or using colors to make it visually appealing and easy to read.
Review and Save: Review your invoice to ensure accuracy, and then save it in Google Sheets for future use.

By following these steps, you can create a well-formatted invoice in Google Sheets ready to be sent to your clients. Alternatively, try using our invoice software to create professional invoices, track payment statuses and more!