| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Send invoices customers can pay by card with Smarfle. From $19/month. Start free. | |||||||||||||||||||||||||
2 | Google Sheets Invoice Template | |||||||||||||||||||||||||
3 | A free invoice you can fill in, print or save as PDF, right in Google Sheets. | |||||||||||||||||||||||||
4 | Make a copy to use it privately in your Google Drive | |||||||||||||||||||||||||
5 | Download for Excel (.xlsx) | Works in Excel. A few Google-only formulas work best in Google Sheets. | ||||||||||||||||||||||||
6 | Quick start | |||||||||||||||||||||||||
7 | 1. Make a copy using the link above. Keep your copy Restricted before entering customer or payment details. | |||||||||||||||||||||||||
8 | 2. On Invoice, clear A15:A16 and E15:E16, then replace the yellow sample customer, dates, number, discount, amount paid and A38 note. Keep the yellow description and rate formulas if you want Price List defaults. Optional log samples: clear inputs in Invoices rows 6:7 and Line Items rows 6:8. Keep all calculated columns. | |||||||||||||||||||||||||
9 | 3. Start typing on Invoice. Yellow fields are editable, including business details. Fill in customer details, add a description, quantity and rate, then check the totals box at the top right. | |||||||||||||||||||||||||
10 | Who it is for | |||||||||||||||||||||||||
11 | This invoice is for a local service business that wants a clear bill without setting up a database. Open the Invoice tab, replace the yellow sample fields, enter the work and check the balance. The form calculates its own totals. You do not need to create a log record before using it. The Invoice Tracker is the separate tool for chasing unpaid balances and reviewing aging. | |||||||||||||||||||||||||
12 | What you can enter | |||||||||||||||||||||||||
13 | Enter the business name, address, phone and email on the form. These fields initially use Settings, but you can type over the defaults. Fill in Invoice #, Issue date, Due date and Bill to. Add up to 12 lines. Choose a service if useful, or leave the service cell blank and type a description and rate yourself. Quantity and taxable status are editable. | |||||||||||||||||||||||||
14 | How the tabs connect | |||||||||||||||||||||||||
15 | Settings supplies business defaults, payment terms, tax and payment instructions. Price List supplies optional descriptions and rates. Invoices and Line Items are optional records for history. Dashboard summarizes only those logs, not direct or duplicated Invoice tabs. Typing on a form does not add a log row. Use the form alone if that is all you need. | |||||||||||||||||||||||||
16 | Set up your first invoice | |||||||||||||||||||||||||
17 | Replace the sample business details in Settings or directly on Invoice. A chosen service fills its description, rate and taxable status only while those yellow cells retain their formulas. Typing in one of those cells replaces its formula on that form. For a later service change, type the new values or restore the formula from a fresh copy. | |||||||||||||||||||||||||
18 | Check the due date after changing terms. It initially adds the term's days to the issue date, but you can type a different date over it. Discount type is None, Amount or Percent. Enter 10 for a 10 percent discount, not 10%. Enter tax as 7% for seven percent. Amount paid is an amount already received, not a payment request. | |||||||||||||||||||||||||
19 | Worked example | |||||||||||||||||||||||||
20 | The sample has two HVAC maintenance visits at $125 and one filter replacement at $45. Subtotal is $295. An amount discount of $25 leaves $270 before tax. With every line taxable and tax at 7%, tax is $18.90 and total is $288.90. After $100 already paid, balance due is $188.90. Change the inputs to match your actual agreement. | |||||||||||||||||||||||||
21 | Definitions | |||||||||||||||||||||||||
22 | Subtotal adds quantity times rate for active lines. Discount reduces the subtotal before tax. Tax applies only to taxable lines after a proportional share of the discount. Total is subtotal minus discount plus tax. Balance due is total minus amount paid. A negative balance indicates an overpayment that needs review. Marking a document Void sets its balance to zero but does not erase its contents. | |||||||||||||||||||||||||
23 | Draft, Sent and Void describe this document. They do not send email or collect a payment. Payment instructions are plain text; provide account details privately when appropriate. This template does not determine whether your service is taxable and is not tax advice. | |||||||||||||||||||||||||
24 | Practical checks | |||||||||||||||||||||||||
25 | Check the Needs attention field at the end of the form. A highlighted line needs a description, valid quantity or rate, or a valid taxable choice. Check dates, discounts and tax before sending. Blank unused lines do not count as errors. A zero rate can be intentional, but verify free items. There is no hidden thirteenth line on the printable form. | |||||||||||||||||||||||||
26 | Preview the document before sending it. Confirm the customer, service address, business phone, due date and payment instructions. Keep customer information out of the public master. Save the finished document as a PDF so later changes to Settings or Price List cannot change the version the customer received. | |||||||||||||||||||||||||
27 | Keep history if you want it | |||||||||||||||||||||||||
28 | For each new invoice, duplicate the Invoice tab (right-click the tab > Duplicate) or File > Make a copy; record it in the log if you want history and totals. Give the duplicate a clear name. Log entries are manual and must use matching invoice numbers in Invoices and Line Items. Do not assume the Dashboard includes forms you have not logged. | |||||||||||||||||||||||||
29 | Capacity and protection | |||||||||||||||||||||||||
30 | The form has 12 lines and fits one portrait US Letter page. For more work, combine related items or prepare another document. Yellow defaults are deliberately editable. Calculations, headings and instructions are protected; the ad uses an editing warning. Hidden calculations can stay collapsed. Owners may change protections in their own copies. | |||||||||||||||||||||||||
31 | Print or save privately | |||||||||||||||||||||||||
32 | No setup is needed for File > Print: choose Current sheet, Portrait, Fit to width. The optional PDF link needs the full URL of the current form tab pasted into its yellow URL box, including gid. After duplicating a tab, replace that URL with the duplicate's URL. The link exports this form only. Never paste the public master's URL when exporting private work. | |||||||||||||||||||||||||
33 | ||||||||||||||||||||||||||
34 | About Smarfle | |||||||||||||||||||||||||
35 | Manage customers, jobs and invoices with Smarfle when you need a connected service-business platform. Plans start at $19/month. Plan limits and usage charges apply. Check current features and pricing on the website. | |||||||||||||||||||||||||
36 | Created by Ihor Lavrenenko, founder of Smarfle | |||||||||||||||||||||||||
37 | ||||||||||||||||||||||||||
38 | ||||||||||||||||||||||||||
39 | ||||||||||||||||||||||||||
40 | ||||||||||||||||||||||||||
41 | ||||||||||||||||||||||||||
42 | ||||||||||||||||||||||||||
43 | ||||||||||||||||||||||||||
44 | ||||||||||||||||||||||||||
45 | ||||||||||||||||||||||||||
46 | ||||||||||||||||||||||||||
47 | ||||||||||||||||||||||||||
48 | ||||||||||||||||||||||||||
49 | ||||||||||||||||||||||||||
50 | ||||||||||||||||||||||||||
51 | ||||||||||||||||||||||||||
52 | ||||||||||||||||||||||||||
53 | ||||||||||||||||||||||||||
54 | ||||||||||||||||||||||||||
55 | ||||||||||||||||||||||||||
56 | ||||||||||||||||||||||||||
57 | ||||||||||||||||||||||||||
58 | ||||||||||||||||||||||||||
59 | ||||||||||||||||||||||||||
60 | ||||||||||||||||||||||||||
61 | ||||||||||||||||||||||||||
62 | ||||||||||||||||||||||||||
63 | ||||||||||||||||||||||||||
64 | ||||||||||||||||||||||||||
65 | ||||||||||||||||||||||||||
66 | ||||||||||||||||||||||||||
67 | ||||||||||||||||||||||||||
68 | ||||||||||||||||||||||||||
69 | ||||||||||||||||||||||||||
70 | ||||||||||||||||||||||||||
71 | ||||||||||||||||||||||||||
72 | ||||||||||||||||||||||||||
73 | ||||||||||||||||||||||||||
74 | ||||||||||||||||||||||||||
75 | ||||||||||||||||||||||||||
76 | ||||||||||||||||||||||||||
77 | ||||||||||||||||||||||||||
78 | ||||||||||||||||||||||||||
79 | ||||||||||||||||||||||||||
80 | ||||||||||||||||||||||||||
81 | ||||||||||||||||||||||||||
82 | ||||||||||||||||||||||||||
83 | ||||||||||||||||||||||||||
84 | ||||||||||||||||||||||||||
85 | ||||||||||||||||||||||||||
86 | ||||||||||||||||||||||||||
87 | ||||||||||||||||||||||||||
88 | ||||||||||||||||||||||||||
89 | ||||||||||||||||||||||||||
90 | ||||||||||||||||||||||||||
91 | ||||||||||||||||||||||||||
92 | ||||||||||||||||||||||||||
93 | ||||||||||||||||||||||||||
94 | ||||||||||||||||||||||||||
95 | ||||||||||||||||||||||||||
96 | ||||||||||||||||||||||||||
97 | ||||||||||||||||||||||||||
98 | ||||||||||||||||||||||||||
99 | ||||||||||||||||||||||||||
100 | ||||||||||||||||||||||||||