Save time by using one of invoice templates in different file formats that are pre-designed with the key sections that you need. Ultimately, deciding between using our Excel or Word invoice templates depends on your needs and preferences. As a file format based on formulas and cells, you can easily automate calculations for repeat invoices and generate reports using our Excel invoice templates. This is important especially when you have a high volume of invoices or you want to set your business up for long-term growth.

Using our Microsoft Excel invoice templates offers more advanced features for managing and tracking your invoices. If you prefer a more straightforward approach, using our Word invoice templates may be a better alternative for making basic invoices where you want to combine text and graphics. However, Excel may only be appropriate for users who are comfortable with using tables, numbers and formulas. Using an Excel invoice template can suit your freelance or small business when you need more complex invoices requiring multiple line items. works really well, but that is just me.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 That way the LOG will show each number and relevant info and then it will also open the template and pre-populate those values into the sheet for the user and even saves that new sheet in a given location with a fixed naming style so the folder shows all the items in a unified way.

My LOG has a button to create a new item that will identify the new number and pop up a form with basic info to populate the LOG. I have a similar system for POs and such but I base it off a LOG. That said, your technique has a number of drawbacks including if they open it up and close it without 'creating' a new invoice the number increments, if they open an old invoice to look at it the number increments, if they open the template and create and print a new invoice but don't save it (or it fails to save) then the increment doesn't save and you get duplicate invoice numbers. Try defining the sheet before that RANGE function. Think you're getting an error because you have an undefined sheet for that range.

Simple invoice template excel